Solution
- Data Storage: Hadoop and MySQL
- Query Tools: Hive and SQL
- Algorithms: rmr (Parallel versions of R) and Java
- Reporting and Dashboards: Pentaho
Issues & Objectives
Transport regulatory authority in Singapore commissioned a system to
- Automatically discover wrong fare incidents and flag commuter’s cards affected by wrong fare charging; and
- Detect emerging fault trends in fare collection equipment so that corrective action could be taken in a timely manner
Challenges
- Large data 15 million transactions per day, which translates to more than 5 billion historical transactions in a year needs to be processed to identify fault patterns and trends
- The data consisted of financial, operations, transit and events data of buses
Project information
Techniques
Forecasting
Client
Transportation Authority
Industries
Public Sector & Education
Location
Singapore
Results
Robust solution in use for over 2 years allows pro-active rather than reactive maintenance
What we build, how it performs - Explore our work!
Would love to hear your thoughts!
