- Organisation
- Médecins Sans Frontières UK
- Predecessor
- Dynamics 365 and other operational data held across separate sources and reporting paths
- Destination
- a centralised Azure SQL data platform and data warehouse with a unified model consumed through Power BI
- Workload
- Azure SQL, Dynamics 365 and Power BI
- Stage
- operational
Evidence boundary: Microsoft supports an operational centralised data platform and named data sources. The source does not state the exact production go-live date or prove retirement of every predecessor database and reporting component.
Verified platform change
Médecins Sans Frontières UK created a central data platform and warehouse on Azure SQL, combining Dynamics 365 and other sources into a unified model refreshed nightly for Power BI.
Transition
From: Dynamics 365 and other operational data held across separate sources and reporting paths
To: a centralised Azure SQL data platform and data warehouse with a unified model consumed through Power BI
Known unknowns
Microsoft supports an operational centralised data platform and named data sources. The source does not state the exact production go-live date or prove retirement of every predecessor database and reporting component.