Nothing, honestly! Nowadays, everybody is talking about data analysis and reporting, while forgetting that the step of data preparation and consolidation is of crucial importance in a BI project. Staring at the front-end awaiting the decisive information to arive, makes sense, only if the back-end processes are settled. This is also confirmed by relevant studies which show that, in less successful data warehouse projects, too much was invested in the front-end analysis and too little in the basic processes of checking and preparing the data.
The contribution which automation can make to a BI project is easy to explain: in the ETL process, it ensures that the decisive data arrive in the data warehouse on time and in the right sequence, and in the reporting process it ensures that this reaches the right person at the right time. Especially for the sequencing a wealth of interdependencies have to be taken in consideration, a task, which cannot be accomplished without a central and transparent control of all the individual processes.
This is where UC4 Software comes in.
BI is a delightful dish on the table. ETL is the cooking. Don’t forget!