Common Rejection Reasons in NCR (Freshers):
1. Only course certificates, no working projects
2. Python known in theory, not used on real datasets
3. Weak SQL - cannot write JOINs under pressure
4. No statistics clarity (mean vs median, p-value, correlation)
5. Copied Kaggle notebooks that cannot be explained
6. Applying for "Data Scientist" with zero analyst basics
7. No idea about the company's business or data

What Actually Gets Freshers Hired:
- 2-3 self-built projects with real, messy data
- Clean SQL and Python fundamentals
- Ability to explain a model in simple business words
- One dashboard (Power BI / Tableau) recruiters can open
- Internship, live project or freelance work experience
- Realistic role targeting: Analyst first, Scientist later
- Consistent applications + referrals on LinkedIn

NCR Fresher Skill Checklist:
Python  : read messy CSV, clean nulls, groupby, merge, plot
SQL     : INNER/LEFT JOIN, aggregation, ranking, date filters
Stats   : mean vs median, variance, correlation, A/B basics
ML      : linear & logistic regression, decision tree, KNN
          train-test split, accuracy / precision / recall / RMSE
BI      : one clean Power BI or Tableau dashboard
Excel   : pivot tables, lookups, conditional formatting
Extra   : Git basics, clear README, simple documentation

Frequently Asked in NCR Fresher Interviews:
- Explain your project end to end in 2 minutes
- Difference between supervised and unsupervised learning
- How do you handle missing values? Why that method?
- What is overfitting and how did you check for it?
- Write a SQL query for top 3 products per region
- Mean vs median - when would you prefer median?
- Which metric would you use for an imbalanced dataset?
- If the model is 95% accurate, is it good? Why or why not?

Which Company Should a Fresher Target First?

If your strength is SQL + Excel + reporting
  → IT services, BPO analytics, MIS roles (Noida)

If your strength is Python + statistics + ML
  → product startups, fintech, healthtech (Gurugram)

If your strength is business thinking + storytelling
  → consulting and analytics firms

If you want structure, training and process
  → MNC GCC centres and large enterprises

Rule: start where your strongest skill is the main requirement.

Realistic Entry Titles in Delhi-NCR:
- Data Analyst / Junior Data Analyst
- Business Analyst (analytics focused)
- MIS Executive / Reporting Analyst
- BI Developer (entry level)
- Analytics Associate / Research Analyst
- Data Science Intern / Trainee
- Junior Data Scientist (after 1-2 years, usually)

Most "Data Scientist" openings ask for experience.
Entry happens through analyst and intern roles.

A Strong NCR Fresher Portfolio (3 Projects):

1. Analytics project (SQL + Power BI)
   Sales or operations data, KPI dashboard, clear insights

2. Machine learning project (Python)
   Churn / price / demand prediction with proper evaluation

3. Domain or local-data project
   Delhi-NCR relevant data: transport, air quality,
   e-commerce delivery, retail footfall

Each project needs:
- README explaining problem, data, method, result
- Clean, commented code
- One screenshot or live dashboard link

How Freshers Build "Experience" in NCR:
- Paid or unpaid internships (3-6 months)
- Live projects during training programmes
- Freelance analytics work for small businesses
- Open-source contributions and data communities
- College research or capstone with real datasets
- Volunteer dashboards for NGOs and local startups

Six months of real work beats six certificates.

90-Day Plan for Delhi-NCR Freshers:

Month 1 - Build the base
- Python: pandas, numpy, cleaning, plotting
- SQL: joins, aggregation, window functions
- Statistics: descriptive stats, distributions, testing

Month 2 - Build proof
- Project 1: SQL + Power BI analytics dashboard
- Project 2: Python ML model with proper evaluation
- Write README files and push everything to GitHub

Month 3 - Go to market
- Rewrite resume around projects and metrics
- Optimise LinkedIn for "Data Analyst Delhi NCR"
- Apply daily: Naukri, LinkedIn, company career pages
- Ask for referrals; attend NCR data meetups
- Do 2 mock interviews and fix weak answers

Helpful Resources:

Free:
- Public datasets (government open data, Kaggle, UCI)
- SQL practice platforms with interview-style problems
- Power BI / Tableau public galleries for dashboard ideas

Paid / Structured:
- Uncodemy - Data Science & Machine Learning using Python
- Uncodemy - Data Analytics Training Course (Noida)
- Mock interviews, resume and portfolio review sessions

Job Platforms for NCR:
- Naukri, LinkedIn, Internshala, AngelList-style startup boards
- Company career pages in Noida Sector 62/63 and Gurugram
- Referrals from alumni and training batch peers