We may earn an affiliate commission when you visit our partners.

Creating New BigQuery Datasets and Visualizing Insights

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

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

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

Course Summary

Summary of the course ley learning points

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches intermediate SQL, a skillset used across data science, data analysis, and business intelligence

Instructors are from Google Cloud Training, which has experience with the subject matter

Part of a series, providing potential for comprehensive learning

May require learners to come in with some SQL experience

Save this course

Save Creating New BigQuery Datasets and Visualizing Insights to your list so you can find it easily later:

Save

Reviews summary

Big query basics for data visualization

learners say this course is a useful introduction to using BigQuery to visualize insights. They remark on the hands-on nature of the course and appreciate the provided labs where they can practice new skills. Some learners mention that they had some difficulty with the outdated labs and differing UI between the course videos and actual product, but overall, this course is well-received for its informative and easy-to-understand content.

Supplemental datasets and exercises

"It taught me, however, that my knowledege of SQL, especially regarding partition tables, wasn´t as good as desired."

Reinforce concepts

"Hands-on experience"

"5 of my QwikLabs were generated error message when I tried to open the tool."

Easy-to-understand explanations

"The explanation is easy to understand, and provided step by step."

"While I think the course is excellent and labs reinforce key concepts"

Outdated and different versions of tools

"The labs are with an older version of BQ/Data Studio which is sometimes confusing"

"Many discrepancies between labs, real products and solution videos."

"Visualization lab didn't match with the actual solution that was posted."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Creating New BigQuery Datasets and Visualizing Insights with these activities:

Review the course materials on SQL JOINs and UNIONs

Show steps

Reviewing the course materials on SQL JOINs and UNIONs will help solidify your understanding of these concepts before moving on to more advanced topics.

Browse courses on SQL

Show steps

Reread the course notes on SQL JOINs and UNIONs.
Review the examples provided in the course materials.

Create a cheat sheet of SQL JOINs and UNIONs

Show steps

Creating a cheat sheet will serve as a handy reference for the syntax and usage of SQL JOINs and UNIONs, making it easier to apply these concepts in your future work.

Browse courses on SQL

Show steps

Gather information about SQL JOINs and UNIONs.
Create a document or spreadsheet to use as a cheat sheet.
Add the information you gathered to your cheat sheet.

Join a study group and discuss SQL JOINs and UNIONs

Show steps

Joining a study group and discussing SQL JOINs and UNIONs will allow you to learn from others and get feedback on your understanding.

Browse courses on SQL

Show steps

Find a study group to join.
Attend the study group meetings.
Participate in the discussions about SQL JOINs and UNIONs.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Follow a tutorial on SQL JOINs and UNIONs

Show steps

Following a tutorial on SQL JOINs and UNIONs will help you solidify your understanding of these concepts and how to use them effectively.

Browse courses on SQL

Show steps

Find a tutorial on SQL JOINs and UNIONs.
Follow the steps in the tutorial.
Try out the JOINs and UNIONs you learned in the tutorial on your own data.

Practice writing SQL queries using JOINs and UNIONs

Show steps

Practicing writing SQL queries using JOINs and UNIONs will help you improve your proficiency in these skills.

Browse courses on SQL

Show steps

Find a dataset to practice on.
Write a series of SQL queries using JOINs and UNIONs to extract and combine data from the dataset.
Review your queries and make sure they are correct.

Practice writing SQL queries using JOINs and UNIONs

Show steps

Practicing writing SQL queries using JOINs and UNIONs will help you improve your proficiency in these skills.

Browse courses on SQL

Show steps

Find a dataset to practice on.
Write a series of SQL queries using JOINs and UNIONs to extract and combine data from the dataset.
Review your queries and make sure they are correct.

Create a BigQuery dashboard

Show steps

Creating a BigQuery dashboard will allow you to practice your data visualization skills and gain a deeper understanding of the data you are working with.

Browse courses on Data Visualization

Show steps

Connect to your BigQuery dataset.
Create a new dashboard.
Add charts and graphs to your dashboard.
Share your dashboard with others.

Create a BigQuery dashboard

Show steps

Creating a BigQuery dashboard will allow you to practice your data visualization skills and gain a deeper understanding of the data you are working with.

Browse courses on Data Visualization

Show steps

Connect to your BigQuery dataset.
Create a new dashboard.
Add charts and graphs to your dashboard.
Share your dashboard with others.

Career center

Learners who complete Creating New BigQuery Datasets and Visualizing Insights will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst helps companies make informed decisions by collecting, analyzing, and visualizing data. This course can help you develop the technical skills needed to succeed in this role, such as SQL, data visualization, and data ingestion. Additionally, the course will help you understand the business context of data analysis, which is essential for communicating your findings effectively.

See salaries and explore the career path for Data Analyst

Business Analyst

A Business Analyst helps organizations improve their performance by analyzing business processes and identifying areas for improvement. This course can help you develop the analytical and problem-solving skills needed to succeed in this role. Additionally, the course will help you understand how to use data to make informed decisions.

See salaries and explore the career path for Business Analyst

Data Engineer

A Data Engineer designs and builds the systems that store and process data. This course can help you develop the technical skills needed to succeed in this role, such as data modeling, data integration, and data warehousing. Additionally, the course will help you understand the business context of data engineering, which is essential for communicating your findings effectively.

See salaries and explore the career path for Data Engineer

Data Scientist

A Data Scientist uses data to solve complex business problems. This course can help you develop the technical skills needed to succeed in this role, such as machine learning, statistics, and data visualization. Additionally, the course will help you understand the business context of data science, which is essential for communicating your findings effectively.

See salaries and explore the career path for Data Scientist

Data Visualization Specialist

A Data Visualization Specialist creates visual representations of data to help others understand complex information. This course can help you develop the technical skills needed to succeed in this role, such as data visualization, data storytelling, and data exploration. Additionally, the course will help you understand the business context of data visualization, which is essential for communicating your findings effectively.

See salaries and explore the career path for Data Visualization Specialist

Information Architect

An Information Architect designs and organizes information systems. This course can help you develop the technical skills needed to succeed in this role, such as data modeling, information retrieval, and information governance. Additionally, the course will help you understand the business context of information architecture, which is essential for communicating your findings effectively.

See salaries and explore the career path for Information Architect

Database Administrator

A Database Administrator manages and maintains databases. This course can help you develop the technical skills needed to succeed in this role, such as database design, database optimization, and database security. Additionally, the course will help you understand the business context of database administration, which is essential for communicating your findings effectively.

See salaries and explore the career path for Database Administrator

Software Engineer

A Software Engineer designs, develops, and maintains software applications. This course may be useful in helping you develop the technical skills needed to succeed in this role, such as data structures, algorithms, and software design. Additionally, the course will help you understand the business context of software engineering, which is essential for communicating your findings effectively.

See salaries and explore the career path for Software Engineer

Financial Analyst

A Financial Analyst analyzes financial data to make investment recommendations. This course may be useful in helping you develop the technical skills needed to succeed in this role, such as financial modeling, data analysis, and risk management. Additionally, the course will help you understand the business context of financial analysis, which is essential for communicating your findings effectively.

See salaries and explore the career path for Financial Analyst

Product Manager

A Product Manager manages the development and launch of new products. This course may be useful in helping you develop the business skills needed to succeed in this role, such as product planning, market research, and customer relationship management. Additionally, the course will help you understand the technical aspects of product management, which is essential for communicating with engineers and other stakeholders.

See salaries and explore the career path for Product Manager

Operations Manager

An Operations Manager plans and executes operational processes. This course may be useful in helping you develop the business skills needed to succeed in this role, such as process improvement, supply chain management, and quality control. Additionally, the course will help you understand the technical aspects of operations management, such as data analysis and project management, which is essential for communicating with operations teams and other stakeholders.

See salaries and explore the career path for Operations Manager

Marketing Manager

A Marketing Manager plans and executes marketing campaigns. This course may be useful in helping you develop the business skills needed to succeed in this role, such as market research, customer segmentation, and campaign management. Additionally, the course will help you understand the technical aspects of marketing, such as data analysis and digital marketing, which is essential for communicating with marketing teams and other stakeholders.

See salaries and explore the career path for Marketing Manager

Sales Manager

A Sales Manager leads and manages a sales team. This course may be useful in helping you develop the business skills needed to succeed in this role, such as sales strategy, customer relationship management, and team management. Additionally, the course will help you understand the technical aspects of sales, such as data analysis and CRM systems, which is essential for communicating with sales teams and other stakeholders.

See salaries and explore the career path for Sales Manager

Project Manager

A Project Manager plans and executes projects. This course may be useful in helping you develop the business skills needed to succeed in this role, such as project planning, risk management, and stakeholder management. Additionally, the course will help you understand the technical aspects of project management, such as data analysis and project management software, which is essential for communicating with project teams and other stakeholders.

See salaries and explore the career path for Project Manager

Consultant

A Consultant provides professional advice to clients. This course may be useful in helping you develop the business skills needed to succeed in this role, such as problem solving, communication, and client relationship management. Additionally, the course will help you understand the technical aspects of consulting, such as data analysis and project management, which is essential for communicating with clients and other stakeholders.

See salaries and explore the career path for Consultant

Reading list

We've selected ten books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Creating New BigQuery Datasets and Visualizing Insights.

Google BigQuery: The Definitive Guide

Save

Provides a comprehensive overview of BigQuery, including its architecture, features, and best practices. It valuable resource for anyone who wants to learn more about BigQuery and how to use it effectively.

Creating New BigQuery Datasets and Visualizing Insights

What's inside

Syllabus

Good to know

Save this course

Reviews summary

Big query basics for data visualization

Activities

Career center

Reading list

Share

Similar courses