FP · Consult

Offering 02 · Information visualisation

The chart is the easy part.

Dashboards, CRMs, order books — one live picture of your operation. Classic BI tools assume clean, connected data already exists. In most operations it doesn't. So our work starts a mile before the chart: reconciling, unifying, structuring — until the numbers deserve the ink.

Watch the work

From inbox to evidence, in three acts.

This is the whole offering in one worksheet: a real week's shape, condensed. Scroll through it the way the data flows.

Act 1 · As it arrives

Operational data, as it actually lands in an inbox: three date formats, a duplicate, a number that isn't one. A chart drawn from this sheet would render without complaint — and be wrong.

Deliveries · week 1 — as emailed
03.01rebar 12 mm1,240
04/01rebar 12mm980
Jan 5rebar-121,120
‹three date formats in one column›
03.01rebar 12 mm1,240
‹duplicate of the first row›
06.01rebar 12 mmn/a
‹not a number›
stated total4,580
‹counts the duplicate, misses the n/a›
Nobody made these mistakes on purpose. This is simply what a busy week does to a spreadsheet.

Act 2 · The mile before the chart

Reconcile, deduplicate, check each figure against its source. This is the unglamorous stretch most dashboard projects skip, and the reason their numbers quietly stop being trusted.

Deliveries · week 1 — reconciled
2024-01-03rebar 12 mm1,240
2024-01-04rebar 12 mm980
2024-01-05rebar 12 mm1,120
‹one duplicate removed — logged, not deleted›
2024-01-06rebar 12 mm1,210
‹recovered from the source file›
total — foots4,550 ✓
Each row is now traceable to its source — and checked against it again on every update, not just once.

Act 3 · Now it can be drawn

Only then do we draw. A chart is as trustworthy as the column it stands on.

Deliveries · week 1 — drawn from checked data
Total, verified4,550
The chart itself took an afternoon. The two acts before it are the work — and everything downstream runs smoother for them.

What it becomes

Dashboards — and the systems of record behind them.

The dashboard is the visible end. Underneath sits something more valuable: your operation's data, clean and machine-readable, often for the first time. That same foundation carries a CRM, a tenant book, an order book.

In production, 24/7

A live operations dashboard

A commodity-procurement operation ran on a dozen daily Excel reports, emailed around. Now a file is emailed in and the dashboard updates: one live view of the whole operation, with every number checked on arrival.

System of record

A tenant & lease CRM

Tenants, leases, rents, and deadlines — kept today in folders and one person's memory — become one system that knows when every contract renews and who hasn't paid. The same shape carries any customer book, built around your actual process.

One live picture

The order book, current

What's ordered, what's delivered, what's outstanding — today it lives across a mailbox, a spreadsheet, and someone's memory. One screen that answers "where do we stand?" without a meeting.

Candor

Who this is for — and who it isn't.

You're a fit if

  • Your numbers live in five places and agree in none: reporting is assembled by hand, and nobody fully trusts it.
  • You need a system of record — a CRM, a tenant book, an order book — shaped to your process, not a vendor's funnel template.
  • Decisions wait for reports: the picture you steer by is days old by the time it reaches you.
  • You suspect the spreadsheets hide errors, and today there's no way to know.

Not a fit — yet — if

  • Your data already lives clean in one system. An off-the-shelf BI tool may be all you need, and our scoping will say so.
  • You need enterprise BI at scale: hundreds of report consumers, embedded analytics, a data team of its own.
  • We build the mile before the chart, then the chart itself. If that groundwork is already done in your operation, an off-the-shelf tool is the better buy.

Fair questions

What buyers ask us about this.

We already have a BI tool — why isn't this solved?

BI tools draw what they're given: they assume clean, connected, trustworthy data already exists. In most operations it doesn't, so the tool faithfully charts the duplicates and the drift. Our work starts earlier, and that head start is the difference between a picture and evidence.

Where does it run, and who can see it?

On infrastructure you control — your own hardware, or a single EU server rented in your name. No third-party clouds you didn't approve, no per-seat platform holding your operation's numbers.

What happens to the person who keeps the spreadsheets today?

They're the expert — the system is built with them, not around them. In our flagship engagement, nine of ten reporting templates were modernized side by side with the staff who keep them, and the cutover stayed reversible.

Is a dashboard all we get?

The dashboard is what you see. What you actually acquire is your operation's data, clean and machine-readable: the same foundation a private AI answers from and an automation acts on. Start here, and the other two offerings get cheaper.

Proof

The mile, walked once already.

Our flagship engagement: a mid-size procurement operation in Kazakhstan ran its daily reporting on roughly a dozen hand-kept Excel layouts, emailed around, reconciled by eye. We built the system that reads those files as they are, checks every number against the totals the files themselves carry, and publishes a live dashboard — about five seconds after a file is emailed in. Real errors surfaced that had looked like correct data for years, including a 2,500-unit contract that "summed" to 4,601.

That's one engagement, told honestly — proven once, deeply. It's the same mile we'd walk through your operation's data, whatever industry it lives in.

How to start

Which numbers does nobody trust?

Tell us where your picture of the operation lives today: the spreadsheets, the systems, the one person who knows. The scoping conversation is free of charge and free of pressure. You'll leave with a recommendation you can act on, and a fixed price if the answer is build.

contact@fp-consult.example