Imaging having an installed base of a few thousand standard reports and a strategic decision to migrate from one tool to another. Migrating reports is a purely sanity tasks that nobody really wants to do. Some companies simply throw the hot patato to India and simply have an eyes-closed technical migration. Costly and mostly frustrating since rebuilding reports in another tool might prove not to be so straightforward due to peculiarities, typically for each different tool.
Why not first clean-up the proliferated reports and focus on what really matters? Statistical methods can help us focus and reduce the complexity before migration takes place. Imagine going from 5000 reports to only 500 to be maintained. Given the fact that the reduction in number of reports is mostly so drastic, an investment in a good clean-up is seldomly too costly.
Cleaning-up reports entails making an (automatic) inventory of all reports, applying advanced analytics to cluster the reports together and the corresponding measures. Feedback to users and identification of steps to mitigate the change. Compiling the inventory mostly takes between one and two weeks, analysis one week, mitigating the change and facilitate the process is mostly done as part of a Performance Management coaching trajectory.