Is there an easy solution to the above challenges?
If there was an easy solution, it would have been implemented a long time ago (and used more often). But there is a solution, and it requires discipline. BI Governance requires that you determine how to work with:
What we have found is that these three elements are woven into each other and that the challenges arise when one does not ensure the balance between these. The chaos on a network drive arises, among other things, when you have the technology available, but you have not provided guidelines for e.g. naming of folders or restricted the right to create folders.
Furthermore, doubts about who has the most recently updated report have been created, as the process of consumption is not visible or simply does not exist.