Complete Guide to Power BI for Data Analysts by Microsoft Press (2024)

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 various features in the Power BI service. Build good habits and develop in your career as a business analyst or data-driven business user. Microsoft Certified Trainer 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 use Microsoft Power BI with confidence.

Concepts

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

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 the product and product rollup queries
Import the other countries' sales data
Append sale 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
Comprehensive create calculated columns and measures - Part one
Comprehensive create calculated columns and measures - Part two
Comprehensive create calculated columns and measures - Part three
Use the FILTER function
Use the ALL function

Enhancing the Data Model - DAX Time Intelligence

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

Enhancing the Data Model - Quick Measures

Learning objectives
Use quick measures

Building Desktop Visualizations - The Basics

Learning objectives
Navigate the Power Bi Desktop report view
Create a clustered column chart
Create a stacked 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
Use the Bookmarks pane
Explore the filter pane
Explore the structure of a .pbix file

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

Complete Guide to Power BI for Data Analysts by Microsoft Press (2024)

Authors

Microsoft Press

Chris Sorensen