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
  • Power BI native visualisations

Technologies

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

Germany, France & Belgium Pharmacy Sales

A cross-border analytics solution tracking pharmacy sales performance across Germany, France, and Belgium. The platform consolidates multi-country sales data into a unified data model, enabling comparative analysis of product performance, regional trends, and market dynamics across European markets.

Key Features

  • Multi-country data consolidation and harmonisation
  • Cross-border sales performance comparison
  • Holidays and weekends highlighting for easier trend analysis
  • Sales distribution across pharmacy types by country
  • Power BI native visualisations

Technologies

Power BI DAX