Complete Guide to Power BI for Data Analysts by Microsoft Press

Course details

In this course, 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-enabled data model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using the various features in the Power BI service. Leveraging his years of experience teaching Power BI to a variety of learners, Microsoft Certified Trainer Chris Sorensen explains the core concepts of Power BI and shows you how to use some of its most widely used features and functions. Whether you’re new to analytics or have been stuck preparing and delivering data using legacy BI tools, this course equips you with the skills and confidence required to navigate and build Power BI solutions—quickly and effectively.

Learning objectives
Import and transform data in Power Query Editor.
Build a data model that supports self-service analysis.
Develop reports and visualizations using the Power BI Desktop.
Enhance user experience in the Power BI service.
Secure, share, and collaborate on dashboards and reports using the Power BI Service.

Concepts

Introduction

Welcome to the course

Getting Started with Power BI

Learning objectives
Understand the data lifecycle
Understand the Power BI environment
Understand Power BI licensing
Understand Power BI release cycles
Set up your environment
Explore data source settings
Introduce our business scenario
Self-service and Copilot

Importing and Transforming Data Using Power Query Editor

Learning objectives
Power Query Editor overview
Import United States sales data
Import customer data
Import sales territory data
Import product data
Import product rollup data
Merge queries
Import the other countries sales data
Append queries
Create columns
Model loading and cleanup
Organize and document Power Query

Enhancing the Data Model - The Basics

Learning objectives
Navigate the Power BI Desktop
Understanding dimensional modeling
Create relationships and manage settings
Modify column properties
Create a column group
Create hierarchies
Optimize relationships
Discuss data model cleanup

Enhancing the Data Model - DAX Basics

Learning objectives
Understand DAX
Create basic DAX expressions
Use logical expressions in DAX
Create calculated columns and measures - Part 1
Create calculated columns and measures - Part 2
Create calculated columns and measures - Part 3
Use the FILTER Function
Use the ALL Function

Enhancing the Data Model - DAX Next Level

Learning objectives
Build a date table
Disable the auto date time setting
Designate a date table
Build relationship between order date and sales
Basic time intelligence functions
Use the CALCULATE Function
Use quick measures

Building Desktop Visualizations - The Basics

Learning objectives
Navigate the Power BI Desktop report view
Create a clustered column chart
Create a clustered bar chart
Create a line chart
Create a KPI visual
Create a card visual
Create slicers

Building Desktop Visualizations - Next Level

Learning objectives
Add a canvas background
Apply a theme
Adjust existing visuals
Create a custom tooltip
Explore drill through
Apply conditional formatting to a visual
Build an order date hierarchy
Enable a drill-down on a visual
Edit interactions between visuals
Use the Selection pane
Explore the Filter pane
Explore the structure of a PBIX file
Use the Bookmarks pane

Using the Power BI Service - Reading View

Learning objectives
Publish to the Power BI service
Explore the Power BI service
Create and use bookmarks
Share reports

Using the Power BI Service - Next Level

Learning objectives
Create a new report using an existing semantic model
Build a dashboard
Set an alert
Use the Q&A dialog
Configure the dashboard

Implementing Security and Access

Learning objectives
Create row-level security (RLS) roles
Validate RLS roles using Power BI Desktop
Assign and validate roles in the Power BI service

Conclusion

Course summary and next steps