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

In this video, you'll learn how to calculate the MTBF (Mean Time Between Failures) and MDT (Mean Downtime) in Power BI.
This is the first in a series of videos exploring the subject of reliability and availability calculations in Power BI.
This video focuses on MTBF and MDT for a machine that is continually running. The data we have for the machines is a table of all the downtime events, both planned and unplanned (breakdowns).
You'll learn how to create the calculated columns and measures required to calculate the MTBF and MDF.
👍Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works!
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Definitions
02:48 - Data Set and Model
04:05 - Building in Power BI - Shift Definition
06.38 - Downtime Event Length Calculated Column
10:10 - Action Running Time Measure
13:40 - Building up the calculations
14:25 - Number of unplanned downtime events
15:15 - MTFB (Hours) measure
16:10 - MDT (Hours) measure
18:45 - Summary of results
-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
Maintenance KPI - Calculating MTBF & MDT (Mean Time Between Failures and Mean Downtime) in Power BI
• Maintenance KPI - % Av...
Why You Need a 'Dates' Table in Power BI and How to Create One - • QT#9 - Why You Need a ...
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my KZbin videos:
effectivedashboards.com/cours...
👉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-...

[@ramakumarguntamadugu1299]

this is great explanation! thank you very much for sharing this content.

[@gabrielalade7793]

Hello Jason, thanks for this great training it really means so much to me. I have watched over and over as I am working on something similar MTBF. But I am totally lost, it's a lot of differences in my data compared yours. Also, I am using tableau for this project. Is there any way you can be of help? I am stocked with my calculated fields. I will appreciate your help. Thanks

[@tshedisomathabatha7059]

Jason thanks for video is very helpful ,where can I get the link for the table used or how create one ?

[@jasondavidsondata]

Hi, thanks for the comment. Which table are you looking for? Is it the source data table?

[@tshedisomathabatha7059]

Yes the source data table and thanks for your quick response.

[@jasondavidsondata]

Hi. You can download the file here - effectivedashboards.com/course/maintenance-kpi-calculating-mtbf-mdt-mean-time-between-failures-mean-downtime-in-power-bi/ Cheers, Jason

[@ericmakwepa8125]

Thanks for the video, kindly the link on how to create the tables

[@ericmakwepa8125]

I saw the link

[@gk9394]

So how can we do this from excel?