Projects
Start with a beginner project and work up. Each one runs in your browser, with checks that tell you when it works.
These lessons are not a second catalog or a video course, and this tab cannot publish a repo for you. Passing every LakeBench lesson means you can write the transforms, the DAG habits, the tests, and the design argument. It does not publish a repo. The Cloud capstone is a numbered GCP free-tier checklist this tab cannot execute. Do those steps outside, then copy the solutions you wrote, add a README that states grain, schedule, and failure modes, and push that.
Incremental Spark MERGE, a simulated night job, dbt-shaped staging and tests, and a publish suite.
Data Analysis & Metrics
ANALYTICSCompute executive subscription health metrics in SQL: Monthly Recurring Revenue (MRR), ARPU, and subscriber churn percentage.
CV: “Engineered executive SaaS KPI scorecard queries in SQL calculating auditable MRR, ARPU, and churn for Series-B due diligence.”
Data Analysis & Metrics
ANALYTICSPerform two-sample hypothesis testing in Python evaluating conversion rates, relative uplift, z-scores, and p-values.
CV: “Authored statistical experimentation frameworks in Python conducting two-sample z-tests and power analysis to validate feature rollouts.”
Data Analysis & Metrics
ANALYTICSDecompose quarterly top-line revenue variances into volume, price, and mix effects using Pandas dataframes.
CV: “Built multi-factor revenue waterfall bridge algorithms in Pandas decomposing top-line sales growth into volume and price drivers.”
Data Analysis & Metrics
ANALYTICSModel customer spend decay curves and project 36-month cumulative Customer Lifetime Value (LTV) using Pandas.
CV: “Modeled longitudinal customer retention decay curves in Python/Pandas projecting 3-year LTV to optimize digital marketing CAC budgets.”
Bigger projects you build over a few weeks on your own laptop. Each one comes with a week plan, starter code, viva questions with model answers and a resume line, so you can present it with confidence.
Intermediate · 5 weeks
Turn a raw sales file into a star schema and a dashboard a manager can read.
Open the planBeginner friendly · 4 weeks
Pull data from a public API every day, load it safely, and chart it.
Open the planBeginner friendly · 3 weeks
Clean messy student records and show placement rates by branch, skill and company.
Open the planBeginner friendly · 3 weeks
Check every new file against rules and send a clear pass or fail report.
Open the planIntermediate · 4 weeks
Spot unusual payments with SQL window functions and show them on a simple report.
Open the planIntermediate · 5 weeks
Turn a stream of page-view events into sessions, funnels and a daily report.
Open the planSame grain fights, in the studio.
The 12 to 18 month path that sequences these is on the roadmap.
