Creating New BigQuery Datasets and Visualizing Insights
This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources.
Note: Even if you have a background in SQL, there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you.
>>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: https://qwiklabs.com/terms_of_service
-Overview of what you will learn in this course
Storing and Exporting Data
-Create new permanent and temporary tables from your query results
Ingesting New Datasets into Google BigQuery
-Load and create new datasets inside BigQuery
Joining and Merging Datasets
-Understand the differences between SQL JOINs and UNIONs and when to use each
-Compare data visualizations and learn how to use Google Data Studio
End of Course Recap