跳至内容
首页Snowflake

项目

Exploring London's Travel Network

基础技能水平
更新时间 2025年1月
Use SQL to analyze a database containing information about Transport for London journeys over 12 years!
开始项目

包含在Premium or 团队

SnowflakeData EngineeringExploratory Data AnalysisData Warehouse30 分钟1 任务1,500 经验值14,631

创建您的免费帐户

或

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

深受数千家公司学习者的喜爱

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！

创建您的免费帐户

或

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

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。