Hoppa till huvudinnehåll
HemData Engineering

project

Exploring London's Travel Network

GrundläggandeFärdighetsnivå
Uppdaterad 2025-01
Use SQL to analyze a database containing information about Transport for London journeys over 12 years!
Starta Projekt

Ingår medPremie or Lag

RedshiftData EngineeringData Warehouse30 min1 Task1,500 XP

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Älskad av elever på tusentals företag

Group

Utbilda 2 eller fler personer?

Testa DataCamp for Business

Projektbeskrivning

Exploring London's Travel Network

How do Londoners get around? Transport for London (TfL) is a vast public transport network that allows London's residents to efficiently travel around the UK's capital, to the tune of over 1.5 million journeys per day! In this introductory project, you will work with a Snowflake, Amazon Redshift, Google BigQuery, or Databricks database containing data on journeys and transport types in London between 2010 and 2022. You will write SQL queries to find the most popular transport methods, examine when the London cable car (which connects London's Royal Docks, where the Mayor's office is located, to Greenwich Peninsula, home of the O2 arena) was particularly busy, and identify rare periods when the Underground (also known as "the tube" to locals) was less busy.

Exploring London's Travel Network

Use SQL to analyze a database containing information about Transport for London journeys over 12 years!
Starta Projekt
  • 1

    Explore how Londoners travel around the city!

Gå med över 19 miljoner elever och börja Exploring London's Travel Network idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.