Data to Dashboard Using Power BI VOD Training Course
Data To Dashboard Logo

Data to Dashboard Using Power BI

Data To Dashboard LogoMatt Allington has been delivering live Power BI training in Australia since 2014, and he has taught literally thousands of people with his live training courses and books.  Now you can get the same training content via a video on demand version of this training course.

In this VOD training, you will learn about the important Power BI Desktop features and how to create different types of reports. You will also learn how to share your reports, create Dashboards on Power BI.com, use the Power BI features such as Q&A, Quick Insights, Analyze in Excel, etc. The course also covers an introduction to Power Query (many people still don’t know how powerful Power Query is, so this is a “taste sampler” of what is possible).

Power BI is easy to learn, and you can supercharge your learning experience with this Video on Demand Training course specifically targeted to you.

Why Should I Purchase?

  • It has been designed and created Matt Allington (Microsoft MVP).
  • Matt is a true Power BI professional who understands business users AND the technology that can solve these problems. i.e. he understands you and your problems.
  • The training is all “example based” using relevant hands on practice scenarios to teach you the tricks.
  • You can download the slides used in the training for future reference.
  • You will have access to the online videos for 12 months, so if you want to come back and watch them again then that is fine.
  • You can purchase the course and complete (and repeat) the content at any time over 12 months.
  • The course is an annual subscription with a list price of US$99 USD for the first year ($29 annual subscription + a $70 sign-up fee) and then US$29 per year after that if you wish to retain access. 
  • There is a certificate available on request after completion of the course.
  • When you buy this and Extracting Data Insights with Power BI and DAX VOD training course at the same time and get 10% off the price of both products. Most people purchase both courses. 

Course Content

This course is a screen recording of one of Matt’s live public training courses. It is not a theater production quality movie but rather a live recording of the step by step training and instructions from a live session. The audio quality in the recording does vary as Matt moves closer and further from the microphone, but it is clearly audible at all times.

Video Content Duration = 3+ Hrs.

The course is designed so that you should participate with the exercises.  You can pause and replay the video as you do the exercises with Matt’s instruction.  It normally takes 6-7 hours of elapsed time to complete the content this way.

Module 1: Introduction to Course – 18 minutes

LessonKey Topics Covered

An Introduction to Power BI

18 minutes

Placing a logo in the report
Resizing a logo
Adding a title to the report
Formatting the title of the report

Module 2: Power BI Desktop – Building Your First Report – 59 minutes

LessonKey Topics Covered
An Introduction to Building Power BI Reports
3 minutes
Placing a logo in the report
Resizing the logo
Adding a title to the report
Formatting the title of the report
Building Power BI Reports – Map Visual
11 minutes
Creating a map visual
Resizing the map
Fields list of the visual
Importing report theme
Renaming a field in the visual
Using colour saturation
Building Power BI Reports – Column Chart Visual
15 minutes
Creating a visual using Q&A feature
Changing the sort order in a visual
Cross-filtering
Data labels in a visual
Reset cross-filtering
Creating an ad-hoc hierarchy in a visual
Drill up and down in the visual
Focus mode (Full-screen mode)
Show Data
Drill Down and Drill Up
Data hierarchy in a table
Deleting a data hierarchy
Building Power BI Reports – Bar Chart Visual
3 minutes
Creating a visual with copy-paste of an existing visual
Repurposing a visual switching it to bar chart
Cross-filtering among the visuals
Cross-filtering by selecting fields on different visuals
Building Power BI Reports – Slicer Visual
6 minutes
Adding a Slicer visual to the report
Filtering using Slicer
Significant difference between Slicer and Cross-filtering
Eraser; List; Dropdown
Selection in a Slicer redraws the entire charts
Controlling cross-filtering using Edit interactions
Building Power BI Reports – Card Visual
2 minutes
Adding a Card visual to the report
Formatting Card visual
Building Power BI Reports – Line Chart Visual
10 minutes
Adding line chart visual to the report
Date hierarchy
Drilldown the date hierarchy
Analytics features
Forecast
Documentation on Forecasting in Power BI
Sharp increase in the line chart
Analyze – Explain the increase
Adding the analysis chart as a visual to the report page
Building Power BI Reports – Bookmarks
9 minutes
Bookmarks pane and Selection pane
Adding a Bookmark
Creating another view and adding a Bookmark
Toggling between Bookmarks
Navigating through different views as in PowerPoint presentation mode
Adding Buttons to Report
Giving labels to the Buttons
Assigning actions to the Buttons
Using the Buttons to trigger the assigned actions

