Mass Rapid Transport Provider In A Large Indian Metro
Challenges
Lack of a consolidated view on routes/operations to understand the trends in ticket sales and patterns in ridership
Understanding revenue patterns across weekdays and day timings covering all stations and ticket types
No current data warehouse-BI infrastructure in place resulting in ridership data in the form of flat files being manually extracted from ERP system for analysis.
Approach
Baselining & detailed workshop to assess current IT and BI infrastructure
Established the IT infrastructure needed covering server, databases and data pipeline integrations
Established a central data warehouse aggregating millions of daily ridership transactional data to provide trends
Established 10+ reports and dashboards to provide insights on ridership, ticket sales and station specific trends and patterns
Achievements
Increased sales from existing customers via recommendations based on usage-patterns
Customer Segmentation for targeted promotions resulting in correct product push and increased sign up to monthly passes
Streamlined business reporting and optimized use of station resources based on ridership patterns
