Meta - Data Analysis with Spreadsheets and SQL
- Offered byCoursera
Data Analysis with Spreadsheets and SQL at Coursera Overview
Duration | 25 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Data Analysis with Spreadsheets and SQL at Coursera Highlights
- Earn a certificate of completion
- Add to your LinkedIn profile
- 31 assignments
Data Analysis with Spreadsheets and SQL at Coursera Course details
- 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 will 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.
Data Analysis with Spreadsheets and SQL at Coursera Curriculum
Working with Data in Spreadsheets
Introduction to the Program
Course Introduction Video
Instructor Introduction Video
Weekly Introduction
What are Spreadsheets and What Can They Do
Uses of Spreadsheets
Recap of the OSEMN Framework
The Use of Spreadsheets in Data Analysis
Weekly Review: Working with Data in Spreadsheets
Course Syllabus
Use of Google Sheets
How to be Successful in this Program
Commonly Used Spreadsheet Tools
OSEMN Framework Overview
Practice Quiz: Spreadsheet Fundamentals
Practice Quiz: The OSEMN Framework and Spreadsheets
Graded Quiz: Working with Data in Spreadsheets
Meet and Greet
Data Analysis with Spreadsheets
Weekly Introduction
Accessing and Labeling Data
Filtering and Sorting Data
Cleaning Data
Formatting Data
Introduction to Functions
Calculating a Total
The Average and Median Functions
Finding Minimum and Maximum Values
Evaluating Correlations
Compare Variables with Charts
Evaluating Trends
Inspecting Relationships between Variables
Modeling and Functions
Examples of Modeling Using Spreadsheets
Limitations of Spreadsheets for Modeling
Opening Spreadsheets (.csv, .xlsx) in Google Sheets
Summary: Data Analysis with Spreadsheets
Exercise: Scrubbing Data with Google Sheets
Activity: Exploring Data in Google Sheets
Exercise: Exploring Data Visually
Practice Quiz: Exploring Data Visually
Practice Quiz: Modeling Data with Spreadsheets
Graded Quiz: Data Analysis with Spreadsheets
Extracting Data with SQL
Introduction: Extracting Data with SQL
Why Use SQL
Examples: Using SQL
SQL in Google Sheets
SELECT Statements
AND, OR, and WHERE Clauses
ORDER BY and LIMIT Clauses
SQL Commands Walkthrough
Writing Functions in SQL
Arithmetic Functions
Aggregate Functions
Group by Functions
SQL Functions Walkthrough
Weekly Review: Extracting Data with SQL
Overview Important SQL Commands
Overview Important Functions in SQL
Practice the Select All Data Command
Practice AND, OR, and Where Clauses
Practice ORDER BY and LIMIT Clauses
Practice Quiz: Writing SQL Queries
Practice Arithmatic Functions
Practice Aggregate Functions
Practice Group by Functions
Graded Quiz: Extracting Data with SQL
Data Visualization
Introduction: Data Visualization
Why Visualization
Different Tools for Data Visualization
Introduction to Common Chart Types
Bar Charts
Pie Charts
Trend Charts
Scatter Plots
Walkthrough: Data Visualization in Google Sheets
Tableau Introduction
Connecting Data
Creating Your First Chart
Creating More Complex Charts in Tableau
New Video
Weekly Review: Data Visualization
Overview Common Chart Types
Download Tableau Public
Practice Quiz: Data Visualization
Practice Bar Charts
Practice Pie Charts
Practice Trend Lines
Practice Scatter Plots
Practice Quiz: Data Visualization in Google Sheets
Practice: Connecting Data
Practice: Creating Your First Chart
Practice: Creating More Complex Charts
Practice Quiz: Tableau
Graded Quiz: Data Visualization
Creating Dashboards
Introduction: Creating Dashboards
The Power of Dashboards
Dashboards and Business Goals
Designing a Dashboard
Building a Dashboard in Tableau
Adding Interactivity
Introduction: Storytelling with Data Visualizations
Case Study: Do's and Don'ts of Storytelling with Data Visualizations
Crafting a Story
Weekly Review: Creating Dashboards
Course Conclusion/Congratulations
New Reading
Practice Quiz: Summarizing Data with Dashboards
Exercise: Create a Dashboard
Graded Quiz: Creating Dashboards
Data Analysis with Spreadsheets
Data Analysis with Spreadsheets and SQL at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?