Data Analysis with Spreadsheets and SQL

Data Analysis with Spreadsheets and SQL

This course is part of multiple programs.

Instructor: Brandon Larkin

35,956 already enrolled

Included with

5 modules

Gain insight into a topic and learn the fundamentals.

292 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

91%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

292 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

91%

Most learners liked this course

What you'll learn

Clean data with spreadsheets and use common spreadsheet formulas to calculate summary statistics
Write foundational SQL statements and queries to extract data in spreadsheets
Create charts in Google Sheets and use Tableau to visualize data and use dashboards to create data visualizations

Skills you'll gain

Category: Marketing Analytics
Category: Data Visualization
Category: Data Wrangling
Category: Data Analysis
Category: Exploratory Data Analysis
Category: Data Manipulation
Category: Data Storytelling
Category: Correlation Analysis
Category: SQL
Category: Data Cleansing
Category: Statistical Analysis
Category: Tableau Software
Category: Descriptive Statistics
Category: Spreadsheet Software
Category: Analysis
Category: Data Visualization Software
Category: Dashboard Creation

Tools you'll learn

Category: Dashboard
Category: Google Sheets
Category: Query Languages

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

33 assignments

Taught in English

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Meta

There are 5 modules in this course

This course introduces you to how to use spreadsheets and SQL queries to analyze and extract data. You will learn how to practically apply the OSEMN data analysis framework and spreadsheet functions to clean data, calculate summary statistics, evaluate correlations, and more. You’ll also dive into common data visualization techniques and learn how to use dashboards to tell a story with your data.

By the end of this course you will be able to: • Clean data with spreadsheets • Use common spreadsheet formulas to calculate summary statistics • Identify data trends and patterns • Write foundational SQL statements and queries to extract data in spreadsheets • Create charts in Google Sheets and use Tableau to visualize data • Use dashboards to create data visualizations You don't need marketing or data analysis experience, but should have basic internet navigation skills and be eager to participate. Ideally you have already completed course 1: Marketing Analytics Foundation and course 2: Introduction to Data Analytics in this program.

This week you learn the basics of spreadsheets and their usefulness in data analysis. You will also identify how to apply the OSEMN framework when working with data in spreadsheets.

What's included

9 videos6 readings4 assignments

9 videosTotal 25 minutes

Introduction to the Program6 minutes
Course Introduction Video3 minutes
Instructor Introduction Video2 minutes
Weekly Introduction1 minute
What are Spreadsheets and What Can They Do3 minutes
Uses of Spreadsheets5 minutes
Recap of the OSEMN Framework3 minutes
The Use of Spreadsheets in Data Analysis4 minutes
Weekly Review: Working with Data in Spreadsheets1 minute

6 readingsTotal 70 minutes

Course Syllabus5 minutes
Join the Meta Marketing Analytics Community or the Meta Data Analyst Community!10 minutes
Use of Google Sheets10 minutes
How to be Successful in this Program10 minutes
Commonly Used Spreadsheet Tools30 minutes
OSEMN Framework Overview5 minutes

4 assignmentsTotal 85 minutes

Review Your Community Knowledge10 minutes
Practice Quiz: Spreadsheet Fundamentals20 minutes
Practice Quiz: The OSEMN Framework and Spreadsheets15 minutes
Graded Quiz: Working with Data in Spreadsheets40 minutes

This week you will learn how to clean data in spreadsheets using foundational spreadsheet functions. You will also learn how to calculate summary statistics in spreadsheets as well as how to identify data trends and relationships between variables.

What's included

16 videos2 readings6 assignments

16 videosTotal 59 minutes

Weekly Introduction1 minute
Accessing and Labeling Data3 minutes
Filtering and Sorting Data6 minutes
Cleaning Data4 minutes
Formatting Data3 minutes
Introduction to Functions2 minutes
Calculating a Total4 minutes
The Average and Median Functions5 minutes
Finding Minimum and Maximum Values2 minutes
Evaluating Correlations4 minutes
Compare Variables with Charts7 minutes
Evaluating Trends3 minutes
Inspecting Relationships between Variables2 minutes
Modeling and Functions5 minutes
Examples of Modeling Using Spreadsheets4 minutes
Limitations of Spreadsheets for Modeling4 minutes

2 readingsTotal 40 minutes

Opening Spreadsheets (.csv, .xlsx) in Google Sheets30 minutes
Summary: Data Analysis with Spreadsheets10 minutes

6 assignmentsTotal 250 minutes

Exercise: Scrubbing Data with Google Sheets60 minutes
Activity: Exploring Data in Google Sheets30 minutes
Exercise: Exploring Data Visually60 minutes
Practice Quiz: Exploring Data Visually25 minutes
Practice Quiz: Modeling Data with Spreadsheets25 minutes
Graded Quiz: Data Analysis with Spreadsheets50 minutes

