- Published 4/28/2026
- 3rd Edition
- Online video 978-0-13-592384-9
Overview:
Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this video shows you how to use Microsoft Power BI with confidence. Not only do you learn the most widely used features and functions of Power BI, but you also get context to understand the why and importance of storytelling in making data-driven decisions.
In this course, we learn ways to import data from various sources, as well as how to transform and cleanse data prior to loading it to a report-ready, self-service, and AI enabled model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using various features in the Power BI service. Build good habits and develop your career as a business analyst or data-driven business user. Chris Sorensen explains the core concepts of Power BI to expose you to the most widely used features and functions in Power BI. He carefully explains the why and how behind using these features, grounding each topic in real-world scenarios. Whether you are new to analytics or have been preparing and delivering data using legacy BI tools, this course shows you how to confidently use Microsoft Power BI.
Skill Level:
Learn How To:
- Get Started with Power BI
- Import and Transforming Data Using Power Query Editor
- Enhance the Data Model: The Basics
- Enhance the Data Model: DAX Basics
- Enhance the Data Model: DAX Next Level
- Enhance the Data Model: Quick Measures
- Build Desktop Visualizations: The Basics
- Build Desktop Visualizations: Next Level
- Use the Power BI Service: Reading View
- Use the Power BI Service: Next Level
- Implement Security and Access
Course requirement:
Pre-requisites:
- Familiarity with the process of analytics and/or experience with tools such as Excel or other reporting tools is useful but not mandatory.
- Power BI Desktop installed on your machine
- Access the Power BI service
Who Should Take This Course:
Job titles:
About Pearson Video Training:
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.
Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.
Table of Contents
Lesson 1: Getting Started with Power BI
Learning objectives
1.1 Understand the data lifecycle
1.2 Understand the Power BI environment
1.3 Understand Power BI licensing
1.4 Understand Power BI release cycles
1.5 Set up your environment
1.6 Explore data source settings
1.7 Introduce our business scenario
1.8 Self-service and Copilot (AI) readiness
Lesson 2: Importing and Transforming Data Using Power Query Editor
Learning objectives
2.1 Power Query Editor overview
2.2 Import United States sales data
2.3 Import customer data
2.4 Import sales territory data
2.5 Import product data
2.6 Import product rollup data
2.7 Merge queries
2.8 Import the other countries sales data
2.9 Append queries
2.10 Create columns
2.11 Model loading and cleanup
2.12 Organize and document Power Query
Lesson 3: Enhancing the Data Model: The Basics
Learning objectives
3.1 Navigate the Power BI Desktop
3.2 Understanding dimensional modeling
3.3 Create relationships and manage settings
3.4 Modify column properties
3.5 Create a column group
3.6 Create hierarchies
3.7 Optimize relationships
3.8 Discuss data model cleanup
Lesson 4: Enhancing the Data Model: DAX Basics
Learning objectives
4.1 Understand DAX
4.2 Create basic DAX expressions
4.3 Use logical expressions in DAX
4.4 Create calculated columns and measures: Part 1
4.5 Create calculated columns and measures: Part 2
4.6 Create calculated columns and measures: Part 3
4.7 Use the FILTER function
4.8 Use the ALL function
Lesson 5: Enhancing the Data Model: DAX Next Level
Learning objectives
5.1 Build a date table
5.2 Disable the auto date/time setting
5.3 Designate a date table
5.4 Build a relationship between order date and sales
5.5 Basic time intelligence functions
5.6 Use the CALCULATE function
5.7 Use quick measures
Lesson 6: Building Desktop Visualizations: The Basics
Learning objectives
6.1 Navigate the Power BI Desktop report view
6.2 Create a clustered column chart
6.3 Create a clustered bar chart
6.4 Create a line chart
6.5 Create a KPI visual
6.6 Create a card visual
6.7 Create slicers
Lesson 7: Building Desktop Visualizations: Next Level
Learning objectives
7.1 Add a canvas background
7.2 Apply a theme
7.3 Adjust existing visuals
7.4 Create a custom tooltip
7.5 Explore drill-through
7.6 Apply conditional formatting to a visual
7.7 Build an order date hierarchy
7.8 Enable drill-down on a visual
7.9 Edit interactions between visuals
7.10 Use the Selection pane
7.11 Use the Bookmarks pane
7.12 Explore the filter pane
7.13 Explore the structure of a PBIX file
Lesson 8: Using the Power BI Service: Reading View
Learning objectives
8.1 Publish to the Power BI Service
8.2 Explore the Power BI Service
8.3 Create and use bookmarks
8.4 Share reports
Lesson 9: Using the Power BI Service: Next Level
Learning objectives
9.1 Create a new report using an existing semantic model
9.2 Build a dashboard
9.3 Configure the dashboard
9.4 Set an alert
9.5 Use the Q&A dialog
Lesson 10: Implementing Security and Access
Learning objectives
10.1 Create row-level security (RLS) roles
10.2 Validate RLS roles using Power BI Desktop
10.3 Assign and validate roles in the Power BI Service
Summary
