Data exploration, analysis, and visualization

In this section, we will begin by exploring our data sources, doing some initial analysis, and then creating some visualizations. We will show you how to create meaningful insights from advertising, analytics, and sales data.

Let’s begin by finding the minimum and maximum date in each of our tables. This will let us know what date range we can compare across our three data sources:

SELECT min(date), max(date)
FROM `ch11.jewelry_sales_data`

We get the following result:

Figure 11.9 – Date range analysis

Running this query across our three tables shows the three datasets have a date range overlap between 2022-05-01 and 2022-12-10. We will use this window to correlate and measure ads, website visits, and sales data.

Continuing our exploration, the following query will return the unique keywords that we are using in our advertising campaigns:

SELECT DISTINCT(keywords)
FROM `ch11.jewelry_ads_data...