Become a data analyst in 30 days? A realistic plan (free Notion template)
No, you won't be a senior analyst in a month. But 30 days is enough to go from zero to three shipped projects and a portfolio that gets interviews moving. Here is the honest day-by-day plan, with a free Notion template to run it.
Search "become a data analyst in 30 days" and you get two kinds of answers: courses promising a career change by Friday, and gatekeepers telling you it takes five years. Both are wrong. Thirty days will not make you a senior analyst, but it is genuinely enough to build the thing that starts careers: a portfolio of real analysis work.
This plan is the Data Analyst track of our free 30 Days of Data Notion template. One focused session a day, 60 to 90 minutes, and by day 30 you have three shipped projects and a published portfolio.
What you can honestly achieve in 30 days
That is not "job-ready senior analyst". It is "person who demonstrably does analysis instead of just watching videos about it", which is the bar most entry-level applicants never clear. If you want the longer view of the role itself, read a day in the life of a data analyst and the full data analyst roadmap.
The 30-day plan, week by week
- Days 1-3
SQL basics, for real this time
Start with the free SQL Foundations intro course, about an hour total, exercises included. If SELECT, WHERE and GROUP BY are already comfortable, skim it and move on.
- Days 4-10
SQL e-commerce analysis
Ship your first project: analyzing an e-commerce dataset in PostgreSQL. Guided version on D8A with the dataset provided, or solo with Kaggle's Olist Brazilian E-Commerce dataset. Finish it, push it to GitHub, write a clear README.
- Days 11-18
Python for data analysis
A full pandas exploration notebook: cleaning, aggregations, visualizations, and written conclusions. Solo alternative: the NYC Airbnb open dataset. Day 17 is the day you push through the hard part instead of quietly quitting; every project has one.
- Day 19
Portfolio v1 goes live
Two projects online with their stories: the problem, your approach, what you found. On D8A the portfolio page builds itself from validated projects; solo, a pinned-repos GitHub profile works.
- Days 22-26
DuckDB analytics on local data
Modern local analytics on parquet files, fast and increasingly common in real teams. Solo alternative: NYC Taxi trip data with DuckDB.
- Days 27-30
Polish, publish, share
The recruiter test on day 28: a stranger should get your value in 60 seconds. Publish on day 29, share it on LinkedIn with #30DaysOfData, and run your retro on day 30.
The two ways to run each project
Every project in the template has two options. Option A is guided on D8A Academy: dataset provided, stepped brief, GitHub validation, portfolio page generated for you. The intro course is free. Option B is solo: the Kaggle datasets named above, scope defined by you. Option A exists because the single biggest killer of self-taught portfolios is not difficulty, it is ambiguity: not knowing what "done" looks like. If you already know how to scope your own work, option B is excellent too, and costs nothing.
Need project inspiration beyond the challenge? We keep a list of data analyst portfolio project ideas that hiring managers actually respond to.
Start tonight, not Monday
The template's day 0 takes ten minutes: pick the DA path, pick your mode, filter the project library, block your daily slot. The plan only works through daily repetition, and daily repetition only works if starting is trivial. Duplicate the template and make today day 0.
