Client & Scope
Client:
Japanese Conglomerate.
They have unique in-house capabilities to provide highly reliable, customized, scalable, flexible IT and network technologies. These capabilities are being increasingly relied upon by governments for efficient technological solutions for Transportation in Indian cities
Scope:
- Data Acquisition from multiple ITMS modules
- Design & Build a Centralized EDW Data Processing / Transformation
- Building Analytics for User Consumption using Tableau
Business Value & Benefits
- Analyzing passenger traffic during peak hours in important routes Analyzing Load Factor to effectively manage schedules and bus frequency
- Analyzing cost and earning for better trip management Commuter’s demographic analysis Route-wise revenue and ridership analysis in BRTS
- Effective management of Commuter’s grievances
Solution & Technology
- All stages of the project, from requirements definition to design, development, testing, reporting and production support .
- Developing EDW from scratch for reporting solution.
- Integrating data from different ITMS modules
- Deriving Route-wise revenue by analyzing data from AVLS and AFCS
- Creating Analytics and Dashboards to see trends and business insights.
- Designing and building new ad-hoc reports using Tableau.
