Software Training Microsoft 365 Power BI

Intermediate Power BI Training

Microsoft 365 Power BI Desktop - Intermediate

0 seconds of 2 minutes, 59 secondsVolume 90%

00:00

02:59

Power BI Desktop - Intermediate Course Description

Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision making. This course builds on the beginner course and enables dashboard creators to support these requirements. Data is only as up to date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organizations reporting data. Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics: Table Relationships, Cardinality, Row-level Security, and Referential Integrity. Sometimes a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course. Visualizations that are not covered in the beginner course are covered here. This course includes: Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps mostly importantly, use cases that determine when each of these visuals is the best one to use are explained and demonstrated. Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters are also included such as: Include / Excluded filters, Cross filters, Top N filters, and relative Date filters. Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others. Even though dashboards are covered in the beginner course, there is so much that can be done with them! In this course, dashboards are created the use the new visualizations and that also incorporate filters and slicers!

Course Playlist

Introduction

1 videos

2 min 59 sec
- Introduction 2 min 59 sec
Refreshing Data

9 videos

25 min 42 sec
- Why It's Important 3 min 15 sec
- Implications for a Data Model 3 min 11 sec
- Introduction to Storage Modes 1 min 28 sec
- Import Mode 6 min
- Directquery Mode 2 min 50 sec
- Live Connect Mode 3 min 23 sec
- Dual Mode 1 min 37 sec
- Push Mode 2 min 39 sec
- Introduction to Refresh Types 1 min 19 sec
Data Modeling

6 videos

48 min 44 sec
- Examining Data Modeling 1 min 27 sec
- Table Relationships: Cardinality 9 min 57 sec
- Creating Visuals from a Multi-table Model 5 min 3 sec
- Table Relationships: Filter Direction 15 min
- Type Detection Options 3 min 26 sec
- Understanding Row-level Security 13 min 51 sec
Column Calculations

5 videos

24 min 48 sec
- Understanding Calculated Columns 2 min 22 sec
- Creating a Calculation with Operators 8 min 3 sec
- Creating a Calculation with the IF Function 4 min 55 sec
- Creating a Calculation with the SWITCH and TRUE Functions 4 min 8 sec
- Creating a Stacked Column Chart from Calculations 5 min 20 sec
Visualizations

7 videos

36 min 10 sec
- Introduction to the New Visualizations 1 min 35 sec
- Creating Donut Charts 5 min 40 sec
- Creating Treemaps 6 min 55 sec
- Creating Line and Stacked Column Charts 7 min
- Creating a Line and Cluster Column Chart 5 min 43 sec
- Creating a Map 5 min 31 sec
- Creating a Filled Map 3 min 46 sec
Filters

5 videos

30 min 47 sec
- Defining and Applying Filters 8 min 7 sec
- Page Filters and Report Filters 6 min 36 sec
- Using a Date Range and Filter 5 min 21 sec
- Using a TOP N Filter 4 min 15 sec
- Filters and Dashboards 6 min 28 sec
Slicers

8 videos

37 min 10 sec
- Defining Slicers 5 min 15 sec
- Prepping a Report 2 min 31 sec
- Applying Slicers 3 min 37 sec
- Adding Multiple Slicers to a Visual 7 min 27 sec
- Adding Slicers to a Tree Map 2 min 19 sec
- Adding Slicers to Line and Stacked Column Charts 5 min 1 sec
- Adding Slicers to a Map 5 min 59 sec
- Syncing Slicers 5 min 1 sec
Dashboard Enhancements

1 videos

3 min 18 sec
- Slicers, Filters, and Dashboards 3 min 18 sec
Creating Reports in the Service

4 videos

20 min 11 sec
- Examining Power BI in the Cloud 2 min 55 sec
- Donut Chart 7 min 6 sec
- TreeMap 5 min 48 sec
- Line and Stacked Column Chart 4 min 22 sec
Conclusion

1 videos

1 min 8 sec
- Recap 1 min 8 sec

Business

Select 50

Full Library

Select 50

Build a custom 50-course library from the Intellezy complete library.

Choose from 11,000+ video lessons

The Most Up-to-Date Content

Content Available in 20+ Languages

Course Assessments & Downloadable Files

And More!

Individual

Monthly

Yearly

$9.95 /monthly

$119.40 total annually

11,000+ Video Lessons

The Most Up-to-Date Learning Content

Content Available in 20+ Languages

Course Assessments & Hands-On Projects

And More!

Intermediate Power BI Training

Microsoft 365 Power BI Desktop - Intermediate

Power BI Desktop - Intermediate Course Description

Course Playlist

Introduction

Refreshing Data

Data Modeling

Column Calculations

Visualizations

Filters

Slicers

Dashboard Enhancements

Creating Reports in the Service

Conclusion

Recommended Courses

Let’s Talk Learning!