Sales Dashboard Walkthrough
Power BI · Projects & Case Studies
Theory
This walkthrough builds the course's sample sales report end to end. The business wants to know total sales, which regions and products lead, and how sales trend by month. The data is three tables: Sales (OrderID, OrderDate, CustomerID, ProductID, Region, Qty, Amount), Customers (CustomerID, Name, City, Segment) and Products (ProductID, Product, Category, Price), plus a DAX 'Date' table.
After loading and typing the columns in Power Query, you relate the dimensions to Sales, mark the Date table, and write the core measures. With the six sample orders the KPI cards read Total Sales ₹6,200, Orders 6, Total Qty 10 and Avg Order Value ₹1,033.33, and the top region is North with ₹3,200. The Overview page shows these cards, a monthly trend (Jan ₹1,200, Feb ₹2,300, Mar ₹2,200, Apr ₹500), a region bar chart and a category matrix. A drill-through Customer page shows each customer's orders, and the report is published and shared as an app.
Why we use it
Seeing every step in one connected example shows how Power Query, modeling, DAX and visuals depend on each other, which isolated lessons cannot.
When to use it
Follow this walkthrough after the earlier sections, then rebuild it on your own dataset. Use it as a template for interview take-home tasks, which usually ask for exactly this kind of small sales dashboard.
How it works
- Business asks for a sales dashboard
- Load and clean Sales, Customers, Products
- Create the Date table and relationships
- Write core measures and check totals
- Design Overview and drill-through pages
- Do totals match the source (₹6,200)? Yes: Publish and share as an app. No: Debug measures and relationships.
- Dashboard in users' hands
Syntax
Steps:
1. Get data → Text/CSV ×3 → Transform data (types, trim)
2. Modeling → New table: Date = CALENDAR(...) → Mark as date table
3. Model view: Customers 1→* Sales, Products 1→* Sales, Date 1→* Sales
4. Home → New measure (core KPIs)
5. Build pages → Publish → Create appExample
Total Sales = SUM(Sales[Amount]) // 6,200
Orders = DISTINCTCOUNT(Sales[OrderID]) // 6
Total Qty = SUM(Sales[Qty]) // 10
Avg Order Value = DIVIDE([Total Sales], [Orders]) // 1,033.33
Top Region =
CONCATENATEX(
TOPN(1, VALUES(Sales[Region]), [Total Sales]),
Sales[Region], ", "
) // North
Page 1 Overview: 4 cards, line chart by 'Date'[Month], bar chart by Region, matrix Category → Product
Page 2 Customer Detail: drill-through on Customers[Name]Key points
- Start from business questions, not visuals
- Type columns and remove unused ones in Power Query
- Relate all dimensions to Sales and mark the Date table
- Build core measures first, then reuse them everywhere
- Reconcile totals with the source before publishing