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.
Module 6: Storing and Exporting Data Create new permanent and temporary tables from your query results
Module 7: Ingesting New Datasets into Google BigQuery Load and create new datasets inside BigQuery
Module 8: Data Visualization Compare data visualizations and learn how to use Google Data Studio
Module 9: Joining and Merging Datasets Understand the differences between SQL JOINs and UNIONs and when to use each
MOOCs stand for Massive Open Online Courses. These arefree online courses from universities around the world (eg. StanfordHarvardMIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you. They also have student discussion forums, homework/assignments, and online quizzes or exams.