Portfolio

Case Studies

Real-world automation, analytics, and data engineering projects – built lean, with minimal enterprise licensing overhead, and designed to scale.

3 case studies
Ingest FLAG Validate SQL Py Generate Deliver Admin App Automation
Automated Client Reporting Pipeline Logistics & Freight

An end-to-end reporting pipeline replacing a manual monthly process with a fully automated workflow – ingesting booking data, detecting anomalies, generating branded PowerPoint reports, and distributing them without human involvement. Extended with a bespoke Flask admin web application for client management, data export, and on-demand report triggering. Built with minimal Power BI Premium licensing.

Microsoft Azure Power Automate Python Flask Azure SQL Report Automation
Read Case Study
Z-Score IQR CV BFD DUP SHD HFM OH Analytics
TFM Pricing – Soft & Hard Services Analyser Crown Commercial Service Framework – Facilities Management

Eight anomaly detection methods, should-cost modelling, and Hard FM work order analysis across large estates – delivered as a self-service desktop application at a token licence cost.

Python / Flask Plotly Docker PyInstaller
IN STRUCTURAL FIELD ! BUSINESS RECONCILE OPERATIONAL CLEAN Data Quality
Data Hygiene: A Practical Briefing DigiRelevance – Practical Guide

Six principles and eight common pitfalls for keeping operational data clean before it hits your production database – with a downloadable checklist covering structural, field-level, business-rule, reconciliation, and operational checks.

Data Engineering ETL / Pipelines SQL Azure
+

More case studies coming soon

Working on something similar?

If you have a reporting, automation, analysis or data quality challenge – get in touch and let’s talk through it.

Get in Touch