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

Power BI Terminology

Understand the important Power BI words and concepts used throughout this course, with simple definitions, practical examples, and visual explanations for beginners.

1. Why Is Power BI Terminology Important?

Before learning Power Query, data modeling, DAX, and visualizations, you should understand the basic terms used in Power BI. These terms help you follow lessons, understand instructions, and work confidently with reports.

At CIIT TRANING INSTITUTE, learners can use the examples in this lesson to understand how common Power BI concepts work together in a practical business reporting scenario.

Example: A Sales Report

Samadhan receives an Excel file containing product sales. Pradnya helps check the data, Samiksha prepares a report layout, Neha checks the totals, Omkar reviews the results, and Nesha explores the report using filters.

This example introduces several terms you will learn: data source, Power Query, data model, measure, visual, report, filter, and dashboard.

Beginner tip: Learn the meaning of each term first. You will understand the practical operations more easily when you start building reports in Power BI Desktop.

2. Data Source, Dataset, and Semantic Model

Data Source

A data source is the original location from which Power BI obtains information. Examples include Excel workbooks, CSV files, databases, and supported online sources.

Dataset and Semantic Model

In Power BI, the term semantic model refers to the organized data, relationships, measures, and metadata used for reporting. Older Power BI learning materials often use the term dataset for this concept.

A source file and a semantic model are not the same thing. A source file contains the original data, while the semantic model organizes data for analysis.

Example

Samadhan stores sales records in SalesData.xlsx. The Excel workbook is the data source. After loading and preparing the relevant tables in Power BI, those tables can form part of a semantic model.

3. How Data Becomes a Report

The following illustration shows how source data moves through preparation and modeling before being displayed in a report.

Data Source Excel or CSV Database Power Query Clean data Transform data Semantic Model Tables Relationships Report Charts Tables and cards Each stage has a different role in preparing and presenting information.

Visual 1: The relationship between the source, transformation, model, and report.

4. Power Query and Data Transformation

Power Query is the data connection and transformation technology used in Power BI Desktop. It helps you prepare source data before loading it into the model.

Term Meaning Example
Query A set of instructions used to retrieve and transform data. Load and prepare a sales table.
Data Type Defines the kind of value stored in a column. Date, text, whole number, or decimal number.
Applied Steps The recorded transformation operations in a query. Remove columns, change types, filter rows.
Merge Queries Combines columns from related tables using matching values. Bring product names into a sales query.
Append Queries Combines rows from tables with compatible column structures. Combine January and February sales.
Remember: Merge is generally used to bring matching columns together. Append is generally used to add rows from one table to another.

5. Rows, Columns, Tables, and Relationships

Row

A row is one record in a table. In a sales table, a row might represent a single order or transaction.

Column

A column represents a field or attribute, such as Product, Region, OrderDate, Quantity, or SalesAmount.

Table

A table organizes information into rows and columns. Power BI models commonly contain fact tables and dimension tables.

Relationship

A relationship connects tables through related columns. For example, a Sales table and a Product table may both contain ProductID.

6. Understanding a Table and Its Relationship

Sales Table OrderID ProductID Sales 101 P01 45000 102 P02 30000 103 P01 15000 104 P03 5000 Product Table ProductID Product Name P01 Laptop P02 Monitor P03 Keyboard ID ProductID connects sales transactions to product details.

Visual 2: An example of a relationship between two tables.

Important: In a typical one-to-many relationship, ProductID should be unique in the Product table. Repeated ProductID values in the Sales table are expected because a product can appear in many transactions.

7. Measures, Calculated Columns, and DAX

DAX

DAX stands for Data Analysis Expressions. It is a formula language used for calculations in Power BI models.

Measure

A measure calculates a result based on the current filter context. Measures are commonly used for totals, averages, percentages, and business performance indicators.

Calculated Column

A calculated column creates a value for each row using a DAX expression. It can be useful when you need a calculated field for grouping, filtering, or relationships where appropriate.

Example DAX Measure

Suppose the sales table contains a column named SalesAmount. You can create a measure to calculate the total sales.

Total Sales =
SUM ( Sales[SalesAmount] )

