Creating New BigQuery Datasets and Visualizing Insights

Go to class
Write Review

Free Online Course: Creating New BigQuery Datasets and Visualizing Insights provided by Coursera is a comprehensive online course, which lasts for 3 weeks long, 8-9 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from Coursera. Creating New BigQuery Datasets and Visualizing Insights is taught by Google Cloud Training.

Overview
  • This is the second course in the Data to Insights course series. 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.

    After completing this course, enroll in the Achieving Advanced Insights with BigQuery course.

    >>> 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

Syllabus
    • Course Introduction
      • 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 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
    • Data Visualization
      • Create dashboards and visualizations with Google Data Studio
    • Course Summary
      • Summary of the course ley learning points