This week you will be introduced to SQL and how it is used in spreadsheets. You will utilize basic queries and functions for handling data with SQL.

What's included

14 videos2 readings8 assignments

14 videosTotal 46 minutes

Introduction: Extracting Data with SQL1 minute
Why Use SQL4 minutes
Examples: Using SQL2 minutes
SQL in Google Sheets2 minutes
SELECT Statements3 minutes
AND, OR, and WHERE Clauses4 minutes
ORDER BY and LIMIT Clauses3 minutes
SQL Commands Walkthrough5 minutes
Writing Functions in SQL2 minutes
Arithmetic Functions5 minutes
Aggregate Functions6 minutes
Group by Functions4 minutes
SQL Functions Walkthrough5 minutes
Weekly Review: Extracting Data with SQL1 minute

2 readingsTotal 25 minutes

Overview Important SQL Commands10 minutes
Overview Important Functions in SQL15 minutes

8 assignmentsTotal 275 minutes

Practice the Select All Data Command30 minutes
Practice AND, OR, and Where Clauses30 minutes
Practice ORDER BY and LIMIT Clauses30 minutes
Practice Quiz: Writing SQL Queries25 minutes
Practice Arithmetic Functions40 minutes
Practice Aggregate Functions30 minutes
Practice Group by Functions40 minutes
Graded Quiz: Extracting Data with SQL50 minutes

This week you will learn about common chart types and how to determine the best type of chart for the dataset you want to present. You will also learn how to create these charts using both Google Sheets and Tableau.

What's included

15 videos2 readings11 assignments

15 videosTotal 58 minutes

Introduction: Data Visualization1 minute
Why Visualization2 minutes
Different Tools for Data Visualization2 minutes
Introduction to Common Chart Types7 minutes
Bar Charts4 minutes
Pie Charts2 minutes
Trend Charts4 minutes
Scatter Plots4 minutes
Walkthrough: Data Visualization in Google Sheets5 minutes
Tableau Introduction6 minutes
Connecting Data7 minutes
Creating Your First Chart5 minutes
Creating More Complex Charts in Tableau4 minutes
Walkthrough: Data Visualization in Tableau4 minutes
Weekly Review: Data Visualization1 minute

2 readingsTotal 30 minutes

Overview Common Chart Types10 minutes
Download Tableau Public20 minutes

11 assignmentsTotal 350 minutes

Practice Quiz: Data Visualization25 minutes
Practice Bar Charts30 minutes
Practice Pie Charts30 minutes
Practice Trend Lines30 minutes
Practice Scatter Plots30 minutes
Practice Quiz: Data Visualization in Google Sheets25 minutes
Practice: Connecting Data30 minutes
Practice: Creating Your First Chart 40 minutes
Practice: Creating More Complex Charts40 minutes
Practice Quiz: Tableau20 minutes
Graded Quiz: Data Visualization50 minutes

In the final week you will be introduced to dashboards and how to use them to report on progress within a business setting. You will also learn how to create dashboards in Tableau and use these to tell a story when presenting your data findings.

What's included

11 videos4 assignments1 discussion prompt

11 videosTotal 43 minutes

Introduction: Creating Dashboards1 minute
The Power of Dashboards2 minutes
Dashboards and Business Goals2 minutes
Designing a Dashboard4 minutes
Building a Dashboard in Tableau7 minutes
Adding Interactivity8 minutes
Introduction: Storytelling with Data Visualizations3 minutes
Case Study: Do's and Don'ts of Storytelling with Data Visualizations5 minutes
Crafting a Story6 minutes
Weekly Review: Creating Dashboards1 minute
Course Conclusion/Congratulations2 minutes

4 assignmentsTotal 200 minutes

Practice Quiz: Summarizing Data with Dashboards15 minutes
Activity: Create a Dashboard45 minutes
Comprehensive Activity: Data Analysis with Spreadsheets90 minutes
Graded Quiz: Creating Dashboards50 minutes

1 discussion promptTotal 10 minutes

Share Your Thoughts!10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(76 ratings)

Brandon Larkin

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
75.42%
4 stars
16.72%
3 stars
2.73%
2 stars
2.73%
1 star
2.38%

Showing 3 of 292

Reviewed on Aug 29, 2024

Very informative and very punctual. As someone who has ADHD, i managed to finish the course with a 91%!

Reviewed on Nov 24, 2025

This course helped me with concepts I wasn't aware of and the explanations are pretty good. Thanks

Reviewed on May 23, 2024

there are a few errors in the materials here and there, but overall the course is a good foundation

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.