RetailX Analytics Dashboard
Power BISQLData Modeling
The Problem
RetailX needed clearer visibility into sales performance across regions and product lines to identify areas of underperformance.
The Approach
I performed multi-table SQL joins and CTEs across 4+ tables to create an analysis-ready dataset. I then developed a star-schema Power BI model linking sales, product, and customer dimensions, and implemented DAX measures to track performance.
The Result
The dashboard revealed that just 2 product lines drove over 60% of total sales, and drill-through reports successfully isolated the specific regions tied to a 30% revenue gap.