Illustrative case: Building materials dealer, Limburg · 2026

From twelve spreadsheets to one management dashboard

Every morning at seven, yesterday’s numbers, without anyone lifting a finger.

Results

Indicative figures

  • 12 → 1Excel files replaced by 1 dashboard
  • −1 daymanual reporting work per week
  • 07:00yesterday’s numbers available, every day
  • 10 wksfrom kickoff to rollout

The story

The story behind From twelve spreadsheets to one management dashboard

Three branches, 14,000 products and a controller who stitched together twelve Excel files every Monday. We built a warehouse-light on AFAS, Exact Online and the POS system and one dashboard with revenue, margin, stock and receivables per branch, updated automatically every morning.

The challenge

Management received numbers a week late, from reports built by one person in Excel. Margin per product group was an estimate, dead stock was spotted too late and the branch managers each had their own truth.

Mobile dashboard 'Yesterday's figures' with revenue, margin, stock and receivables per branch Revenue KPI card: €142,860, 6.4% above last year

The sources were scattered: finance in AFAS, purchasing in Exact Online, sales in a POS system without a reporting module and pricing agreements in an Access database.

Our approach

We started with KPI definitions: what is margin, when is stock dead, which revenue counts for which branch. Then we built a warehouse-light in PostgreSQL with daily pipelines from AFAS (GetConnector), Exact Online and a POS export, with data quality checks that flag deviations.

From the video: Stock in Venlo Signal: €180,000 in slow-moving stock, 214 items unsold for more than 180 days Push notification at 07:01: tile margin in Venlo 4 points below target

On top of the warehouse we built Power BI dashboards for management, the controller and branch managers, with roles and permissions. Two review rounds with the users determined which numbers belong on the first screen.

Ten weeks from kickoff to full rollout, with a four-week parallel period alongside the old Excel reports to validate the numbers.

The solution

One dashboard with revenue, margin, stock rotation, dead stock, receivables and open orders per branch and product group, updated every morning at 07:00. Alerts on deviations. The controller spends the freed day on analysis instead of copy-paste.

From the video: Alert at 07:01 Gross margin chart for the last 30 days, with the target band

Within one quarter the dashboard identified €180,000 of dead stock that was subsequently reduced.

Watch it in action0:21 · 3 scenes

Project facts

About this project

Something similar in mind? Book a call
Client
Building materials dealer, Limburg
Year
2026

Delivered

  • KPI definitions
  • Warehouse-light on PostgreSQL
  • Pipelines from AFAS, Exact and POS
  • Data quality checks and alerts
  • Power BI dashboards with roles
  • Training
  • BI plan

Technology

  • Power BI
  • PostgreSQL
  • Node.js
  • AFAS GetConnector
  • Exact Online API
  • dbt
  • Azure (EU)
  • Grafana

Illustrative case: composed from comparable engagements. Figures are indicative, not the measured result of one client.

Let’s build something.

Tell us about your project. You will hear back within one business day and receive a concrete proposal within a week.

info@rabzi.nl