MS Fabric: UK Railway Analytics Dashboard
Analyses historical and live UK railway operational data to evaluate on-time performance, delays, cancellations, and passenger trends. Using Microsoft Fabric's Medallion Architecture, large-scale datasets from multiple sources are processed, enriched, and modelled to produce KPI dashboards for real-time operational insights and transport planning.
The pipeline applies SCD Type 2 historisation so planners can track how route performance changes over time. Power BI dashboards surface delay root-causes, revenue trends, and forecasted passenger volumes.
Multi-source UK railway data through SCD Type 2 pipelines on Microsoft Fabric, surfaced as real-time KPI dashboards for delay root-cause and revenue analysis.