LSE Data Analytics Course: Employer Project - Thoughtworks

Requirements:

-write a project plan that outlines the project timeline, objectives, tasks, and milestones (This includes identifying and defining the problem statement and conducting research relevant to the business scenario to inform analyses and recommendations.)

-conduct exploratory data analysis and analyse the data sets provided to develop insights that can inform innovation processes, seeking additional data as required to support relevant analysis

-document the analysis

-prepare data-informed recommendations to give to the business, including the intended outcomes of your recommendations and the justification of this recommendation as a critical focus area

-create compelling visualisations (This might mean preparing a data dashboard, composing a narrative with data storytelling, or designing a slide deck to support the recommendations being put forward, outlining the existing context and the expected future scenario.)

-present the insights, recommendations, and justification of the approach, along with the rationale and supporting evidence, in a written report and as part of a group presentation shared with the relevant employer partner.

Scenario:

About the client The Greater London Authority (GLA) is the governance body for the Greater London region, which is the administrative area of London, UK. The GLA consists of two political branches: the executive Mayoralty (the Mayor of London) and the 25-member London Assembly. The London Assembly ensures the Mayor’s policies, actions, and strategies are in the public interest

The GLA has powers over transport, policing, economic development, and fire and emergency planning. The responsible bodies for the delivery of these services are Transport for London, the Mayor’s Office for Policing and Crime, and the London Fire Commissioner.

Initial questions:

How can we increase the uptake of cycling in London? What are the main factors that determine whether people choose to cycle? What interventions and changes to the transport network have had the most impact on cycling engagement?

Data:

The semi-wrangled data has been collected from the following sources:

London, England Cycling Infrastructure Database https://data.london.gov.uk/dataset/cycling-infrastructure-database Contains comprehensive details of cycling infrastructure across London, including cycle lanes and tracks, cycle parking, and signalised crossings for cycles Monthly statistics on the number of cyclists on Superhighways CS3 and CS6 From the counters at Blackfriars Bridge and Victoria Embankment https://cycling.data.tfl.gov.uk/

Sydney, Australia Cycling Infrastructure Data, https://opendata.transport.nsw.gov.au/dataset/infrastructure-cycleway-data specifically: Bicycle count explorer Bicycle count sites Contains data for the whole of New South Wales, which includes Sydney Most of the data is non-tabular and difficult to work with. Twice annual statistics on the number of cyclists in local government areas Cycling count data for different local government areas (LGA) Cycle network Shapefile for the TfNSW bicycle network maintained by Roads and Maritime Services

New York City, USA NYC Open Data https://data.cityofnewyork.us/Transportation/Bicycle-Counts/uczf-rk3c Bicycle counts at key locations Bicycle routes Bicycle parking Various other publicly available cycling-related data sets are available on NYC OpenData (2022).