Create the project, dataset, and tables within BigQuery to execute the queries needed to complete the below
Fantastic news! We've Found the answer you've been seeking!
Question:
Create the project, dataset, and tables within BigQuery to execute the queries needed to complete the below tasks.
A Word Document with SQL queries & answer to each task + Screenshots of each query on Google BigQuery interface and screenshot of sample results from Google BigQuery interface.
TASK 1: Reports on Customers
Create a list of customers using the reports listed below
- List of Customers: Create a query that provides a list of customers with 5 demographic qualities about them (5 columns of your choice from table Consumer_Demo). Sort your data based on two columns (one ascending and one descending). Add a filter to your query and write a sentence about what the query is doing.
- List of Customers + Revenue: Update the query from task 1.1 to return customers and their purchases. For each customer, report the total revenue the customer generated.
- List of Customers + Revenue + Interests: Update query from task 1.2 to report the products the customer has purchased + the total revenue of each product + 2-3 columns from Consumer_Interests
Related Book For
Posted Date: