M365 Power BI Desktop - Intermediate

Name: M365 Power BI Desktop - Intermediate
Rating: 4.5 (9 reviews)

Getting a deeper diver with Microsoft 365 Power BI- Intermediate.

Created byIntellezy Trainers

Last updated 1/2024

English

What you'll learn

Data Refresh and Storage Mode Types
Data Modeling: Cardinality and Filter Direction
Active / Inactive Relationships
Referential Integrity
Column Calculations
Visualizations
Donut Chart, Tree Map
Line & Stacked Column Chart
Line & Clustered Column Chart
Map, Filled Map
Filters and Slicers
Interactive Dashboard with Filters and Slicers

Course content

11 sections • 36 lectures • 2h 56m total length

Introduction3:58
Explore data refreshing implications for dashboards, and learn data modeling, column calculations, and visuals like doughnut charts, tree maps, line and clustered column charts, and filled maps, filters and slicers.

Why Refreshing Data is Important3:32
Implications for a Data Model2:07
Introduction to Storage Modes3:57
Explore storage modes in Power BI Desktop, including import, direct query, live connect, and push. Assess security, bandwidth, and data freshness to build reliable data models.
Overview of Refresh Types4:13
Explore refresh types in M365 Power BI Desktop, including import, directory, live connect, and push storage modes, and how tiles refresh automatically while visuals may need live connect.

Refreshing Data Modeling9:16
Table Relationships - Cardinality9:51
Visuals from a Multi Table Model3:04
Create visuals from a multi-table model in Power BI Desktop, using product category, sales amount, and channel name in a clustered column chart while noting refresh times for imported data.
Filter Direction6:58
What is Row-Level Security?2:44
Learn how to set up row-level security in Power BI by creating department-based roles, using data analysis expressions, and testing cross-filtering direction before deployment.
Table Relationships - Active and Inactive Relationships4:06
Table Relationships - Referential Integrity4:33
Understand referential integrity in data modeling by examining relationships between tables and orphan records. Learn to manage relationships and report refresh options in Power BI Desktop for reliable results.
Type Detection Options3:01
Explore type detection options in Power BI Desktop and how the schema informs relationships. Test auto-detecting new relationships after data load and keep updates unchecked to preserve stability.

Understanding Calculated Columns5:50
Learn to create calculated columns in Power BI Desktop, decide their placement, and apply a five percent unit price increase with correct syntax and currency formatting.
Date Calculations4:42
Create a new Power BI column using DAX to subtract ship date from order date to get days between, and fix 1900 baseline results by formatting as a whole number.
Conditional Calculation One3:30
Conditional Calculation Two4:51
Order Status Visual7:10

Requirements

Excel Level 2, Access Level 1, PBD Beginner

Description

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

This course continues the journey that started with the beginner course. Since we all want up-to-date dashboards as quickly as possible, data refresh issues and data model issues are considered next, and optimized as much as possible. Column calculations follow to derive even more value from our data. Visuals are built, and then refined with filters and slicers. Finally, these are all implemented on a Power BI dashboard.

You will learn more about the following:

• Data Refresh and Storage Mode Types
• Data Modeling: Cardinality and Filter Direction
• Active / Inactive Relationships
• Referential Integrity
• Column Calculations
• Visualizations
• Donut Chart, Tree Map
• Line & Stacked Column Chart
• Line & Clustered Column Chart
• Map, Filled Map
• Filters and Slicers
• Interactive Dashboard with Filters and Slicers

This course will no longer receive updates. Please see Microsoft 365 Power BI Desktop - Intermediate for newest updates to application.

Who this course is for:

Individuals who want to gain more insight into the power of understanding and showing your data in Microsoft 365 Power BI.

M365 Power BI Desktop - Intermediate

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Refreshing Data4 lectures • 14min

Data Modeling8 lectures • 44min

Column Calculations5 lectures • 26min

Visualizations7 lectures • 30min

Filters4 lectures • 27min

Slicers4 lectures • 22min

Dashboards1 lecture • 5min

Conclusion1 lecture • 1min

Course Assessment0

Requirements

Description

Who this course is for: