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
- 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.
- 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.
