Business Analytics Career Options for Students in Delhi NCR

What moves a Delhi NCR analytics fresher
up the salary band:

✓ Strong SQL (window functions, not just SELECT)
✓ Power BI or Tableau with real portfolio dashboards
✓ Python for analysis and automation
✓ Business framing in projects, not just charts
✓ Internship or live project experience
✓ Communication skill — presenting to stakeholders
✓ Domain knowledge (banking, retail, healthcare)

Company type:
• IT services / BPO analytics: lower band
• Consulting (Big 4): mid-upper band
• GCCs and BFSI captives: upper band
• Product companies: upper band + stock

Typical jump after 1–2 years:
• Move from services to GCC/product
• +30–60% salary
• Skill and portfolio driven

What does NOT reliably increase your offer:

✗ Additional certifications with no project
✗ Excel-only skill sets
✗ A long list of tools you cannot discuss
✗ Course count on the resume
✗ A degree with no applied portfolio
✗ "I'm a fast learner" as a differentiator

Why these fail:
The hiring manager is looking for evidence
that you can answer a business question with
data. Anything that does not prove that adds
very little to a fresher resume.

What actually works for freshers:
• One strong portfolio project (dashboard
  with a real business question)
• Ability to explain decisions, not just
  charts
• Clear SQL and one BI tool
• Some Python for analysis
• Real communication skills

That combination typically moves a fresher
from the ₹4 LPA end of the range to ₹7–8 LPA
in Delhi NCR — and makes them competitive
for product and consulting roles too.

SQL depth — the difference that matters:

ENTRY LEVEL (every fresher has this)
SELECT region, SUM(sales)
FROM orders
WHERE year = 2026
GROUP BY region;

UPPER BAND (fewer freshers have this)
WITH monthly AS (
  SELECT
    region,
    DATE_TRUNC('month', order_date) AS month,
    SUM(amount) AS revenue
  FROM orders
  WHERE order_date >= '2026-01-01'
  GROUP BY region, month
)
SELECT
  region,
  month,
  revenue,
  LAG(revenue) OVER (
    PARTITION BY region
    ORDER BY month
  ) AS prev_month,
  ROUND(
    (revenue - LAG(revenue) OVER (
      PARTITION BY region
      ORDER BY month
    )) * 100.0
    / NULLIF(LAG(revenue) OVER (
      PARTITION BY region
      ORDER BY month
    ), 0),
    2
  ) AS mom_growth_pct
FROM monthly
ORDER BY region, month;

What this shows the interviewer:
✓ You can structure multi-step queries
✓ You understand window functions
✓ You can handle division by zero
✓ You think about trend and growth,
  not just totals

That difference often moves a fresher from
the ₹4 LPA band to the ₹6–7 LPA band.

Business framing — the difference in
how you present an analysis:

WEAK PRESENTATION
"I built a sales dashboard. Revenue by
region. Top products. Monthly trend."

Why it is weak:
• It lists charts
• It says nothing about decisions
• The hiring manager learns nothing about
  your thinking

STRONG PRESENTATION
"I was asked why Q3 revenue growth had
slowed. I found that while overall revenue
grew 6%, one region (West) had actually
declined 4% — masked by strong growth in
the North. Within West, the decline was
driven by a single product line, where a
pricing change in July reduced repeat
purchases. I recommended reversing the
pricing change for that product line only.

What changed: The recommendation was
accepted, and the next month showed a 3%
recovery in the West region."

Why this works:
✓ Names the business question
✓ Shows the analytical path
✓ States the specific finding
✓ Connects insight to a decision
✓ Includes the outcome

This is what "business framing" means.
It is also the skill that most technical
candidates lack.

90-Day Business Analytics Plan — Student:

7:00 AM — Wake up, exercise (30 min)
8:00 AM — Review goals for the day
9:00 AM — Learning block (2 hours)
   - Weeks 1–3: SQL
   - Weeks 4–6: Power BI / Tableau
   - Weeks 7–8: Python pandas
   - Weeks 9–10: Statistics + framing
   - Weeks 11–12: Portfolio + applications
11:00 AM — Practice block (2 hours)
   Query real datasets, build dashboards
1:00 PM — Lunch break
2:00 PM — Portfolio project work
5:00 PM — Review progress, plan tomorrow
6:00 PM — Exercise, rest
8:00 PM — Read analytics blogs / case studies (30 min)
10:00 PM — Wind down

Where to practise:
• Kaggle datasets (real, messy data)
• Public government datasets (data.gov.in)
• Any e-commerce or fintech dataset
  from Kaggle with meaningful business
  questions

Weekly Checkpoints:

Week 3: SQL
□ Can I write joins confidently?
□ Do I understand GROUP BY and window
  functions?
□ Can I answer a business question in
  one query?

Week 6: BI tool
□ Do I have a dashboard on real data?
□ Does it answer a business question,
  not just show numbers?
□ Have I documented the decisions?

Week 8: Python
□ Can I load, clean and analyse a
  dataset in pandas?
□ Can I reproduce my dashboard
  analysis in Python?

Week 10: Framing
□ Can I write an analysis narrative
  from question to recommendation?
□ Do I understand a basic A/B test?

Week 12: Job search
□ Is my portfolio project on GitHub
  or a public BI link?
□ Have I applied to 25 analyst roles
  in Delhi NCR?
□ Can I explain every design decision
  in my dashboard?