Скачать с ютуб Single Pane of Glass Reporting - Simple is as Simple does - WK8 в хорошем качестве

Single Pane of Glass Reporting - Simple is as Simple does - WK8

This solution was initially pieced together nearly two years ago to deal with the major issue in the NYC Water Towers Data: the "Inspected By" and "Lab Used" values are free text, so they are riddled with spelling mistakes and other data irregularities. This challenge is common when free text is used or systems age and values should be merged. Every ERP project we have worked on has had instances similar to this. The ideal solution of creating a PowerApp to manage the task. On the surface, it is simple; the "issue" with this solution is that, in essence, you need to replicate the functionality of Excel. This is not a significant problem, but it is a solution that will require complexity. That means the Total Cost of Ownership will be higher. Every component that adds cost in business must also add at least that much more value. By adding a simple Power Automate Desktop script to trigger a refresh of the spreadsheet stored in SharePoint and emailing us with the number of updates required, we can prompt the team to make the necessary changes. Value is received, and cost is minimised. #singlepaneofglass #businessdataanalytics #powerbi #powerautomate #powerautomatedesktop #geoirdieintelligence #geordielife