Exploring London's Travel Network
Use SQL to explore 12 years of Transport for London journey data.
Transport for London (TfL) enables over 1.5 million daily journeys. In this project, you'll analyze a database of London travel data from 2010 to 2022 using SQL. Discover the most popular transport modes, identify trends in cable car usage, and uncover rare slow periods on the Underground.
- Query a transport database covering 2010–2022 journeys.
- Identify the most used modes of transport in London.
- Analyze cable car and Underground travel trends.
- Apply SQL skills on real-world urban mobility data.