Back to Projects
Case Study
Data Analysis and Visualization

Mexico Toy Sales Dashboard

A Power BI dashboard that helps understand toy sales, revenue, profit, products, stores, and monthly business performance in Mexico.
Live Production AppDiscuss Project
Mexico Toy Sales Dashboard cover image

Key Metrics Analyzed

Total Revenue$14.44M
Total Profit$4.01M
Total Orders829K
Average Profit Margin27.79%
Average Order Value17.42
Total Stores50
Average Revenue Per Store$6.17K
Total Units Sold1M

Overview & Objectives

This project analyzes Mexico toy sales data using Power BI. It helps users understand sales revenue, total profit, order volume, profit margin, average order value, product performance, store performance, and city-level sales trends. The dashboard includes three report pages. The first page focuses on sales overview with revenue, profit, orders, product category performance, monthly revenue, profit by store location, and revenue by day. The second page focuses on product analysis with product pricing, cost, profitable products, revenue contribution, price distribution, and revenue by category over time. The third page focuses on store insights including total stores, revenue per store, top profitable stores, store locations, open date performance, and average monthly revenue by store location.

Project Goal

Build a clear Power BI dashboard that helps users explore toy sales performance, product profitability, category revenue, and store-level insights.

The Business Problem

Sales data can be difficult to understand when revenue, profit, orders, product categories, store locations, cities, and product pricing are analyzed separately. The business needed one clear dashboard to monitor sales performance, identify profitable products, compare store locations, and understand revenue trends across Mexico toy stores.
Methodology

My Approach

  • 1I cleaned and prepared the toy sales dataset.
  • 2I created Power BI measures for total revenue, total profit, total orders, average profit margin, average order value, product cost, units sold, and store-level revenue.
  • 3I designed dashboard pages for sales overview, product analysis, and store insights.
  • 4I added visual comparisons by store location, product category, day, city, product name, store name, and month.
Implementation

Roadmap Execution

Data Preparation

Cleaned and prepared the Mexico toy sales dataset for analysis.

Data Modeling

Created the Power BI data model for sales, products, categories, stores, cities, dates, revenue, profit, and orders.

DAX Development

Built measures for total revenue, total profit, total orders, average profit margin, average order value, product cost, units sold, and store revenue.

Sales Overview

Designed the sales overview page with revenue, profit, orders, product category, monthly trends, store location, and day-level analysis.

Product Analysis

Created product analysis visuals for pricing, costs, profitable products, category contribution, price distribution, and category revenue over time.

Store Insights

Built store insights visuals for total stores, revenue per store, top stores, store location performance, open date analysis, and monthly store revenue.

Key Features

Sales overview dashboard
Total revenue and profit tracking
Total orders by product category
Revenue by month
Profit by store location
Orders by month
Profit by month
Revenue by day
Product price analysis
Top profitable products
Product category revenue contribution
Product price distribution
Revenue by category over time
Store insights dashboard
Top profitable stores
Store performance by open date
Average monthly revenue by store location

Business Impact

Helps monitor toy sales performance in one place
Makes revenue and profit trends easier to understand
Shows which products and categories generate the most revenue
Supports better store and product decisions
Reduces manual retail reporting work by using one interactive Power BI dashboard

Challenges Overcome

  • Combining product, sales, orders, profit, store, city, and time data into one dashboard
  • Making sales performance easy to understand
  • Showing product profitability clearly
  • Comparing store locations and individual stores
  • Designing simple business visuals for quick retail decisions
Outcomes

Final Outcomes & Learnings

  • The final dashboard gives a clear view of sales revenue, profit, orders, product performance, and store performance.
  • Users can quickly identify high-revenue categories, profitable products, strong store locations, top stores, and monthly sales trends.

Project Gallery & Screenshots

Power BI Mexico toy sales dashboard showing sales overview with revenue, profit, orders, product categories, monthly trends, store locations, and day revenue
Power BI Mexico toy sales dashboard showing product analysis with product costs, profitable products, price distribution, and category revenue over time
Power BI Mexico toy sales dashboard showing store insights with total stores, revenue per store, top profitable stores, store locations, and monthly store revenue

Technologies Used

Power BIPower QueryDAXExcelData ModelingData Visualization

Data Sources

Mexico toy sales datasetProduct sales dataStore location dataProduct category dataMonthly revenue dataProfit and order dataStore performance data

Need similar outcomes in your business?

Let's scope your metrics and construct dashboards tailored to your parameters.

Discuss Similar Projects