ElectroHub is a production‑ready Power BI dashboard for analyzing multi‑category retail sales data for a fictional e‑commerce company. It uses a Star Schema data model and advanced DAX measures to deliver interactive business insights across 9 product categories and 24 months of sales history.
- Industry: E‑Commerce / Retail Analytics
- Company: ElectroHub (fictional)
- Data: 24 months of historical sales transactions
- Users: Executives, Sales Managers, Data Analysts
- Objective: Real‑time monitoring of sales, profit, and discounts with self‑service analytics
- Top and Bottom 5 products by Sales, Profit, and Quantity Sold
- Sales trends over time at daily, monthly, quarterly, and yearly levels
- Visual relationship between Sales and Profit (correlation analysis)
- Comparison of Sales / Profit / Quantity between two user‑selected periods
- Average discount by discount category and its impact on profitability
- KPI for Total Number of Orders
- Order‑level detail table showing Sales, Profit, Discount, Net Sales with filters for Product, Date, Customer, and Promotion
- Sales performance by City with geographic insights
- Model Type: Star Schema
- Fact Table: Sales (Sales Amount, Profit, Quantity, Discount, Net Sales, Date, Customer, Product, Promotion keys)
- Dimension Tables:
- Product (Product, Category, Sub‑category, Brand, etc.)
- Customer (Customer, City/Region, Segment)
- Date (full calendar with Year, Quarter, Month, Day)
- Promotion (Promotion, Discount Category, Rate, Period)
- Relationships: One‑to‑Many from each dimension to the Sales fact table
- Benefits: Simple analytics, scalable model, fast aggregation, and clean filter propagation
- Power BI Desktop – Data modeling and report design
- Power Query – ETL (data cleaning, shaping, and loading)
- DAX (Data Analysis Expressions) – Calculated measures and time‑intelligence metrics
- Excel / CSV / Database – Source data for sales and dimensions
- Git & GitHub – Version control and project hosting (for this repository)