An analysis of the global superstores dataset. This analysis was conducted as a task assigned by Vikot Solutions limited. Three datasets were provided by the company.
-
Customer segment and region: Contains data for customer information, including ID, name, region and others. Preview:
-
Product details: Contains all the details of the products sold in the store, including product ID, name, category subcategory and others.
-
Orders: Contains all order details and daily sales including discounts. Preview:
Data cleaning and transformation were undertaken in Microsoft Power BI. Actions taken include:
- Removal of duplicates.
- Correction of wrong data types.
All analysis and visualizations were done in Microsoft Power BI. Some visuals required the writing of Data Analysis Expression (DAX) before their creation.
Please download the powerpoint file for the comprehensive report.