Power BI Master Class - Dashboards and Power BI Service 2020
4.5 (1,851 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,857 students enrolled

Power BI Master Class - Dashboards and Power BI Service 2020

Learn how to create interactive dashboards and to publish to the Power BI Service
4.5 (1,851 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,857 students enrolled
Created by Ian Littlejohn
Last updated 8/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 9 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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

**** Updated June 2020 this bestselling Udemy course has been updated to the new Microsoft Power BI user interface ****

Recent reviews:

"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. 100% money back guarantee ****

This course is presented by Ian Littlejohn - who with over 65 000 students is one of the most popular instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

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:

  1. Introduction and Course Content

  2. Signing up for Power BI and Loading Data

  3. Tables , Cards, Matrix and Multi Row Cards

  4. Columns, Bar, Line, Pie, Treemap, Geographical and Scatterplot graphs

  5. Filters, Slicers and Asking questions of your data

  6. Performing trend analysis 

  7. Creating Interactive Reports and Dashboards

  8. Publishing to Power BI Service and Configuring Power BI Service

  9. Security and setting up row level security

  10. Data Gateways and refreshing data sets

  11. Using Drill throughs, bookmarks, advanced tool tips and grouping

  12. Using Custom visualizations and themes

  13. Power BI and analyzing data with Microsoft Excel

  14. 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.

  1. Course 1 - Query Editor

  2. Course 2 - Data Modeling and DAX Formulas

  3. 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
Expand all 93 lectures 06:39:10
+ Introduction
4 lectures 08:50

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

Preview 01:52
Download the Training Data Files
00:04

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

Loading Data into Power BI
04:27
+ Power BI Tables
11 lectures 41:42

Introduction to using the Power BI Tables visualization

Introduction to Power BI Tables
00:41

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

Preview 04:53

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

Formatting and Sorting Tables
08:51

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

Using Multiple Measures in Tables
02:31

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

Preview 04:56

Practical activity for Tables visualization

Practical Activity - Tables
00:16
Completed Activity - Tables
03:04

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

Methods of Aggregation
07:45

Practical activity for Methods of Aggregation

Practical Activity - Methods of Aggregation
00:40
Completed Activity - Methods of Aggregation
05:22

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

Percentage Calculations
02:43
+ Matrix and Cards
9 lectures 38:46

Introduction to the Matrix and Card visualizations.

Introduction to Matrix and Cards
00:47

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

Creating the Matrix Visualization
09:10

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.

Methods of Aggregation for Matrix
03:34

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

Percentage of Calculations for the Matrix
02:46
Conditional Formatting Matrix Visualization
07:05

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

Multi Row Visualization
04:01

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

Card Visualization
04:08
Practical Activity - Cards, Multi Row and Matrix
00:11
Completed Activity - Matrix and Card
07:04
+ Filters and Slicers
12 lectures 48:17

Introduction to the Filters and Slicers section.

Introduction to Filters and Slicers
00:45

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

Text Slicers
06:04

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

Numeric Slicers
04:16

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

Date Slicers
04:26

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

Visual Level Text Filters
05:44

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

Visual Level Numeric Filter
03:03

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

Visual Level Date Filters
05:01

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

Page and Report Level Filters
03:41
Practical Activity - Filters
00:34
Completed Activity - Filters
07:37
Synchronising Slicers
03:40
Hierarchical Slicers
03:26
+ Column Visualizations
8 lectures 34:27

Introduction to the Column visualization section.

Introduction to Column Visualizations
01:01

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

Column Visualizations
08:19

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

Stacked Column Visualizations
04:22

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

Cross Filtering and Slicers
03:41

Practical activity for the column and bar visualiations

Practical Activity - Column and Bar Visualizations
00:30
Completed Activity - Column and Bar Graph
05:50
Graph Options
04:31

In this lesson you will learn how to use the Analytics Pane options to create reference lines, averages and percentiles.  

Analytics Pane
06:13
+ Trend Analysis
6 lectures 24:08

Introduction to the Trend Analysis.

Introduction to Trend Analysis
01:15

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

Line Graphs
09:08

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

Area Graphs
05:07

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

Ribbon Graphs
04:09

Practical activity for the trend analysis section.

Practical Activity - Trend Analysis
00:16

The conclusion to the Trend Analysis section.

Completed Activity - Trend Graphs
04:13
+ Other Graph Types
8 lectures 38:53

Introduction to the Other Graph Types section.

Introduction to Other Graph Types
00:27

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

Combination and Waterfall Visualizations
07:07

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

Pie and TreeMap Graphs
04:15

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

Geographical Graphs
04:52

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

Scatterplots and Bubbleplots
08:19

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

Decomposition Tree
03:43

Conclusion to the Other Graphs section.

Key Influencers
05:01
Q and A Visualization
05:09
+ Interactive Dashboards
10 lectures 54:06

Introduction to the Interactive Reports section.

Introduction to Interactive Dashboards
00:52

In this practical activity you will create an interactive report

Practical Activity - Create an Interactive Report
00:16

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

Preview 09:20

In this lesson you will learn how to use the drill through filter functionality that is in Power BI.

Drill Through Filters
03:40

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

Grouping and Groups
07:59

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

Advanced ToolTips
05:32

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

Bookmarks
06:05
Action Buttons
08:00
Personalize Visualizations
03:47

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

Publish Interactive Dashboards
08:35
+ Power BI Service
6 lectures 23:27

Introduction to the Power BI Service section.

Introduction to Power BI Service
01:35

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

Setting Up Dashboards
06:07

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

Set up Alerts and Subscriptions
04:11

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

Getting Insight from your Data
03:17

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

Setting up the Mobile View
04:58
Natural Language Queries
03:19
+ Power BI Security, Workspaces and Refresh
6 lectures 31:54

Introduction to Power BI security, workspaces and refresh.

Introduction to Power BI Security, Workspaces and Refresh
01:18
Understanding Data Gateways
04:25

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

Data Gateways
11:02

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

Row Level Security
05:25

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

App Workspaces
04:32

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

Publishing Apps
05:12