Data Analysis with Spreadsheets and SQL
About 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.
68/100
CourseAsk score
- What the provider tells you
- 32/45
- Who stands behind it
- 20/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- clean data with spreadsheets
- calculate summary statistics using spreadsheet formulas
- identify data trends and patterns
- write basic SQL statements to extract data
- create visualizations using Google Sheets and Tableau
- use dashboards for data storytelling
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Udemy
Coursera
Compared on these lists
Where this course ranks against the alternatives.