Healthcare · Northern Ireland · Data Lakehouse
Operational lakehouse & live dashboard
A pharmacy group's scattered operational data turned into a clean, queryable bronze→silver→gold lakehouse, with a decision-first dashboard on top.
7.4M
rows live
The team moved from days-late spreadsheets to a single trusted, queryable source of truth — live, automated, and private to their tenancy.
—Context
A multi-site pharmacy group ran on a legacy dispensing system with no analytics layer. Reporting meant manual exports into spreadsheets, days late and impossible to trust.
—Challenge
Capture millions of rows of operational history, clean and conform them without losing fidelity, and surface live patient, dispensing and stock analytics the team could actually make decisions from — all while data stayed in their own cloud tenancy.
—What we built
- Automated bronze → silver → gold pipelines on Azure, running incrementally every day with quality checks and lineage.
- 20+ modelled gold tables — patient analytics, dispensing, stock, prescriber and seasonal trends.
- A live operational dashboard reading straight from gold, refreshed on every pipeline run.
- An in-dashboard AI assistant for natural-language questions over the data.
—Outcome
The team moved from days-late spreadsheets to a single trusted, queryable source of truth — live, automated, and private to their tenancy.
—Stack
AzureDuckDBPythonNext.jsAI Assistant
→Ready to ship
Let's get your production AI live.
Bring us your operational data. We'll build the system that acts on it — deployed in your environment, measured in production.