---
title: "Holacheck: A single database for ticket inspection in public transport | Basco&T"
description: "Holacheck: the database that unifies the data sent by public transport companies, and the Power BI dashboard to monitor ticket-inspection work."
canonical_url: "https://www.basco-t.com/en/data-intelligence/holacheck"
locale: en
meta:
  "og:description": "Holacheck: the database that unifies the data sent by public transport companies, and the Power BI dashboard to monitor ticket-inspection work."
  "og:image": "https://www.basco-t.com/_og/d/c_BascoCard%2Ctitle_~SG9sYWNoZWNrOiBBIHNpbmdsZSBkYXRhYmFzZSBmb3IgdGlja2V0IGluc3BlY3Rpb24gaW4gcHVibGljIHRyYW5zcG9ydCB8IEJhc2NvJlQ%2Cdescription_~SG9sYWNoZWNrOiB0aGUgZGF0YWJhc2UgdGhhdCB1bmlmaWVzIHRoZSBkYXRhIHNlbnQgYnkgcHVibGljIHRyYW5zcG9ydCBjb21wYW5pZXMsIGFuZCB0aGUgUG93ZXIgQkkgZGFzaGJvYXJkIHRvIG1vbml0b3IgdGlja2V0LWluc3BlY3Rpb24gd29yay4%2Cp_Ii9lbi9kYXRhLWludGVsbGlnZW5jZS9ob2xhY2hlY2si%2Cs_pQ6Jv7L_JoqHMLwU.png"
  "og:image:alt": "Holacheck: A single database for ticket inspection in public transport | Basco&T"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Holacheck: A single database for ticket inspection in public transport | Basco&T"
  "twitter:description": "Holacheck: the database that unifies the data sent by public transport companies, and the Power BI dashboard to monitor ticket-inspection work."
  "twitter:image": "https://www.basco-t.com/_og/d/c_BascoCard%2Ctitle_~SG9sYWNoZWNrOiBBIHNpbmdsZSBkYXRhYmFzZSBmb3IgdGlja2V0IGluc3BlY3Rpb24gaW4gcHVibGljIHRyYW5zcG9ydCB8IEJhc2NvJlQ%2Cdescription_~SG9sYWNoZWNrOiB0aGUgZGF0YWJhc2UgdGhhdCB1bmlmaWVzIHRoZSBkYXRhIHNlbnQgYnkgcHVibGljIHRyYW5zcG9ydCBjb21wYW5pZXMsIGFuZCB0aGUgUG93ZXIgQkkgZGFzaGJvYXJkIHRvIG1vbml0b3IgdGlja2V0LWluc3BlY3Rpb24gd29yay4%2Cp_Ii9lbi9kYXRhLWludGVsbGlnZW5jZS9ob2xhY2hlY2si%2Cs_pQ6Jv7L_JoqHMLwU.png"
  "twitter:image:alt": "Holacheck: A single database for ticket inspection in public transport | Basco&T"
  "twitter:title": "Holacheck: A single database for ticket inspection in public transport | Basco&T"
---

> Index of every page on this site: [llms.txt](https://www.basco-t.com/llms.txt)

[←** Data Intelligence & Operations**](https://www.basco-t.com/en/expertise#data)

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

[**Talk to us about your project**](https://www.basco-t.com/en/contatti)

**Transport companies**

**Single database**

**Power BI dashboard**

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

<dl>

<dt>**Client**</dt>
<dd>**Ticket-inspection company**</dd>

<dt>**Sources**</dt>
<dd>**Data sent by public transport companies**</dd>

<dt>**Tools**</dt>
<dd>**Central database, Power BI**</dd>

<dt>**Phases**</dt>
<dd>**Database, then dashboard**</dd></dl>

## **How it works**

1. ### **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. ### **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.**

## **Other projects in this area**

- [<h3>**Autofine**</h3>

  Machine learning to recover unpaid fines.Discover the project](https://www.basco-t.com/en/data-intelligence/autofine)
- [<h3>**Mobility Lens**</h3>

  Data intelligence for planning, investment and real estate.Discover the project](https://www.basco-t.com/en/data-intelligence/mobility-lens)
- [<h3>**Q-Mobility**</h3>

  Online quotes and back office for coach hire.Discover the project](https://www.basco-t.com/en/data-intelligence/q-mobility)

## **Give your data real value**

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

[Talk to us about your projectTalktousaboutyourproject](https://www.basco-t.com/en/contatti)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://www.basco-t.com/en#website","@type":"WebSite","inLanguage":"en-GB","name":"Basco&T","url":"https://www.basco-t.com/en","publisher":{"@id":"https://www.basco-t.com/#identity"},"translationOfWork":{"@id":"https://www.basco-t.com/it#website"}},{"@id":"https://www.basco-t.com/en/data-intelligence/holacheck#webpage","@type":"WebPage","description":"Holacheck: the database that unifies the data sent by public transport companies, and the Power BI dashboard to monitor ticket-inspection work.","name":"Holacheck: A single database for ticket inspection in public transport | Basco&T","url":"https://www.basco-t.com/en/data-intelligence/holacheck","isPartOf":{"@id":"https://www.basco-t.com/en#website"},"potentialAction":[{"@type":"ReadAction","target":["https://www.basco-t.com/en/data-intelligence/holacheck"]}],"primaryImageOfPage":{"@id":"https://www.basco-t.com/#logo"}},{"@id":"https://www.basco-t.com/#identity","@type":"Organization","name":"Basco&T","url":"https://www.basco-t.com","logo":{"@id":"https://www.basco-t.com/#logo"},"sameAs":["https://www.linkedin.com/company/basco-t/","https://www.facebook.com/profile.php?id=61573738169898","https://www.instagram.com/mobility_metrics/"]},{"@id":"https://www.basco-t.com/#logo","@type":"ImageObject","caption":"Basco&T","contentUrl":"https://www.basco-t.com/logos/Logo Sfondo Bianco.png","inLanguage":"en-GB","url":"https://www.basco-t.com/logos/Logo Sfondo Bianco.png"}]}
```

## Sitemap

See the full [sitemap](https://www.basco-t.com/sitemap.md) for all pages.
