I know most MBA aspirants have not scored good in CAT or any other entrance exam and then made their biggest mistake by joining any Tier 2 or Tier 3 college. But today I’m sharing strategy of one of my friend who skipped MBA and done this 1 course and now earning 17 lpa as his first salary.

Here is step by step Roadmap for you to follow:-

Phase 1: Foundation (Month 1–2)

What to learn?

• Excel basics: formulas (SUM, IF), sorting, filtering
• Data thinking:
  • What is a KPI?
  • Difference between data vs insights
• Basic statistics: mean, median, percentage change, trends

Best resources

• YouTube: “Excel for beginners full course” (any 6–8 hr video)
• Practice: download datasets from Kaggle

Projects 

1. Sales dashboard
   • Add: monthly growth %, top products, worst-performing category
2. Student analysis
   • Add: topper trends, subject-wise difficulty

Mistake to avoid

Most people just “learn Excel” and stop.
You need to think: what story is this data telling?

Phase 2: Core Skill Building (Month 3–5)

What to learn?

• Advanced Excel: Pivot Tables, XLOOKUP, dashboards
• SQL:
  • SELECT, WHERE, JOIN
  • GROUP BY, ORDER BY
• Power BI:
  • Charts, filters, storytelling dashboards

Best resources

• SQL: practice on platforms like LeetCode (easy level)
• Power BI: YouTube dashboard tutorials + replicate

Projects 

E-commerce Analysis

• Add: revenue trends, top cities, repeat customers
• Use SQL + Power BI

1. Customer Churn Analysis
   • Why are users leaving?
   • Show insights + recommendations
2. Marketing Campaign Analysis
   • ROI, cost per acquisition, best channel

Mistake to avoid

People copy projects from YouTube.
Recruiters instantly know.

Instead:

• Change dataset
• Add your own insights
• Write “recommendations”

Phase 3: Real-World Exposure (Month 6–8)

What to do

• Apply to 50+ internships (don’t wait for perfect skill)
• Offer free work to startups for 2–4 weeks
• Take messy, unclean data (this is real work)

Smart strategy

• Don’t say “I need internship”
• Say: “I analyzed your data, here’s what I found”

Output

• 2–3 internships (even small startups work)
• Real dashboards with business impact

Mistake to avoid

Waiting to become “perfect” before applying

Reality:
You learn faster after getting rejected

Phase 4: Portfolio + Branding (Month 9–10)

What to build?

• GitHub:
  • Upload projects with explanation (not just code)
• Portfolio (Notion is enough):
  • Problem → Analysis → Insights → Recommendations

LinkedIn strategy 

Post 3 times/week:

Examples:

• “I analyzed Swiggy data, here are 3 shocking insights”
• “This Power BI dashboard took me 5 hours, here’s what I learned”
• “SQL mistake beginners make”

Mistake to avoid

Silent learning

If no one knows your work,
it doesn’t exist in the job market.

Phase 5: Job Preparation (Month 11–12)

What to prepare?

SQL Questions

• Difference between WHERE vs HAVING
• Types of JOIN (INNER, LEFT, RIGHT)
• GROUP BY use cases
• Write queries on sales data

Excel Questions

• Pivot table use
• VLOOKUP vs XLOOKUP
• Data cleaning steps

Power BI Questions

• How you built dashboard
• Why you chose certain charts
• What insights you found

Case Study Questions

Example:
“Sales are dropping. What will you analyze?”

Your answer should include:

• Check trends
• Segment by region/product
• Identify problem area
• Suggest solution

Resume strategy

• Not “learned SQL”
• Write: “Analyzed 10,000+ rows of sales data and improved insights on revenue trends”

Application strategy

• 10–15 applications daily
• Focus on referrals
• Track in Excel sheet