Data Analysis using Excel

This is a sample of a case study that I completed, a capstone projects in the Google DA Professional Certificate. I analyzed 5M+ observations using Power Query and aggregated the data using pivot tables and charts for easy visualization. It can be accessed using this link. Download to view the Excel file if it doesn’t work properly online.

I’ve also provided this document with the summary of the case study including the business task, description of data sources, applied steps in data transformation, analysis, visualizations, etc.

Feel free to engage me regarding the same.