Data Analysis Cookbook: Master Data Analysis with SQL and Pandas
SOTAAZ·
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.