An interactive Power BI Retail Analytics Dashboard for TechMart — analyzing sales performance, profit margins, regional distribution, and product-level insights across categories and customer segments.
Tools: Power BI Desktop · DAX · Data Modeling
| File | Description |
|---|---|
Tech_Mart_Test.pbix |
Power BI dashboard file with all visuals, data model, and DAX measures |
techmart_dashboard.jpg |
Dashboard screenshot for quick preview |
- Track total sales, profit, quantity sold, and order count across years
- Analyze monthly sales trends to identify seasonal peaks and dips
- Compare regional performance (East, Central, West, South)
- Break down sales by category — Furniture, Technology, Office Supplies
- Identify the Top 10 best-selling products by sales value
- Visualize country-wise sales distribution on an interactive map
| KPI | Value (2022) |
|---|---|
| 💰 Total Sales | 2.08 Million |
| 📦 Total Profit | 150.78K |
| 🛍️ Total Quantity Sold | 4,430 |
| 🧾 Total Orders | 806 |
- May is the peak month — highest sales at 0.22M
- January starts low at 0.13M, with a clear ramp-up through mid-year
- A secondary peak appears in August–September (0.20M) before year-end slowdown
- Bookcases lead at 16K, followed closely by Phones and Tables (12K each)
- Accessories and Storage items form a competitive mid-tier at 9–10K
- Laptops appear twice in the top 10, confirming strong Technology category demand
- All four regions (East, Central, West, South) show comparable sales volumes (~0.5M each)
- East region leads slightly in both sales and profit
- Profit margins are thin across all regions — visible from the small yellow profit bars vs. orange sales bars
- Technology dominates at 36.24% (751.98K)
- Office Supplies follow at 33.07% (686.28K)
- Furniture trails at 30.69% (636.84K)
- Category split is fairly balanced — no single category overwhelmingly dominates
- Sales span North America, Europe, and South America
- Strongest concentration in the United States and Europe
- Emerging presence in South America suggests untapped growth potential
- Power BI Desktop — Dashboard design, data modeling, interactive visuals
- DAX (Data Analysis Expressions) — KPI calculations for Total Sales, Profit, Quantity, Orders
- Data Modeling — Relationships between sales, product, region, and time tables
- Data Analysis — Trend analysis, category segmentation, regional comparison, geo mapping
- 4 interactive slicers — Category, Customer Segment, Region, Year
- Monthly trend line chart — Full-year sales pattern view
- Stacked bar chart — Regional Sales vs. Profit side-by-side
- Donut chart — Category-wise sales composition
- Horizontal bar chart — Top 10 products ranked by sales
- Map visual — Country-wise sales bubble map
TechMart Retail Dataset (Sales Transactions)
↓
Data Cleaning & Modeling in Power BI
↓
DAX Measures (Sales, Profit, Quantity, Orders)
↓
Interactive Dashboard (Slicers: Category, Region, Segment, Year)
↓
Stakeholders: Retail Managers, Sales Teams, Business Executives
Romaan Uddin Siddiqui — Aspiring Data Analyst
📍 Bhopal, Madhya Pradesh
🔗 GitHub Profile
Feel free to open an issue or connect via GitHub with questions or suggestions.