Overview
I completed this project as part of my technical interview process for a data analyst role at one company. Having found the project fun and engaging, I thought it would be good to share it here as well. The process followed in data cleaning, modelling, and analysis is explained on the first page of the Power BI report. Basically, the task includes modelling of data to establish links between these four tables: Orders, Customers, Products, & Suppliers. After modelling, analysis can then be done to answer five simple questions using the data.
Here is the case study information:
My solution