open to data, bi & ai roles — netherlands

Francisco Rau_

I build the pipelines, metrics and reporting that operations teams use every day: fourteen months of it at work, and more in my own products below.

Data & BI Analyst · MSc Data Science + BSc Economics, Tilburg University · EN / ES native · NL A2 (learning)
Pillar one · contact-centre BI suite

One operation, four working tools

At a Dutch contact centre I owned operational BI end to end: capacity planning, performance measurement and live operational reporting. The four tools below show that kind of work, built on invented data: every name and number is made up, and the operations P&L is a concept of my own. Click into any of them.

01Measure performance→ 02Live operations view→ 03Plan the capacity→ 04Price it in euros
01 · Measure

Daily Agent Report

Every agent judged against a “frontier” — the 70th percentile of their own campaign's clean-day performance, so a hard workload or short shift is never unfairly penalised. A pace × closing index, statistical shrinkage for thin samples, and a dialer burn-down that predicts what carries to tomorrow.

combined = pace × closing — volume can't hide weak conversion, or vice-versa.
metric designstatisticsbenchmarkingExcel/Sheets
Open the live report →
02 · Runruns live

Agent TV Board

A supervisor wallboard for a live operations view. Live queues, agent statuses with idle-time flags and passed-call counters, incoming-call routing, and a rotating stats panel — calls, conversion and pace, per agent and per campaign. This page simulates a live operations view in real time.

dark · full-screen · best on a desktop
real-timedashboardsops designJavaScript
Open the live board →
03 · Plan

Campaign Staffing Simulator

Any mailing calendar in, daily agent demand out — 500+ days ahead. A cohort funnel with measured pickup decay and callbacks that re-enter on their promised day, plus flow-choke detection and a batch optimizer that re-verifies its own fixes by re-simulating.

under-staff → letters wait · over-staff → everyone slows down. The target is the right number.
Pythoncohort modelingforecastingoptimization
Open the live simulator →
04 · Priceconcept · own design

Operations P&L — Unit Economics

The layer that turns it all into money: what every agent-hour costs, what every campaign, call attempt and talk-minute earns. Attempt-level economics expose where the retry schedule starts losing money; break-even durations and closing rates turn operational metrics into executive decisions.

“attempts 4–5 lose €239/day” — the retry policy is a money dial, not an ops dial.
unit economicsP&L modelingbreak-even analysis
Open the P&L model →
Pillar two · Citania

From a market gap to a working product

Built on my own time: first the research that showed me the gap was real, then a booking platform for salons and barbershops in Mexico City, like Treatwell or Fresha. Deployed, not launched yet.

The research first

How many salons in Mexico City can you book online?

Before building anything, I checked whether the gap was real. I collected every salon, barbershop and similar business in Mexico City from Google Maps: 10,605 of them across 54 neighbourhoods, with the duplicates removed. Then I checked each one for a way to book online, in two separate ways, so one check couldn't fool me. More than nine out of ten had none.

  • Two checks per business: does its website use a booking system, and does its Google listing have a "Reserve" button.
  • Runs on its own: it works through the night and picks up where it stopped if anything breaks.
PythonGoogle Maps dataautomation
Businesses found 10,605
Can be booked online 727
No way to book online 9,878
93%
can't be booked online
2
separate checks
8
types of business
54
neighbourhoods
SaaS product · deployed, pre-launch

Citania — online booking for salons and barbershops in Latin America

The product the research pointed to: a multi-tenant booking platform in the Treatwell/Fresha category, built for Latin America (Spanish, MXN, CDMX-first). A TypeScript monorepo — Express 5 + Postgres, contract-first OpenAPI, a React web app and an Expo React Native mobile app.

  • Over 4,000 automated tests covering the full booking flow, with database-level slot exclusivity — double-booking is blocked by a database constraint.
  • Two-way Google Calendar sync live, with loop prevention via source tags, booking IDs and etags.
  • Two AI features: a voice receptionist that books against the live calendar, and a photo import that reads a handwritten appointment book.
  • Role-based pricing, cancellations, reviews, reminders, segmented marketing + loyalty, and a full owner dashboard (calendar, services, team, inventory, clients, reports).
Owner dashboard — the operator side of the product
Consumer booking page — real-time availability, booking flow end to end. Open the booking page →
TypeScriptPostgreSQLExpressOpenAPIReactReact Native
Pillar three · Alpha Scout

A football scouting & valuation platform

Built alone, end to end: the data collection, the models, the product and the design. Over 29,000 players across 156 leagues, valued match by match, with the testing published.

Live product · beta

Alpha Scout — find undervalued players before the market does

Alpha Scout uses a machine-learning model, trained on more than 100,000 player-seasons, to estimate what every player should be worth from their performance, age, league strength and contract, and gives a calibrated probability that each one rises in value over the season. Does it work? I backtested it: I rebuilt its July shortlist for every year from 2019 to 2025, using only data available at the time. A year later, its picks were worth on average about 1.3 times as much as comparable players it didn't pick (same league level, position, age, minutes and price), in all seven years. That's a backtest, not a live track record.

  • Real data at scale: over 29,000 players across 156 leagues, collected match by match and refreshed every week, with more than 100,000 player-seasons of history behind the estimates.
  • Honest about its limits: the results are published league by league, including where it's weak, and it won't price players above €60M, where it hasn't been tested.
  • Built for the people who buy: a club view with squad gaps and realistic budgets, similar players under €1M from your region, a contract-expiry radar and one-click club reports.
The live demo — real players, real data
Pythonstatisticsbacktestingautomationweb app
Try the live demo →
Earlier work

Modeling & research

Econometrics · research

Erroneous convictions (ENPOL)

Empirical paper on Mexico's national prison-population survey — quantifying due-process failures linked to wrongful-conviction risk.

econometricssurvey data
More

Happy to walk through the method and the data behind any project here.

franciscorau08@gmail.com