When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Certificate?

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.

Data Analysis with Spreadsheets and SQL

Data Analysis with Spreadsheets and SQL

This course is part of multiple programs.

Instructor: Brandon Larkin

34,792 already enrolled

Included with

Learn more

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

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

33 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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.

Module details

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

Graded Quiz: Working with Data in Spreadsheets40 minutes
Review Your Community Knowledge10 minutes
Practice Quiz: Spreadsheet Fundamentals20 minutes
Practice Quiz: The OSEMN Framework and Spreadsheets15 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

Graded Quiz: Data Analysis with Spreadsheets50 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

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

Graded Quiz: Extracting Data with SQL50 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

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

Graded Quiz: Data Visualization50 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

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.