Power BI Core Skills

Want to work with Power BI and have no idea where to start? Let us show you in this straightforward course with easy to follow practical exercises.

Enroll now for $95 USD !

Course Summary

Do you need to get started with Power BI?

  • You need to turn raw data into compelling, interactive reports and dashboards
  • You want to understand how to connect Power BI to a variety of data sources like SQL Server, Excel, and cloud services
  • You’re using Excel, Tableau, or another tool, but want to upskill or switch to Power BI
  • You want to learn how to get stared cleaning, shaping, and modeling your data for reliable reporting
  • You need to share reports securely via Power BI Service, and understand licensing and distribution options
  • You’re new to Power BI or self-taught, and want a structured, professional foundation

If so, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

We encourage you to complete the practical exercises. We have tried to make this as easy as possible. You do not need to install SQL Server, databases, etc. We have an online version hosted for you. All you need will need to install is Power BI and you’ll want that later anyway !

For those who aren’t in a position to do the practical exercises, or who need to see how steps are done, we’ve also provided video walkthroughs of those too.


Enroll now for $95 USD !

Modules and Lessons

Module 0: Getting started

Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment

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
How to use these labs
Lab 1: Overview
Lab 1: Installing and Configuring Power BI Tools
Lab 1: Exercise 1: Video Walkthrough
Lab 1: Exercise 2: Video Walkthrough
Lab 1: Exercise 3: Video Walkthrough

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: Overview
Lab 2: Discovering and Preparing Data with Power Query
Lab 2: Exercise 1: Video Walkthrough
Lab 2: Exercise 2: Video Walkthrough
Lab 2: Exercise 3: Video Walkthrough
Lab 2: Exercise 4: Video Walkthrough

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
TMDL View
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: Overview
Lab 3: Creating and Enhancing Semantic Data Models
Lab 3: Exercise 1: Video Walkthrough
Lab 3: Exercise 2: Video Walkthrough
Lab 3: Exercise 3: Video Walkthrough
Lab 3: Exercise 4: Video Walkthrough

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: Overview
Lab 4: Creating Querying and Sharing Dashboards with the Power BI Site
Lab 4: Exercise 1: Video Walkthrough
Lab 4: Exercise 2: Video Walkthrough
Lab 4: Exercise 3: Video Walkthrough
Lab 4: Exercise 4: Video Walkthrough
Lab 4: Exercise 5: Video Walkthrough

Module 5: Next steps

Summary and further steps


Enroll now for $95 USD !