01 / The brief

The question

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

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.

Results & observations

  • 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.

Challenges

  • 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

Approach

  1. I cleaned and prepared the toy sales dataset.
  2. I 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.
  3. I designed dashboard pages for sales overview, product analysis, and store insights.
  4. I added visual comparisons by store location, product category, day, city, product name, store name, and month.
Implementation details

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.

Explore the report

Select a screenshot for a larger view.