This measure adds the values in the SalesAmount column. Its displayed result can change when report filters or slicers change the current filter context.

8. How Measures Work with Filters

A measure does not always show one fixed result. Its result can change according to the filters applied to a report or visual.

Total Sales Measure SUM of SalesAmount Region: North ₹45,000 Example result Region: South ₹30,000 Example result Region: West ₹15,000 Example result Illustrative values only; results depend on actual data.

Visual 3: The same measure can display different results for different regions.

Remember: Measures are evaluated in context. A region filter can change the total sales result without changing the measure formula itself.

9. Visualizations, Reports, and Dashboards

Visualization

A visualization, often called a visual, displays data graphically or in a structured format. Examples include bar charts, line charts, cards, tables, matrices, and maps.

Report

A report is an interactive collection of report pages containing visuals, filters, and other supported elements. It is commonly developed in Power BI Desktop.

Dashboard

In Power BI Service, a dashboard is a single-page canvas that can combine tiles from reports and other supported sources. It is different from a multi-page report.

Tile

A tile is an individual item displayed on a Power BI dashboard, often created by pinning supported report content or other supported information.

10. Understanding a Report and Dashboard

Report Sales Analysis May contain multiple report pages Dashboard Executive Overview Total Sales ₹90,000 Orders 120 One dashboard canvas Conceptual illustration, not an actual Power BI screenshot.

Visual 4: A report can contain multiple pages, while a Power BI dashboard is a single-page canvas in the Service.

Important difference: A report and a dashboard are not interchangeable terms. Reports support interactive analysis across report pages; dashboards summarize information on one canvas in Power BI Service.

11. Filters, Slicers, and Interactions

Term Meaning Example
Filter Restricts the data included in a visual, page, or report. Show sales for 2026 only.
Slicer A visual control that lets report users select values to filter data. Select a particular region.
Drill Down Moves through levels of a hierarchy in a visual. Year to quarter to month.
Drill Through Navigates to a detail page filtered for a selected item. Open a detailed page for one product.
Bookmark Captures a configured report state, depending on its settings. Return to a saved report view.

12. Refresh, Workspace, and Publishing

  • Refresh: Updates data from the configured source when refresh is supported and successfully completed.
  • Workspace: A place in Power BI Service where teams organize and manage Power BI content.
  • Publish: Sends supported report content from Desktop to a destination in Power BI Service.
  • Permissions: Determine who can view, edit, share, or manage content.
  • Gateway: A supported connection mechanism that can allow the Service to reach certain data sources located on private networks.
Practical example: Neha publishes a sales report to an approved workspace. Omkar receives access to view it, while authorized report owners maintain the report and configure data refresh as needed.

13. Quick Revision Table

Term Remember it as
Data Source Where the original data comes from.
Power Query Connect and transform data.
Semantic Model Organized data and model information for analysis.
Relationship A connection between related tables.
DAX Formula language for model calculations.
Measure A calculation evaluated in the current context.
Visualization A graphical or structured display of data.
Report An interactive collection of report pages.
Dashboard A single-page canvas in Power BI Service.
Slicer A visual control for filtering report data.

14. Beginner Practice Questions

Q1. What is a data source?

Answer: The original location from which data is obtained, such as an Excel workbook or database.

Q2. What is Power Query used for?

Answer: Connecting to, cleaning, and transforming data.

Q3. What does DAX stand for?

Answer: Data Analysis Expressions.

Q4. What is the difference between a report and a dashboard?

Answer: A report can have multiple pages and interactive visuals. A dashboard in Power BI Service is a single-page canvas.

Q5. What does a slicer do?

Answer: It allows a user to select values and filter report data.

Q6. What is a measure?

Answer: A calculation that returns a result based on its evaluation context, commonly used for totals and business metrics.

Summary

In this lesson, you learned the important vocabulary used in Power BI, including data sources, semantic models, Power Query, tables, relationships, DAX, measures, visualizations, reports, dashboards, filters, and slicers.

Understanding these terms will make the upcoming lessons at CIIT TRANING INSTITUTE easier to follow. You will use these concepts when connecting data, preparing tables, building models, creating calculations, and designing reports.