Case studies

The detail behind the work

Selected products and delivery work, with the problem, approach, outcome and provenance set out clearly.

Answerable answer on UK inflation and interest rates, with numbered citations and two sources

TechGuidr engagement · Economic research

Two AI products built for a research business

A research business needed customers to find its current thinking across a large archive. Answerable brought cited research answers into daily use; Foreseeable brought AI into its account teams’ workflow.

Answerable: in production and daily use. Foreseeable: in production.

Read the case study

Workforce intelligence dashboard with organisational indicators, financial impact estimates and an AI-assisted summary

Technology leadership · Learning and wellbeing

Rebuilding the foundations of an enterprise platform

A learning and wellbeing platform needed its applications, data and deployment foundations brought into a coherent system. An architectural review led to a rebuild of both principal applications and the iOS and Android apps, and a migration of the cloud estate.

Both rebuilt applications and the iOS and Android apps entered production.

Read the case study

Earlier work

Case studies from before TechGuidr

Projects delivered before TechGuidr was founded, by teams its founder led or worked in: at Microsoft, through a consulting partner and in earlier roles. Each sets out the problem, the approach, what was delivered and the outcome.

Real-time intelligence for a global engine fleetAerospace · Data platform · Earlier role

A global aerospace manufacturer

The problem: One of the world's largest aerospace companies needed to see its commercial airline engine fleet as it flew, not in retrospective reports.
The approach: Analyse petabytes of engine data in the cloud for patterns and anomalies.
What was delivered: A cloud data platform on Microsoft Azure and Power BI.
The outcome: A real-time view of the fleet, with the ability to predict engine maintenance events early enough to minimise aircraft time out of service.

Petabyte-scale · Azure · Power BI · Predictive maintenance

A university sent home overnightHigher education · Cloud · Earlier role

A leading UK university

The problem: When the pandemic hit, a leading UK university needed more than 5,000 staff and students working and learning remotely, at speed, on infrastructure never designed for it.
The approach: A modern desktop platform that could scale quickly, rolled out under tight time pressure.
What was delivered: Azure Virtual Desktop for more than 5,000 staff and students.
The outcome: Remote teaching and working at full scale, on a platform designed to outlast the crisis that forced it.

5,000+ users · Azure Virtual Desktop · Pandemic response, 2020

Studio analytics in the early days of AzureGaming · Microsoft · At Microsoft

AAA games studios

The problem: AAA games studios each held their own analytics, with no central view across titles and platforms, at a time when Azure itself was young.
The approach: Build on a young Azure platform, dogfooding the internal Microsoft tooling that became public services including Power BI.
What was delivered: Studio analytics centralised on Azure, and Global BI workloads migrated from on-premises to Azure.
The outcome: A single analytics estate across studios, built early enough that the tools it proved out went on to become products.

AAA studios · Early Azure · Power BI lineage

Finding where the stock was goingRetail · Data warehouse · Earlier role

A leading UK retailer

The problem: Significant, unexplained losses in stock management, with the evidence buried in high-volume transactional data.
The approach: Record the patterns and trends in stock movement, with automated analysis around the events where losses clustered.
What was delivered: A data warehouse platform on SQL Server for the high-volume transactional data.
The outcome: The stock and logistics lifecycle segmented and visible, so losses could be traced to causes rather than absorbed as a cost of trading.

High-volume transactional analysis · SQL Server

Tracking every donated bagNon-profit · Cloud platform · Earlier role

A national charity

The problem: Donated goods were leaking out of the collection network before reaching stores, and the retail side of the charity ran with no regular, accurate analysis.
The approach: Bring collections, stores and sales into one view: legacy tills connected for real-time sales, and IoT tracking across vehicles, textile banks and clothing bags.
What was delivered: A greenfield Azure data platform with a 360-degree view of operations.
The outcome: A consolidated view of donated goods, collection operations and retail sales.

Azure · IoT · Retail reporting

Watching the odds being played in real timeGambling & gaming · Consulting · Through a consulting partner

A betting company

The problem: Fixed-odds terminals and spread betting carried fraud patterns the company could only see after the money had gone.
The approach: Reveal, in real time, who was playing the odds on a particular event.
What was delivered: A cloud data platform, and a Data & Advanced Analytics practice at the consulting partner, with the architects, engineers and data scientists recruited around it.
The outcome: Fraudulent activity visible as it happened rather than in the post-mortem, and a data practice that outlived the engagement.

Real-time · High-volume transactions · Practice build-out

Have a decision or delivery challenge to work through?

Start a conversation The work, on one page