Skip to main content
Data Intelligence & Operations

Holacheck

A single database for ticket inspection in public transport

Holacheck was built for a ticket-inspection company that receives data from many local public transport companies, each with its own formats and timing. We built the database that unifies them and, on top of it, a Power BI dashboard that lets department heads follow the work across millions of aggregated records.

  • Millions

    of records aggregated in a single dashboard

  • 1

    database for every transport company served

  • 2

    phases: the database first, then the Power BI dashboard

The challenge

Every transport company sends its own data, with different formats, codes and frequencies. Without a common base, comparing companies, areas and periods takes manual work, and information reaches decision-makers late.

Client
Ticket-inspection company
Sources
Data sent by public transport companies
Tools
Central database, Power BI
Phases
Database, then dashboard

How it works

  1. 01

    The database

    We collect the feeds sent by public transport companies, normalise them and load them into a single data model, with quality checks at every update.

  2. 02

    The Power BI dashboard

    On top of the database we build a dashboard with aggregated views and filters by company, area and period, designed for department heads.

What it offers

  • Unified data

    One model for the data of every company served, instead of scattered files and formats.

  • Millions of records at a glance

    Indicators and aggregations computed on the full dataset, a few clicks away.

  • Continuous monitoring

    Managers follow the work as it happens and spot anomalies and deviations straight away.

The result

With our product, department heads get a single, up-to-date view of the work carried out for every transport company, with no manual consolidation.

Give your data real value

Tell us where you're starting from: we'll reply within one working day.