📊
CareerBecome a Data Analyst in 12 Weeks
SQL + Excel + Python + Tableau, plus 2 case-study projects and job-ready portfolio.
12 weeks10 hours/wkbeginner
Want this personalized to YOU?
Get a plan adapted to your level, schedule and goal — free.
🎯 Goal
Land a junior data analyst role in 12 weeks.
🧠 Skill Breakdown
- SQL
- Spreadsheet mastery
- Python for analysis
- BI dashboards
- Storytelling with data
📅 Curriculum Plan
Week 1: Excel/Sheets foundations
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 2: SQL basics
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 3: SQL advanced
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 4: Python basics
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 5: EDA in Python
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 6: Stats refresher
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 7: Tableau or Power BI
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 8: Case study #1
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 9: Storytelling
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 10: Case study #2
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 11: Portfolio site
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
Week 12: Job hunt
- Objective: One concept per week.
- Practical Tasks:
- Tutorial sprint
- Real exercise
- Apply to dataset
- Expected Outcome: Reusable artifact.
🚀 Final Project
Two portfolio case studies (report + dashboard) + a live portfolio site.
📚 Books & Long-Form Reading
- A canonical book or course in this field
👥 Communities to Join
- Active subreddit, Discord or forum for this topic
🔁 Progress Tracking
- Weekly self-check questions and a clear "ready to move on" criterion
Ready to start your own?
Mentora will tailor this exact path to your level and schedule in seconds.
Get my personalized plan