Problem statement and business impact: company of 30-40 employees grows to double size and also the services that the company provides are getting more complex. Management cannot afford intuitive approach, decision making has to be data-driven. (When reports are required, it usually takes a few days for the finance and backoffice colleagues to prepare them. Calculation mistakes spotted by managers in the results require the same fun redone with the same effort.)
Solution: together with the Customer we started whiteboarding the architecture from the data sources to be integrated down to the first reporting requirements. We identified the connections between the data silos from various source systems and the transformations necessary to obtain clean and verified data for the reports. This has then been continued to become a continuously evolving system as the new insights inspire other new questions. Company management now has fresh data about the state of business each hour in the form of visually appealing reports.