Maven Toys Sales Performance Dashboard
Maven Toys Sales Performance Dashboard
Embedded Files
Project Overview
Project Overview
This project is an interactive sales performance analysis of Maven Toys data. I used Power Query to clean and prepare the data, including merging related datasets using the Merge Queries feature. I then created PivotTables, PivotCharts, KPI cards, slicers, and a Timeline to analyze revenue, profit, profit margin, units sold, product performance, store performance, monthly trends, and inventory.
This project is an interactive sales performance analysis of Maven Toys data. I used Power Query to clean and prepare the data, including merging related datasets using the Merge Queries feature. I then created PivotTables, PivotCharts, KPI cards, slicers, and a Timeline to analyze revenue, profit, profit margin, units sold, product performance, store performance, monthly trends, and inventory.
Data Cleaning & Preparation
Maven Toys Source Data
Power Query – Data Merging & Transformation
Final Merged & Prepared Dataset
Data Cleaning, Merging & Preparation
Data Cleaning, Merging & Preparation
I prepared the Maven Toys data using Power Query by cleaning and organizing the source datasets. I used the Merge Queries feature to combine related sales, product, store, and inventory data. I then expanded the required fields and applied the necessary transformations to create a consolidated dataset ready for analysis and dashboard development.
I prepared the Maven Toys data using Power Query by cleaning and organizing the source datasets. I used the Merge Queries feature to combine related sales, product, store, and inventory data. I then expanded the required fields and applied the necessary transformations to create a consolidated dataset ready for analysis and dashboard development.
Data Analysis & PivotTables
Revenue & Profit by Category
Top 10 Products by Profit
Top 10 Stores by Revenue & Profit
Monthly Revenue & Profit Trend
Data Analysis & PivotTables
Data Analysis & PivotTables
Using PivotTables, I analyzed Maven Toys' revenue, profit, profit margin, units sold, product performance, store performance, monthly trends, and inventory. These PivotTables provided the calculations and summaries used to create the interactive dashboard and identify key business performance patterns.
Using PivotTables, I analyzed Maven Toys' revenue, profit, profit margin, units sold, product performance, store performance, monthly trends, and inventory. These PivotTables provided the calculations and summaries used to create the interactive dashboard and identify key business performance patterns.
Interactive Sales Dashboard
I developed an interactive Excel dashboard to provide a clear overview of Maven Toys' sales and profitability performance. The dashboard combines KPI cards, PivotCharts, slicers, and a Timeline to allow users to explore performance by product category, product, store, and time period.
Key Insights
Key Insights
1. Overall Sales Performance
1. Overall Sales Performance
Maven Toys generated $14.44M in total revenue and $4.01M in total profit, resulting in an overall 27.79% profit margin. The business also recorded approximately 1.09M units sold, providing a strong overall view of sales volume and profitability.
2. Category Performance
2. Category Performance
Toys was the strongest-performing product category in terms of revenue and profit, followed by Games and Art & Crafts. This indicates that the Toys category is a major contributor to the company's overall financial performance.
3. Top Products by Profit
3. Top Products by Profit
The Top 10 Products by Profit analysis highlights the products making the largest contributions to overall profitability. These products can be considered key performers and may deserve greater attention when evaluating product strategy and sales performance.
4. Store Performance
4. Store Performance
The Top 10 Stores analysis compares stores based on revenue and profit, helping identify the locations making the strongest contribution to the business. This comparison provides a useful view of differences in store-level performance.
5. Monthly Performance
5. Monthly Performance
The monthly analysis shows how revenue and profit changed over time, making it easier to identify stronger and weaker periods. May recorded the highest monthly revenue in the analysis, highlighting an especially strong sales period.
6. Sales vs. Inventory
6. Sales vs. Inventory
The dashboard compares units sold with stock on hand to provide an overview of sales activity relative to available inventory. Inventory levels are higher than units sold across the analyzed products, making inventory monitoring an important part of ongoing performance analysis.
7. Profitability
7. Profitability
The overall 27.79% profit margin provides a high-level measure of how effectively revenue is being converted into profit. Comparing profitability across products, categories, stores, and periods can help identify areas with stronger financial performance.
Tools & Skills Used
Tools & Skills Used
Tools Feature/Purpose
Microsoft Excel Data analysis, calculations, and dashboard development
Power Query Data cleaning and transformation
Merge Queries Combined Related Datasets
Data Preparation Organizing the consolidated dataset for analysis
PivotTables Data aggregation and analysis
PivotCharts Interactive data visualization
Slicers Interactive filtering by key categories
Timeline Filtering and exploring data by date
Excel Calculation Calculating revenue, profit, and profit margin metrics
KPI Cards Displaying key performance metrics
Dashboard Design Presenting findings in an interactive, user-friendly format
Page updated
Google Sites
Report abuse