Sales Performance Dashboard Mancha Skins
As part of my work for Mancha Skins, I developed a comprehensive Power BI dashboard to analyze and visualize sales data from November 2024 to June 2025. The goal was to transform raw sales data into meaningful insights to support strategic business decisions, marketing focus, and inventory management.
Project Objectives:
-
Identify top-performing products and revenue drivers.
-
Visualize monthly sales trends to track growth and seasonality.
-
Analyze geographic distribution of sales for targeted marketing.
-
Provide a user-friendly, interactive tool for business owners.
Key Insights Delivered:
-
Total Revenue: $3,800, with the Odin 2 Mini Full Wrap skin accounting for ~$2,200 (57.77% of revenue).
-
Total Units Sold: 153 units, with Odin 2 Mini variations leading sales volumes.
-
Sales Trend Analysis: Clear visualization of month-by-month sales from Nov 2024 through June 2025, helping pinpoint periods of growth and potential slowdowns.
-
Geographic Insights: Sales distribution mapped across different countries, providing insights into emerging markets and regional demand.
-
Product Performance Breakdown: Detailed revenue analysis per product to identify opportunities for inventory optimization and promotional strategies.
Skills and Tools Used:
-
Data Cleaning & Preparation:
-
Microsoft Excel for initial data organization and cleaning.
-
Data transformation techniques (removing duplicates, correcting inconsistent product names).
-
-
Data Visualization & Analytics:
-
Power BI Desktop to build interactive dashboards.
-
Creation of:
-
Bar charts for product revenue breakdown.
-
Line graphs for sales trends over time.
-
Map visualizations for geographic sales distribution.
-
KPI cards for total revenue and units sold.
-
-
-
Data Modeling:
-
Power Query for loading and transforming raw CSV/Excel data.
-
DAX (Data Analysis Expressions) to create calculated columns and measures (e.g. total revenue, percentage contribution).
-
-
Dashboard Design:
-
User-friendly layout focusing on readability and business storytelling.
-
Consistent color palette matching Mancha Skins’ brand identity.
-
Interactive filters to allow customized views of data.
-
-
Reporting & Communication:
-
Data storytelling to translate technical insights into actionable business recommendations.
-
Design of export-ready visuals suitable for presentations and stakeholder reports.
-
This project significantly improved Mancha Skins’ ability to monitor sales performance, identify key revenue drivers, and make data-driven decisions for marketing and inventory planning. It also reduced the time required for manual reporting, enabling the business to focus on growth and strategy.
