Data & dashboards

Power BI or custom dashboards, right every morning.

Your numbers live in your accounting system, your CRM, your store and 12 spreadsheets. We connect them, put them in 1 data warehouse and build dashboards in Power BI or custom code that refresh themselves. No manual work, no argument about which version is correct.

What we do

Dashboards and a data warehouse for SMEs that want to manage by numbers

Almost none of the companies we walk into actually steer on data. Not because the data is missing, but because it is scattered across four or five systems and stitched together in Excel again every Monday. By the time the report is ready, the week is over. We build the pipeline between your systems and your decisions.

First the connections: Exact Online, AFAS, Shopify, GA4, your planning tool or your own software. With Airbyte or our own Node.js connectors we load the data into a warehouse on PostgreSQL or BigQuery. With dbt we turn it into clean, documented tables where “revenue” has exactly 1 definition. On top of that we build dashboards: Power BI if your organization runs on Microsoft, Metabase or custom React if you want something of your own or embedded.

The difference from a one-off report: the numbers refresh themselves, permissions per user are handled and every KPI traces back to its source. Clean data is also the foundation for AI: forecasting, anomaly detection, an assistant that answers questions about your numbers. We build that in the same environment.

Dashboard Plate 15 · DATA & DASHBOARDS
  • 2–10 weeks from source to dashboard
  • 1 definition per KPI, in every report
  • 0 manual exports
  • 100% your data, in your environment

Components

8 components

What you get.

01

Power BI dashboards

Data model, DAX measures and reports you open in Teams and on your phone. Row-level security so every manager sees only their own numbers.

02

Custom dashboards & KPI apps

Dashboards in React and Recharts, embedded in your own portal or software. For when Power BI is too heavy or too expensive for your users.

03

Data pipelines & warehouse

Airbyte, dbt and PostgreSQL or BigQuery: 1 place where all your data comes together, clean, documented and with history.

04

Reporting automation

The monthly report that now takes 2 days lands in your inbox or Teams channel on the 1st of every month. As PDF, Excel or a live link.

05

AI analytics & forecasting

Revenue and inventory forecasts, anomaly detection and an assistant that answers plain-language questions about your data.

06

E-commerce & marketing dashboards

Shopify, GA4, Google Ads, Klaviyo and Mollie in 1 view: margin per product, cost per order, customer value over time.

07

BI as a service

Your BI specialist on call, for a flat monthly fee: new reports, pipeline maintenance and dedicated time for your questions.

08

Data quality & governance

Definitions recorded, tests on every load, permissions per role and an audit log. So a number in a meeting is never up for debate again.

Delivered

  • KPI definitions & measurement plan
  • Data pipelines (Exact, AFAS, Shopify, GA4)
  • Data warehouse (PostgreSQL or BigQuery)
  • dbt data model with tests
  • Power BI or custom dashboards
  • Role-based permissions
  • Automated reporting & alerts
  • Documentation & data dictionary
  • Handover to your own people

How we work

→ Process

How an engagement runs.

  1. 01

    KPI session

    Week 1: which 5 to 10 numbers steer your business, who looks at them and which decision follows. No dashboard without an answer to that question.

  2. 02

    Sources & pipelines

    We inventory your systems and build the connections. Data loads automatically, with history, into your own warehouse.

  3. 03

    Data model

    With dbt we translate raw tables into the terms you use: customer, order, project, margin. Every definition documented and tested.

  4. 04

    Dashboards

    First version within 2 weeks after the pipelines, then 2 rounds of feedback with the people who will use it.

  5. 05

    Go-live & operations

    Permissions, refresh schedules and alerts configured. Then pipeline maintenance and new reports under a BI retainer, or you run it yourself.

Why RABZI

Why RABZI for this work.

01

Developers, not just analysts

We build the pipelines, the warehouse and the dashboard. If an API is missing, we write one. No “the system cannot do that”.

02

One truth

