Jake Wang
Blog
MyTesla
MyLife
GitHub
Blog
SQL, Python, and ML notes for data analysts.
Excel
Git
Machine Learning
Python
SQL
Statistics
Visualization
2026-06-13
How to Design Metrics and Diagnose Drops
2026-06-13
SQL INSERT, UPDATE & DDL for Analysts
2026-06-13
Time Series for Analysts: Trend to Forecast
2026-06-13
K-means Clustering for Customer Segmentation
2026-06-13
Python venv & Project Setup for Analysts
2026-06-13
Regex for Analysts: Python, Pandas & SQL
2026-06-13
Git Basics for Data Analysts
2026-04-25
RFM Segmentation with SQL & Python
2026-04-25
Statistics for Analysts: Testing & A/B Tests
2026-04-25
NumPy Cheat Sheet for Data Analysts
2026-04-25
scikit-learn Workflow for Data Analysts
2026-04-25
How to Choose the Right Chart for Your Data
2026-04-25
Advanced SQL: Windows, CTEs & Tuning
2026-04-25
Data Analyst Learning Path: What to Learn First
2026-04-25
How to Choose the Right Machine Learning Model
2026-04-25
Power BI for Analysts: Modeling, DAX & Visuals
2026-04-25
Excel for Analysts: Formulas & Pivot Tables
2026-04-25
Matplotlib & Seaborn Cheat Sheet for Analysts
2026-04-24
Pandas Cheat Sheet for Data Analysts
2026-04-24
SQL Patterns for Analysts & Interviews
2026-03-06
SQL Cheat Sheet for Data Analysts