Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

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

Import Data Excel / CSV Transform Power Query Model & DAX Measures Dashboard Build & Test

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.
Best practice: Keep one transaction per row, use clear column names, and avoid merged cells or totals mixed into the source data.

3. Import and Clean the Data

  1. Open Power BI Desktop.
  2. Select Home → Get data → Excel or choose the CSV connector.
  3. Select the workbook and the required worksheet or table.
  4. Choose Transform Data to open Power Query Editor.
  5. Check column names, remove unnecessary blank rows, and review duplicates.
  6. Set OrderDate to Date, Quantity to Whole Number, and UnitPrice and Cost to Decimal Number or Fixed Decimal Number as appropriate.
  7. Choose Close & Apply to load the cleaned data.

Data Preparation Checklist

Before loading the model Column names are clear and consistent Dates and numeric fields have correct data types Blank rows and unexpected values are reviewed Totals are not stored as ordinary transaction rows

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

FactSales OrderID Quantity, Sales, Cost DimProduct Product, Category DimDate Date, Month, Year DimRegion Region, Territory DimSalesperson Employee, Team

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.

Important: Do not create relationships between unrelated columns simply because their values look similar. Incorrect relationships can cause duplicated totals or misleading results.

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 Sales = SUMX( FactSales, FactSales[Quantity] * FactSales[UnitPrice] )

Total Cost

Total Cost = SUMX( FactSales, FactSales[Quantity] * FactSales[Cost] )

Total Profit

Total Profit = [Total Sales] - [Total Cost]

Profit Margin

Profit Margin % = DIVIDE( [Total Profit], [Total Sales], 0 )

Total Orders

Total Orders = DISTINCTCOUNT(FactSales[OrderID])
Formatting tip: Format Total Sales, Total Cost, and Total Profit as currency. Format Profit Margin % as a percentage. Format Total Orders as a whole number.

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

SALES PERFORMANCE DASHBOARD Total Sales $125K Total Profit $32K Total Orders 1,240 Profit Margin 25.6% Monthly Sales Trend Sales by Region West East North Top Products LaptopMonitorKeyboard Report Filters YearRegionProduct

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

KPI Card $125K Total Sales Shows one key value Line Chart Shows change over time Bar Chart Compares categories

8. Add Slicers and Interactions

  1. Add a slicer using the Year or OrderDate field.
  2. Add a Region slicer and a Product slicer.
  3. Arrange slicers together in a clearly labeled area.
  4. Select a chart and use Format → Edit interactions to review how other visuals respond.
  5. Test whether selecting a region updates the KPI cards, product chart, and trend chart as expected.
Usability tip: Use descriptive chart titles, readable labels, consistent number formats, and a restrained color palette. Avoid filling the page with too many visuals.

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

Check Numbers Compare with source Test Filters Verify interactions Present Report Explain key findings

10. Practical Assignment

Build Your Own Sales Dashboard

Complete the following tasks in Power BI Desktop.

  1. Import a sales dataset with dates, products, regions, quantities, prices, and costs.
  2. Clean the dataset in Power Query and confirm the data types.
  3. Create Total Sales, Total Cost, Total Profit, Profit Margin %, and Total Orders measures.
  4. Build four KPI cards for Total Sales, Total Profit, Total Orders, and Profit Margin %.
  5. Add a monthly sales trend line chart.
  6. Add product and regional comparison charts.
  7. Add Year, Region, and Product slicers.
  8. Format the dashboard and test all slicers and chart interactions.
  9. 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.