Love it Diana and thank you for spending time with us yesterday!
Double love your comment! Not just for reporting but for life in general!Please do let us know how we can help you along your Power BI journey. We really love this stuff!
I agree with Andrew that trust is the most important thing for stakeholders. At PIH, we spent many years building out a data warehouse and it took many requirements gathering and then training sessions to get end users to use and rely on the data that was being produced. Many were still doing manual exports from source systems to double check the accuracy of the data, but we accompanied them throughout those checks to ensure that they understood what transformations and calculations were being done in the data warehouse so that they could have trust that the data was accurate and timely.
We also found that when multiple departments rely on the same data, centralizing the data and it's related transformations helped to build more trust across those departments because they were looking at data that was formatted in the same way. If those teams are manually exporting and applying their own filters or logic, they're often going to create discrepancies, so getting both teams together to build a common understanding of what logic is needed and why, helps us to have one source of truth and a shared understanding of what the data is telling us, rather than wasted time questioning why two reports are showing different totals.
Plan To GrowVena Academy