
We were able to merge in a central place all the data sources of the IT department. This represented: 1 200 resources, 250 projects grouped in 12 portfolio's. We build a single source of truth to pilot a yearly budget of 90M€. We can reconcile the financial view with the operational (capacity) view.
We were able to integrate many sources, even referentials (Excel files). The dataFactory gave us the flexibility to evolve requirements. This was key as business requirements were not 100% mature. We were able to add new sources, while keeping history of data.
Lots of changes happened in the organisation. Organisation changes and change in financial calculation rules / definitions. We used the historisation capabilities of the dataFactory to keep this under control. We were able to split the evolution in figures into changes of scope or evolution of financial KPI.
In less than 10 months, we were able to achieve what we did not think was possible: The onboarding and weekly use of our capacity dashboards by the 75 middle managers. As a consequence, our forecast exercice shrinked from 2 months to 3 days, with an accuracy of 2%. Review collected by and hosted on G2.com.
Requires a bit of thinking to modelise the datamodel in datavault. But we were supported by great consultants. Review collected by and hosted on G2.com.
Validated through a business email account
Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate.

