Data Analysis with Spreadsheets and SQL

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 spreadsh

• 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