Skip Navigation Get In Touch
Case Study Azure Data EngineeringBreeze Autocare100+ Stores

A scalable data foundation. Shipped in 30 days.

Three POS systems, no central repository, weekly reporting that arrived as static PDFs in inboxes. Replaced with a unified Azure data warehouse, in under a month, with zero downtime. Four years on, the same architecture still runs every analytics and AI capability the business has built.

The outcome

Three POS systems, unified into one Azure warehouse. Built in 30 days. Still running four years on.

Ship time
30 days, kickoff to production
Continuity
Zero hours of downtime
Scale
100+ stores, 3 brands
Longevity
Same architecture, four years on
Industry Automotive Services
Platform Microsoft Azure
Scale 100+ Stores Nationwide
POS Systems PMA · DRB · IBA
The starting point

Three POS systems. No common ground.

Breeze Autocare runs across multiple brands and service formats, each supported by different point of sale systems. Every system generated data in its own format, with no centralised repository to pull it together. Reporting relied on manual extraction, ending in static PDFs sent by email each week.

As the business grew and acquired new stores, the manual process became harder to sustain. Decisions were being made on data that was already a week old by the time it reached the people who needed it.

PMA
PMA System
Generated XML exports, incompatible with other formats, with no direct integration path downstream.
XML
DRB
DRB System
Produced CSV files that needed manual normalisation before any analysis could begin.
CSV
IBA
IBA System
Excel-based output, siloed by store, incompatible with enterprise-wide consolidation.
XLS
Risk
Single point of failure
Data
Week-old reporting
Process
Manual consolidation
Scale
No growth path
Business Continuity
Critical risk
A single on-premise server carrying disaster recovery risk for 100+ stores.
What was built

Redesigned. Not replicated.

The Zig migrated the entire reporting operation from on-premise infrastructure to Microsoft Azure and built a centralised data warehouse from scratch.

Rather than a straight lift-and-shift, the architecture was redesigned to ingest data from all POS systems, normalise it across formats, and apply the business logic needed to generate consistent metrics at scale.

The warehouse was designed to grow. New data sources, new stores, new business logic, all addable without rearchitecting the foundation.

Data Architecture, Simplified
PMA
XML
DRB
CSV
IBA
XLS
Single source of truth
Azure Data Warehouse
Normalise
Business Logic
Power BI
Migration approach
01 Multi-phased delivery, no big-bang cutover.
02 Zero downtime across all 100+ store operations.
03 Architecture built to scale, not just to migrate.
In Practice

Built once, leveraged repeatedly.

The warehouse was the foundational layer. Power BI dashboards came next, replacing the static PDF emails. Then fleet invoicing automation, built directly on the warehouse. Then integrations with Sage and Cinch. Then AI tooling.

None of those required rearchitecting what was built in the first month. That is the point.

Before · After
Before
Manual weekly consolidation across multiple POS systems.
No central repository. Every system in its own silo.
Static PDF output distributed by email.
Single on-premise server, business continuity risk.
Data was a week old before it reached decision-makers.
After
Unified Azure data warehouse ingesting all POS data automatically.
Single source of truth across every brand and store.
Interactive Power BI reporting in real time.
Cloud-native infrastructure, scalable, resilient, secure.
The foundation for AI, fleet invoicing, Sage and Cinch integrations.
What it unlocked

The backbone of everything since.

The warehouse became the backbone of everything that came next. Four years on, the same foundation continues to support an expanding set of use cases across every business unit.

Day 1 → 30
Azure Data Warehouse, live
Centralised warehouse built from scratch. All three POS systems ingesting automatically. Zero downtime. Multi-phased delivery.
Shortly After
Interactive Power BI reporting
Static PDF emails replaced with real-time interactive dashboards accessible across the business.
Continued Build
Fleet invoicing & integrations
Fleet invoicing automation built directly on the warehouse, alongside integrations with Sage and Cinch. None of which required rearchitecting the foundation.
Ongoing
AI-powered tooling
The foundation that made every AI capability possible, grounded in clean, reliable, centralised data from day one.
Four Years On
Same architecture, still scaling
The same warehouse built in 30 days continues to power every analytics, reporting, and AI use case across every business unit.

See what's possible.
Build what matters.

Tell us where your data is holding you back. We will be direct about what it takes to fix it (no slides, no theatre).