Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Power BI for the Business Analyst
Course Content
Expand All
Module 1 - Session 1
Module 1: Foundations of Power BI – Data to Dashboard
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Module 1 Topics
Intro to Power BI for the Business Analyst
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Getting Started
Training Course Overview
Introduction to Power BI
Introduction to Adventure Works Sample Database
Summary – Introduction
Power BI Desktop – Building Your First Report
15 Lessons
Expand
Module Content
0% Complete
0/15 Steps
Introduction to Building Reports
Adding Logo and Title to Report
Adding a Visual to the Report
Adding a Visual using Q&A Feature
Data Hierarchies
Visual Headers
Formatting Features
Repurposing an Existing Visual
Cross Filtering
Slicers and Filters
Adding a Visual to Display a Single Value
Adding a Visual from Visualizations Pane
Analytics Features in Power BI
Bookmarks and Buttons
Summary – Building Your First Report
Power BI Desktop – Different Types of Reports
8 Lessons
Expand
Module Content
0% Complete
0/8 Steps
Creating a New Report in the Same Workbook
Visual to Display Top 20 Customers
Conditional Formatting
Drill Through Report
Bookmarks and Buttons Revisited
Tool Tip Report (Custom Tool Tips)
Mobile Layout
Summary – Different Types of Reports
Module 1 - Session 2
Reports in PowerBI.com
10 Lessons
Expand
Module Content
0% Complete
0/10 Steps
An Introduction to Sharing Power BI Reports
An Introduction to Power BI.com
Workspaces in Power BI.com
Publishing Reports to My Workspace
My Workspace for Personal Use and Personal Sharing
Creating a Group Workspace
Creating and Editing Reports in Power BI.com
Importing PBIX Files into Power BI.com
Providing Access to Group Workspace
Summary – PowerBI.com
Dashboards in PowerBI.com
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Introduction to Dashboards in Power BI.com
Creating Dashboards
Summary – Dashboards in PowerBI.com
Power BI.com Salient Features
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Importing Excel Files into Power BI.com
Quick Insights
Analyze in Excel
Power BI.com – Other Important Features
Summary – Power BI.com Salient Features
Sharing Production Reports to End Users
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Creating and Sharing Power BI Workspace App
Mobile App
Summary – Sharing Production Reports to End Users
Module 2 - Session 1
Module 2: Get & Transform Data
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Module 2 Topics
Intro to Power Query
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Introduction to Power Query
The Get Data User Experience
Power Query UI Walk Through
Summary – Introduction to Power Query
Simple Transformations
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Cleansing Data
Splitting Columns into Columns and Rows
Cleansing Tables
Summary – Simple Transformations
Appending and Merging Data
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Appending Flat Files in a Folder
Merging Data with Joins
Audit Query
Summary – Appending and Merging Data
Module 2 - Session 2
Star Schema
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Flattening Tables
Building a Star Schema
Summary – Star Schema
Advanced Concepts
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Relative References in Queries
Conditional Logic – IF Statements
Accessing Data from Previous Row
Summary – Advanced Concepts
Module 3 - Session 1
Module 3: Extracting Data Insights with DAX and Power BI
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Module 3 Topics
Introduction to Data Modelling with Power BI
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Review of the Four Stages of Self-Service BI
Introduction to Data Modelling
Thinking of Data in Tables
Review of Adventure Works Sample Database
Summary – Intro to Data Modelling with Power BI
Power BI Data Model
8 Lessons
Expand
Module Content
0% Complete
0/8 Steps
Loading Data
Two Types of Power BI Tables
Relationships in Power BI
Data Compression
Default Aggregations, Custom Themes, Summary
Planning Your Data Model
Best Practices and Tips
Summary – Power BI Data Model
Writing DAX Formulas
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Measures
Calculated Columns
DAX Functions
Why to Write DAX Formulas
Practice Exercises 1
Answers to Practice Exercises 1
Summary – Writing DAX Formulas
Module 3 - Session 2
The CALCULATE Function Explained
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
The CALCULATE Function
Debugging Your DAX Formulas – 6 Step Process
Filter Behaviour Revisited
Summary – Calculate Function
Leveraging the CALCULATE Function
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
The ALL Function
Alternatives in Using ALL Function
Practice Exercises 2
Answers to Practice Exercises 2
Summary – Leveraging the CALCULATE Function
Time Intelligence
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Introduction to Time Intelligence
Auto Time Intelligence
Running Totals
Change vs Prior Year/Month
Summary – Time Intelligence
The FILTER Function Explained
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
The FILTER Function
Filter Function is like a Calculated Column
FILTER Function Pattern to get Business Insights
Summary – Filter Function
What-if Analysis
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Loading and Connecting a Second Data Table
Measures to Derive Business Insights from 2 Data Tables
What-if Analysis in Power BI
Two Cool Things with What-if Analysis
Summary – What-if Analysis
Building DAX Knowledge
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
The SWITCH Function
Harvester Measure to Display Dynamic Chart Title
Field Parameters in Power BI
Next Steps
Summary – Building DAX Knowledge
Rate the Course
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Course Feedback