Sales Performance Analytics Dashboard

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