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 to the process for exploring your own transportation data in BigQuery.