Working with Data in Spreadsheets-Introduction to the Program
Introduction to the Program
()
Course Introduction Video
()
Instructor Introduction Video
()
Course Syllabus
Use of Google Sheets
How to be Successful in this Program
Working with Data in Spreadsheets-Spreadsheet Fundamentals
Weekly Introduction
()
What are Spreadsheets and What Can They Do
()
Uses of Spreadsheets
()
Commonly Used Spreadsheet Tools
Working with Data in Spreadsheets-The OSEMN Framework and Spreadsheets
Recap of the OSEMN Framework
()
The Use of Spreadsheets in Data Analysis
()
OSEMN Framework Overview
Weekly Review: Working with Data in Spreadsheets
()
Data Analysis with Spreadsheets-Scrubbing Data
Weekly Introduction
()
Accessing and Labeling Data
()
Opening Spreadsheets (.csv, .xlsx) in Google Sheets
Filtering and Sorting Data
()
Cleaning Data
()
Formatting Data
()
Data Analysis with Spreadsheets-Exploring Data
Introduction to Functions
()
Calculating a Total
()
The Average and Median Functions
()
Finding Minimum and Maximum Values
()
Evaluating Correlations
()
Data Analysis with Spreadsheets-Exploring Data Visually
Compare Variables with Charts
()
Evaluating Trends
()
Inspecting Relationships between Variables
()
Data Analysis with Spreadsheets-Modeling Data with Spreadsheets
Modeling and Functions
()
Examples of Modeling Using Spreadsheets
()
Limitations of Spreadsheets for Modeling
()
Summary: Data Analysis with Spreadsheets
Extracting Data with SQL-SQL Fundamentals
Introduction: Extracting Data with SQL
()
Why Use SQL
()
Examples: Using SQL
()
SQL in Google Sheets
()
Extracting Data with SQL-Writing SQL Queries
SELECT Statements
()
AND, OR, and WHERE Clauses
()
ORDER BY and LIMIT Clauses
()
SQL Commands Walkthrough
()
Overview Important SQL Commands
Extracting Data with SQL-Functions in SQL
Writing Functions in SQL
()
Arithmetic Functions
()
Aggregate Functions
()
Group by Functions
()
SQL Functions Walkthrough
()
Overview Important Functions in SQL
Weekly Review: Extracting Data with SQL
()
Data Visualization-The Power of Data Visualization
Introduction: Data Visualization
()
Why Visualization
()
Different Tools for Data Visualization
()
Introduction to Common Chart Types
()
Overview Common Chart Types
Data Visualization-Data Visualization in Google Sheets
Bar Charts
()
Pie Charts
()
Trend Charts
()
Scatter Plots
()
Walkthrough: Data Visualization in Google Sheets
()
Data Visualization-Data Visualization with Tableau
Tableau Introduction
()
Download Tableau Public
Connecting Data
()
Creating Your First Chart
()
Creating More Complex Charts in Tableau
()
Weekly Review: Data Visualization
()
Creating Dashboards-Summarizing Data with Dashboards
Introduction: Creating Dashboards
()
The Power of Dashboards
()
Dashboards and Business Goals
()
Creating Dashboards-Creating Dashboards with Tableau
Designing a Dashboard
()
Building a Dashboard in Tableau
()
Adding Interactivity
()
Creating Dashboards-Storytelling with Data Visualization
Introduction: Storytelling with Data Visualizations
()
Case Study: Do's and Don'ts of Storytelling with Data Visualizations
()
Crafting a Story
()
Weekly Review: Creating Dashboards
()
Creating Dashboards-In Practice: Data Analysis with Spreadsheets
Course Conclusion/Congratulations
()