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

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.

All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid until March 12, 2027

Save 40% Off 3 Months

Access thousands of top-rated learning programs with a Coursera Plus monthly subscription and take 40% off 3 months for a limited time.

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

Traffic lights

Read about what's good

what should give you pause

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

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Bigquery data loading and looker studio

According to learners, this course provides a practical introduction to key tasks like ingesting external data into BigQuery and performing data visualization using Looker Studio. Students found the hands-on labs particularly valuable for reinforcing concepts. While many appreciated the coverage of core BigQuery operations, feedback on the SQL section is mixed; some found it clear and helpful, especially the unique BigQuery aspects, others felt it was too basic or lacked depth, especially for more experienced users or those without prior SQL knowledge. Some reviewers noted technical issues with labs as a point of friction. Overall, it's considered a good foundation for working with BigQuery data and Looker Studio.

Effectively shows visualizing data with Looker Studio.

"Connecting BigQuery data to Looker Studio was demonstrated effectively, making visualization easy."

"The Looker Studio module was the most straightforward and immediately applicable part for me."

"I appreciated learning how to build dashboards from the data I processed in BigQuery."

"Visualization with Looker Studio tied the data processing steps together nicely."

Covers loading and handling data in BigQuery well.

"The section on ingesting new datasets into BigQuery was clearly explained and very useful."

"I learned exactly how to load external data, which was a primary goal for me."

"Understanding how to get different data sources into BigQuery is a key takeaway."

"The course does a good job of explaining the process for creating new datasets."

Focuses on applying skills with hands-on labs.

"The hands-on labs in this course are very practical and helped solidify my understanding of the concepts."

"I really enjoyed the exercises that guided me through loading data and connecting it to Looker Studio."

"This course provided practical, real-world examples that I can apply immediately to my work."

"The labs were useful for practicing the steps of data ingestion and visualization."

Some students faced problems with the lab environment.

"I encountered several technical glitches trying to get the labs to work, which was frustrating."

"The instructions for setting up the lab environment could be clearer to avoid issues."

"Some labs were not loading correctly, which prevented me from completing the exercises as intended."

"Getting the necessary permissions for the labs took extra troubleshooting time for me."

SQL coverage is mixed - basic for some, unclear for others.

"The SQL joins explanation felt a bit rushed and wasn't clear enough for someone not already familiar with different join types."

"I found the SQL concepts covered to be quite basic; I was hoping for more advanced BigQuery SQL techniques."

"Requires prior SQL knowledge to fully follow the section on joining and merging datasets."

"Some BigQuery-specific SQL syntax points were helpful, but the core SQL was a bit light."

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

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

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

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

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

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

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

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

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

Here's a deal for you

What's inside

Syllabus

Traffic lights

Save this course

Reviews summary

Bigquery data loading and looker studio

Activities

Career center

Reading list

Share

Similar courses

Coursera Buyer Protection & Guarantee

7-Day Free Trial & Free Audit

14-Day Refund Guarantee

Verified Academic & Industry Partner