Classic Models Sales Dashboard (Power BI)
An interactive Power BI dashboard designed to explore sales performance, customer trends, product categories and revenue drivers, using a clean star schema and DAX measures.
Problem
Create a business-ready reporting dashboard that helps stakeholders answer questions such as: Which products drive revenue? Which customers and regions perform best? How do sales trends change over time?
Data
- Dataset: Classic Models (sales, orders, customers, products)
- Entities: customers, orders, order details, products, employees and offices.
- Preparation: data cleaning, relationship mapping, data types, date table creation.
Methods
- Data model: star schema approach for reliable analytics
- DAX: measures for revenue, profit, YoY/period comparisons, KPIs
- Visuals: KPI cards, trend lines, category breakdowns, customer ranking, slicers for exploration
- UX: clear layout, filters for product line, region, date and customer segments
Results
- Delivered a dashboard that supports quick performance monitoring and drill-down analysis
- Enabled identification of top products and sales trends over time
- Provided consistent KPIs through a structured model and reusable measures