![Jason Davidson](/img/default-banner.jpg)
- 216
- 1 047 545
Jason Davidson
United Kingdom
เข้าร่วมเมื่อ 24 ต.ค. 2019
To all Maintenance and Reliability Professionals,
YOU are in the right place if you want to learn how to get the most out of Power BI to quickly build truly effective maintenance and reliability dashboards and reports
This channel is built specifically for maintenance and reliability professionals who are looking to learn how to use PowerBI to build reports and dashboards to display, interact with and unlock insights within your maintenance and reliability data. No matter if you are a beginner or are further up the PowerBI learning curve this channel has something for you
The videos you'll have access to in this channel will focus on explaining how to define the common maintenance and reliability KPIs such as work order backlog, work order workflow measures, mean time between failures (MTBF), mean time to repair (MTTR), maintenance costs and much more. It'll also use case studies & quick tips the help you get the most out of Power BI's powerful features - Enjoy!
YOU are in the right place if you want to learn how to get the most out of Power BI to quickly build truly effective maintenance and reliability dashboards and reports
This channel is built specifically for maintenance and reliability professionals who are looking to learn how to use PowerBI to build reports and dashboards to display, interact with and unlock insights within your maintenance and reliability data. No matter if you are a beginner or are further up the PowerBI learning curve this channel has something for you
The videos you'll have access to in this channel will focus on explaining how to define the common maintenance and reliability KPIs such as work order backlog, work order workflow measures, mean time between failures (MTBF), mean time to repair (MTTR), maintenance costs and much more. It'll also use case studies & quick tips the help you get the most out of Power BI's powerful features - Enjoy!
Simplify Accessing Power BI Reports for Business Users: Building a One-Stop Reporting Hub
Business user who just want to quickly locate and run their reports often complain that the Power BI Service home page is cluttered and confusing.
In this video, I'll cover 2 approaches to making it simpler and quicker for business users to access Power BI Reports.
I've had lots of feedback that the Power BI Service Home page is cluttered, confusing and just not a good user experience for day-to-day business users who want to run reports.
They are not interested in building their own reports they just want to quickly and easily get to the information they need so they can use it to make better decisions.
Power BI "Apps" are tools designed to package reports in a single location that a business user can navigate to and find all the information they need in one place. Apps are great however if you want to show the same report in multiple apps then this can be an issue in terms of ensuring that the same version of the report is published to each app each time the report is updated.
Often apps are created on a department-by-department basis. For example, there is an app for Maintenance, an app for Health, Safety and Environment, for Operations, Finance etc.
But what happens if you are a manager and you want to look across multiple departments? You don't want to have to navigate to 4 or 5 different apps. You want all of your reports in one place, that is quick to access and simple to navigate around.
In this video, we'll cover 2 approaches to make it quick and easy to set up apps that can pull reports from apps into a single location, without then needing to publish multiple versions of the report.
The first approach using apps, but using a feature that allows you to embed links into your app.
The second approach uses Matrix Scorecards as a landing page reporting hub that shows the key values, but also lets you quickly navigate to your tailored list of reports and apply a custom filter to each one!
------------------------------------------------------------------------------------------
🎥 Related Videos
------------------------------------------------------------------------------------------
➡️A Guide to Metrics
th-cam.com/video/zzbLVgmNSsE/w-d-xo.html
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power-bi-quick-start-plus/
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX file for this TH-cam video:
effectivedashboards.com/course/create-neat-little-risk-matrix-svg-icons-ideal-for-power-bi-table-and-matrix-visuals/
effectivedashboards.com/courses/free-resources/
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-articles/
In this video, I'll cover 2 approaches to making it simpler and quicker for business users to access Power BI Reports.
I've had lots of feedback that the Power BI Service Home page is cluttered, confusing and just not a good user experience for day-to-day business users who want to run reports.
They are not interested in building their own reports they just want to quickly and easily get to the information they need so they can use it to make better decisions.
Power BI "Apps" are tools designed to package reports in a single location that a business user can navigate to and find all the information they need in one place. Apps are great however if you want to show the same report in multiple apps then this can be an issue in terms of ensuring that the same version of the report is published to each app each time the report is updated.
Often apps are created on a department-by-department basis. For example, there is an app for Maintenance, an app for Health, Safety and Environment, for Operations, Finance etc.
But what happens if you are a manager and you want to look across multiple departments? You don't want to have to navigate to 4 or 5 different apps. You want all of your reports in one place, that is quick to access and simple to navigate around.
In this video, we'll cover 2 approaches to make it quick and easy to set up apps that can pull reports from apps into a single location, without then needing to publish multiple versions of the report.
The first approach using apps, but using a feature that allows you to embed links into your app.
The second approach uses Matrix Scorecards as a landing page reporting hub that shows the key values, but also lets you quickly navigate to your tailored list of reports and apply a custom filter to each one!
------------------------------------------------------------------------------------------
🎥 Related Videos
------------------------------------------------------------------------------------------
➡️A Guide to Metrics
th-cam.com/video/zzbLVgmNSsE/w-d-xo.html
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power-bi-quick-start-plus/
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX file for this TH-cam video:
effectivedashboards.com/course/create-neat-little-risk-matrix-svg-icons-ideal-for-power-bi-table-and-matrix-visuals/
effectivedashboards.com/courses/free-resources/
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-articles/
มุมมอง: 4 369
วีดีโอ
Create Neat Little Risk Matrix SVG Icons - Ideal for Power BI Table and Matrix Visuals
มุมมอง 1K2 หลายเดือนก่อน
I'll show you how to create mini SVG icons in Power BI in this video. These icons are an excellent way to indicate the risk zone of a work order (or any records you're tracking) on the risk matrix. Perfect for displaying lists of items with their associated risk placements. As well as creating the mini SVG risk matrix icons, I'll walk you through several enhancements and fixes for the risk matr...
Build an Interactive Risk Matrix in Power BI (Button Slicer Technique)
มุมมอง 3.6K5 หลายเดือนก่อน
Learn how to build an interactive work order risk matrix in Power BI. This approach uses the native button slicer as an overlay for an image of the risk matrix. With this simple approach, you can have a powerful visual for representing risk up and running in about 30 minutes. What you'll learn - - Importing custom risk matrix images (easily created in PowerPoint) - Creating a helper table for s...
Use Power Automate, Power BI, OpenAI and Outlook (Email) to Automate Weekly Operations Reporting
มุมมอง 4.2K5 หลายเดือนก่อน
Learn how to combine your Power BI data with the natural language generation capability of openAI to generate a weekly management report. Many companies have a cadence of creating monthly, weekly and daily management overview reports. These reports typically involve creating a narrative around a set of underlying event data. In the domain of maintenance and operations, this could be HSE inciden...
Power BI Matrix Revamp: Update Your Layout with the Latest Features & Visual Tricks
มุมมอง 1.5K7 หลายเดือนก่อน
In this video, discover how to transform your Power BI Matrix visuals using the latest features and some insightful visualisation techniques I've picked up recently. What you'll learn: 👉 Enhancing readability with strategic white space 👉 Crafting impactful titles and sub-titles for better labelling 👉 Innovative ways to label matrix rows and column categories ...and more! 🤔 Reflecting on past Po...
Show Targets and Highlight Variances With REFERENCE LABELS in Power BI New Card Visual
มุมมอง 1.2K7 หลายเดือนก่อน
Unlock the full potential of your Power BI dashboards in this easy-to-follow tutorial! Learn how to power up your Power BI card visuals by adding extra detail with reference labels. In this video, I'll guide you through the simple steps to enhance your Power BI card visual, providing more context on the current performance against a backlog threshold target. This will not only improve the aesth...
Create Power BI Card Visuals That Act As Slicers Using New Slicer Visual
มุมมอง 3.3K8 หลายเดือนก่อน
Learn how to set-up the Power BI Button Slicer to look and feel like a card visual that also acts as a slicer! There are often situations when you might want to display a row or column of card visuals that each show a filtered value within a category. For example, you might want to show 4 cards each displaying the number of backlog work orders for safety, environmental, production and routine w...
OpenAI (ChatGPT) in Power BI: Pt 3 - Prompt Engineering & Effectiveness Testing
มุมมอง 1.3K9 หลายเดือนก่อน
Dive into Part 3 of this practical case study, where we continue leveraging OpenAI's LLM to enhance the quality of manually entered work order defect reporting data. 👍 Evaluate AI Feedback Effectiveness: Learn how to assess the impact of OpenAI's coaching tips on improving work order data quality. 👍 Continuous Improvement Loop: Understand the process of testing and refining the AI response for ...
Enhancing Data Quality with OpenAI in Power BI: Part 2 - Avoiding Redundant Processing
มุมมอง 8559 หลายเดือนก่อน
Delve deeper in Part 2 of the case study, where we explore the setup of a data improvement process using Open AI for reviewing manually entered data. In this insightful video, you'll learn how to: 👉 Optimize Power BI: Enhance your setup to efficiently differentiate between assessed and unassessed work orders. 👉 Refine PowerAutomate: Upgrade your Flow to effectively avoid redundant submissions t...
Displaying Value AND Percentage of Target on Power BI Gauge Visual
มุมมอง 4.7K10 หลายเดือนก่อน
In this video, I'll explain how to update the Power BI gauge visual call-out to display not only the call-out value but also the percentage of the target value being tracked by the gauge. It's super simple to do and only takes a few minutes to set up. I'll also explain how to create a neat dynamic sub-title that provides additional information related to the current value vs a year to day targe...
Integrate OpenAI Models (like ChatGPT) Into Your Power BI Dashboards Using Power Automate
มุมมอง 10K10 หลายเดือนก่อน
Harness the Power of OpenAI for Power BI: This video offers a straightforward approach to integrating OpenAI models, such as the one behind ChatGP, with Power BI reports via Power Automate. We'll focus on a specific use case: utilizing OpenAI's GPT-3.5-Turbo for carrying out quality control of work order data. However, this method is versatile enough for any data set. Inside, you'll discover: 👉...
Maintenance KPIs In Power BI: Work Management Process Dashboard
มุมมอง 6K11 หลายเดือนก่อน
In this video, I'll cover a case study of a maintenance work management dashboard in Power BI. I'll take you through each of the maintenance work management KPIs on the dashboard and explain why they are there. I'll also cover the design decisions I made and why. The purpose of the dashboard is to help track the flow of work through the maintenance work management process steps: 1. Identify and...
Visualise Availability, MTBF & Maintenance Costs of Equipment with Power BI Scatter Charts
มุมมอง 986ปีที่แล้ว
In this video, you'll learn how to use Power BI Scatter Charts to visualise the reliability of different types of equipment effectively. This is ideal for maintenance and reliability engineers looking to visualise and communicate this date to managers and build a case for investment. What You'll Learn: How to represent three key dimensions: Availability, Mean Time Between Failure (MTBF), and To...
Using ChatGPT to Fast-Track Creation of Power BI Sparkline SVG Charts In the NEW CARD VISUAL
มุมมอง 1.8Kปีที่แล้ว
In this video, you'll learn how to create your own SVG sparkline charts and add them to the new card visual in Power BI. To shortcut the process we'll start by using one of the SVG sparkline accelerator templates provided by a blogger called Kerry Kolosko. We'll then take that base template and customise it to meet our specific requirements with the help of ChatGPT. This is a great approach if ...
Enhance the Amazing New Power BI Card Visual with Conditional Formatting of ICONs and Accent Bars
มุมมอง 3.5Kปีที่แล้ว
Enhance the Amazing New Power BI Card Visual with Conditional Formatting of ICONs and Accent Bars
Power BI's Stunning New Card Visual Explained
มุมมอง 3.9Kปีที่แล้ว
Power BI's Stunning New Card Visual Explained
QT#93 - Slopegraphs: The Simple and Better Way to Visualize Change Using Power BI Line Charts
มุมมอง 847ปีที่แล้ว
QT#93 - Slopegraphs: The Simple and Better Way to Visualize Change Using Power BI Line Charts
QT#92- 2 Options For Displaying Year To Date (YTD) Values Over Multiple Years - Power BI Line Graphs
มุมมอง 1.1Kปีที่แล้ว
QT#92- 2 Options For Displaying Year To Date (YTD) Values Over Multiple Years - Power BI Line Graphs
QT#91- Display Current Value + the Change From Previous Week on Data Labels on a Power BI Line Chart
มุมมอง 1Kปีที่แล้ว
QT#91- Display Current Value the Change From Previous Week on Data Labels on a Power BI Line Chart
QT#90 - Adding a Budget vs Actual Variance Value to a Power BI Clustered Column Chart
มุมมอง 10Kปีที่แล้ว
QT#90 - Adding a Budget vs Actual Variance Value to a Power BI Clustered Column Chart
QT#89 - Adding Conditional Formatting Icons to Data Labels on Power BI Visuals
มุมมอง 2.1Kปีที่แล้ว
QT#89 - Adding Conditional Formatting Icons to Data Labels on Power BI Visuals
QT#88 - Dynamic Formatting Power BI Data Label Rounding Suffixes
มุมมอง 1.1Kปีที่แล้ว
QT#88 - Dynamic Formatting Power BI Data Label Rounding Suffixes
Power BI Visual Guide #17- Master SMALL MULTIPLES with Bars & Lines: Level Up Your Data Viz
มุมมอง 3Kปีที่แล้ว
Power BI Visual Guide #17- Master SMALL MULTIPLES with Bars & Lines: Level Up Your Data Viz
QT#86- APPLY and CLEAR all Slicers with One-Click in Power BI
มุมมอง 1.6Kปีที่แล้ว
QT#86- APPLY and CLEAR all Slicers with One-Click in Power BI
QT#85- 5 Ways to Use SUBTITLES on Power BI Visuals to Enhance Your Storying Telling
มุมมอง 2.4Kปีที่แล้ว
QT#85- 5 Ways to Use SUBTITLES on Power BI Visuals to Enhance Your Storying Telling
QT#84 - 3 Ways ChatGPT Can Be Your Power BI Report Development Buddy
มุมมอง 2.2Kปีที่แล้ว
QT#84 - 3 Ways ChatGPT Can Be Your Power BI Report Development Buddy
QT#83 - Conditional Formatting Power BI Table or Matrix Cells Using The Cells Text Content
มุมมอง 4.9Kปีที่แล้ว
QT#83 - Conditional Formatting Power BI Table or Matrix Cells Using The Cells Text Content
QT#82 - Improving the Design of a matrix visual HEAT MAP in Power BI
มุมมอง 2Kปีที่แล้ว
QT#82 - Improving the Design of a matrix visual HEAT MAP in Power BI
Power BI CARD with STATES by OKViz Deep Dive - Learn 3 Ways To Set Up This Great Card Visual
มุมมอง 5Kปีที่แล้ว
Power BI CARD with STATES by OKViz Deep Dive - Learn 3 Ways To Set Up This Great Card Visual
QT#81 - How to Configure the Time Period 'Cycle Over' Comparison Values in Power BI Metrics
มุมมอง 2.2Kปีที่แล้ว
QT#81 - How to Configure the Time Period 'Cycle Over' Comparison Values in Power BI Metrics
Not all heroes wear capes!
Lol, that's made my day 🤣
great explaining with good presentaiton.
Amazing idea to use metrics as a navigation page! Nevertheless, if you prefer to bundle copies of reports in the site manager's app, this is not that much of a maintenance nightmare: You can either use a REST API and a deployment script to deploy to two workspaces or you can set up a watchdog process that, once a new version is published in the report's main workspaces it is copied to the site managers workspace. For this approach, I'd recommend to use live connected reports so that you don't create copies of the data. Since you need Power BI deployment pipelines to automate the update of the app and you need Premium license for deployment pipelines, that may be the solution for larger organizations. But I think, for many use cases I like your metrics approach more anyway.
Interesting video. I'm new to Power BI. What's the benefit of creating an app for, in your example, the Site Manager, rather than simply giving them access to the Site Manager workspace and filling the workspace with the reports/scorecards/etc relating to the Site Manager?
Definitely use an app. They offer loafs of additional options for end users to make is easier for them to access reports. Sorry I don't have time for a more comprehensive answer but do a bit of Googling to find out what the options are because it's defo a better option. Plus if you have added the reports to the workspace it's just clicking a few buttons to publish the app.
Can you please tell me which license of power bi you are using. Can i do it with pro license
Hi, It's a pro licence so you should be fine.
You can also add embebed power apps.
Nice! I've never actually thought of that before.
Very helpful. Thank you!
Exactly, what I need for today'. Thanks for your excellent content, hard to come by good info on PBI apps.
Thanks for your kind words. Glad it was helpful!😀
Thank you
Wow
I can't put the length in points
Thank you. It has helped me a lot in the execution of my tasks in my company.
There are penty of videos talking about the Conccepts you should take into consideration when creating a Risk Management Dashboard. But almost none of the actuall show an exampe. That is great.
Great One.Thank You
Thanks mate, 2 mins of video were more worthy than hours of research.
Great video I want to do the same project but I want to make a scheduled daily refresh of the report and I want it to send an email daily after each refresh. With the report content included in the email
I have closed work orders that have zero planned hours the I need to remove from the equation
🎉🎉🎉appreciate your kind words
thank you for sharing this great video, I'm excited to update the KPI dashboard I manage. How do you insert the arrow icon into the measure?
12:50- pronounced lo-CAL :) 18:00- Count the Number of Lines, Condition in flow 27:30 - Refresh button (and 1:37)
Can this be done with multiple arguments? Trying to format the entire matrix but don’t want to write 40 measures. Thanks in advance.
Very informative. Can you share a video which will explain the different Bookmark Settings and how and when to use them? If you already have created one, can you share the link?
This training is such a miracle! I really appreciate your video, you are my hero! The only subject I wish you covered is about formating the "Date" which is a common problem.
Thanks!
Thanks so much. I'm glad the videos helped you 😄
Very useful video, thank you so much. But the pbix file can not be found to refer the report. :(
Thank you for the video. One question - instead of a value in a card visual, can the alert be generated based on a value in a table visual? Meaning if some of the values in a particular column have breached the threshold value
thanks for your sharing. How to delete the grand total row in json table?
I am getting an extra grid when selecting the post mitigation column. So ideally it is a 5 by 5 matrix but an extra grid in the row is making it a 6 by 5 matrix. Any solution to this problem? Thanks!
Off the top of my head it could be a few things. 1.) You have a blank value for a risk ranking. 2.) Your have 26 unique values, instead of 25. In the values assigned to each work order. Hope that points you in the right direction.
I know this is old, but do you know how to update this to work with the new work centers?
Thanks for the great video. Would this method apply to embedding a Matrix as well?
Awesome! Thx
Thanks! This was bugging my mind as I read Story telling with Data book. This line graph was an example
Sir I am your fan!!
Thanks 😊 appreciate your kind words!
Why don't the names of the values show up for me?
Thanks so much this is exactly what I was looking for and clearly explained.
Hello Jason; can you please share the pbix file of dashboard
Thank you, Jason. I couldn't find resources for the Maintenance KPI - MTBF, MDT, and % Availability. Could you please share the direct link?
Another great video. Not sure if the 'situation' with licensing has changed since you created? I have a PBI Pro License but only Power Automate Flow and PAD free licenses and this works fine. Many thanx
I have no option to turn off shared y axis : /
Helpful video. Thanks a ton.
can i sort by category in treemap
Hi, do you know on how to make matrix's header display vertically instead of horizontally
How did you center the words? It seem like you skipped that from 5:15 to 5:17
I have wathed a lot of videos on this subject and this is the closest to what I have. But I still cannot get the filters ot work. I am on the latest PBI, but my card uses CALCULATE / FILTER. I wonder if that is my problem? BM = CALCULATE([ALL Jobs],Filter(NewDimDate,NewDimDate[CurrMonthOffset] = 0), FILTER('Table1','Table1'[BM Status] = "Allocated"))
Thanks for the video! Any idea what happened to the Shared Y-Axis and Scale to fit options? These seem to be missing and I can't find anything recent online about their removal.
I just started using the scorecard recently and when you go to connect to the data I no longer see the ability to select 'Track all data in this time series' or 'Track this data point'. Did the updated version remove this or place it somewhere else?
Did you find an answer to this anywhere, I have the same question?
hi, thanks for the great video.. can you please share the link of this file !
Is there a link to the PBIx file used in this example? I checked the link to the resources and its pertaining to the work order data
I am trying to do something similar to this. However, my company wants to link a microsoft teams list. Do you have a video that links a microsoft list to Power BI so I can track requests for information?
It seems the Custom Label feature has since been removed from the Call out Value in the latest version of PowerBI it seems on different forum sites. This is unfortunate because it'd be a big help if it were the case.