跳至内容
家Snowflake

Projects

Exploring London's Travel Network

基本的技能水平
更新 2025年1月
Use SQL to analyze a database containing information about Transport for London journeys over 12 years!
启动项目

包含优质的 or 团队

SnowflakeData EngineeringExploratory Data AnalysisData Warehouse301 Tasks1,500 XP13,995

创建您的免费帐户

或者

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学员的喜爱

Group

培训2人或以上？

试试DataCamp for Business

项目描述

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!
启动项目
  • 1

    Explore how Londoners travel around the city!

加入 19百万名学习者 立即开始Exploring London's Travel Network ！

创建您的免费帐户

或者

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。