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
Skills
Advanced Statistical Model
Client
Transportation Authority
Domain
Big Data Analytics
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!
