About this 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 <<< ***NEW! Specialization Completion Challenge and earn rewards valued at $100. See below for details.*** 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. SPECIALIZATION COMPLETION CHALLENGE As if learning new skills weren't enough of an incentive, we're excited to announce a special completion challenge for 'From Data to Insights with Google Cloud Platform' specialization. Here’s how it works: Our completion challenge runs through August 31, 2018. Complete this Specialization anytime before 12:59pm PT on August 31, 2018 and we'll send you 100 Qwiklabs credits, valued at $100, that you can use to take additional labs and earn badges, which you can then add to your resume and social profiles. Your challenge awaits – begin learning on Coursera today!
Who is this class for: This is course is primarily aimed at new Data Analysts, Business Analysts, and Business Intelligence professionals. It is also intended for Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform.
| Basic Info | Course 2 of 4 in the From Data to Insights with Google Cloud Platform Specialization |
| Level | Beginner |
| Commitment | 1 week of study, 5-7 hours/week |
| Language | English |
| Hardware Req | You'll need a desktop web browser to run this course's interactive labs via Qwiklabs. |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
- Video: Qwiklabs Introduction
- Video: Recap of Google Analytics ecommerce dataset
- Video: Demo: Importing JSON Data
- Video: Temporary Tables and Query Results
- Video: Performance Preview: Query Cache
- Video: Creating Logical Views
- Video: Lab Overview
- Video: Lab Solution
- Video: Demo: Loading Data into BigQuery
- Video: Lab Intro
- Video: Lab Solution
- Reading: Background: Partitioned Tables
- Video: Introducing BigQuery Table Wildcards for Easy Merges
- Video: SQL JOIN Syntax
- Video: Walkthrough: SQL Join Types
- Video: Avoiding Pitfalls when Merging Datasets
- Video: Ecommerce Dataset Recap
- Video: Lab Intro
- Video: Lab Solution
- Video: Comparing Good and Bad Visualizations
- Video: Dimensions, Measures, and Reports
- Video: Introducing Google Data Studio
- Video: Demo: Data Studio Walkthrough
- Video: Lab Intro
- Video: Lab Solution
- Reading: Building a Monitoring Dashboard
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Excelent, very clear explanations
This course is very helpful.
It would be great if one could practice in bigquery with the public data without consuming the free processing, just during the course. I would like to work to connect all the concepts up to this point and that would be easier if I had a token to use in google cloud platform so no money would be need.
great course by google