Data Analyst Roadmap: Skills, Tools and Projects to Get Your First Job

Every company now has data: sales, customers, website visits, deliveries, complaints. But data alone helps nobody. Someone has to clean it, explore it and say: "Sales dropped in the south because delivery times rose. Fix this first."

That person is the data analyst. It is one of the most accessible entry points into tech, and a good first role for career switchers.

A typical week might include:

• Collecting data from databases, spreadsheets and tools
• Cleaning it: fixing errors, duplicates and missing values
• Analysing: finding trends, comparing groups, calculating metrics
• Building dashboards that managers can use
• Explaining findings in presentations or short reports
• Working with stakeholders to clarify what they really need

You may work in marketing, finance, operations, product or HR analytics, or for a consulting firm. Job titles include data analyst, business analyst, BI analyst and product analyst.

The first tool everywhere. Learn:

• Formulas: SUM, IF, COUNTIFS, SUMIFS
• Lookups: VLOOKUP or XLOOKUP, INDEX/MATCH
• Pivot tables and charts
• Data cleaning: remove duplicates, text functions, dates
• Basic keyboard shortcuts

You don't need advanced maths to start. Learn:

• Mean, median, mode and why the median can be better
• Standard deviation and distributions
• Correlation vs causation
• Sampling and bias
• Percentages, growth rates and averages across groups
• Basics of A/B testing and confidence

The most important technical skill for analysts. See SQL for beginners. Aim to be comfortable with:

• SELECT, WHERE, ORDER BY
• GROUP BY and aggregates
• JOIN (inner, left)
• Subqueries and CTEs
• Window functions (later)

Power BI and Tableau are the most common. Looker Studio is free and good for starting. Learn to:

• Connect to data and model simple relationships
• Create clear charts and dashboards
• Use filters and basic calculated fields
• Choose chart types that suit the question

A good dashboard answers a question at a glance. Avoid clutter and too many colours.

Not required for every entry-level role, but it widens your options. Learn:

• Python basics. See Python roadmap for beginners
• pandas for data cleaning and analysis
• matplotlib or seaborn for charts
• Reading data from CSV, Excel and databases
• Jupyter notebooks for sharing analysis

This separates good analysts from average ones.

• Ask the right question. "What decision will this analysis support?"
• Tell the story. Context, finding, recommendation.
• Write clearly and keep slides simple. See writing in public.
• Speak with confidence. See overcoming stage fright.
• Know a domain: retail, banking, healthcare, e-commerce or logistics.

Study in short, regular sessions. See deep work and focus and spaced repetition.

Employers want proof that you can go from a question to a recommendation.

1. Sales analysis: Which products, regions and months drive revenue? Recommend actions.
2. Customer churn: Why do customers leave? Which groups are at risk?
3. Web or app analytics: Where do users drop off in the signup funnel?
4. Public data: for example, road accidents, air quality, cricket statistics or the Indian census. Pick something you care about.
5. Personal finance tracker: analyse your own spending, as in save your first ₹10 lakh. Use anonymised data if you share it publicly.

1. The question and why it matters
2. The data: source and cleaning steps
3. The analysis: methods and key charts
4. The findings: what you discovered
5. The recommendation: what the business should do
6. Limitations: what you could not conclude

Publish on GitHub, a portfolio website or LinkedIn with a short write-up. Keep the writing simple.

• Lead with a summary and skills (Excel, SQL, Power BI, Python).
• Add projects with results: "Analysed 50,000 orders and identified three product categories responsible for 62% of returns."
• Include domain experience if you have it.
• Use the keywords from job posts honestly.

See how to build a resume that gets shortlisted and LinkedIn profile for recruiters.

Interviews often include:

• SQL questions: joins, aggregates, ranking and window functions
• Excel tasks or a case study
• Statistics and metrics: "How would you measure the success of this feature?"
• Business cases: "Sales fell 10% last month. How do you investigate?"
• Behavioural questions. See HR interview questions
• A take-home assignment in some companies

Practise explaining your projects aloud. For a general method, see software interview preparation.

1. Clarify the problem and the metric.
2. Break it down: by time, product, region, customer type.
3. Form hypotheses: possible causes.
4. Say what data you'd check for each.
5. Recommend the next step.

• Job sites and LinkedIn, searching "data analyst", "business analyst", "junior analyst" and "MIS executive"
• Internships and apprenticeships
• Freelance work for small businesses (e.g. dashboards in Excel or Looker Studio)
• Internal moves from your current job into an analytics team
• Referrals through your network

Some entry roles use titles like MIS executive or reporting analyst. They can be a good first step.

If you are switching careers, see career switch into IT or data. For choosing skills strategically, see in-demand skills in India.

Pay varies widely by city, company and skill. Entry-level offers often range from modest to decent, and rise as you add SQL depth, domain knowledge and communication. Check current job listings and talk to people in the field instead of relying on course marketing. For negotiation, see salary negotiation in India.

Typical growth paths:

• Senior analyst, then analytics manager
• Data scientist (add statistics and machine learning)
• Analytics engineer or data engineer (add engineering)
• Product or business roles

• Learning tools without a question to answer
• Ignoring SQL
• Making cluttered dashboards
• Presenting numbers without a recommendation
• Using only the famous datasets everyone uses
• Not checking data quality
• Skipping domain knowledge
• Starting machine learning before the basics

Not necessarily. Many analysts come from commerce, engineering, economics and other fields. Skills and projects matter.

Excel, then SQL, then Python for most people.

Either. Check which is more common in jobs near you. Power BI is widespread in India.

AI can speed up queries and charts, but analysts who understand the business, check results and communicate insight remain valuable. See using AI at work.

Two or three strong projects beat ten weak ones.

Job requirements and salaries change. Check current job listings and credible sources.