Introduction

• What is EDA?
• Why EDA?
• Data Visualization
• Iterative Process
• Case Study: Problem
• Case Study: Hypothesis Formulation
• Case Study: Data Analysis
• Case Study: Data Visualization

Data Transformation

• Data Tables
• Tidy Data
• Pivot / Unpivot
• Common Data types
• Data Transformation
• Exercise Guide
• Excel Interface
• Keyboard Shortcuts
• Formula Syntax & Name Range
• Reference Types
• IF / IFS / Nested IF
• AND / OR
• SWITCH
• Information Functions
• LEN / TRIM
• LEFT / RIGHT / MID
• UPPER / LOWER / PROPER
• REPLACE / SUBSTITUTE
• Flash Fill
• SEARCH
• Combining Text
• Splitting Text to Columns
• Date Value
• Create Date
• Date Elements
• Date Calculation
• INDEX / MATCH
• VLOOKUP / HLOOKUP
• Limitations of LOOKUP Functions
• Dynamic Array Formulas
• VLOOKUP with Array / XLOOKUP
• Importing Data from CSV
• Importing Data from HTML
• Power Query
• Excel Table

Analyzing One Variable

• Analyzing a Numerical Variable
• Mean vs. Median
• Spread
• Distribution
• Outliers
• Summarizing Data
• Conditional COUNT / SUM / AVERAGE
• Dynamic Array Calculation
• Filtering Rows
• FILTER / SORT / SORTBY
• Visualizing Distributions
• Histogram
• Robust Statistics
• Categorical Data
• Frequency Table
• Frequency Table with PivotTables
• Data Binning
• Visualizing Comparison, Composition
• Bar Chart / Pie Chart

Analyzing Multiple Variables

• Analyzing Two Variables
• Correlation
• Scatter Plot
• Exploring Numerical x Numerical
• Contingency Table
• Heat Map
• Exploring Categorical x Categorical
• Categorical x Numerical
• Values and Dimensions
• Visualizing Comparison, Composition
• Exploring Categorical x Continuous
• Visualizing Time-Series
• Exploring Time Series
• Exploring Multiple Variables

Understanding Data

• Unit of Analysis
• Correlation & Causation

Basic Concepts

• Relational Databases
• SQL Command Overview
• Table Schema
• Data Types
• Which Data Type?
• Solutions
• Google BigQuery

Querying Data

• Getting Set Up
• SELECT one column
• SELECT multiple columns
• SELECT all columns
• SELECT with a column alias using AS
• SELECT without FROM
• SELECT a specific value as a column
• ORDER BY, LIMIT
• SELECT a limited number of rows
• SELECT distinct values in a column
• SELECT distinct combinations of fields
• Sort rows by a column
• Sort rows by a column in descending order
• Sort rows by multiple columns
• Select the 3 top-grossing movies from the list
• Selection criteria
• Use WHERE clause to filter data based on boolean expression
• Comparison Operators

Data Transformation

• Arithmetic Calculations
• Perform a calculation on one column
• Perform a calculation on multiple columns
• Dividing Numbers
• Mathematical Functions
• Rounding Numbers
• Type Casting
• Dates and Times
• Date and Time Conversion
• Date Functions
• Date Formatting
• Datetime Functions
• String Functions
• Conditional Expressions

Aggregating Data

• Aggregate Functions
• Summarizing Tables
• More Aggregrate Functions
• GROUP BY
• GROUP BY Multiple Dimensions
• GROUP BY One Column
• Filtering
• Filtering Rows
• Filtering Groups
• GROUP BY Conditional Expressions
• Grouping Sets
• GROUP in Summary

Combining Tables

• Working with multiple tables
• Joining Tables
• Types of Joins
• INNER JOIN
• LEFT/RIGHT (OUTER) JOIN
• FULL JOIN
• Join Syntax
• INNER JOIN
• Sequences of JOINs
• Order of Execution
• Complex Queries
• Subqueries

Table Schema