N° 03 / Services — Data & Ops

Most reporting platforms break the day the underlying schema changes.

We build the semantic models, reporting layers, and refresh systems the rest of the operation quietly depends on. The work is invisible when it's right and very visible when it isn't.

We build for the day the schema changes — because it will. A report that's correct today and silently wrong next quarter is worse than no report at all.


How we engage

Three shapes of engagement. Pricing is per engagement — the discovery sprint is fixed-fee and a low-risk way to begin.

[01]
Discovery sprint2–3 weeks · Fixed fee
We trace where the numbers come from, where they diverge, and what a trustworthy reporting layer would need to do.
[02]
Embedded build6–14 weeks · Quoted per engagement
We build the semantic model, the refresh system, and the reporting on top — with tests that fail loudly when the source changes.
[03]
Advisory retainerOngoing, monthly · Monthly retainer
We keep the model honest as sources, schemas, and definitions drift. Governance is a habit, not a project.

In practice

A few projects in this lane. Each one is a real engagement with a full case study.

Project Marrburn
A medallion data architecture under a bespoke operations platform — auto-ingested files, conformed in the middle, shaped at the top into BoM, inventory, planning, stock, and financial modelling.
Project Integral Mesh
Semantic models imported from Power BI, then natural-language query over data and documents — all running on-premise behind the firewall.

Frequently asked
[01]
We already have dashboards. Why does this matter?
Dashboards are the easy part. The hard part is the model underneath — making sure a number means the same thing on every screen, and still means it after the next source change.
[02]
What tools do you use?
We're comfortable across the common warehouse and BI stacks. The tool matters less than the model and the tests around it.
[03]
What is a semantic model, in plain terms?
It's the single agreed definition of each metric — what revenue, or a breach, actually means — sitting between the raw data and every report. Get it right once and the reports agree.
[04]
Can you fix reporting we already have?
Often. We start by tracing the numbers. Sometimes the fix is the model; sometimes it's the refresh; occasionally it's a definition nobody agreed on.
[05]
How do you handle governance?
Lightly but consistently. Definitions in version control, changes reviewed, tests that catch drift. Governance that needs a committee tends not to happen.
[06]
What about data quality at the source?
We surface it rather than paper over it. If a source is wrong, the reporting should make that obvious, not average it away.

N° 07 / Contact

Tell us what you're trying to build.

A short brief is enough to start. We read every enquiry ourselves and reply within two working days.

Coordinates
Kola Solutions Limited
Office 1426, 3 Fitzroy Place
1/1 Sauchiehall Street
Finnieston, Glasgow
Scotland G3 7RH
55.8655° N · 4.2809° W

[email protected]
Company no. SC781583