Learn SQL, Python, SAS, R, Excel & dbt
the way analysts actually use them
Real-world scenarios · Step-by-step explanations · Hands-on challenges
From beginner to advanced — at your own pace.
SQL
SELECT, JOINs, GROUP BY, Window Functions, CTEs, and analytical query patterns used at every data-driven company.
Python
pandas DataFrames, data cleaning, groupby, merging, pivot tables, visualization, and statistical analysis.
SAS
DATA step, PROC procedures, formats, PROC SQL, macro programming, and statistical procedures for enterprise analytics.
R
Vectors, data frames, dplyr/tidyr/ggplot2, joins, strings, dates, linear & logistic regression, purrr, and reproducible analysis.
Excel
XLOOKUP, SUMIFS, dynamic arrays, Pivot Tables, Power Query, named ranges, advanced charting, LAMBDA, and What-If Analysis for analysts.
dbt
Transform raw warehouse data into analytics-ready models using SQL + Jinja. Sources, tests, documentation, macros, and CI/CD for analytics engineers.
How Every Lesson Works
Real Scenario
Each lesson starts with a workplace scenario — the kind of request your manager would actually make.
Learn the Concept
Clear theory + terminology definitions before you write a single line of code.
Step-by-Step Code
Follow a guided walkthrough. SQL runs live in your browser against a real database.
Solve the Challenge
Apply what you've learned, use hints if needed, then reveal the solution and explanation.