Power Bi Master Class Dashboards And Power Bi Service

Learn how to create interactive dashboards and to publish to the Power BI Service

Last updated 2022-01-10 | 4.7

- Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video
- Learn to use the EASIEST Business Intelligence tool to create INTERACTIVE Reports and Dashboards in Power BI
- Lifetime access to course materials and practice activities. 100% money back guarantee

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video

Learn to use the EASIEST Business Intelligence tool to create INTERACTIVE Reports and Dashboards in Power BI

Lifetime access to course materials and practice activities. 100% money back guarantee

Load Dashboards and Reports into the Power BI Service and Configure the Power BI Service

Learn to use FILTERS and SLICERS to ask the MEANINGFUL questions of your data

Learn how to use different graph VISUALIZATIONS such as column

line

pie

combo

treemap

geographical and waterfall

Learn to create POWERFUL tables and matrixes of reporting data

Work with Power BI and Excel together - Learn to use Excel to analyze Power BI data

Learn to use CUSTOM Visualizations and Themes in Power BI

* Requirements

* You will require Power BI desktop and access to the Power BI Service on the Internet
* You should be able to work with data in Excel and do basic reporting
* You will require a work email address to sign up for the Power BI Service
* Download the Power BI Desktop app which is available free from Microsoft for Windows

Description

If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Power BI effectively!

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

"Course had a lot of detailed information, I learned a lot. Would highly recommend this to anyone at a beginner or intermediate level."

"I think the course is very detailed, concise and at the right pace. I would recommend this course to everyone starting with PBI"

"After completing this course, I got to know, how much powerful is Power BI. This is excellent for interactive dashboards as well as easy to create any critical report."

**** Lifetime access to course materials and practice activities. ****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn the to use the AMAZING Power BI tool to create dashboards and how to use the power BI service to publish your work.

In this class (the last module of my 3 part "Power BI Master Class" Series), you will cover:

Introduction and Course Content
Signing up for Power BI and Loading Data
Tables , Cards, Matrix and Multi Row Cards
Columns, Bar, Line, Pie, Treemap, Geographical and Scatterplot graphs
Filters, Slicers and Asking questions of your data
Performing trend analysis
Creating Interactive Reports and Dashboards
Publishing to Power BI Service and Configuring Power BI Service
Security and setting up row level security
Data Gateways and refreshing data sets
Using Drill throughs, bookmarks, advanced tool tips and grouping
Using Custom visualizations and themes
Power BI and analyzing data with Microsoft Excel
Publishing and embedding dashboards and reports

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.

Please note that this course is the third course in a series of three courses for the Power BI Master Class series. Search for my instructor profile to purchase these other courses.

Course 1 - Query Editor
Course 2 - Data Modeling and DAX Formulas
Course 3 - Dashboards and Power BI Service

Who this course is for:

Excel users who want to learn how to create professional reports in Power BI

Course content

15 sections • 96 lectures

Introduction 4 lectures

Introduction to the Course Preview 01:51

Introduction to the video. Includes an overview of the BI Reporting certification and the course content.

About the Course Preview 01:55

Download the Training Data Files Preview 00:04

Loading Data into Power BI Preview 06:34

In this lesson you will learn how to load an Excel spreadsheet into Power BI.

Power BI Tables 11 lectures

Introduction to Power BI Tables Preview 00:38

Introduction to using the Power BI Tables visualization

Creating Tables in Power BI Preview 05:25

In this lesson you will learn how to create Tables using the Table visualization in Power BI.

Formatting and Sorting Tables Preview 08:49

In this lesson you will learn how to format and sort the Table visualization.

Using Multiple Measures in Tables Preview 03:52

In this lesson you will learn how to use multiple different types of measures in your Power BI Tables.

Cross Filtering Tables Preview 04:32

In this lesson you will learn how to use the powerful cross filtering function in Tables

Practical Activity - Tables Preview 00:16

Practical activity for Tables visualization

Completed Activity - Tables Preview 03:40

Methods of Aggregation Preview 09:32

In this lesson you will learn how to use the main methods of aggregation - Sum, Count, Average, Max, Min and Distinct Count

Practical Activity - Methods of Aggregation Preview 00:43

Practical activity for Methods of Aggregation

Completed Activity - Methods of Aggregation Preview 05:14

Percentage Calculations Preview 02:13

In this lesson you will learn how to use the Show Value As - Percentage of Grand Total option.

Matrix and Cards 9 lectures

Introduction to Matrix and Cards Preview 00:45

Introduction to the Matrix and Card visualizations.

Creating the Matrix Visualization Preview 07:21

In this lesson you will learn how to create the Matrix visualization.

Methods of Aggregation for Matrix Preview 03:18

In this lesson you will learn how to apply different methods of aggregation such as Count, Average, Sum, Max, Min and Distinct Count to the Matrix visualization.

Percentage of Calculations for the Matrix Preview 03:32

In this lesson you will learn how to use the Share Value As - Percentage of function with the Matrix visualization.

Conditional Formatting Matrix Visualization Preview 07:18

Multi Row Visualization Preview 04:31

In this lesson you will learn to use the Multi Row visualization.

Card Visualization Preview 05:15

In this lesson we review how to create and configure the Card visualization.

Practical Activity - Cards, Multi Row and Matrix Preview 00:11

Completed Activity - Matrix and Card Preview 06:24

Filters and Slicers 13 lectures

Introduction to Filters and Slicers Preview 00:43

Introduction to the Filters and Slicers section.

Text Slicers Preview 06:52

In this lesson you will learn how to use Text filters to filter your data.

