on-demand course

Microsoft Power BI - A Complete Introduction [2023 EDITION]

with Academind by Maximilian Schwarzmüller GmbH, Manuel Lorenz

June 2022

Beginner to intermediate

17h 41m

English

Packt Publishing

Closed Captioning available in German, English, Spanish, French, Italian, Japanese, Korean, Chinese (Simplified)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Welcome to This Course
3m 12s
Module Introduction
55s
What Is Power BI?
5m 46s
Installing Power BI Desktop
3m 33s
Connecting Power BI Desktop to Source Files
10m 7s
Creating Our First Visuals
7m 34s
Comparing Excel and Power BI
3m 20s
Course Outline
5m 30s
The Two Ways (Paths) of Taking This Course
2m 22s
How to Get the Most Out of This Course
3m 15s
Important: How to Access Course Resources, Project Files, and Slides
9m 48s
Module Introduction
1m 26s
The Power BI Desktop Workflow
5m 15s
Interface Tour
9m 28s
Important! Creating the Project Template and Recommended Settings
5m 38s
Module Introduction
1m 12s
Understanding Data Preparation / Cleaning / Cleansing
4m 50s
Connecting Power BI Desktop to Source Files
10m 36s
How Power BI Queries Data
5m 1s
Understanding Basic Row Operations
9m 7s
Filtering Data
6m 0s
Analyzing Columns and Removing Blank Fields
11m 0s
Understanding and Using the Append Feature
8m 28s
Choosing and Removing Columns
7m 6s
Append Behind the Scenes
2m 50s
Understanding the Transpose Feature
2m 58s
Replacing Values
7m 36s
Working with Dates - The Basics
6m 50s
Understanding Data Formats
5m 50s
Handling Data Format Errors
8m 19s
Understanding Pivoting and Unpivoting
4m 30s
Applying Pivoting and Unpivoting
3m 56s
Fixing a Sorting Problem
2m 11s
Extracting Data, Splitting Columns, and Sorting Multiple Columns
9m 24s
Introducing the "Group By" Feature
4m 20s
Improving the Project Structure
3m 16s
Wrap Up
3m 6s
Module Introduction
57s
Data Warehouse, Data Model, and Data Schema
5m 45s
The Star Schema - Theory
6m 14s
Applying the Star Schema to Our Project
2m 26s
Understanding References
4m 7s
Comparing References and Duplicates
6m 40s
Importing Country and Region Codes
7m 54s
Using "Enter Data" to Create a Table
3m 2s
Understanding the Merge Feature
3m 29s
How to Join Tables
3m 19s
Understanding Outer, Inner, and Anti Joins
5m 37s
Join Kind in Practice
5m 2s
Handling Merge Errors
11m 31s
Understanding the DIM-age Table
3m 26s
Bringing Back the "age-group" Column
4m 41s
Getting the Maximum Values from Each Age Group
3m 31s
Creating Conditional Columns
7m 23s
Creating an Index Column
2m 26s
Creating a DIM-gender Table
3m 17s
Understanding the FACT Table
3m 2s
Finishing the FACT Table
8m 50s
Applying Basic Mathematical Operations
2m 31s
Using the Enable Load Feature
6m 59s
Wrap Up
2m 46s
Query Editor – Assignment Problem
54s
Query Editor – Assignment Solution
10m 23s
Module Introduction
1m 26s
Query Editor Versus Data Model
4m 40s
Understanding Relationships
2m 35s
Creating Our First Relationship
9m 59s
Understanding Cardinality and Difference Relationship Types
2m 23s
One to Many and Many to One
2m 23s
One to One
1m 38s
Many to Many
3m 28s
Fixing the Column Order Bug
3m 34s
Understanding the Cross-Filter Direction
11m 16s
Understanding Active Properties
1m 41s
Adding Relationships to the Project
6m 57s
M-Language Versus DAX (Data Analysis Expressions)
4m 18s
Creating a Custom Column with the M-Language
6m 30s
Creating a Calculated Column with DAX
7m 1s
M Versus DAX - What Should I Choose?
2m 25s
The DAX Basics
3m 0s
The Core DAX Syntax
4m 1s
DAX Data Types
3m 0s
DAX Operators
4m 55s
DAX Core Functions
4m 20s
Creating a Table with the CALENDAR Function
11m 48s
Extracting Data with the DOT Notation
4m 5s
Adding and Dividing Columns
8m 1s
Working with IF Functions
6m 43s
Understanding Relationship Functions
4m 40s
Calculated Column Versus Measure
1m 51s
Understanding and Creating Measures
5m 14s
Working with FILTER and CALCULATE Functions - Theory
5m 45s
Combining CALCULATED and FILTER Functions
9m 11s
Adding the Filter Condition to CALCULATE
3m 32s
Using Measures in Measures
4m 25s
Changing the Measure's Home Table
4m 21s
Understanding the Data Category
3m 0s
Wrap Up
2m 40s
Data Model and RelationshipView – Assignment Problem
1m 0s
Data Model and RelationshipView – Assignment Solution
14m 44s
Module Introduction
1m 3s
The Power BI Workflow and Understanding Basic Visual Elements
4m 49s
Creating and Duplicating Pages
2m 8s
Organizing Visuals
6m 3s
Creating a New Visual
3m 0s
Creating Line and Column Charts
7m 3s
How FILTER Affects the Visual
6m 40s
Understanding Interactions
5m 23s
Hierarchies and Drill Down
7m 31s
Formatting Chart Colors
7m 50s
The Canvas
3m 0s
Formatting the Page Background / Wallpaper
2m 37s
Formatting the Filter Pane and Filter Cards
7m 17s
Formatting Visuals: General Settings
4m 42s
Diving Deeper into Formatting Visuals
8m 4s
Working with Report Themes
7m 13s
Finishing the Report Theme
2m 24s
Understanding the Slicer
9m 36s
Default Summarization and Sorting Order
4m 20s
Creating Treemaps and Working with Multiple Slicers
6m 36s
Creating Tables
6m 36s
Syncing Slicers
3m 12s
Filter on Visual, Page, and Report Level
9m 48s
Creating Single and Multi-Row Cards
7m 48s
Adding a Secondary Y-Axis
4m 35s
Combining Column and Line Charts
2m 51s
The Waterfall Chart
3m 12s
Importing Visuals
2m 19s
Finishing Touches
5m 10s
Wrap Up
4m 25s
Report Visualizations – Assignment Problem
50s
Report Visualizations – Assignment Solution
10m 5s
Module Introduction
1m 52s
The Next Steps
4m 58s
Power BI Pro Pricing
4m 14s
Power BI Pro Interface Tour
6m 38s
Publishing and My Workspace - Theory
3m 19s
Publishing/Importing Power BI Desktop Projects to Pro
4m 10s
Datasets Walkthrough
4m 26s
List View Versus Lineage View
4m 3s
Exploring Reports in Pro
4m 47s
Understanding Dashboards
7m 21s
Creating Reports and Dashboards
7m 32s
Diving Deeper into "My Workspace", Understanding Refresh and a Refresh Error
4m 34s
Gateways - Theory
1m 40s
Gateways: Configuring Manual and Scheduled Refresh
11m 53s
Sharing Data from "My Workspace" Through Direct Access
13m 45s
Sharing Links
5m 42s
Understanding Collaboration Workspaces - Theory
1m 38s
Creating Collaboration Workspaces
8m 10s
Sharing Data Through Apps
1m 39s
Publishing and Unpublishing Apps
9m 21s
Deleting Collaboration Workspaces
1m 15s
Workspaces Versus Apps
2m 19s
Working with Power BI Mobile
5m 48s
Wrap Up
2m 48s
Module Introduction
1m 22s
Importing JSON Data
6m 28s
Importing Data from REST APIs
5m 1s
Preparation: Setting Up a MySQL Server
8m 9s
Importing Data from a MySQL Server (and Other SQL Servers)
6m 38s
Wrap Up
56s
Module Introduction
43s
Helpful Resources
5m 2s
Using Preview Features
1m 17s
Congratulations!
6m 36s

