Superstore Analytics

Designed and developed a high-end, multi-page "Clean Dark" Executive Dashboard for retail performance tracking using Power BI and a robust star schema data model. Built to prioritize rapid executive digestion, the portal features a dynamic home landing page with custom HTML/CSS alert cards, transparent button navigation overlays, and real-time KPI monitoring. Key findings uncovered critical operational insights: while product categories like Phones and Copiers drive strong revenue, specific sub-categories like Tables and Bookcases incur heavy net losses, and aggressive discounting past 20% severely erodes profit margins below zero. The dashboard also highlights customer segmentation trends—where the Consumer segment commands 46.8% of total profit—and isolates key account risks to drive immediate executive action.