
With a population of over 4 million, the city of interest for the client body, is expecting the population to grow by 25% by 2020 and host more than 10 million tourists per day. The economy is growing significantly and all these trends were adding to the pressure on the existing infrastructure. The client body handles more than 12 million ticketing transactions per day and wanted to develop and fine-tune the land transport (whether by car, bus or train) policies using advanced analytics to ensure comfort, convenience and pricing of the city public transport. The scope was identified as the implementation of an enterprise data warehousing platform that would enable the client to perform in depth analysis of bus, train ridership and taxi availability for meaningful trend analysis, long term policy planning and data mining.