Hands-On Exercise – Analyzing Advertising Data
In this chapter, we will walk through a hands-on exercise analyzing advertising data in BigQuery. We will cover some of the common challenges and approaches for handling sales, marketing, and advertising data in BigQuery. In this chapter, we intend to show you a repeatable process for handling advertising data in BigQuery that can be replicated with real data sources.
This chapter will cover the following sections:
- Exercise and use case overview
- Loading CSV data files from a local upload
- Data preparation
- Data exploration, analysis, and visualization
By the end of this chapter, you will understand specific approaches to handle advertising data in BigQuery. Following along this with chapter will give you hands-on experience and experience prior to trying out these steps with real data. Using this chapter as a reference can help you as a process guide to explore your own advertising data in BigQuery.
...
