EDA using SQL (Case Study)

🔍 EDA using SQL: A Visual Case Study

Most people jump straight into dashboards and ML models without ever properly exploring their data. That's where insights get missed.

This 5-page visual case study walks you through Exploratory Data Analysis (EDA) entirely in SQL ~ no Python, no pandas, just clean queries that work.

What's inside:

✅ Data Profiling ~ row counts, null detection, distinct values

✅ Distributions & Stats ~ MIN, MAX, AVG, STDDEV, percentiles

✅ Outlier Detection ~ Z-score and IQR methods with examples

✅ Trend Analysis ~ DATE_TRUNC + window functions

✅ Quick Cheatsheet ~ all key queries in one reference sheet

Perfect for:

→ Data Analysts & aspiring Data Scientists

→ SQL learners who want real-world technique

→ Anyone prepping for data interviews

Download. Save. Use it every time you touch a new dataset.