Skip to content

Data and analytics

We bring data from your systems into one place, so reports refresh on a schedule and everyone works from the same numbers.

Charts of analytics on a laptop screen

Who it’s for

  • The same figure comes out differently depending on who runs the report.
  • Someone spends days each month copying data between spreadsheets to build reports.
  • Your data sits in several systems that don’t talk to each other.
  • Trustees, directors or funders ask for figures you can’t produce quickly.

What’s included

  • Data pipelines

    Data collected from each system on a schedule, checked and loaded without manual steps.

  • Warehouses and models

    A warehouse with business terms defined once.

  • Dashboards and reports

    Reports and dashboards in tools such as Power BI.

  • Data quality checks

    Missing or unusual data flagged before it reaches a report.

How it runs

  1. Map the figures

    We list the reports you rely on, where each figure comes from and how it’s worked out today.

  2. Build the pipelines

    We start with the sources behind your most important reports and add the rest in order.

  3. Define each figure once

    We agree one definition for each key figure with the people who report on it.

  4. Build the reports

    We build the dashboards with your team and show the people who’ll change them how they work.

What you get

  • Documented, scheduled pipelines
  • A single source for each key figure
  • Dashboards your team can use and change
  • A data dictionary in plain English

Where we’ve done this

Questions about data and analytics

Our data is spread across spreadsheets. Is that a problem?

It’s the usual starting point. We map where each figure comes from first, then move the most important sources into pipelines.

Which reporting tools do you work with?

We work with common tools such as Power BI, and with the reporting tools you already pay for.

Do we need a data warehouse?

Not always. For a few sources and simple reports, a scheduled pipeline into a reporting tool can be enough. We suggest a warehouse when the number of sources or the history you need calls for one.

Who can change the reports afterwards?

Your team. Reports are built in tools they can use, and the guide explains where every figure comes from.

How do you know the figures are right?

Each new figure is checked against the report it replaces before anyone relies on it, and data quality checks flag anything unusual.

Ask us directly

If it isn’t answered here, send it to us and we’ll reply by email.

Send a question

Related services

Send us the details and we’ll reply with what we’d do first.

Let’s talk

Ask about this service