Business Analytics Strategy
Testing ETL projects - used for Extracting data, Transforming it according to reporting requirements and Loading it into the data warehouse - is very complex because of many reasons. Typically huge amounts of data are handled and data comes often from multiple sources that need to be combined. Sometimes, the data is loaded incrementally, sometimes it needs to be reloaded in full. These ETL-flows can also apply all kinds of complex calculations and transformations on the data.
The real promise of Performance Management can only be delivered when it is part of a well-automated architecture. Those who claim that automation is not needed and that e.g. Balanced Scorecards can exist just fine in MS Excel without the possibility to drill-down to the lower-level data are just wrong.