Toy store sales analysis

Toy store management wants to do sales analysis based on the sales data of three regions Chicago, Los Angeles and New York for the years 2020 and 2021. The analysis includes trend analysis, region based analysis, Top N products sales compared with total revenue etc.

The analysis includes data cleaning, transformation, analysis and visualization with multiple dynamic parameters.

Technology used: Microsoft Power BI, excel

The key insights:

1. Among the weekdays, most revenues are recorded on Wednesday.

2. Los Angeles is the region with most revenues

3. on monthly trend analysis, 2021 revenue is in much better position compared to 2020 for all cities and the good news is it increasing rapidly for all cities at the end of 2021.