Numeric Slicers Preview 04:40

In this lesson you will learn how to use numeric slicers to filter your data.

Date Slicers Preview 05:12

In this lesson you will learn how to use Date Slicers to filter your data.

Visual Level Text Filters Preview 05:02

In this lesson you will learn how to use the visual level text filter.

Visual Level Numeric Filter Preview 02:58

In this lesson you will learn how to use the visual level numeric filter.

Visual Level Date Filters Preview 03:36

In this lesson you will learn how to use the visual level date filter

Page and Report Level Filters Preview 02:54

In this lesson you will learn how to use the page and report level filters.

Practical Activity - Filters Preview 00:34

Completed Activity - Filters Preview 06:30

Drill Through Filters Preview 03:38

Synchronising Slicers Preview 03:58

Hierarchical Slicers Preview 01:41

Column Visualizations 8 lectures

Introduction to Column Visualizations Preview 00:59

Introduction to the Column visualization section.

Column Visualizations Preview 08:37

In this lesson you will learn how to use the Column visualization in Power BI.

Analytics Features Preview 05:34

Stacked Column Visualizations Preview 04:41

In this lesson you will learn how to use the Stacked Column visualization

Cross Filtering and Slicers Preview 05:19

In this lesson we discuss the different filtering options that Slicers and cross filtering provide.

Practical Activity - Column and Bar Visualizations Preview 00:30

Practical activity for the column and bar visualiations

Completed Activity - Column and Bar Graph Preview 06:22

Graph Options Preview 03:57

Trend Analysis 6 lectures

Introduction to Trend Analysis Preview 01:13

Introduction to the Trend Analysis.

Line Graphs Preview 09:07

In this lesson you will learn how to use the Line graph for trend analysis.

Area Graphs Preview 04:41

In this lesson you will learn how to use the Area graph for trend analysis

Ribbon Graphs Preview 03:34

In this lesson you will learn how to use the Ribbon graph for trend analysis.

Practical Activity - Trend Analysis Preview 00:14

Practical activity for the trend analysis section.

Completed Activity - Trend Graphs Preview 03:27

The conclusion to the Trend Analysis section.

Other Graph Types 8 lectures

Introduction to Other Graph Types Preview 00:26

Introduction to the Other Graph Types section.

Combination and KPI Visualizations Preview 03:45

In this lesson you will learn how to use the Waterfall and KPI visualizations.

Pie and TreeMap Graphs Preview 05:06

In this lesson you will learn how to create the Pie graph

Geographical Graphs Preview 06:05

In this lesson you will learn how to create geographical maps.

Scatterplots and Bubbleplots Preview 06:50

In this lesson you will learn how to use the Scatterplots and Bubbleplot visualizations.

Decomposition Tree Preview 03:06

In this lesson we show you how to complete the Scatterplot practical activity.

Key Influencers Preview 03:08

Conclusion to the Other Graphs section.

Q and A Visualization Preview 05:03

Interactive Dashboards 10 lectures

Introduction to Interactive Dashboards Preview 00:50

Introduction to the Interactive Reports section.

Practical Activity - Create an Interactive Report Preview 00:16

In this practical activity you will create an interactive report

Create the Interactive Dashboard Preview 08:54

In this lesson you will learn how to create an interactive report.

Report Features Preview 05:00

Grouping and Groups Preview 05:36

In this lesson you will learn how to create Groups and how to use the Grouping functionality.

Advanced ToolTips Preview 05:32

In this lesson you will learn how to create advanced Tooltips for your visualizations.

Bookmarks Preview 05:58

In this lesson you will learn how to create and use Bookmarks in Power BI.

Action Buttons Preview 06:57

Personalize Visualizations Preview 04:08

Publish Interactive Dashboards Preview 07:49

In this lesson you will learn how to publish the interactive report to the Power BI Service.

Power BI Service 7 lectures

Introduction to Power BI Service Preview 01:33

Introduction to the Power BI Service section.

Review the Report Preview 07:52

Setting Up Dashboards Preview 04:30

In this lesson you will learn how to set up dashboards in the Power BI service.

Set up Alerts and Subscriptions Preview 02:37

In this lesson you will learn how to setup alerts and subscriptions in the Power BI Service.

Getting Insight from your Data Preview 02:57

In this lesson you will learn how to use the Quick Insight option for Power BI.

Setting up the Mobile View Preview 05:02

In this lesson you will learn how to set up the mobile report view.

Natural Language Queries Preview 02:35

Power BI Security, Workspaces and Refresh 6 lectures

Introduction to Power BI Security, Workspaces and Refresh Preview 01:16

Introduction to Power BI security, workspaces and refresh.

Understanding Data Gateways Preview 03:23

Data Gateways Preview 09:50

In this lesson you will learn how to implement and configure the personal data gateway.

Row Level Security Preview 04:44

In this lesson you will learn how to implement row level security.

App Workspaces Preview 04:37

In this lesson you will learn how to create app workspaces in the Power BI Service.

Publishing Apps Preview 05:18

In this lesson you will learn how to create and publish Apps

Power BI and Excel 4 lectures

Introduction to Power BI and Excel Preview 01:52

Introduction to Power BI and Excel section.

Power BI and Excel Connections Preview 05:42

In this lesson you will learn how to access Power BI data sets using Excel Pivot Tables.

Excel Data Types with Power BI Preview 06:48

In this lesson you will learn how to Pin Excel Pivot Tables, Pivot Charts and ranges of data into Power BI.

Excel Online Workbooks Preview 02:50

In this lesson you will learn how to load Excel workbooks into the Power BI Service.