Data Science Career Roadmap for Freshers
A stage-by-stage data science roadmap for freshers in India: statistics, Python, SQL, exploratory analysis, modelling and first roles.
Part of the Data Science track: modules, projects and first roles →
By the GullyMentor team · 7 min read · Published 2026-10-18 · Updated 2026-11-01 · Sources listed at the end. Not a promise about mentorship outcomes.
Begin with questions, data quality and statistical reasoning. Data Science includes modelling, but many valuable investigations first require careful exploration and a clear understanding of what the data represents.
This roadmap is for students, freshers and working professionals in India who search for a data science path and find mostly tool lists. It is organised in stages. Each has what to practise, one free resource and a check for when to move on.
Stage 0: Prerequisites
Practise Python functions, tables and plots. Review probability, distributions, averages and variation. Learn to describe a sample and the population you hope to understand.
Add SQL early. Most data in Indian companies sits in databases, and the first task in many analyst roles is writing a query, not training a model. Learn SELECT, WHERE, GROUP BY, JOIN and simple aggregates.
Use a small fictional delivery dataset. Calculate typical delivery time and inspect the distribution. A mean alone may hide a small number of very long delays.
- Practise: load, filter, group and plot in pandas; write the same summaries in SQL.
- Free resource: Kaggle Learn's Python, Pandas and Intro to SQL courses, and Khan Academy's statistics and probability lessons.
- Ready to move on when: you can answer a descriptive question two ways, in pandas and in SQL, and get the same number.
Stage 1: Foundations, exploratory analysis
Check row meaning, missingness, impossible values and observation periods. Compare distributions across meaningful groups and write down questions raised by each plot.
Keep observations separate from explanations. A difference between two delivery zones does not establish why the difference exists.
Learn to make plain, honest plots: a histogram, a box plot, a line over time, a bar chart with a labelled axis. Every plot gets a caption that says what the reader should notice.
- Practise: a full exploratory notebook on one dataset with at least five plots and a list of questions you cannot yet answer.
- Free resource: the pandas getting started tutorials and Kaggle Learn's Data Visualization course.
- Ready to move on when: you can show a plot that changed your mind about the data.
Stage 2: First project, statistical judgement
Study sampling, uncertainty, confounding and experimental design alongside examples. Ask how the collection process could distort a result. Records from only completed deliveries may exclude the most problematic cases.
Learn confidence intervals and hypothesis tests well enough to use them and to say what they do not tell you. Learn why a large sample does not fix a biased one. Practise writing a finding with its uncertainty and its alternative explanations in the same paragraph.
- Practise: a short investigation that explains the evidence, alternative interpretations and missing information, written for a manager who has five minutes.
- Free resource: OpenIntro Statistics, a free textbook with exercises, and freeCodeCamp's Data Analysis with Python for practice.
- Ready to move on when: you can explain selection bias with an example from your own data rather than from a textbook.
Stage 3: Depth, adding models when the question needs them
For a prediction task, define the target, available inputs, baseline and evaluation split. For a descriptive question, a model may add complexity without helping.
Compare a simple approach first. Record transformations and experiments so another person can reproduce the result. Keep final evaluation data separate from model selection.
Depth here also means communication. Learn to write a one-page memo with a recommendation, the evidence, the limitation and what you would check next. Learn to build a simple dashboard or a clean set of charts for people who will never open your notebook. Learn enough Git to version your work.
- Practise: one project with a prediction component and one that deliberately has none, each with a memo.
- Free resource: Microsoft's Data Science for Beginners for a structured revision of the whole process.
- Ready to move on when: your notebook runs from a fresh restart and your memo makes sense to someone who has not seen the notebook.
Stage 4: Interview readiness
Prepare one investigation to discuss in depth: the question, the data and its limits, what you found, what you could not establish and what changed your mind. Expect questions on mean versus median, selection bias, correlation versus causation, when to build a model, and how you make work reproducible. Expect a SQL exercise. Our data science interview questions guide has practice prompts.
- Practise: present the investigation in five minutes, then take hostile questions.
- Ready to move on when: you can state your main finding and its main weakness in the same breath.
Realistic first roles in India
Most people who later hold Data Scientist titles started somewhere else. For freshers in India the realistic first roles are data analyst, business analyst, reporting or MIS analyst, analytics associate, research analyst, and junior roles in product or marketing analytics. These roles use SQL, spreadsheets, dashboards and exploratory analysis every day, and they teach you how data is actually collected and misused in an organisation.
Data Scientist titles usually follow a year or more of such experience, or a postgraduate degree with a research component. Working professionals often move into analysis within their own domain first, where their knowledge of the business is an advantage. Use job descriptions to identify further preparation; avoid treating a course duration as an employment timeline.
Mistakes beginners make
- Jumping to models before understanding what a row means.
- Reporting an average without looking at the distribution.
- Treating an association as a cause and building a recommendation on it.
- Skipping SQL because it feels less exciting than machine learning.
- Submitting a notebook that only runs in the session where it was written.
What to put in your portfolio
Build a portfolio with a runnable notebook, data dictionary, source permissions and a concise findings memo. Include a plot with a clear caption and one limitation that could change your recommendation. Add a SQL file that reproduces your main summaries. Two investigations of different kinds, one descriptive and one predictive, show range better than many similar ones.
A notebook that runs only in your existing session is unfinished. Restart and run from the beginning, checking that paths and dependencies are documented.
Career direction
Explore data research, analytics-support and trainee responsibilities first. Scientist roles can require deeper mathematics, domain knowledge and experience. This roadmap is a learning sequence, not a promise about how long any of it will take.
How GullyMentor approaches it
A GullyMentor mentor gives you a fictional dataset and a real question, reviews your exploration, statistics and memo, and prepares you for analyst interviews including SQL. See the Data Science track at /career-tracks/data-science. We do not guarantee jobs, interviews or salaries.
Sources & further reading
- pandas getting started tutorials
- Kaggle Learn: Python
- Kaggle Learn: Intro to SQL
- Kaggle Learn: Data Visualization
- Khan Academy: Statistics and probability
- OpenIntro Statistics (free textbook)
- freeCodeCamp: Data Analysis with Python
- Microsoft: Data Science for Beginners (free course on GitHub)
Examples and practice recommendations are educational illustrations. Tool documentation and programme inclusions should be checked for your intended use.