An end to end Python pipeline that loads NHS England financial data into a MySQL star schema, with analytical views, key performance indicators and Power BI reporting across 206 trusts.
- 206 NHS trusts across three financial years
- Python to MySQL extract, transform and load pipeline
- Analytical views and KPI metrics feeding Power BI