Creating New BigQuery Datasets and Visualizing Insights

  • 4.6
Approx. 11 hours to complete

Course Summary

This course teaches you how to create BigQuery datasets and visualize insights using Google Cloud Platform. It covers topics such as data ingestion, data modeling, and data visualization.

Key Learning Points

  • Learn how to create BigQuery datasets and tables
  • Understand data ingestion and data modeling
  • Visualize insights with Data Studio

Related Topics for further study


Learning Outcomes

  • Create BigQuery datasets and tables
  • Understand data modeling and ingestion
  • Visualize insights with Data Studio

Prerequisites or good to have knowledge before taking this course

  • Basic knowledge of SQL
  • Familiarity with Google Cloud Platform

Course Difficulty Level

Intermediate

Course Format

  • Online
  • Self-paced

Similar Courses

  • Data Warehousing for Business Intelligence
  • Data Visualization with Tableau
  • Big Data Essentials: HDFS, MapReduce and Spark RDD

Related Education Paths


Related Books

Description

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.

Outline

  • Introduction
  • Course Introduction
  • Qwiklabs Introduction
  • Recap of Google Analytics ecommerce dataset
  • Storing and Exporting Data
  • Creating Permanent Tables
  • Demo: Importing JSON Data
  • Temporary Tables and Query Results
  • Performance Preview: Query Cache
  • Creating Logical Views
  • Lab Overview
  • Lab Solution
  • Module Quiz
  • Ingesting New Datasets into Google BigQuery
  • Ingesting New Data into BigQuery
  • Demo: Loading Data into BigQuery
  • Lab Intro
  • Lab Solution
  • Background: Partitioned Tables
  • Module Quiz
  • Joining and Merging Datasets
  • Introducing JOINs and UNIONs
  • Introducing BigQuery Table Wildcards for Easy Merges
  • SQL JOIN Syntax
  • Walkthrough: SQL Join Types
  • Avoiding Pitfalls when Merging Datasets
  • Ecommerce Dataset Recap
  • Lab Intro
  • Lab Solution
  • Module Quiz
  • Data Visualization
  • Overview of Data Visualization principles
  • Comparing Good and Bad Visualizations
  • Dimensions, Measures, and Reports
  • Introducing Google Data Studio
  • Demo: Data Studio Walkthrough
  • Lab Intro
  • Lab Solution
  • Building a Monitoring Dashboard
  • Module Quiz
  • End of Course Recap
  • End of Course Recap

Summary of User Reviews

This course on creating BigQuery datasets and visualizing insights on Coursera has received positive reviews from users. Many users found the course to be comprehensive and informative.

Key Aspect Users Liked About This Course

The course provides a thorough understanding of BigQuery datasets and their visualization.

Pros from User Reviews

  • Comprehensive and informative course
  • Great explanations and practical examples
  • Hands-on approach to learning
  • Good pace and structure
  • Useful for both beginners and advanced learners

Cons from User Reviews

  • Some users found the course to be too basic
  • Could have included more advanced topics
  • Lack of support from the instructor
  • The course could be more engaging and interactive
  • Not enough emphasis on real-world applications
English
Available now
Approx. 11 hours to complete
Google Cloud Training
Google Cloud
Coursera

Instructor

Google Cloud Training

  • 4.6 Raiting
Share
Saved Course list
Cancel
Get Course Update
Computer Courses