Power BI Data to Dashboard Training for Excel and Power BI Professionals
Power BI Online Training

Foundations of Power BI – Data to Dashboard Online Training

Matt Allington has been delivering live Power BI in Australia since 2014 and he has taught literally thousands of people with these live training courses and books.  Now you can get the live training experience by watching this recorded live training course.

In this training, you will understand the Power BI Desktop features and learn 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. You will also get an introduction on Power Query. Power BI is easy to learn, and you can supercharge your learning experience with this Online 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/Power Pivot/Power Query 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 real time scenarios to teach you the tricks.
  • You can download the slides used in the training.
  • You will have access to the online videos for 36 months, so if you want to come back and watch them again then that is fine.
  • You can purchase the course and start-off on the course at any time, and you will get access to the lessons (videos) immediately.
  • It is great value at US$99 for 36 months access to the online materials (videos).
  • You can claim 8 CPD hours.
  • Certificate available on request after completion of the course.
  • Buy this and any other Online Training at the same time and automatically get 10% off the price of those products!

Course Content

This course is a screen recording of one of Matt’s live public training courses. It is not a theatre 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.

Course Duration – 3.25 Hrs.

Module 1: 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 2: 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 3: Sharing Reports in Power BI.com – 33 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 4: Power Query – An Introduction – 74 minutes

LessonKey Topics Covered
Power Query – An Introduction
24 minutes
Getting data from a web page
Power Query
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 data
Power Query – 2 More Power Query Techniques
17 minutes
Edit 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 with Power Query
21 minutes
Get Data from Folder
Combine & Edit
Sample File query
Consolidation query
Editing Sample File query
Fixing the Consolidation query
Refreshing the Consolidation query
Power Query Audit
12 minutes
Data used for the example
Create connection without load
Create a new query
Merge Queries as New
Profiling
Adding Variance column
Replace Values
Adding Status column

Additional Goodies

  • Copy of Slides used in the training.
  • Self-paced training with timestamps provided for all the topics in every lesson to go through any specific section anytime.
  • CONTACT COURSE TEACHER button enables you to send a message to Matt Allington directly for any query on the course.
  • Certificate available on request after completion of the course.

Ready to purchase? You can purchase online from my shop here and start learning immediately.

Scroll to Top

Power Query can automate boring, repetitive tasks you do every day.  Watch free previews of my online training course to see how.