👋👋 Hello, I'm Cheikh Abdou Seye, and I'm passionate about the dynamic world of data engineering, management, and visualization.
I'm excited to share my latest personal Power BI project - a robust Sales Performance Dashboard, crafted entirely using native visuals only! This dashboard provides deep insights into sales data from a fictitious metropolitan French retail grocery company.
-------------
⚠️ Disclaimer
Please note that the datasets used to showcase this Sales Performance Dashboard were randomly generated using ChatGPT and are intended for demo purposes only. The sales representatives' names displayed are also fictitious. Any resemblance to real persons or businesses is purely coincidental.
-------------------------------------- Business rules --------------------------------------
All visuals are conditionally formatted based on these 4 rules:
- Leaders (green): meet or exceed both Revenue Performance Target (95%) and Gross Margin Target (45%)
- Revenue Performers (R-p) (yellow): meet or exceed Revenue Performance Target (95%) only
- Gross Margin Performers (GM-p) (orange): meet or exceed Gross Margin Target (45%) only
- Need Help (red): Not meet both Revenue Performance Target (95%) and Gross Margin Target (45%)
-------------------------------------- Key Features --------------------------------------
📈 KPIs: shows Actual vs Target, trends, and comparison against precious period (MoM and YoY)
- New card combined with SVG styling (gradient sparkline)
- New card combined with SVG styling (comparison)
- Dynamic number formatting (G, M, k, etc.)
🗺️ Maps:
- Shape map with custom metropolitan French regions and department maps (topoJSON)
- Conditional formatting based on Revenue performance & Gross margin.
- In-Page bookmark for a toggling map view change (Region vs Departement)
🧾 Table: shows a ranking (top-to-bottom) of Revenue performance & Gross margin, by Product and Sales managers (Departement and Region)
- SVG Sparkline to show Revenue trend (last 60 days)
- SVG Styling with Conditional formatting by Products and Sales Manager (Departement and Region)
- Slicer built with Field parameter.
📉 Magic Quadran: shows Product and Sales Manager in 4 clusters (Leaders, R-p; GM-p and Need Help)
- Scatter chart
- Conditional formatting based on Revenue performance & Gross margin.
📊 Audio Wave: shows the variance between Revenue Target and Actuals
- Error bar
- Conditional formatting based on Revenue performance & Gross margin.
- Slicer built with Field parameter for Period selection (D, W, M, Q, Y)
--------------------------
The user-guided tour is entirely crafted with native Power BI elements (button, rectangle, speech bubble, and line) and bookmarks
--------------------------
I hope this dashboard is useful and inspiring!
If you like the dashboard features, please leave a comment and/or give a kudo! 👍
