Data Analysis with Spreadsheets and SQL (Coursera)

Offered by Meta,
Data Analysis with Spreadsheets and SQL (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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 course is part of the Meta Marketing Analytics Professional Certificate.

Syllabus

Working with Data in Spreadsheets
Module 1
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.

Data Analysis with Spreadsheets
Module 2
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.

Extracting Data with SQL
Module 3
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.

Data Visualization
Module 4
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.

Creating Dashboards
Module 5
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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Python Data Visualization (Coursera) Coursera
Rice University

Python Data Visualization (Coursera)

This if the final course in the specialization which builds upon the knowledge learned in Python Programming Essentials, Python Data Representations, and Python Data Analysis. We will learn how to install external packages for use within Python, acquire data from sources on the Web, and then we will clean, process, analyze, and visualize that data. This course will combine the skills learned throughout the specialization to enable you to write interesting, practical, and useful programs.

Oct 2nd 2026
4 Weeks
HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera) Coursera
Columbia University

HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera)

HI-FIVE (Health Informatics For Innovation, Value & Enrichment) Training is an approximately 10-hour online course designed by Columbia University in 2016, with sponsorship from the Office of the National Coordinator for Health Information Technology (ONC). The training is role-based and uses case scenarios. No additional hardware or software are required for this course. Our nation’s healthcare system is changing at a rapid pace.

Sep 28th 2026
4 Weeks
Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera) Coursera
Rice University

Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera)

Confidence intervals and Hypothesis tests are very important tools in the Business Statistics toolbox. A mastery over these topics will help enhance your business decision making and allow you to understand and measure the extent of ‘risk’ or ‘uncertainty’ in various business processes. This course advances your knowledge about Business Statistics by introducing you to Confidence Intervals and Hypothesis Testing. These are done by easy to understand applications.

Oct 5th 2026
4 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Oct 5th 2026
5-12 Weeks
Python and Statistics for Financial Analysis (Coursera) Coursera
The Hong Kong University of Science and Technology - HKUST

Python and Statistics for Financial Analysis (Coursera)

Python is now becoming the number 1 programming language for data science. Due to python’s simplicity and high readability, it is gaining its importance in the financial industry. The course combines both python coding and statistical concepts and applies into analyzing financial data, such as stock data.

Oct 5th 2026
4 Weeks
3D Data Visualization for Science Communication (Coursera) Coursera
University of Illinois at Urbana-Champaign

3D Data Visualization for Science Communication (Coursera)

This course is an introduction to 3D scientific data visualization, with an emphasis on science communication and cinematic design for appealing to broad audiences. You will develop visualization literacy, through being able to interpret/analyze (read) visualizations and create (write) your own visualizations.

Oct 5th 2026
4 Weeks
Data intelligence for businesses and managers (Coursera) Coursera
Institut Mines-Telecom

Data intelligence for businesses and managers (Coursera)

With the proliferation of connected objects (computers, tablets, watches, etc.), huge masses of data are generated every second. This Big Data has led to the emergence of a data economy, where data is the main source of competitive advantage for companies. In this sense, data and its processing tools have become a strategic priority for companies, and the main gas pedal of their digital transformation.

Oct 5th 2026
5-12 Weeks
Healthcare Information Design and Visualizations (Coursera) Coursera
Northeastern University

Healthcare Information Design and Visualizations (Coursera)

Introduces processes and design principles for creating meaningful displays of information that support effective business decision-making. Studies how to collect and process data; create visualizations (both static and interactive); and use them to provide insight into a problem, situation, or opportunity. Introduces methods to critique visualizations along with ways to answer the elusive question: “What makes a visualization effective?”

Oct 5th 2026
4 Weeks
Population Health: Responsible Data Analysis (Coursera) Coursera
Leiden University

Population Health: Responsible Data Analysis (Coursera)

In most areas of health, data is being used to make important decisions. As a health population manager, you will have the opportunity to use data to answer interesting questions. In this course, we will discuss data analysis from a responsible perspective, which will help you to extract useful information from data and enlarge your knowledge about specific aspects of interest of the population.

Oct 5th 2026
4 Weeks
Practical Time Series Analysis (Coursera) Coursera
The State University of New York

Practical Time Series Analysis (Coursera)

Many of us are "accidental" data analysts. We trained in the sciences, business, or engineering and then found ourselves confronted with data for which we have no formal analytic training. This course is designed for people with some technical competencies who would like more than a "cookbook" approach, but who still need to concentrate on the routine sorts of presentation and analysis that deepen the understanding of our professional topics.

Oct 5th 2026
5-12 Weeks
Excel/VBA for Creative Problem Solving, Part 2 (Coursera) Coursera
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 2 (Coursera)

Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Oct 5th 2026
4 Weeks
Population Health: Predictive Analytics (Coursera) Coursera
Leiden University

Population Health: Predictive Analytics (Coursera)

Predictive analytics has a longstanding tradition in medicine. Developing better prediction models is a critical step in the pursuit of improved health care: we need these tools to guide our decision-making on preventive measures, and individualized treatments. In order to effectively use and develop these models, we must understand them better. In this course, you will learn how to make accurate prediction tools, and how to assess their validity. First, we will discuss the role of predictive analytics for prevention, diagnosis, and effectiveness. Then, we look at key concepts such as study design, sample size and overfitting.

Sep 28th 2026
4 Weeks