Category: Business Intelligence / Sales Analytics
Tools: Power BI, DAX, Data Modeling
Overview
A multi-page Power BI dashboard built to track order performance, sales trends, and problem-order risk across product lines, customers, and regions.
Data Model & Approach
Structured a relational model with TBL_Measure, Fact_Sales, and Dim_Product tables. Wrote DAX measures covering total sales, shipped vs. unshipped orders, order/product/customer counts, and a benchmarked Problem Orders % KPI.
Key Features
Sales Overview page: product line, customer, and deal-size breakdowns with a sales-vs-quantity scatter analysis
Problem Orders page: KPI gauge against target, geographic map by country, Key Drivers visual identifying root causes of order issues
Skills Demonstrated
DAX measure design · KPI/target tracking · geographic visualization · root-cause analysis · multi-page dashboard architecture
