Microsoft 365 Power BI Desktop - Intermediate

Focused View

Intellezy Trainers

3:44:56

11 View

1 - Introduction

1 - Introduction.mp4

05:30

2 - Refreshing Data

2 - Why Its Important.mp4

03:15

3 - Implications for a Data Model.mp4

03:10

4 - Introduction to Storage Modes.mp4

01:27

5 - Import Mode.mp4

06:00

6 - DirectQuery Mode.mp4

02:49

7 - Live Connect Mode.mp4

03:23

8 - Dual Mode.mp4

01:37

9 - Push Mode.mp4

02:38

10 - Introduction to Refresh Types.mp4

01:19

3 - Data Modeling

11 - Examining Data Modeling.mp4

01:27

12 - Table Relationships Cardinality.mp4

09:57

13 - Creating Visuals from a MultiTable Model.mp4

05:02

14 - Table Relationships Filter Direction.mp4

15:00

15 - Type Detection Options.mp4

03:25

16 - Understanding RowLevel Security.mp4

13:50

4 - Column Calculations

17 - Understanding Calculated Columns.mp4

02:21

18 - Creating a Calculation with Operators.mp4

08:02

19 - Creating a Calculation with the IF Function.mp4

04:55

20 - Creating a Calculation with the SWITCH and TRUE Functions.mp4

04:08

21 - Creating a Stacked Column Chart from Calculations.mp4

05:20

5 - Visualizations

22 - Introduction to the New Visualizations.mp4

01:34

23 - Creating Donut Charts.mp4

05:40

24 - Creating TreeMaps.mp4

06:55

25 - Creating Line Stacked Column Charts.mp4

06:59

26 - Creating a Line Cluster Column Chart.mp4

05:43

27 - Creating a Map.mp4

05:30

28 - Creating a Filled Map.mp4

05:30

6 - Filters

29 - Defining and Applying Filters.mp4

05:30

30 - Page Filters and Report Filters.mp4

05:30

31 - Using a Date Range Filter.mp4

05:30

32 - Using a Top N Filter.mp4

05:30

33 - Filters and Dashboards.mp4

05:30

7 - Slicers

34 - Defining Slicers.mp4

05:30

35 - Prepping a Report.mp4

05:30

36 - Applying Slicers.mp4

05:30

37 - Adding Multiple Slicers to a Visual.mp4

05:30

38 - Adding Slicers to a Tree Map.mp4

05:30

39 - Adding Slicers to Line and Stacked Column Charts.mp4

05:30

40 - Adding Slicers to a Map.mp4

05:30

41 - Syncing Slicers.mp4

05:30

8 - Dashboard Enhancements

42 - Slicers Filters and Dashboards.mp4

05:30

9 - Conclusion

43 - Course Recap.mp4

05:30

10 - Microsoft 365 Power BI Desktop Intermediate Assessment

Description

Expand upon introductory Power BI Desktop knowledge

What You'll Learn?

Data Refresh and Storage Mode Types
Data Modeling
Column Calculations
Visualizations
Filters and Slicers
Interactive Dashboard

Who is this for?

Anyone with basic Power BI and Excel skills that wants to expand their knowledge.

What You Need to Know?

Excel level 2

Power BI Desktop - Beginner

More details

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!

Instructor:Â Eric W. Brockway
Who this course is for:
Anyone with basic Power BI and Excel skills that wants to expand their knowledge.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Intellezy Trainers

Instructor's Courses

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.