The 30-day Data Analyst ramp-up
Week-by-week plan from SQL basics to your first portfolio project.
- W1
Master SELECT, WHERE, GROUP BY, and the seven JOIN patterns
Practice on a single clean dataset until you can write 20 queries from memory.
- W2
Window functions (ROW_NUMBER, RANK, LAG/LEAD, running totals)
These show up in 80% of real interviews.
- W3
Pick one BI tool (Tableau, Looker, or Power BI) and rebuild the same dashboard three times: a finance KPI tracker, a marketing funnel, and a product retention view.
- W4
Take a public dataset and produce a written insight memo: question, method, finding, recommendation. One page max. This becomes your portfolio piece. Skip Python, R, and ML on the first pass. Strong SQL + one BI tool + clear writing lands the first job.
Finished this lesson? Save your progress.