Portfolio - Data Analysis & Web Projects


Note: The stories built around each porfolio project demonstrated (containing my role and project description) serve as a narrative with a purpose to better show my skills and knowledges.

  1. SKELETON APP WITH REALTIME DATA UPDATE

  2. SUPERSTORE BENCHMARKING SALES ANALYSIS

  3. COFFEE SALES ANALYSIS DASHBOARD

  4. IMDB MOVIES DATASET ANALYSIS

  5. Fortune 500 German companies using Python

  6. Data Business Survey Analisys using Power BI

  7. BUILDING ETL PIPELINE ON WORLD’S LARGEST BANKS



MVC REALTIME UPDATE- In the reusable skeleton MVC App Firebase NoSQL database triggers event for each DB update. Subscribing to event handler and providing custom callback function client receives fresh real-time data...

COFFEE- There are Data about Sales of different coffee types in different countries during the period od few years. It's required to build Dashboard and get some insights...

MOVIES- A reporter writes an article about 40-year movie industry for MovieMaker Magazine. They hired me to analyze Dataset and provide useful insights from it ...

SUPER STORE- A competitor hired me for getting insights from their Sales Dataset to answer some particular business questions for benchmarking...

GERMANY- As a Data Analyst I want to know more about the largest German companies, ranked within Fortune Global 500. There is a Wiki page to analyze and get insights...

DATA BUSINESS- There are results of Twitter/LinkedIn Survey of Data Professionals, to be processed and valuable insights obtained ...

BANKS WORLDWIDE- A multi-national firm has hired me to access and process data using Python skills for ETL. There will be extracted, transformed and loaded real-world data about the world's largest banks ...



About the author

Barry The Analyst has been working from May 2022 untill July 2023 with one big company in Ireland, and since July 2023 has worked with one big company in Germany. This blog was started as a private note collection in order to (re)develop, refresh and strengthen essential skills of Data Analysis field. The content was generated on the way of learning path, with a degree in Electrical Engineering and experience in C++/SQL. Private notes turned into public blog to share the knowledge and provide support to anyone who would find this interesting...

 

Who is this for?

This is not yet another basic course that would explain elementary concepts. There are many basic features of tools and technologies that are skipped in blog articles and portfolio projects here presented. If you are not an absolute beginner in SQL/databases, Excel, Python and Power BI this might be useful material if you would like to advance a career as Data Analyst and/or Python Developer ...

This template downloaded form free website templates