📚 180-Day Free Roadmap to Become a Job-Ready Data Analyst
This roadmap is designed for aspirants with zero experience, focusing on free learning paths, projects, interview prep, and tools that are widely accepted in the industry.
🎯 GOAL:
To become a job-ready Data Analyst (Entry-Level) within 6 months using only free resources.
🔧 TOOLS & SKILLS YOU WILL MASTER:
| Tool | Description |
|---|
| SQL | Querying databases, joins, aggregations |
| Python | Pandas, NumPy, Matplotlib, Seaborn |
| Excel | Pivot tables, charts, functions |
| Tableau Public | Dashboards, visual storytelling |
| Power BI | Interactive reports, DAX |
| Git/GitHub | Version control, portfolio building |
✅ PHASE-WISE ROADMAP (Free Resources Only)
| Phase | Duration | Focus Area | Goals |
|---|
| Phase 1 | Day 1–30 | Basics + SQL + Excel | Learn SQL, Excel, and basics of data analysis |
| Phase 2 | Day 31–60 | Python + Stats | Learn Python, Pandas, basic stats |
| Phase 3 | Day 61–90 | Visualization + EDA | Master visualization tools (Tableau/Power BI), EDA |
| Phase 4 | Day 91–120 | Projects + GitHub | Build 3–5 real-world projects |
| Phase 5 | Day 121–150 | Interview Prep | DSA (SQL, Python), MCQs, Case Studies |
| Phase 6 | Day 151–180 | Mock Interviews + Hackathons | Final polish, mock interviews, hackathons |
🔢 DAY-BY-DAY PLAN (FREE RESOURCES ONLY)
🟩 PHASE 1: BASICS + SQL + EXCEL (Day 1 – Day 30)
| Day | Topic | Activities | Free Resources |
|---|
| 1-3 | Intro to DA | What is DA? Roles, Responsibilities | Google Data Analytics Certificate - Free |
| 4-7 | Excel Basics | VLOOKUP, INDEX-MATCH, Pivot Tables | Excel Exposure, YouTube Tutorials |
| 8-10 | Intermediate Excel | Charts, Conditional Formatting | Same as above |
| 11-15 | SQL Basics | SELECT, WHERE, GROUP BY, ORDER BY | Mode SQL Tutorial, W3Schools SQL |
| 16-20 | SQL Joins & Subqueries | INNER JOIN, LEFT JOIN, Nested Queries | Mode SQL, LeetCode Easy |
| 21-25 | SQL Aggregations & Window Functions | SUM, AVG, COUNT, RANK(), ROW_NUMBER() | Mode SQL, HackerRank |
| 26-30 | Practice SQL + Excel | Solve 20+ SQL problems, build dashboard in Excel | LeetCode, HackerRank, Kaggle datasets |
🟦 PHASE 2: PYTHON + STATISTICS (Day 31 – Day 60)
| Day | Topic | Activities | Free Resources |
|---|
| 31-35 | Python Basics | Variables, Loops, Functions | Python for Everybody - Coursera |
| 36-40 | Numpy & Pandas | Arrays, Series, DataFrame | Kaggle Python Course |
| 41-45 | Data Cleaning | Missing Values, Outliers | Kaggle Intro to ML |
| 46-50 | Descriptive Statistics | Mean, Median, Variance, SD | Statistics How To |
| 51-55 | Inferential Statistics | Hypothesis Testing, p-value, CLT | Kaggle Intro to Statistics |
| 56-60 | Correlation, Regression | Scatter Plots, Linear Reg | Towards Data Science - Regression |
🟨 PHASE 3: VISUALIZATION + EDA (Day 61 – Day 90)
🟥 PHASE 4: PROJECTS + GITHUB (Day 91 – Day 120)
| Day | Topic | Activities | Free Resources |
|---|
| 91-95 | Project 1: Sales Analysis | Analyze sales trends, create dashboard | Use Walmart/Superstore dataset |
| 96-100 | Project 2: Customer Segmentation | RFM, Clustering | Mall Customers Dataset |
| 101-105 | Project 3: HR Attrition Analysis | Predict churn, visualize attrition factors | IBM HR Dataset |
| 106-110 | Project 4: Stock Market Trends | Visualize stock trends | Yahoo Finance API |
| 111-115 | Build GitHub Portfolio | Upload all code and dashboards | GitHub Pages, README.md |
| 116-120 | Resume Building | Add Projects, Skills, Certifications | Canva Templates (Free), LinkedIn Profile |
🟪 PHASE 5: INTERVIEW PREP (Day 121 – Day 150)
| Day | Topic | Activities | Free Resources |
|---|
| 121-125 | SQL Interview Questions | Solve 50+ questions | LeetCode SQL, StrataScratch |
| 126-130 | Python Interview Questions | Pandas, Numpy, Strings | HackerRank, LeetCode |
| 131-135 | MCQs & Aptitude | Statistics, Probability, Business Cases | Indiabix, PrepInsta |
| 136-140 | Case Studies | Revenue Drop, User Growth | Case in Point PDF (Free), ProductX |
| 141-145 | Behavioral Interview | STAR Method, Tell me about yourself | YouTube videos, Glassdoor |
| 146-150 | Mock Interviews | Record and analyze responses | Pramp, Peer groups, Zoom recordings |
🟫 PHASE 6: FINAL POLISH (Day 151 – Day 180)
| Day | Topic | Activities | Free Resources |
|---|
| 151-155 | Hackathon Participation | Join Kaggle/Tableau/ML hackathons | Kaggle Competitions |
| 156-160 | Apply Jobs | LinkedIn, Indeed, Glassdoor, AngelList | Update resume, apply daily |
| 161-165 | Debugging Errors | Fix project issues, improve dashboard | Review feedback |
| 166-170 | Soft Skills & Communication | Improve presentation skills | TED Talks, Toastmasters (Free online sessions) |
| 171-175 | Final Revision | All topics, notes, interview prep | Your own notes, flashcards |
| 176-180 | Full Mock Tests | Simulate full interview rounds | Take 3 full-length mocks |
📌 BONUS: YOUR JOB APPLICATION CHECKLIST
✅ Completed 3–5 projects
✅ GitHub profile with clean documentation
✅ Updated LinkedIn profile with keywords
✅ Tailored resume for each application
✅ Mock interviews recorded and reviewed
✅ Applied to at least 10 jobs per week
✅ Attended at least 2 hackathons
✅ Practiced 100+ SQL & Python questions
✅ Read blogs/books on analytics and communication
📝 TIPS FOR SUCCESS:
- Stick to a schedule: Wake up early, set daily goals.
- Build a GitHub profile: Showcase all your work.
- Document everything: Write blogs on Towards Data Science or Medium.
- Apply every day: Don’t wait until Day 180 to start applying.
- Track progress: Use Notion or Excel to track your daily tasks.