Every KPI has 1 definition, written in code and documented. Sales and finance look at the same number.

03

Your data stays yours

The warehouse lives in your environment, on European servers. We have no platform of our own to lock you into.

04

Tool-independent

Power BI, Metabase, Looker Studio or custom: we choose what fits your users and your licenses, not our margin.

05

Ready for AI

A clean data model is the prerequisite for forecasting and AI assistants. We build it so that step stays small.

06

Fixed price per dashboard

You know up front what the first dashboard costs and when it will be ready. Expand per dashboard or on a retainer.

Pricing

→ Pricing

Pricing for data & dashboards.

Fixed prices, excl. VAT. Extra work only after approval.

Launch from€3,950

One clear goal, sharply executed. The entry level you keep building on.

  • One dashboard (Power BI or custom)
  • Connection to 1–2 sources
  • KPI definitions
  • Automatic refresh
  • Training
Request a quote
Flagship from€24,500

For platforms, multiple brands or markets, and projects where nothing is standard.

  • Data platform
  • Real-time pipelines
  • Predictive models
  • Governance
  • BI retainer
Request a quote

Work

→ All work

Relevant work

Fleet control · −32% · 98.4% · 1,240 · 14 wks Plate 01 · FLEET CONTROL

Illustrative caseTransport company, Rotterdam · 2025

Real-time planning platform for 140 vehicles

−32% empty kilometers

KPIs · 12 → 1 · −1 day · 07:00 · 10 wks Plate 02 · KPIS

Illustrative caseBuilding materials dealer, Limburg · 2026

From twelve spreadsheets to one management dashboard

12 → 1 Excel files replaced by 1 dashboard

Frequently asked questions

Questions about data & dashboards.

01How much does custom dashboard development cost?

A first dashboard, including a connection to 1 or 2 sources and a data model, starts at RABZI from €3,950 excl. VAT. Growth (from €9,500) delivers a compact data warehouse with 3 dashboards. A full data platform with multiple sources, history and governance starts from €24,500. Maintenance and new reports after that from €500 per month. Power BI or BigQuery licenses are billed separately.

02Power BI or a custom dashboard?

Power BI if your organization runs on Microsoft 365, the users are internal and you want to adjust reports yourself. Custom if the dashboard has to live inside your own software or customer portal, if external users need access, or if per-user license costs are getting out of hand. Metabase is a good middle ground. We advise based on your users, not on our preference.

03Do we need a data warehouse?

With 1 source and simple questions, no; then we connect the dashboard directly. As soon as you want to combine 2 or more systems, keep history your source system discards, or use the same numbers in several reports, yes. A compact warehouse on PostgreSQL costs little and prevents every dashboard from getting its own version of the truth.

04Which systems can you connect?

Exact Online, AFAS, Twinfield, Moneybird, Shopify, WooCommerce, Lightspeed, HubSpot, Pipedrive, GA4, Google Ads, Meta, Klaviyo, Mollie, planning and project software, and your own databases. If a system has an API, we connect it. If it does not, we work with exports, SFTP or a custom connector. We build those ourselves.

05How current are the numbers?

You decide per source. Financial data usually refreshes nightly, store and marketing data hourly, operational data from your own software can be real time. Refreshing more often costs more API traffic and compute, so we choose what makes sense per KPI. A revenue figure that changes every 5 minutes rarely leads to better decisions.

06Can you automate our Excel reporting too?

Yes. Often the first step is not a dashboard but the monthly report that currently takes 2 days of manual work. We automate the data collection and rebuild the report, as a dashboard or still as an Excel file that fills itself every month. Your colleagues keep the familiar format, minus the manual work.

Knowledge

→ All articles

Keep reading

Reply < 1 business day · Available for new projects

Let your numbers speak for themselves.

Tell us which 3 numbers you want to see every morning and where they come from today. We reply within 1 business day, and within a week you have a fixed-price proposal.

info@rabzi.nl · ...