Mexico Toys Sales
Analyzed Sales & inventory data for a fictitious chain of toy stores in Mexico for patterns in sales and showcased the results in a Power BI dashboard.
Insights
- During the two years provided 1M units have been sold with a 4M revenue
- Arts & crafts are the most sold category
- Downtown stores have the highest sales and are the most common
- Airport stores are low but still sell 68K
- September is the highest selling month following it october which is the lowest selling month
- Downtown stores sell the most units followed by commercial with a very high margin
The Process
The data (link) consists of 6 CSV files as follows:
- Data Dictionary
- Sales
- Products
- Stores
- Inventory
- Calendar
Calculation using M & DAX language
There's a cost and a price for each item, so using M language we made a revenue column for each item
Utilizing Dax Filters and Calculate functions we cross referenced each items revenue and what we got from each sale in the sales table
Measures
For this particular analysis we 5 used measures- Oldest Store Opened
- Newest Store Opened
- Sum of Units Sold
- Sum of Revenue
- Count of Stores