- 216
- 1 154 046
Jason Davidson (Power BI)
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/
มุมมอง: 6 057
วีดีโอ
Create Neat Little Risk Matrix SVG Icons - Ideal for Power BI Table and Matrix Visuals
มุมมอง 1.4K5 หลายเดือนก่อน
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)
มุมมอง 5K8 หลายเดือนก่อน
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
มุมมอง 5K9 หลายเดือนก่อน
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.7K10 หลายเดือนก่อน
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.7K11 หลายเดือนก่อน
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
มุมมอง 4.7K11 หลายเดือนก่อน
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.6Kปีที่แล้ว
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
มุมมอง 998ปีที่แล้ว
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
มุมมอง 7Kปีที่แล้ว
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
มุมมอง 13Kปีที่แล้ว
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
มุมมอง 8Kปีที่แล้ว
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
มุมมอง 1.2Kปีที่แล้ว
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
มุมมอง 2.2Kปีที่แล้ว
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
มุมมอง 4.1Kปีที่แล้ว
Enhance the Amazing New Power BI Card Visual with Conditional Formatting of ICONs and Accent Bars
Power BI's Stunning New Card Visual Explained
มุมมอง 4.4Kปีที่แล้ว
Power BI's Stunning New Card Visual Explained
QT#93 - Slopegraphs: The Simple and Better Way to Visualize Change Using Power BI Line Charts
มุมมอง 970ปีที่แล้ว
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.3Kปีที่แล้ว
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
มุมมอง 1.2Kปีที่แล้ว
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
มุมมอง 12Kปีที่แล้ว
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.4Kปีที่แล้ว
QT#89 - Adding Conditional Formatting Icons to Data Labels on Power BI Visuals
QT#88 - Dynamic Formatting Power BI Data Label Rounding Suffixes
มุมมอง 1.2Kปีที่แล้ว
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
มุมมอง 3.4Kปีที่แล้ว
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.8Kปีที่แล้ว
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.5Kปีที่แล้ว
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
มุมมอง 6Kปีที่แล้ว
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
มุมมอง 2.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.6Kปีที่แล้ว
QT#81 - How to Configure the Time Period 'Cycle Over' Comparison Values in Power BI Metrics