North Milan Railway “Treno-Milano” Ticketing
With a view to improving the service offered to commuters in the Lombardy Region, a pass has been introduced by the main transport companies that allows you to travel within the region with a single ticket.
This type of subscription is provided by all of the participating transport companies.Each company manages the sale of subscriptions autonomously and sees to allocating the related revenues based on the routes travelled.
Qwerty Informatica was hired to create a system to manage the data incoming from the central system, including:
- Allocating revenue sharing based on routes travelled
- Adapting codes and other attributes in line with the company’s standard
- Integrating sales with other types of tickets
- Daily transmission of sales data to the SAP system for accounting purposes
- Reporting system for any problems in transmitting data from the various points of sale and to verify and reconcile data
In order to make the data usable by company management, and enterprise reporting system was made that uses the data contained in the SAP-fed BW system.
BW provides analysis cubes accessible with BusinessObjects to monitor the daily trend of sales volumes and travelers, for marketing actions to be undertaken, to verify the flow of travelers in the individual stations equipped with turnstiles.