Toy Store Descriptive Sales Analysis

The project is dealing with an exploratory analysis of a Toy Store Business. The dashboard is aiming to capture the key takeaways from the data I had in my hands. Moreover, the dashboard is aiming to help the business owners understand what happened in the years of 2017 and 2018. The dataset was public through Maven Analytics data playground.

Business Questions the Dashboard aims to answer:

1. How many stores, product categories, unique products, and sales did 2018 and 2017 had?

2)What are the sales in the different product categories?

3)Which are the top 5 stores regarding sales in those years?

4)How much is the average price the consumer can find in those different product categories?

5)How much is the average cost for each product category?

6)How much is the net average profit that each category is bringing back to the business in those years?