12

Hands-On Exercise – Analyzing Transportation Data

In this chapter, we will walk through a hands-on exercise analyzing transportation data in BigQuery. We intend to show you a repeatable process for handling transportation data in BigQuery that can be replicated with real data sources.

This chapter will cover the following sections:

  • Exercise and use case overview
  • Loading data from GCS to BigQuery
  • Data preparation
  • Data exploration, analysis, and visualization

By the end of this chapter, you will understand specific approaches for handling transportation data in BigQuery. Following along with this chapter will give you hands-on experience prior to trying out these steps with real data. Using this chapter as a reference can help you as a guide ...

Get Data Exploration and Preparation with BigQuery now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.