SQL for Exploratory Data Analysis Essential Training

Learn how to use SQL to understand the characteristics of data sets destined for data science and machine learning.

Introduction

• Welcome
• What you should know

1. Introduction to Exploratory Data Analysis

• Why explore data?
• Exploring data with statistics
• Testing hypothesis with statistics

2. Data Quality Checks

• Why check data?
• Types of quality checks
• Imputing missing values
• Identifying business logic checks

3. Calculating Quartiles

• Why learn about the distribution of data?
• Minimum, maximum, and median values
• Ordering and counting
• Calculating quartiles
• Introduction to box plots

4. Histograms

• Introduction to histograms
• Partitioning data
• Calculating histograms
• Simple histogram visualization

5. Checking Correlation between Attributes

• Introduction to correlation
• Calculating correlation with SQL

Conclusion

• Next steps