Empower your team to turn data into impactful business strategies.
Streamline data workflows and improve decision-making speed.
Keep your business ahead with advanced data visualization and reporting tools.
01 Introduction
What is Power BI?
The Building Blocks of Power BI
The Power BI Desktop Interface
Important Information About Power BI Updates
The Power BI Web App
02 Working with Power BI Desktop Files
Opening Files
Saving Files
Creating a New File
Publishing to the Power BI Web App
03 Connecting to Data Sources with Power BI Desktop
Connecting to an Excel Workbook
Connecting to an Access Database
Viewing All Connection Options
Creating a Manual Dataset
Managing Data Sources
04 Data Structure and Data Normalization Power BI Data Model
Power BI Data Types
Making data fitted to the Data Model
Discovering different Data Formats
05 Introduction to Power Query
Overview of Power Query
Benefits of using Power Query
Differences between Power Query and other data extraction tools
06 Basic Data Transformation
What is Data Transformation?
Role of Power Query in Data Transformation
Basic Transformation through Data types, Filters, and Removing Columns
07 Advanced Transformations
Using Power Query functions (text, date, time, number, etc.)
Implementing custom functions in Power Query
Grouping and aggregating data
Using conditional transformations
Unpivoting and pivoting data
Dealing with large data sets and performance optimization
08 Working with Advanced Data Sources
Consolidate Excel or CSV files using “From Folder” source
Extracting data from APIs using Power Query
Web scraping using Power Query
Extracting and Linking from PDF
Dealing with complex data structures
09 Managing Relationships in the Data Model
Using the Relationships View
Creating Relationships
Editing Relationships
Deleting Relationships
Using the Manage Relationships Dialog
10 Intro Data Analysis eXpressions (DAX)
Overview of DAX, its syntax, and structure
Understanding the role of DAX in data analysis and reporting
Creating a New Calculated Column
Creating a New Measure
Using DAX functions for data manipulation and aggregation
11 Visualization
Overview of Visualization
Introduction on Report Pages
Adding Table and Matrix
Adding a Column Chart
Configuring Visualization
12 Visual Interactions and Filters
Introduction to Visual Interactions
Turning Interactions On and Off
Interacting by Filtering, Highlight or None
Working with Filters
The Filter pane
Slicers
13 Creating Dashboards
Reports to Dashboards
Pin Visualizations
Refreshing Dashboard
Defining Hyperlinks
Using Bookmarks for more
Interactions
14 Publishing to Power BI Service (Fabric)
Log in to Microsoft 365 and access Power BI Service (Fabric)
Explore the Power BI Service Environment
Publishing Power BI Report
Sharing your Power BI Report
