Data Analysis Cookbook: Master Data Analysis with SQL and Pandas

Data Analysis Cookbook: Master Data Analysis with SQL and Pandas

Should you learn SQL or Python for data analysis? The answer is "both." This Cookbook teaches you to solve the same problems in two ways: SQL (BigQuery) and Pandas.

Curriculum Overview

SQL Track (BigQuery)

• Sales analysis with date/time functions
• Category performance with GROUP BY
• NULL handling and data cleaning
• Ranking and trend analysis with Window functions
• CTE and cohort analysis
• Product analysis with string functions
• Table combinations with JOIN

Pandas Track (Python)

• Data loading and exploration
• Data cleaning and preprocessing
• Advanced filtering techniques
• Grouping and aggregation
• Data merging and joining
• Date/time data handling
• Pivot and data restructuring

Common Sections

• Visualization: Matplotlib, Seaborn, Plotly
• Statistics: Hypothesis testing, correlation, regression, A/B testing
• ML Intro: Clustering, classification, regression, time series, recommendation systems

Key Features

• Live interactive dashboards (E-Commerce, Finance)
• Real-world projects: CS/Operations, Marketing Strategy
• 85 interview prep problems
• Free sample data (BigQuery thelook_ecommerce)
• Bilingual support (Korean/English)

Who Is This For?

• Aspiring data analysts
• Those deciding between SQL and Python
• Learners wanting practice with real data
• Anyone preparing for analytics interviews

Get Started

Build your core data analysis skills with this free Cookbook.

Go to Data Analysis Cookbook