Zenler Player
Your course is loading. Hang tight.
Power BI Core Skills
Back to curriculum
0% Complete
0% Complete
Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment
Module introduction
Why implement a BI system?
Common BI needs
What is Power BI ?
Power BI positioning
Power BI overview
Microsoft positioning vs competition
V1 Power BI limitations
History of V1 support for Excel versions
Current common components
Sign up for Power BI
PowerBI.com site
Q & A
Dynamic formatting
Power BI Desktop
Power BI Mobile apps
Power BI Windows app discontinued
Other tools
How Power BI relates to Fabric
Quiz 1: Overview of Power BI
Lab 1: Installing and Configuring Power BI Tools
Module introduction
Power BI data
Connect to data
Template apps
Organizational apps
Publish from Excel discontinued
Power Query for Excel
Power Query for Excel data sources
Power Query in Power BI Desktop
Load options
Editing queries to transform data
Query settings
Context menus
M language script
M language reference
Combining queries
Queries as functions
Altering and refreshing queries
Quiz 2: Discovering and preparing data with Power Query
Lab 2: Discovering and Preparing Data with Power Query
Module introduction
Power Pivot in Excel
Power Pivot audience
Typical Power BI development methodology
Data model views
Table relationships
DAX
DAX table references
DAX operators
DAX functions
Calculated columns
Calculated tables
Defining measures
Implicit vs explicit measures
Quick measures
Manually entering data
Defining parameters
Data types and formatting
Hierarchies
Key performance indicators
Quiz 3: Creating and enhancing semantic data models
Lab 3: Creating and Enhancing Semantic Data Models
Module introduction
Sign up
Try to keep up with changes
Current licensing
Site status
Power BI dashboard
Power BI report
Workspace
Custom visualizations
Sharing dashboards
Q and A
Synonyms and Q and A setup
Scheduled and manual refresh
Refresh options
Refresh on-premises data
Microsoft Entra ID
Power BI for developers
Quiz 4: Creating querying and sharing dashboards and apps with the Power BI site
Lab 4: Creating Querying and Sharing Dashboards with the Power BI Site
Summary and further steps
Module 0: Getting started
Who is this course for?
Preview
Who is Greg?
Preview
What will I learn in this course?
Preview
Configuring your lab environment
Preview
Module 1: Overview of Power BI
Module introduction
Why implement a BI system?
Common BI needs
What is Power BI ?
Power BI positioning
Power BI overview
Microsoft positioning vs competition
V1 Power BI limitations
History of V1 support for Excel versions
Current common components
Sign up for Power BI
PowerBI.com site
Q & A
Dynamic formatting
Power BI Desktop
Power BI Mobile apps
Power BI Windows app discontinued
Other tools
How Power BI relates to Fabric
Quiz 1: Overview of Power BI
Lab 1: Installing and Configuring Power BI Tools
Module 2: Discovering and preparing data with Power Query
Module introduction
Power BI data
Connect to data
Template apps
Organizational apps
Publish from Excel discontinued
Power Query for Excel
Power Query for Excel data sources
Power Query in Power BI Desktop
Load options
Editing queries to transform data
Query settings
Context menus
M language script
M language reference
Combining queries
Queries as functions
Altering and refreshing queries
Quiz 2: Discovering and preparing data with Power Query
Lab 2: Discovering and Preparing Data with Power Query
Module 3: Creating and enhancing semantic data models
Module introduction
Power Pivot in Excel
Power Pivot audience
Typical Power BI development methodology
Data model views
Table relationships
DAX
DAX table references
DAX operators
DAX functions
Calculated columns
Calculated tables
Defining measures
Implicit vs explicit measures
Quick measures
Manually entering data
Defining parameters
Data types and formatting
Hierarchies
Key performance indicators
Quiz 3: Creating and enhancing semantic data models
Lab 3: Creating and Enhancing Semantic Data Models
Module 4: Creating querying and sharing dashboards and apps with the Power BI site
Module introduction
Sign up
Try to keep up with changes
Current licensing
Site status
Power BI dashboard
Power BI report
Workspace
Custom visualizations
Sharing dashboards
Q and A
Synonyms and Q and A setup
Scheduled and manual refresh
Refresh options
Refresh on-premises data
Microsoft Entra ID
Power BI for developers
Quiz 4: Creating querying and sharing dashboards and apps with the Power BI site
Lab 4: Creating Querying and Sharing Dashboards with the Power BI Site
Module 5: Next steps
Summary and further steps
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson