orders, region, categories dataset | PowerBI, PowerQuery, DAX
Chocolate Sales Analytics is a Power BI dashboard built to replace manual Excel reporting with fast, reliable, decision-ready insights across sales, profit, products, people, and regions.
What used to take 2+ hours every week now takes under 5 minutes, while surfacing actionable opportunities that directly improved profitability.
The sales team spent 2+ hours onmultiple Excel files to track revenue, products, and regional performance. Reporting required manual consolidation each week, making it slow, error-prone, and reactive.
As a result:
- Sales and profit were visible, but profitability by product was unclear
- High-revenue products were incorrectly assumed to be high-margin
- Regional performance issues surfaced late or not at all
- Identifying top sales performers required manual effort
- Leadership lacked a single, trusted source of truth
Decisions were based on partial insight instead of real-time data.
This Power BI dashboard replaces fragmented Excel reporting with a single, interactive analytics layer that delivers instant visibility into sales, profit, people, and markets.
It enables stakeholders to:
- Identify top products and salespeople
- Track profit margins
- Understand regional performance
- Monitor sales targets
-
Executive KPIs
- Total Revenue, Total orders, Total countries shipped and Boxes Sold
- Overall Profit Margin (65.13%)
-
Visual Insights
- Best selling Products by Sales and Profit margin
- Revenue & Profit by Region
- Sales Team Performance
- Sales Trends
-
Interactivity
- Date range filtering
- Product categories and region slicing
- PowerBI Desktop - Visualization and dashboard development
- DAX - Calculated columns and measures
- Power Query - Data transformation
- Data modeling
- Excel - Data sources
- Orders - 6114 records - Sales Person, Geography, Product, Date, Sales ($), Boxes
- Region - Product, Category, Cost per box
- Product categories - Geo (Country), Region
⭐ If this helped you, please star the repo!