Teacher since April 2026
Lin Zhao
Data cleaning, SQL, exploratory analysis and honest charts
9
tutors built
4.5Sample
average from 22 reviews
427Sample
lessons taught by their tutors
About Lin
I teach the part of data science that takes most of the time: getting data into a shape you can trust, querying it, exploring it and showing it honestly. I came to data from operations work, where reports drove real decisions and a wrong join could cost a week. I teach by handing you small, deliberately messy tables and asking what is wrong with them. I like checklists, plain SQL and simple charts, and I am suspicious of any analysis that skips looking at the raw rows. I enjoy helping spreadsheet users make the step into proper analysis.
Knows about
Tutors by Lin
9 tutors
SQL for Analysis: First Queries
Write SQL that answers real questions, and check that the answer is right96 lessonsSampleLin ZhaoFreeFeature Engineering for Tabular DataFeature Engineering for Tabular Data
Create features that help models learn, without leaking the answer72 lessonsSampleLin Zhao$7SQL Window Functions and CohortsSQL Window Functions and Cohorts
Rank, compare and track users over time with window functions and clean CTEs61 lessonsSampleLin Zhao$6Metric Definitions That Hold UpMetric Definitions That Hold Up
Define metrics precisely so every dashboard and team means the same thing54 lessonsSampleLin Zhao$6From Spreadsheets to Data AnalysisFrom Spreadsheets to Data Analysis
Bring your spreadsheet skills into structured, repeatable data analysis50 lessonsSampleLin Zhao$3Data Cleaning FundamentalsData Cleaning Fundamentals
Turn a messy table into data you can trust, with every change written down49 lessonsSampleLin Zhao$4Charts That Tell the TruthCharts That Tell the Truth
Choose, build and critique charts that show data honestly and clearly45 lessonsSampleLin Zhao$4Messy Real World DataMessy Real World Data
Handle time zones, dirty join keys, shifting definitions and late data like a seasoned analystLin Zhao$7Exploratory Data Analysis Step by StepExploratory Data Analysis Step by Step
Explore a new dataset with a clear routine and turn what you notice into testable questionsLin Zhao$4Recent reviews
What students said about Lin's tutors.
- Rashid A.Sample
Good beginner course. The row count checks saved me from sharing a wrong report.
- Gustavo L.Sample
We found four different definitions of active user across our dashboards. The specification template fixed months of arguments.
- Annika S.Sample
Great time window aggregates lesson. The cyclical encoding trick was simple and useful.
- Precious M.Sample
I can now build retention tables without exporting to spreadsheets. Clear and precise.
- Valentina B.Sample
I'm a marketer and can now pull my own campaign numbers. The fan out lesson explained a mistake I had made for months.
- Karim J.Sample
Out of fold target encoding explained clearly at last. My validation scores dropped a bit but now match production.