Content preview from Microsoft Power BI - A Complete Introduction [2023 EDITION]

Adding a Secondary Y-Axis

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft Power BI - The Complete Masterclass - 2025 EDITION

Nikolai Schuler

Power BI Masterclass

Dan We

Power BI Masterclass - Beginners to Advanced

Dan We

Learning Microsoft Power BI

Reid Havens

Publisher Resources

ISBN: 9781789959031Supplemental Content

Microsoft Power BI - A Complete Introduction [2023 EDITION]

with Academind by Maximilian Schwarzmüller GmbH, Manuel Lorenz

Chapter 1 : Getting Started

Chapter 2 : Understanding the Power BI Desktop Basics and Preparing the Course Project

Chapter 3 : Data Preparation in the Power Query Editor

Chapter 4 : Data Transformation in the Power Query Editor

Chapter 5 : The Data Model - Working with Relationships and DAX (Data Analysis Expressions)

Chapter 6 : Creating Visuals in the Report View

Chapter 7 : Power BI Pro and Mobile: Sharing and Collaborating with Workspaces and Apps

Chapter 8 : Other Data Sources

Chapter 9 : How to Stay Up-To-Date in the Power BI World

Chapter 10 : Course Round-Up

Chapter 11 : Optional - Power BI Desktop Crash Course (Introduction and Summary)

Chapter 12 : Bonus - Selected Features by Example and Refresher Project

Content preview from Microsoft Power BI - A Complete Introduction [2023 EDITION]

Adding a Secondary Y-Axis

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Microsoft Power BI - The Complete Masterclass - 2025 EDITION

Power BI Masterclass

Power BI Masterclass - Beginners to Advanced

Learning Microsoft Power BI

Publisher Resources

Chapter 1 : Getting Started

Chapter 2 : Understanding the Power BI Desktop Basics and Preparing the Course Project

Chapter 3 : Data Preparation in the Power Query Editor

Chapter 4 : Data Transformation in the Power Query Editor

Chapter 5 : The Data Model - Working with Relationships and DAX (Data Analysis Expressions)

Chapter 6 : Creating Visuals in the Report View

Chapter 7 : Power BI Pro and Mobile: Sharing and Collaborating with Workspaces and Apps

Chapter 8 : Other Data Sources

Chapter 9 : How to Stay Up-To-Date in the Power BI World

Chapter 10 : Course Round-Up

Chapter 11 : Optional - Power BI Desktop Crash Course (Introduction and Summary)

Chapter 12 : Bonus - Selected Features by Example and Refresher Project

Content preview from Microsoft Power BI - A Complete Introduction [2023 EDITION]

Adding a Secondary Y-Axis

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Microsoft Power BI - The Complete Masterclass - 2025 EDITION

Power BI Masterclass

Power BI Masterclass - Beginners to Advanced

Learning Microsoft Power BI

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.