Module 3: Power BI Desktop – Other Reports – 33 minutes

LessonKey Topics Covered
Building Power BI Reports – Top Customers Report
9 minutes
Adding a new page to the report
Copying and pasting the Logo and Title from previous page
Editing the Title
Table and Matrix visuals
Adding a Table to the report
Adding fields (columns) to the Table
Filtering the Table to display Top 20 Customers
Sorting the Table by selecting a column
Formatting a column
Conditional Formatting on the columns of the Table
Building Power BI Reports – Customer Detail Report
9 minutes
Creating a Table with all transactions
Adding DRILLTHROUGH filter
Adding a Card with Customer Name
Drillthrough to the Customer Detail Report
Interactive Drillthrough Report
Building Power BI Reports – Tool Tip Report
15 minutes
Adding Fields to Tooltips
Building a Custom Tooltip
Creating a Blank Page named ToolTip
Formatting Page as Tooltip Page
Changing Page Size to Tooltip
Changing Page View to Actual Size
Adding Tooltip field to TOOLTIP
Building the Tooltip Report
Viewing the Custom Tooltip

Module 4: Sharing Reports in Power BI.com – 32 minutes

LessonKey Topics Covered
Publishing Reports to Power BI.com
15 minutes
Signing in to Power BI.com
Power BI.com Key Areas
Creating an App Workspace
Assigning Access to App Wokspace
Publishing a Report from Power BI Desktop
Published Report as Dataset in Power BI.com
Reports in Power BI.com and Power BI Desktop
Workbooks in Power BI.com
Creating Dashboards
7 minutes
Dashboards in Power BI.com
Pinning Visuals on to Dashboard
Resizing Dashboard Tiles
Pinning a Range from a Workbook
Adding Tiles from other Sources
Pinning entire Report Page on to Dashboard
Fully Interactive Report on Dashboard
Q&A in Power BI.com
Mobile Phone View of Dashboard
Power BI.com – Other Topics
11 minutes
Sharing Methods
Sharing Workspace
Sharing Dashboards
Sharing Reports
Publish to Web
Creating and Sharing an App Workspace
Quick Insights
Pinning an Insight to Dashboard
Analyze in Excel
Thin Workbook
Sharing Thin Worbooks

Module 5: Power Query – An Introduction – 54 minutes

LessonKey Topics Covered
Introduction to Power Query
2 minutes

Overview of the topics that will be covered in the other 2 lessons in this module

Connect to, Clean and Load Data

35 minutes

Getting data from a web page
Steps to show how Power Query works
Remove Rows
Context menu button
Use First Row as Headers (Promote the first row as column headers)
APPLIED STEPS
Cog of a step – step wizard
Remove Columns
Cleaning and tidying
Changing Data type
Replace Values
Renaming Table
Shape of the table
Unpivot Other Columns
Transform and Add Column
Loading dataEdit Queries
Creating Country-State hierarchy
Combining State and Country into a column
Add Column – Column From Examples
Data view
Building geographical hierarchy
Using the State Country combined column
Setting Data Category
Using Colour Saturation in Map visual
Copying a query from Power BI to Excel
Copying query code to a text editor
File Consolidation
18 minutes
Get Data from Folder
Combine & Edit
Sample File query
Consolidation query
Editing Sample File query
Fixing the Consolidation query
Refreshing the Consolidation query

Additional Goodies

  • Copy of Slides used in the training.
  • Self-paced training with demos, illustrative examples, sample exercises and downloadable example files.
  • Certificate available on request after completion of the course.

Where to purchase?

As you may have read here, Matt has migrated his video on demand training content to http://skillwave.training in partnership with Ken Puls and Miguel Escobar (of M is for Data Monkey and Power Query Academy fame).  If you would like to purchase Matt’s Data to Dashboard training course, head over to https://www.skillwave.training/shop/data-to-dashboard-using-power-bi/ and purchase the course. 

As an alternative, you can complete this course as a live, instructor led class instead (see the link here https://exceleratorbi.com.au/power-bi-virtual-online-training/ )

This live class is delivered by Jason Cockington. Jason is a full time Power BI trainer and consultant certified by Matt to deliver this content. If you purchase the live, instructor led version of the course, you will receive the Video on Demand version of the content outlined on this page for free for the first 12 months included in the price (best of both worlds). 

Scroll to Top

Power BI Online Training from a Pro

Matt Allington has 6 years’ experience teaching Power BI. There are lots of ways to learn.