Power BI
Video/Text

How to Create a Work Order Backlog Analysis Dashboard using Power BI in Under 90 Minutes

1 Module 5 Chapters 19 Lessons

Course overview

Get up and running with Power BI in under 90 minutes with my Power BI Quick Start Course.

Learn more

Course Structure

FREE Course
5 Chapters

Power BI Quick Start

The 5 Step Effective Dashboard Building Process 2 Lessons

Introduction

1.) The 5 Step Effective Dashboard Building Process

Importing Data 1 Lesson

2.) Importing Data and Carrying out Basic Transformations

Building Your Dashboard 7 Lessons

3.) Adding Calculated Columns Containing DAX IF() and SWITCH() Statements

4.) Adding Measures containing DAX SUM(), COUNTROWS(), SUMX() Functions

5.) Best Practice Page Layout, Adding and Customising Cards and Importing a Theme

6.) Adding Cards and Applying Visual Level Filters

7.) Adding a Slicer, Sorting One Field By Another and Dealing with (Blank) Values

8.) Add and Format Column Chart Visuals

9.) Add Matrix Visual and Heat Map Conditional Formatting

Adding Interaction To Your Dashboard 6 Lessons

10.) How to Control Cross Filtering of Visuals Using Edit Interactions

11.) Creating and Configuring a Drillthrough Report

12.) Adding Colour Conditional Formatting Using a DAX Measure

13.) Adding a Help Pop-up Tooltip to a Visualisation

14.) Creating a Bookmark for Drilling Through to Total Backlog

15.) Adding a Pop-up Tooltip with Additional Information

Section 5 - Publishing the Dashboard to the Power BI Service 3 Lessons

16.) Publishing Your Dashboard to the Power BI Service

17.) Final Overview of Dashboard Functionality

Final Dashboard Power BI File

Pen
>