Enhancing Data Quality with OpenAI in Power BI: Part 2 - Avoiding Redundant Processing

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 to OpenAI.
Building upon the foundations laid in the first video, I'll introduce key updates to both Power BI and PowerAutomate Flow. These crucial enhancements are tailored to prevent the repeated processing of maintenance work order defect report texts by the OpenAI model.
Why is this important? It's simple - we aim to eliminate the hassle of redundant reviews for the same work order, a vital step in our case study.
Moreover, keep in mind that each review conducted by ChatGPT incurs a cost. While not excessively expensive, these costs can accumulate, especially when dealing with a large volume of work orders or other records. It's essential to optimise our processes to avoid unnecessary expenses in conducting duplicate data quality assessments.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Intro
01:18 - Add in Assessment Status Filter
05:16 - Adding a dynamic message to the Power Automate Button
08:20 - Adding a condition to the Power Automate Flow
17:34 - Testing the updated Flow
19:04 - Add Automated Semantic Model Refresh to Flow
-------------------------------------------------------------------------------------------
🎥 Related Videos - Other Videos Wheere I Use ChatGPT
-------------------------------------------------------------------------------------------
Pt1 - Integrate OpenAI Models (like ChatGPT) Into Your Power BI Dashboards Using Power Automate
• Integrate OpenAI Model...
Pt3 - Calling OpenAI (ChatGPT) from Power BI: Pt 3 - Prompt Engineering & Effectiveness Testing
• OpenAI (ChatGPT) in Po...
Using ChatGPT to Fast-Track Creation of Power BI Sparkline SVG Charts In the NEW CARD VISUAL
• Using ChatGPT to Fast-...
QT#84 - 3 Ways ChatGPT Can Be Your Power BI Report Development Buddy
• QT#84 - 3 Ways ChatGPT...
-----------------------------------------------------
🎓 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 help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
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-...