Power BI
Text

Free Resources

3 Modules 0 Chapters 78 Lessons

Course overview

Free resources to download and use.

Learn more

Course Structure

FREE Course
76 Lessons

YouTube Video Files

This module contains all of the Power BI and other resources used in my YouTube videos.

How to Import Row Based KPI data From Excel to Power BI using Power Query – Maintenance KPI Example

Formatting a MATRIX of Maintenance KPIs Imported from Excel into Power BI – Pt2

Adding KPI Target Values to a Maintenance KPI Matrix & How to Set the Display Format for Each – Pt3

Replicating an Excel Maintenance KPI Matrix in Power BI Pt4 – KPI Grouping Headers using Power Query

QT#9 - Why You Need a 'Dates' Table in Power BI and How to Create One

QT#25 – Save Space! – TOGGLE between maintenance backlog hours and work order MEASURES on a Matrix

QT#23 – Adding a HELP OVERLAY to provide instant help on how to interact with your dashboard

Case Study: Creating a Work Order Risk Matrix Visual in Power BI Using the Synoptic Panel

QT#24 – Add VISUAL level HELP tooltips to show KPI or category definitions – make users happy

QT#27 – How to Configure the Power BI POWER KPI Visual including setting up the KPI Indicator Index

QT#28 – 5 Tips for Using Power BI DECOMPOSITION Tree for Equipment Failure Root Cause Analysis

Resources for Mini Course on YouTube – Power BI OkViz Bullet Chart

QT#29 – Alternative to Power BI Standard Visual Level Tooltip That’s Far Easier For Readers to Find

Resources for Mini Course on YouTube – Power BI Waterfall Charts

QT#30 – Power BI – How to CLEAR all FILTERS on the screen with ONE CLICK

QT#34 – Add tooltips to specific dates on a Power BI line chart to explain increases and decreases

QT#35 – Toggle show hide tooltips

QT#37 – Keep Power BI visuals in their place! Stop backgrounds covering visuals when clicked.

How to use DAX USERELATIONSHIP() - Example 1 - Non-date example. Using a common category axis

How to use DAX USERELATIONSHIP() - Example 2 - Creating Relationships Between Multiple Date Fields In the Same Record

Power BI Visual Guide #1 - The Matrix Pt1 - Configuration and Formatting Options Explained in Detail

Power BI Visual Guide #2 - Matrix Pt2 - Drilldowns, Conditional Formatting Bars & Column Sort Order

Power BI Visual Guide #4 - The KPI - 4 Different Ideas For Tracking KPI Goals or Limits

Power BI Visual Guide #5 - The Multi Row Card - 3 Configuration Options and One Major Drawback!

QT#40 - Adding Different CONDITIONAL FORMATTING Rules to a Power BI Matrix Column Values

QT#41 - 6 Steps for Optimising a Power BI Matrix to Displaying Multiple Measures

Power BI Visual Guide #6 - 2 Ways to Configure Small Multiples to Replace Busy Line Graphs

Power BI Visual Guide #7 - Treemap - 4 Ways to View Your Data, With Alternatives

Power BI Visual Guide #8 - The Gauge - Good or Bad? 4 Scenarios Using Different Data Models

Power BI Visual #9 - Scatter Chart Pt1 - Cost Optimisation Using a Scatter Chart and Analytics Lines

Power BI Visual Guide #9 - Scatter Chart Pt2 - Creating a Risk Matrix Using a Scatter Chart

Power BI Visual Guide #10 - The Ribbon Chart- 3 Examples of How to Use a Ribbon Chart With Your Data

Power BI Visual #11 - The Funnel

Power BI Visual #12 - The Donut Chart Done Right

Power BI Visual Guide #13 - Gantt Chart By MAQ Software - Including How to Configure the KPI Metrics

QT#42 - One Setting to Display First, Last, Maximum and Minimum Values on Power BI Line Graphs

QT#43 - Dynamically Set Power BI Line Graph Y-Axis Start & End Range - Stop Labels Overlapping Line

QT#44 - Highlighting and Displaying Power BI Line Chart Min, Max, First, and Last Data Labels

