Project Overview
An interactive Power BI sales dashboard for Teghs Company — tracking revenue performance, product category trends, regional sales distribution, and sales rep productivity.
Technical Build
- Data Model: Star schema with a central sales fact table linked to date, product, customer, and region dimension tables
- Power Query: Data cleaning and transformation — merged datasets from multiple sources, handled date discrepancies, created calculated columns
- DAX Measures: YTD Revenue, MoM Growth %, Running Total, Top N Products filter, and custom KPI calculations
- Visuals: Revenue trend (line chart), regional heatmap, product performance matrix, and KPI cards with conditional formatting
Key Business Questions Answered
- Which regions are over- or under-performing against target?
- What is the month-over-month revenue trend by product category?
- Which sales reps are driving the most revenue this quarter?
Skills Demonstrated
End-to-end BI development: data modeling, ETL in Power Query, DAX authoring, and dashboard UX design for executive audiences.