Hands-on exercise – data loading and transformation in BigQuery
To assist with your learning of the concepts in this chapter, we will take you through a hands-on example, including loading data from a local file and preparing some basic transformations on the table data. This hands-on exercise will prepare you for loading your own data in the future and give you experience of doing some basic processing of that data. We will follow a scenario that utilizes a traffic collision dataset. This example and the scenario will build in the future chapters. Follow along by reading the scenario and following it step by step in your Google Cloud console. It may be useful to do a little role-playing here, as follows!
Understanding the scenario
Consider yourself as the Head of Data Analytics for the company described in this scenario. Your company is building a service to reduce users’ cellphone usage while driving. The company’s data team is just beginning to bring in...
