2‑Month “Final Arc” Sprint From beginner to job‑ready analyst

Data Quest – 2 Month Plan

Compressed from the full 1‑year roadmap: focus only on SQL, Python+pandas, Excel, BI dashboards and 2–3 serious projects so you become job‑ready as fast as possible if you stick to this every day. [file:1]

8 weeks • 3–5 hours / day • Daily quests
Tracks: Excel • SQL • Python • BI • Portfolio

Quest Log – Weeks 1‑4

Click a card when you finish that day
Daily routine

45–60 min: video / reading • 45–60 min: practice (platforms) • 60–90 min: project / exercises • 10–15 min: write 3 bullets in log. [file:1]

Core skills Project Review Light / rest
Week 1 – Foundation & Tools
Day 1 – Setup & Mindset
Core
3–4 hrs
  • Install VS Code, Python, Git, Jupyter / notebooks.
  • Set up folders, GitHub repo, and “Data Quest Log”.
  • Read what a junior data analyst actually does day‑to‑day.
Tools Planning
Day 2 – Excel Basics
Core
3 hrs
  • Practice SUM, AVERAGE, COUNT, IF on an expenses sheet.
  • Build a small expenses summary with charts.
Excel Mini dashboard
Day 3 – Excel Pro
Core
3–4 hrs
  • VLOOKUP/XLOOKUP, pivot tables, cleaning data.
  • Redo the expenses file with categories and months.
Excel+ Cleanup
Day 4 – SQL Intro
Core
3 hrs
  • Set up SQL playground (online or local DB).
  • Learn SELECT, WHERE, ORDER BY on 1–2 tables.
SQL
Day 5 – Joins
Core
3–4 hrs
  • Practice INNER/LEFT JOIN on sales/orders data.
  • Write at least 15 join queries with filters.
Joins
Day 6 – Recap
Review
2–3 hrs
  • Summarize Excel + SQL in your log as “moves/skills”.
  • Redo 10 queries and 2 Excel tasks from memory.
Review
Day 7 – Light Day
Rest
1–2 hrs
  • Watch 1–2 analyst project videos only.
  • Organize files and GitHub repo.
Light
Week 2 – SQL Deep Dive
Day 8 – Aggregations
Core
3–4 hrs
  • GROUP BY, HAVING, SUM/COUNT/AVG on sales data.
  • Answer “top customers”, “top categories”, “monthly trends”.
Aggregate Biz Q&A
Day 9 – Subqueries
Core
3 hrs
  • Subqueries in WHERE and FROM.
  • Write at least 10 subquery problems.
Subqueries
Day 10 – Window Functions
Core
3–4 hrs
  • ROW_NUMBER, RANK, running totals, moving averages.
  • Top 3 products per category, monthly running sales.
Windows
Day 11 – SQL Challenge
Project
3–4 hrs
  • Solve 20–30 problems on a SQL platform (HackerRank, LeetCode, etc.).
  • Write notes on the 3 most difficult questions.
Challenge
Day 12 – SQL Mini Case
Project
4 hrs
  • Pick one dataset (e‑commerce / FinTech style).
  • Create 15–20 questions, answer with queries and insights.
Case Study
Day 13 – Cleanup & GitHub
Review
2–3 hrs
  • Refactor queries, add comments, push to GitHub.
  • Update log with “SQL patterns I keep using”.
Review GitHub
Day 14 – Reset
Rest
1–2 hrs
  • Light SQL quizzes only; plan Python week.
Light
Weeks 3‑4 – Python & EDA

Week 3: Python basics, pandas, cleaning and EDA on at least 2 datasets. Week 4: Stats intuition + visualizations + 1 storytelling notebook you can show recruiters. [file:1]

Weeks 5‑8 – BI & Portfolio

Week 5: Power BI/Tableau basics + 2 dashboards. Week 6: End‑to‑end case study (SQL + Python + BI). Week 7: One more domain project (FinTech / real estate). Week 8: Interview prep, portfolio polishing, mock “case” presentations. [file:1]

Projects, Platforms & XP

Make it feel like a game, not homework
Flagship project ideas
Mobility Analytics “City Rides”
SQL + Python + BI • Trips, fares, zones, time‑of‑day.
  • Find most profitable time slots and areas.
  • Detect low‑utilization pockets and propose fixes.
  • Interactive dashboard with filters for time, area, vehicle.
E‑Commerce Control Room
Excel + SQL + BI • Orders, customers, products.
  • Track revenue, AOV, repeat rate, category performance.
  • Design a “control room” dashboard for leadership.
Real Estate Heatmap
Python + Viz • Prices, locations, features.
  • Find what drives price (area, location, amenities).
  • Build a heatmap / map dashboard for hot vs cold zones.
Game‑based practice platforms

Use each 20–30 minutes after main study so you always “end on a game”.

SQL Arenas
Daily puzzles to keep SQL sharp.
  • Any SQL challenge site: aim for 5–10 questions/day.
  • Focus on joins, aggregations, window functions early.
Set your SQL arena
Python Dojo
Short katas to fix syntax in your muscle memory.
  • Use coding challenge sites with XP/streak system.
  • Focus on loops, functions, lists/dicts in Week 3.
Set your Python dojo
Dashboard Sprints
90‑minute “from raw CSV to dashboard” runs.
  • Weekly: pick dataset, build a simple dashboard against the clock.
  • Score yourself on clarity of KPIs and design.
XP bar (manual)

Each finished day = +1 XP. When you click cards, imagine this bar filling.