Sales Dashboard Project
In this practical project, you will build an interactive sales dashboard using Power BI Desktop. You will organize sales data, create business calculations, design visualizations, and present important findings through a single report page.
Project Scenario
You are a Power BI developer at CIIT TRANING INSTITUTE. The management team wants to understand sales performance across products, regions, sales representatives, and months.
Your task is to create a dashboard that helps managers answer: How much revenue was generated? Which products performed best? Which regions need attention? How are sales changing over time?
1. Project Objectives
- Import and inspect a sales dataset.
- Clean column names, data types, and missing values.
- Create a suitable data model.
- Build DAX measures for sales performance.
- Design clear charts, cards, and slicers.
- Test report interactions and validate the results.
Project Workflow
2. Prepare the Sales Dataset
Start with an Excel workbook or CSV file containing one row for each sales transaction. For this project, use a dataset with fields similar to the following example.
| Column | Example | Purpose |
|---|---|---|
| OrderID | ORD1001 | Identifies each order. |
| OrderDate | 2026-01-15 | Supports monthly and yearly analysis. |
| Product | Laptop | Allows product comparisons. |
| Region | West | Supports regional analysis. |
| Salesperson | Samadhan | Supports employee performance analysis. |
| Quantity | 3 | Records units sold. |
| UnitPrice | 25000 | Records price per unit. |
| Cost | 18000 | Supports profit calculations. |
3. Import and Clean the Data
- Open Power BI Desktop.
- Select Home → Get data → Excel or choose the CSV connector.
- Select the workbook and the required worksheet or table.
- Choose Transform Data to open Power Query Editor.
- Check column names, remove unnecessary blank rows, and review duplicates.
- Set OrderDate to Date, Quantity to Whole Number, and UnitPrice and Cost to Decimal Number or Fixed Decimal Number as appropriate.
- Choose Close & Apply to load the cleaned data.
Data Preparation Checklist
4. Create the Data Model
For a small practice dataset, a single sales table may be sufficient. For a larger project, use a star schema with a central fact table and separate dimension tables.
Example Star Schema
In Model view, create one-to-many relationships from dimension tables to FactSales using the matching keys. Ensure that the dimension-side keys are unique and that date relationships use compatible data types.
5. Create DAX Measures
Measures calculate results based on the current filter context. Select the sales table, choose New measure, and create measures similar to these examples. Adjust table and column names to match your model.
Total Sales
Total Cost
Total Profit
Profit Margin
Total Orders
6. Design the Dashboard Layout
Use a consistent layout so managers can find the most important information quickly. Keep the main performance indicators near the top, followed by trends and detailed comparisons.
Suggested Sales Dashboard Wireframe
The figures shown in this wireframe are illustrative. Your actual values will depend on the dataset you load.
7. Add the Required Visualizations
| Visual | Fields or measures | Business question |
|---|---|---|
| Card | Total Sales | What is the total revenue? |
| Card | Total Profit | How much profit was generated? |
| Card | Total Orders | How many distinct orders were placed? |
| Line chart | OrderDate or Month, Total Sales | How does sales performance change over time? |
| Bar chart | Product, Total Sales | Which products generate the most sales? |
| Bar or column chart | Region, Total Profit | Which regions are most profitable? |
| Slicer | Year, Region, Product | How can users explore a subset of the data? |
Choosing the Right Visual
8. Add Slicers and Interactions
- Add a slicer using the Year or OrderDate field.
- Add a Region slicer and a Product slicer.
- Arrange slicers together in a clearly labeled area.
- Select a chart and use Format → Edit interactions to review how other visuals respond.
- Test whether selecting a region updates the KPI cards, product chart, and trend chart as expected.
9. Validate the Dashboard
Before presenting the report, verify that the measures and interactions produce reliable results.
- Compare Total Sales against a trusted total from the source dataset.
- Check that Total Orders counts distinct OrderID values.
- Verify that Profit equals Total Sales minus Total Cost.
- Test each slicer individually and in combination with other slicers.
- Confirm that dates appear in chronological order.
- Check titles, currency formats, percentage formats, and spelling.
- Ensure no visual is clipped or difficult to read.
Final Quality Check
10. Practical Assignment
Build Your Own Sales Dashboard
Complete the following tasks in Power BI Desktop.
- Import a sales dataset with dates, products, regions, quantities, prices, and costs.
- Clean the dataset in Power Query and confirm the data types.
- Create Total Sales, Total Cost, Total Profit, Profit Margin %, and Total Orders measures.
- Build four KPI cards for Total Sales, Total Profit, Total Orders, and Profit Margin %.
- Add a monthly sales trend line chart.
- Add product and regional comparison charts.
- Add Year, Region, and Product slicers.
- Format the dashboard and test all slicers and chart interactions.
- Write three business observations based on the results in your actual dataset.
Submission Checklist
- Power BI report file (.pbix).
- Screenshot of the completed dashboard.
- List of DAX measures used.
- Three findings supported by the report data.
- A short explanation of any data cleaning performed.
11. Knowledge Check
Question 1: Why should data types be checked before creating visuals?
Correct data types help Power BI interpret dates, numeric values, and text correctly. Incorrect types can cause sorting, calculation, and aggregation problems.
Question 2: Which visual is suitable for displaying a monthly sales trend?
A line chart is generally suitable because it shows how a measure changes across a sequence of dates or months.
Question 3: What is the purpose of a DAX measure?
A measure calculates an aggregated result based on the current filter context, such as Total Sales or Total Profit.
Question 4: How can you verify that a dashboard is accurate?
Compare key totals with the source data, verify calculation logic, and test slicers and interactions using different filter selections.
Question 5: Why are slicers useful?
Slicers allow users to filter the report by fields such as year, region, and product so they can explore relevant parts of the data.
Summary
In this project, you learned how to build a practical sales dashboard using Power BI Desktop. The process includes importing and cleaning data, designing a model, creating DAX measures, choosing suitable visualizations, adding slicers, and validating report accuracy.
- Prepare reliable data before building visuals.
- Use measures to calculate important sales KPIs.
- Choose charts according to the business question.
- Use slicers and interactions to make the report interactive.
- Validate the results before sharing the dashboard.
A successful dashboard is not only visually clear; it also provides accurate, relevant information that supports business decisions.