The Data Analysis Tool for Urban Transport is a simple Excel-based tool that enables users to compare several urban transport related indicators in a city with similar indicators in peer cities. Such a comparison would allow users to identify areas where the city under study is performing well or is performing poorly. The tool has been developed using a database on urban transport covering over 93 cities with data collected only from secondary sources. The output is a report presenting how the city is performing vis-a-vis peer cities with respect to a set of performance indicators. The tool aims to provide a comparative framework for urban transport experts so that they can better identify the main deficiencies in the city’s transport system and recommend the most appropriate remedial measures. The idea is to get a report that would be something like a pathologists report helping a doctor better identify the patient’s ailment.
Click here to access the Excel tool (Data is current to 2016)