Скачать или смотреть Creating a Data Warehouse Through Joins and Unions |

BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.

The dataset you'll use is an ecommerce dataset that has millions of Google Analytics records from the Google Merchandise Store. You will explore the available fields and row for insights.

This lab focuses on how to create new reporting tables using SQL JOINS and UNIONs.

Scenario: Your marketing team provided you and your data science team all of the product reviews for your ecommerce website. You are partnering with them to create a data warehouse in BigQuery which joins together data from three sources:

Website ecommerce data
Product inventory stock levels and lead times
Product review sentiment analysis
What you'll do
In this lab, you learn how to perform these tasks:

Explore new ecommerce data on sentiment analysis.
Join datasets and create new tables.
Append historical data with unions and table wildcards.


Lab Link:
https://www.cloudskillsboost.google/c...