Portfolio

NHS Open Prescribing Data for Scotland

An Azure-based solution utilising medallion architecture to analyse NHS Scotland's open prescription data. Raw data is ingested into Azure Data Lake, transformed via automated pipelines, and visualised through an interactive Power BI dashboard — enabling prescription pattern analysis across Scotland's health boards.

Key Features

Automated data ingestion from NHS open data APIs
Azure-based data lake and transformation pipelines
Regional breakdown by health board
Time-series analysis with drill-downs

Technologies

Azure Data Lake Azure Data Factory Kusto Power BI DAX NHS Open Data