Skip to main content

Holacheck

Process review and business intelligence for ticket inspection services

Two assignments for Holacheck, a company that carries out ticket inspection and penalty management on behalf of public transport operators: review of the inspection planning processes and construction of an integrated database to support the management dashboard.

Client
Holacheck
Service
Operational Excellence & Process Optimization
Projects
Process review, database integration and automation
Years
2025-2026

2025Process review

Review of operating processes and management support tools

Objective criteria for planning inspections, integration of data from clients and a business intelligence dashboard for monitoring activities.

The stages of the work

The project linked inspection planning to the results measured in the field, to direct resources to where fare evasion is highest.

  1. Analysis and diagnosisShifts, penalty flow and systems in use
  2. Planning criteriaObjective rules for work plans
  3. Data integrationTemplates and validation rules
  4. Management dashboardContinuous monitoring of results

Source: Basco&T assignment.

The context

Holacheck wanted to make the shift planning of its ticket inspectors more dynamic, linking work plans to inspection results and adopting criteria shared by all project leaders, so as to concentrate resources on the lines, time slots and days with the highest fare evasion.

In addition, penalty data come from the management systems of the various clients, each with its own formats and timing: integrating them was the precondition for full visibility over the process and for making payment reminders more effective.

What we did

  1. Operational analysis and diagnosis

    Mapping of shift planning practices and of the flow for issuing penalties and sending reminders, with an assessment of the management system in use.

  2. Planning criteria and standards

    Definition of objective criteria for assigning shifts and of a standard company process for building work plans.

  3. Integration with client systems

    Analysis of data exchange methods, unified templates, validation rules and a reminder protocol to make data exchange more regular and reliable.

  4. Business intelligence dashboard

    Requirements and development of an interactive dashboard to check the data collected by inspectors, store them as historical records, analyse trends and indicators, and update work plans dynamically.

The new operating model

BeforeAfter
Work plans set at the start of the period
Plans updated on the basis of inspection results
Criteria set by individual project leaders
A standard process with objective criteria
Client data in heterogeneous formats
Unified templates and validation rules
Monitoring through periodic reports
Management dashboard with indicators and time series

What we delivered

  • Report analysing processes and areas for improvement
  • Objective criteria and standard process for work plans
  • Templates and rules for integrating client data
  • Business intelligence dashboard for management

2026Data management

Database integration, anonymisation and automation

Construction of a single, reliable database that complies with data protection legislation and is fed automatically, to support the work plan dashboard.

The context

The dashboard developed to monitor work plans relied on data collected from different clients, with different management systems and formats and with personal information to be protected.

To make it a stable tool, a single, clean, automatically updated database was needed.

What we did

  1. Choosing the technology

    Comparison of different database solutions in terms of performance, scalability, maintainability and total cost of hardware, licences and maintenance, with guidelines for the chosen architecture.

  2. Data acquisition and cleansing

    Collection of data from all clients, including those using different systems, integration of network data in GTFS format, quality checks and field normalisation.

  3. Anonymisation

    Replacement of personal information with unique codes, in compliance with data protection legislation.

  4. Automatic updating

    Development of data extraction, transformation and loading procedures with consistency checks and anomaly handling.

What we delivered

  • Technical document comparing and selecting the technology
  • Single, normalised and anonymised database
  • Automatic updating system with consistency checks

More Operational Excellence & Process Optimization projects

View all projects
Start Romagna

Start Romagna

Assessment of accounts receivable and payable procedures

Mapping of administrative processes, analysis of the causes of delays in recording invoices, and new procedures in SAP.

Read the project
ATC Esercizio, La Spezia

ATC Esercizio, La Spezia

Workload mapping and new organisational structure

Analysis of the workloads and critical processes of four company departments and two options for a new organisation chart.

Read the project

Cooperativa Trasporti Riolo Terme

Cooperativa Trasporti Riolo Terme

Analysis of the sustainability of the coach hire service and company valuation

Profitability of coach hire with driver by type of service and vehicle, proposals on fares and synergies, and valuation of a local operator.

Read the project

Want to give management data-driven control tools?

Tell us what you need: we reply within one working day.