Finally...Conditionally Formatting Power BI Line Graph Labels...Unfortunately, It's Almost Useless 😞

Power BI Multi-Row Card Conditional Formatting - How it Works and Why it's Not that Useful

QT#47 - Adding a vertical current date line to a line chart

QT#48 - A Simple Way to Highlight and Add Comments to Specific High or Low Points on a Line Graph

Adding Total and Average Values to Table

QT#49 - Drill Through From a Power BI Card Visual in 5 Simple Steps

Power BI Visual Guide #14 - Maps - How to Set-Up and Configure Map Visuals Plus Pros and Cons

QT#50 - 2 Good Reasons For Adding Series Labels to Power BI Line Charts and How to Configure Them

Power BI Drillthrough Masterclass Lesson 1 - How to Configuring a Drillthrough in a Power BI Report

QT#51 – How To Use a Power BI Slicer For Page Navigation. Ideal If You Have Limited Space

Power BI Visual Guide #15 - The Slicer (Pt 1 and Pt 2 Files)

Case Study - Creating a Maintenance KPI Balanced Score Card in Power BI

Case Study – Top Quartile Reporting in Power BI using the PERCENTILE.INC() Function

Power BI Analytics Pane – Easily Create FORCAST, TREND, TARGET, MIN/MAX Lines & More in a few clicks

QT#52 – Power BI Multi-Row Card Conditional Formatting – How To Highlight Off Target Category Values

Power BI Visual Guide #16 - The Multi Info Card (With Better Conditional Formatting Option)

QT#55 – Adding a Sparkline to a Power BI Matrix Plus Cool Formatting Ideas

QT#56 - Refreshing Narrative Dataset Values on Power BI Chart Using Power Automate Button

QT#57 - Setting Sort Order of Y-Axis of a Ribbon Chart (Not Perfect, But Works)

Maintenance KPI - Planned Vs Actual Work Order Hours (Planner Accuracy) - Power BI Dashboard

QT#58 – When to Switch Off the ‘Keep All Filters’ Toggle in a Power BI Drill Through

Maintenance KPI – Calculating MTBF & MDT (Mean Time Between Failures & Mean Downtime) in Power BI

Maintenance KPI – % Availability and % Technical Availability In Power BI – Scenario 1

Maintenance KPI – MTBF, MDT & % Availability In Power BI Scenario 2 – Duty / Standby Machines

Creating a Pop-Out Navigation and Filter Bar Using Power BI Bookmarks. 4 Ideas for Sections to Add

How to Create Cool Sub-Tabs to Switch Between Visuals on a Power BI Report Page – Bookmark Navigator

Show and Hide Power BI Field Parameter Slicers to Reduce Confusion and Save Space

QT#66 – Integrate Measures Into the Standard Power BI Text Box to Create Dynamic Titles

Maintenance KPI – Percentage of Proactive and Reactive Work Hours Completed

QT#69 – Power BI Data Label Conditional Formatting + Neat Dynamic Y-Axis Trick

QT#70- Neat Idea For Adding Conditional Formatting Alternative to DATA BARS in Power BI TABLE visual

How to EMBED a Power BI Report DATA Directly Into An Alert Driven EMAIL Using Power Automate

Power BI Visuals – BAR CHARTS vs. TABLE DATA BARS – How to Configure Them and When To Use Each One

Create Custom Notification Centre in Power BI - Shows Count of Unread Notifs For Current User for Logged in User

How to Add METRIC Check-in NOTES As Narratives in POWER BI REPORTS

Power BI CARD with STATES by OKViz Deep Dive – Learn 3 Ways To Set Up This Great Card Visual

QT#82 – Improving the Design of a matrix visual HEAT MAP in Power BI

QT#90 - Adding a Budget vs Actual Variance Value to a Power BI Clustered Column Chart

FREE Course
1 Lesson

Power BI Risk Management Dashboard Files

Downloadable resources for the YouTube course on how to create a risk management dashboard using Power BI

Resource Downloads

FREE Course
1 Lesson

Power BI Quick Start Work Order Backlog Dashboard Files

Files to support the Youtube version of the Power BI Quick Start Course

Resource Downloads

Pen
>