NHS A&E Attendance Analytics Pipeline

A cloud-based data pipeline that extracts, processes, and visualises monthly Accident & Emergency (A&E) attendance data from NHS England. This project automates the ingestion of raw CSVs, normalises attendance figures by regional population, and outputs cleaned datasets with per-capita metrics to support meaningful, population-adjusted insights with an integration into an automated Power BI dashboard.

A high-level overview of the project’s objective, dataset, tech stack, and business value — all components of the end-to-end A&E Analytics Pipeline.


Technical Documentation


Workflow Overview


ETL Output: Automated Power BI Dashboard