Case study · Aviation

Compliance the whole airport can prove, refreshed every day.

How a major European airport rebuilt its compliance reporting in Power BI, validated the calculation logic behind it, and gave regulators and operations teams one view they both trust.
Calculation model validation Compliance monitoring Report UX rebuild
Major European international airport, regional travel and logistics hub
INDUSTRY
Aviation / airports
ENGAGEMENT
Model review + monitoring build
STACK
MS Power BI, Microsoft SQL
SCOPE
Phased, 2 operational areas

/01THE IMPACT

2 areas

covered by one shared calculation and design framework

Daily

dataflow refresh keeping compliance figures current

Users

active internal and external users on the reports

Views

report views per day across both audiences

/02THE CHALLENGE

The airport had a working prototype and deep domain knowledge. What it lacked was a model it could defend and a report an outsider could read.
The team came to us with an existing report and a clear grasp of the business context behind it, then asked us to review the calculation logic underneath. The numbers had to hold up to external scrutiny, the model needed a more rigorous foundation, and the report itself had to work for two very different audiences at once. The visual design and the experience were where it fell short for the people outside the building.

Complex calculation logic

Multi-layered business rules with dynamic reallocation and grouping, all of which had to stay consistent across changing entities and periodic adjustments.

Two audiences, one report

Internal teams needed a high-level operational overview. External stakeholders needed detailed, entity-specific views they could read without a guide.

Gaps in the source data

Missing values needed custom completion rules, using similarity checks across multiple attributes so the analytical integrity of the figures held.

/03THE APPROACH

We validated the model first, rebuilt the report around its two audiences, then handed the team something they could extend on their own.

01

Discover & assess

We reviewed the existing prototype and audited the calculation logic line by line, surfacing the gaps and inconsistencies in the applied methodology.

Logic audit
Gap analysis

02

Design & model

We defined a refined calculation framework and implemented multi-level logic so results stayed consistent across every entity and reporting period.

Calculation framework
Multi-level logic

03

Build & visualize

We rebuilt the report in Power BI, applying modern UX and UI principles to the clarity, navigation, and accessibility so both internal and external users could find their way around it.

Power BI
UX / UI
Accessibility

04

Adapt & rebuild

When the business changed its calculation methodology mid-project, we rewrote the key measures to align with the updated logic without breaking the rest of the model.

Measure rewrite
Change handling

05

Validate & test

We ran extensive validation sessions with business users to confirm the accuracy, completeness, and usability of every output. Those outputs now serve as the base other departments build their own analysis on.

User validation
Accuracy checks

06

Deploy & enable

We delivered the finished monitoring solution and ran knowledge-transfer sessions, so the internal analysts could maintain and iterate on it without waiting on us.

Handover
Enablement

07

Extend & scale

After the report was adopted, the airport extended the scope and we applied the same logic and design framework to a second operational area, keeping both consistent and easy to maintain.

Reusable framework
Second area

/04THE RESULTS

A compliance view the airport can stand behind, in front of regulators and on the ops floor.

External stakeholders read it unaided

Entity-specific views and a rebuilt experience mean regulators and partners get the detail they need without someone walking them through it.

Internal teams catch issues early

Daily-refreshed monitoring surfaces threshold pressure while there is still time to act, instead of after a breach shows up in a quarterly review.

One framework, now two areas

The validated logic and design system carried straight into a second operational area, so the airport scales reporting without rebuilding it each time.

Ready for reports your team actually uses?

Book a discovery call. We scope the work, tell you honestly whether we're the right fit, and you decide from there.