Maven Toys Dashboard

As a recently appointed Data Analyst at Maven Toys, a well-established toy store franchise operating across Mexico, my primary task is to develop an easy-to-use, dynamic report. This report is intended for the executive team to efficiently track essential business indicators and overarching trends.

The key steps in this process include:

1. Establishing a connection to and profiling the data.
2. Developing a structured relational model.
3. Implementing calculated metrics and additional data fields.
4. Crafting an interactive report for strategic insights.

Key Insights:

1. Toys Category: Identified as the highest-earning category. It's crucial to maintain sufficient stock, particularly in key locations such as commercial areas and city centers.
2. Arts & Crafts Category: Ranks as the second-highest in profitability. However, there's been a noticeable downward trend in profits since April 2023, consistently falling below the average.
3. Games Category: Exhibiting a steady increase in profits. Maven Toys should focus on leveraging this growth in the arts and crafts segment in the forthcoming years.
4. Sales Trends: A drop in sales is observed during February and August. Implementing discount strategies in these months could enhance sales and profit margins.
5. Top-Selling Products: The Playdoh Can and Deck of Cards emerge as the most profitable items. Sales are often hampered by low stock levels, highlighting the need for frequent restocking.
6. Product Performance: Uno cards are underperforming and might be considered for discontinuation from the product line.