insta jobData analyst roadmap for freshers: skills, projects and resume proof
An entry-level data analyst needs strong SQL, working Python or spreadsheet skills, basic statistics and the ability to explain what the numbers mean. Here is what to learn, what to build, and how to write resume lines that prove it.
Last updated: 13 November 2026
In short
- Learn SQL first: it is the core tool of the job and a standard interview topic.
- Add Python or advanced spreadsheets, basic statistics and one dashboard tool.
- Build three or four projects on real public data, each answering a question you chose.
- On your resume, pair each skill with what you did: "Wrote SQL queries to…" beats "Familiar with SQL".
What a data analyst does day to day
A data analyst turns raw data into answers a team can act on. At entry level the work is mostly:
- Pulling data with SQL from a company database or data warehouse.
- Cleaning it: duplicates, missing values, wrong data types, inconsistent labels.
- Analysing it: comparing periods, spotting trends and outliers, and checking whether a difference is real or noise.
- Presenting it in dashboards, charts and short written summaries for non-analysts.
- Answering questions from product, sales, operations or finance teams, such as "Why did orders drop last week?"
Reporting, MIS, product and business analyst roles often overlap with this work, but some business analyst roles are about gathering software requirements instead. Read the responsibilities, not just the title.
Skills roadmap
Work through these roughly in order.
- SQL. GROUP BY and HAVING, inner and left joins, subqueries and CTEs, window functions such as ROW_NUMBER and running totals, date functions and NULL handling. Practise on a real PostgreSQL or MySQL database.
- Spreadsheets. Excel or Google Sheets: formulas, XLOOKUP or VLOOKUP, pivot tables and clear charts. Many teams still share work in spreadsheets.
- Python for analysis. pandas for cleaning, merging and aggregating; Matplotlib or Seaborn for charts; Jupyter notebooks.
- Statistics. Mean, median and spread; distributions; correlation versus causation; sampling; confidence intervals; hypothesis tests; A/B testing basics.
- Dashboards. One BI tool such as Power BI, Tableau or Looker Studio, used to answer one clear question.
- Communication and Git. Summarise every analysis: the question, the answer, the evidence and the caveats. Keep your work on GitHub.
What Insta Job checks for this role
Insta Job's Data Analyst direction is built on four core skills: SQL, Python, statistics and data pipelines. It is only suggested when at least one resume line shows real work with SQL, statistics or data pipelines. The related Data Engineer direction uses Python, SQL, data pipelines and Docker, and needs demonstrated SQL or pipeline work.
| Skill | Words Insta Job recognises |
|---|---|
| SQL | SQL, PostgreSQL, Postgres, MySQL, SQLite |
| Python | Python |
| Statistics | statistics, statistical modelling (or modeling) |
| Data pipelines | ETL, data pipeline, data pipelines, Airflow, Spark |
| Experiment design | A/B testing, experiment design (when an opening asks for it) |
| Docker (Data Engineer) | Docker, containerized, containerised |
Excel, Power BI, Tableau, pandas and NumPy are not in Insta Job's skill list today. Keep them on your resume, because employers ask for them and recruiters read them, but the app's analyst direction is driven by SQL, Python, statistics and pipeline evidence. Also note that "statistical analysis" on its own is not matched; the word "statistics" is.
When Insta Job matches you to an opening, it reads the skills that listing asks for and shows the opening only if your resume demonstrates at least two of them, including at least one core skill of the direction.
Resume lines that count as evidence
Insta Job reads your resume line by line and sorts every line that names a skill into one of three kinds:
- Demonstrated: the line pairs the skill with an action word such as built, developed, implemented, designed, wrote, created, tested, deployed, automated, optimized, evaluated, used or using.
- Mentioned: the skill appears without an action word, or the line contains "familiar with", "learning", "interested in", "exposure to", "beginner" or "planning to". A mention counts for less, and on its own it cannot put a direction or an opening on your list.
- Negated: "no", "not", "without" or "lacking" just before the skill. These lines do not count at all.
| Weak line | Stronger line |
|---|---|
| Familiar with SQL, Python and Power BI. | Wrote SQL queries in PostgreSQL to find the main causes of late deliveries in a public e-commerce dataset. |
| Analysed sales data in SQL and Excel. | Wrote SQL queries to analyse sales by region and month, and built an Excel pivot report from the results. |
| Good knowledge of statistics. | Used Python and descriptive statistics to compare exam results across two batches and summarised the findings in a one-page report. |
| Knowledge of ETL. | Built an ETL script in Python that loads daily CSV exports into MySQL and flags missing values. |
"Analysed" reads fine to people but is not on Insta Job's list of action words, so pair it with one that is. "Learning" anywhere in a line turns the whole line into a mention: "Built a sales dashboard with SQL; currently learning Spark" counts only as a mention, so put learning plans on a separate line. Back each skill in your skills section with a project line, and only write what you can explain in an interview.
Portfolio projects that prove the skills
Put each on GitHub with a README covering the question, data source, method, findings and limitations.
-
Business questions in SQL
Load a public e-commerce dataset into PostgreSQL and answer business questions: top products, repeat customers, monthly revenue, retention. Proves: joins, CTEs, window functions and business framing.
-
Cleaning a messy dataset
Take public data with real problems, for example from data.gov.in, and document every cleaning decision in a notebook. Proves: pandas skills and judgement.
-
A dashboard for one decision
Build a dashboard for one audience and one question, such as what a college canteen should stock each week. Proves: chart choice and communication.
-
A/B test write-up
Use a public A/B test dataset or simulate one. State the hypothesis, run the test and explain the result and its limits. Proves: statistics you can apply.
-
A small automated pipeline
A Python script that pulls data from a public API on a schedule, cleans it and loads it into a database. Proves: ETL basics, useful for data engineer roles too.
Interview topics to prepare
- SQL, written live: join types, GROUP BY versus window functions, finding duplicates, the Nth highest value, running totals and NULLs.
- Statistics: mean versus median and when each misleads, standard deviation, correlation versus causation, p-values in plain words.
- Python and spreadsheets: pandas merge and groupby, missing values, lookups and pivot tables.
- Case questions: "Orders fell sharply yesterday. How would you investigate?" Break the problem down before touching data.
- Aptitude: campus and mass-hiring processes in India often begin with a quantitative and logical reasoning test.
- Your projects: be ready to defend every number, chart and decision.
Common fresher mistakes
- Listing tools without showing what you did with them.
- Projects that repeat a tutorial on a classroom dataset, with no question of your own.
- Skipping SQL to chase machine learning courses, or writing "advanced" next to skills you cannot defend.
- Applying to every role titled "analyst" without checking whether it is actually data work.
How Insta Job helps with this role
Add your resume as a PDF or DOCX, up to 5 MB (PDFs up to 10 pages). The file is read in your browser and never uploaded. Insta Job then:
- Suggests up to three career directions, such as Data Analyst or Data Engineer, each citing the resume lines it used. There is no numeric fit score.
- Shows matching openings from a selected set of employer job feeds, checked every six hours. Listings not confirmed in the last 24 hours are dropped, and you apply on the employer's site.
- Reads your graduation year and experience (you can correct both), hides openings whose stated requirements rule you out, and flags graduation, experience or location conditions it cannot confirm.
- Shows which skills an opening asks for that your resume does not clearly show yet.
- Links to LinkedIn, Glassdoor, Foundit and Naukri searches for the role.
It is free, with ten free AI searches per browser. With AI on, only the passages that show your skills are sent, with contact details removed; if AI ranking is unavailable, searches still run on your device. You must be 18 or older.
FAQ
Can I become a data analyst without a computer science degree?
Yes. Analysts come from commerce, economics, statistics, science and engineering backgrounds, and demonstrable skills matter more than the degree name. Some employers do set degree or batch conditions, so check each listing.
Is SQL and Excel enough, or do I need Python?
Some entry-level roles need only SQL, spreadsheets and a BI tool. Python widens your options and makes cleaning large datasets easier, so learn it once your SQL is solid.
Why doesn't Insta Job suggest Data Analyst for my resume?
Usually because no line pairs SQL, statistics or data pipelines with an action word, or because the resume only names tools the app does not recognise yet, such as Excel or Power BI. Rewrite your project lines as shown above and search again.