Microsoft 365 Power BI Report Builder - Intermediate

Focused View

Intellezy Trainers

6:15:41

13 View

1. Introduction

1. Introduction.mp4

04:49

2. Required Course Setup

1. Accessing the Power BI Service.mp4

03:34

2. Reviewing Exercise Files.mp4

05:47

3. Loading Data Files to the Service.mp4

03:55

3. Using Parameters

1. Defining Parameters and their Benefits.mp4

08:05

2. Controlling Chart Colors with a Parameter.mp4

09:32

3. Controlling Rows per Page with a Parameter.mp4

11:18

4. Filtering a Dataset with Parameters.mp4

15:08

5. Using Multi-value Parameters.mp4

05:08

4. Enhancing Reports with Expressions

1. Applying Conditional Formatting with IIF.mp4

09:12

2. Applying Conditional Formatting with SWITCH.mp4

05:20

3. Alternating Colors by Row.mp4

07:48

4. Using Expressions in a Chart.mp4

13:27

5. Applying TOP N Filter Expressions.mp4

08:10

6. Calculating Running Totals.mp4

07:41

5. Charts for Reports or Dashboards

1. Understanding Chart Types.mp4

09:18

2. Creating Charts Using the Wizard (Column Chart).mp4

08:34

3. Creating Charts Manually (Bar Chart).mp4

09:24

4. Modifying Charts.mp4

12:33

5. Creating a Donut Chart.mp4

12:44

6. Creating a Funnel Chart.mp4

09:19

7. Creating a Tree Map.mp4

06:24

8. Creating a Sunburst Chart.mp4

08:42

9. Creating a Line Chart.mp4

10:43

10. Creating a Stacked Area Chart.mp4

12:59

11. Creating a Scatter Plot.mp4

18:19

6. Advanced Grouping Options

1. Introducing Group Expressions.mp4

05:32

2. Examining Functions.mp4

05:23

3. Reviewing Operators.mp4

03:11

4. Creating Expressions on Field Values.mp4

08:04

5. Creating Expressions on Date Values.mp4

09:43

6. Grouping Data with a Hierarchy.mp4

05:14

7. Leveraging Group Headers and Footers.mp4

09:31

7. Adding Interactivity to a Report

1. Adding Interactive Sorting.mp4

06:03

2. Adding Interactive Hierarchies.mp4

05:43

3. Applying Interactive Filtering.mp4

12:29

4. Adding Bookmarks for Navigation.mp4

11:49

5. Creating a Document Map or Table of Contents.mp4

08:03

8. Adding Maps to Visualize Data

1. Introducing Map Concepts.mp4

06:14

2. Starting a Basic Map.mp4

04:42

3. Completing a Map.mp4

07:36

4. Creating a Color Analytical Map.mp4

08:28

5. Creating a Bubble Map.mp4

06:01

6. Creating a Map with ESRI Shapes.mp4

12:16

9. Conclusion

1. Course Recap.mp4

01:46

10. Power BI Report Builder - Intermediate Assessment

1. Assessment Test.html

Description

Progress your existing Power BI Report Builder knowledge.

What You'll Learn?

Using Parameters
Enhancing Reports with Expressions
Charts for Reports or Dashboards
Advanced Grouping Options
Adding Interactivity to a Report
Adding Maps to Visualize Data

Who is this for?

Anyone looking to expand upon their Power Bi Report Builder - Beginner experience.

What You Need to Know?

Power BI Report Builder - Beginner

Familiar with Windows basics

Folder navigation and basic file operations

Saving and renaming files

Manipulating windows

Basic text formatting

Basic spreadsheet operations

Basic clipboard operations like copy and paste

More details

Description
This course continues where the beginner course leaves off.Â Parameters are introduced and integrated with datasets for customized selection of data.Â Drop-down lists are created for interactive filtering.
Expressions are used to enhance reports.Â Visual formatting is added with alternating colors and rows, and conditional formatting is also applied.Â Expressions are used to correct for bad data.Â Top N filters are created along with running values.Â A number of functions are introduced like: IIF, SWITCH, ROWNUMBER and others.
Charts for reports and dashboards are introduced with emphasis on the reasons for using specific chart types.Â Traditional charts are created as well as treemaps, sunburst charts, donut charts, funnel charts and scatter plots.Â Expressions and parameters are added to charts to customize appearance and add functionality.
Advanced grouping is explored by creating groups with expressions.Â Hierarchies are created manually. Grouping layers are added manually for perfect control of all aspects of data groups.
Interactivity is added to reports through interactive sorting, filtering, collapsible and expandable hierarchies, bookmarking, and document mapping.
Maps are a staple on modern reports. To finish the course, geographic maps are added to reports to help analyze business data.Â These maps include heat maps and color maps. International maps are also created using spatial data available from the Internet.

Instructor:Â Eric Brockway
Who this course is for:
Anyone looking to expand upon their Power Bi Report Builder - Beginner experience.

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.