It is a normal monthly scene: a team of analysis preparing their monthly reports, extracts for regulators or reports for overseas HQ. They are in search of the „truth“ and need a golden report to unify everything.
The final report is the end result of hours and hours of manual labour by analysts who must access local databases and upload data into spreadsheets.
Faced with limited budgets for an inordinate amount of BI/DWH requests, many companies employ large teams to deal with these requests rather than automating the process and taking on larger BI projects.
It is unnecessary to ask analysts to spend two weeks pumping out monthly reporting Excel spreadsheets when a better solution is available.