Playful Insights - Maven Toys

This business report summarizes the sales data of Maven Toy stores across Mexico for January 2017 to September 2018. These are the 3 questions that we focused on answering in this analysis.

1. Which product categories drive the biggest profits?
2. Can you find any seasonal trends or patterns in the sales data?
3. Are sales being lost with out-of-stock products at certain locations?

The analysis was conducted in Power Bi to drive meaningful patterns & trends and the results are presented in an interactive dashboard.

Bottom line: Toys is the most profitable category so it should always be in stock.

Electronics is the second most profitable category but it has been seeing a decline with profits below average since April 2018 while Arts & Crafts has seen a constant upward trend in profit so Maven should make the most of the growth in arts and craft in the coming years.

We see a decline in sales in February and August, discounts should be offered to help increase sales and profit. Uno cards is the worst performing product Maven Toys should discontinue it.

Action Figure & Colorbuds are 2 top profitable products and wee see a loss in their sales due to low inventory levels, Maven Toys should look into it & prioritize.