Power BI Master Class - Dashboards and Power BI Service
4.5 (230 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.
1,431 students enrolled

Power BI Master Class - Dashboards and Power BI Service

Prepare and learn for the Microsoft MCSA BI Reporting Exam 70-778 Analyzing and Visualizing Data using Power BI Desktop
4.5 (230 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.
1,431 students enrolled
Created by Ian Littlejohn
Last updated 12/2018
English
Current price: $11.99 Original price: $99.99 Discount: 88% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 11 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ 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
  • Life time access to course materials and practice activities. 100% money back guarantee

  • Students will be prepared for the visualization and Power BI Service module of the Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

  • 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
Description

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.

Please note that this course is the third course in a series of three courses for the Power BI Master Class that cover the key outcomes of the Exam 70-778.

  1. Course 1 - Consume and Transform Data
  2. Course 2 - Data Modeling and DAX Formulas
  3. Course 3 - Dashboards and Power BI Service

Ian Littlejohn is a professional trainer and consultant. Ian has been working and training users on Microsoft Power BI since the release of Power BI. In this series of courses Ian teaches and prepares users for the Microsoft Exam 70-778 Analyzing and Visualizing Data by using Microsoft Power BI.  

The Microsoft MCSA BI Reporting is a valuable  certification for every Excel and Power BI user. The certification consists of two exams.  Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. Ian has created a series of courses that will assist all users to prepare for these exams.

Even, if you are not preparing for the exam you will find these courses a valuable resource to learn the most important and powerful features of Microsoft Power BI.

In this third course - Dashboards and Power BI Service we 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.

Who this course is for:
  • Excel users who want to learn how to create professional reports in Power BI
  • Learners who want to prepare themselves for Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
Course content
Expand all 97 lectures 05:39:54
+ Introduction
1 lecture 02:30

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

Preview 02:30
+ Overview of the BI Reporting Certification
2 lectures 04:11

In this lecture we provide an overview of the Microsoft MCSA BI Reporting certification.

Preview 04:00

Links to the MCSA BI Reporting Certification exams and resources.

Links to the MCSA BI Reporting Certification
00:11
+ Signing Up for Power BI and Loading Data
4 lectures 14:05

Introduction to the Signing up for Power BI section.

Preview 00:28

In this lesson we review how to sign up for Power BI

Preview 03:07

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

Loading Data into Power BI
10:13

Conclusion to the Signing up for Power BI section.

Conclusion to Signing up for Power BI and Loading Data
00:17
+ Power BI Tables
10 lectures 30:43

Introduction to using the Power BI Tables visualization

Introduction to Power BI Tables
00:38

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

Creating Tables in Power BI
04:35

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

Formatting and Sorting Tables
07:36

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

Using Multiple Measures in Tables
03:29

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

Cross Filtering Tables
03:30

Practical activity for Tables visualization

Practical Activity - Tables
00:19

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
06:59

Practical activity for Methods of Aggregation

Practical Activity - Methods of Aggregation
00:47

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

Percentage Calculations
02:16

Conclusion to the Tables Section.

Conclusion to Tables Section
00:33
+ Matrix and Cards
8 lectures 26:50

Introduction to the Matrix and Card visualizations.

Introduction to Matrix and Cards
01:18

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

Creating the Matrix Visualization
07:28

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
02:56

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
03:56

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

Multi Row Visualization
02:50

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

Card Visualization
07:26
Practical Activity - Cards, Multi Row and Matrix
00:25

Conclusion to the Matrix and Card Visualization Section.

Conclusion to Matrix and Card Visualizations
00:31
+ Filters and Slicers
10 lectures 35:46

Introduction to the Filters and Slicers section.

Introduction to Filters and Slicers
01:36

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

Text Slicers
05:43

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

Numeric Slicers
04:34

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

Date Slicers
05:44

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

Visual Level Text Filters
04:42

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

Visual Level Numeric Filter
05:31

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

Visual Level Date Filters
04:46

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

Page and Report Level Filters
02:14
Practical Activity - Filters
00:36

Conclusion to the Filters and Slicers section.

Conclusion to Filters and Slicers
00:20
+ Column Visualizations
9 lectures 34:35

Introduction to the Column visualization section.

Introduction to Column Visualizations
00:59

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

Column Visualizations
07:39

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

Stacked Column Visualizations
05:31

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

Cross Filtering and Slicers
05:01

Practical activity for the column and bar visualiations

Practical Activity - Column and Bar Visualizations
00:30
Graph Options
06:37

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

Analytics Pane
07:29
Practical Activity - Graph Options
00:19

Conclusion to the Column visualization section.

Conclusion to the Column Visualizations Section
00:30
+ Trend Analysis
6 lectures 21:37

Introduction to the Trend Analysis.

Introduction to Trend Analysis
01:33

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

Line Graphs
09:59

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

Area Graphs
04:42

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

Ribbon Graphs
04:24

Practical activity for the trend analysis section.

Practical Activity - Trend Analysis
00:19

The conclusion to the Trend Analysis section.

Conclusion to Trend Analysis Section
00:40
+ Other Graph Types
10 lectures 42:02

Introduction to the Other Graph Types section.

Introduction to Other Graph Types
01:33

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

Waterfall and KPI Visualizations
08:21

In this lesson you will learn how to use the combination graph visualization.

Combination Graphs
03:13

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

Pie Graphs
03:00

In this lesson you will learn how to create the Treemap graph.

Treemap Graphs
01:42

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

Geographical Graphs
02:36

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

Scatterplots and Bubbleplots
08:50

Practical activity to work with the Scatterplot and Bubbleplot visualizations

Practical Activity - Scatterplots
00:27

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

Practical Activity Completed - Scatterplots and Bubbleplots
11:55

Conclusion to the Other Graphs section.

Conclusion to Other Graphs
00:25
+ Interactive Dashboards
9 lectures 42:04

Introduction to the Interactive Reports section.

Introduction to Interactive Dashboards
01:35

In this practical activity you will create an interactive report

Practical Activity - Create an Interactive Report
00:30

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

Create the Interactive Dashboard
08:19

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

Drill Through Filters
05:59

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

Grouping and Groups
08:04

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

Advanced ToolTips
05:53

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

Bookmarks
06:16

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

Publish Interactive Dashboards
05:00

Conclusion to the Interactive Dashboards section.

Conclusion to Interactive Dashboards
00:28