How to Become a Data Analyst in 2026 With No Prior Experience, 6 Month Roadmap

Learning how to become a data analyst is one of the most practical career decisions a student or working professional can make in India right now. Companies across banking, healthcare, e-commerce, retail, and IT are actively hiring data analysts, and according to NASSCOM, India currently has a shortage of over 11 lakh data professionals. That gap between demand and supply is not closing anytime soon, which means the opportunity for someone starting from scratch today is genuinely real.

The data analyst career does not require a computer science degree. It does not require advanced mathematics. It requires a specific set of tools, learned in the right order, applied to real problems, and demonstrated through a portfolio of actual work. This 6-month roadmap gives you exactly that, a structured, step-by-step plan built around what Indian employers are actually looking for in 2026.

What Does a Data Analyst Actually Do, Before You Start Learning

Understanding the job before learning the skills is the step most beginners skip, and it costs them direction.

A data analyst collects raw, unorganized data from business systems, cleans and processes it, analyzes it for patterns and trends, and presents findings in a way that helps decision-makers take action. In practice, that means writing SQL queries to pull sales records from a database, building a Power BI dashboard that shows which product categories are underperforming, or using Python to analyze customer behaviour across 50,000 transactions.

The tools, Excel, SQL, Python, Power BI, and Tableau, are not the skill. They are instruments. The actual skill is asking the right business question, finding the right data, processing it correctly, and communicating the answer clearly. Every part of this data analyst roadmap builds toward that ability, not just technical proficiency with software.

Can You Really Become a Data Analyst From Scratch in 6 Months

This is the first honest question to answer before anything else.

Yes, and here is why it is realistic rather than just motivational.

The core technical stack for an entry-level data analyst role in India consists of four tools: Excel, SQL, Python, and Power BI. None of these requires a programming background to start. SQL reads like structured English. Excel is already familiar to most students. Python is consistently rated the most beginner-friendly programming language in the world. Power BI is designed specifically for business users, not software engineers.

The 6-month timeline is based on 2 to 3 hours of daily focused practice, not passive tutorial watching, but active work on real datasets. Students with commerce, arts, BBA, BCom, and humanities backgrounds have followed this exact data analyst career path and secured entry-level positions within 6 months.

What makes this timeline work is the order in which you learn. Most people who fail to become a data analyst in 6 months do not fail because the skills are too hard, they fail because they learned the tools in the wrong sequence and built no portfolio before applying.

The Right Order to Learn Data Analytics Skills, and Why Sequence Matters

Before the month-by-month breakdown, understand why this specific sequence exists.

Excel comes first because it teaches you how data is structured, rows, columns, categories, and values, before you write a single line of code. Every data analyst job interview in India tests Excel. Skipping it creates gaps that show up later.

SQL comes second because data lives in databases, and SQL is the universal language to access it. It is the most listed technical requirement in data analyst job postings on Naukri and LinkedIn in 2026. You cannot describe yourself as a data analyst without knowing SQL.

Python comes third because once you understand data structure from Excel and can query databases with SQL, Python adds the computational power to process large datasets, automate analysis, and build statistical models that Excel and SQL alone cannot handle.

Power BI comes fourth because visualization is how you communicate findings. A dashboard built in Power BI is what business stakeholders actually see from your work; it is the output of everything you did with Excel, SQL, and Python.

Portfolio and job preparation come fifth and sixth because skills without demonstrated application are invisible to recruiters.

Follow this order. Do not skip steps. Do not learn everything simultaneously.

Month 1, Microsoft Excel and the Foundation of Data Thinking

Excel is where the data analyst journey begins, not because it is the most impressive tool, but because it teaches you to think about data before you touch code.

By the end of month 1, you need to be comfortable with these specific Excel skills:

PivotTables are the most frequently used data summarization feature in Excel and one of the most tested topics in data analyst interviews. Learn to group data, calculate totals, filter by category, and drill down into subsets using PivotTables before moving on to anything else.

XLOOKUP and VLOOKUP are how you match and pull data between tables, a task that comes up in almost every real-world data job. XLOOKUP is the modern replacement for VLOOKUP, but interviewers still ask about both.

IF, SUMIF, COUNTIF, and SUMIFS are the conditional functions that let you answer how many orders came from Delhi last month or what is the total revenue from customers who spent more than ₹5,000. These are basic data analyst operations performed in Excel before you ever open Python.

Data cleaning in Excel, removing duplicates, handling blank cells, splitting text columns, and correcting data formats, is critical because in real analyst jobs, 40 to 50 percent of your time is spent cleaning data before analyzing it. This skill directly transfers to Python and SQL work later.

Charts and basic visualization, bar charts, line charts, scatter plots, and pie charts. More importantly, learn when to use each one and how to format them clearly for a non-technical audience.

Practice on real datasets from Kaggle or data.gov.in. Download a public dataset and try to answer 5 specific business questions using only Excel. This habit of working with real data is what separates job-ready analysts from those who only know the software theoretically.

For structured Excel training with hands-on lab practice on real datasets, the Advanced Excel training in Dwarka Mor at Infotech Softnet covers all these skills with daily practical sessions.

Month 2, SQL and the Ability to Query Any Database

After Excel, SQL, Structured Query Language, is the single most important skill on the data analyst career path in India. If you only have time to learn one technical tool deeply before applying for jobs, SQL is that tool.

SQL is how you communicate with databases. When a company stores millions of customer records, transaction logs, or inventory data in a relational database system like MySQL, PostgreSQL, or Microsoft SQL Server, SQL is what you write to pull exactly the data you need for your analysis.

The syntax is more readable than most beginners expect. A SQL query literally says: SELECT these columns FROM this table WHERE this condition is true, and that is almost exactly the code you write.

In month 2, work through these SQL concepts in this order:

SELECT, FROM, and WHERE are the building blocks of every SQL query. Every other concept builds on top of these three. Spend the first week here until they feel instinctive.

GROUP BY with aggregate functions, COUNT, SUM, AVG, MAX, MIN, are how you summarize data. Total orders by city. Average order value by month. Top 10 highest revenue products. These are the most common real-world SQL tasks for entry-level analysts.

JOINs are the most important SQL concept for getting hired. INNER JOIN, LEFT JOIN, and RIGHT JOIN let you combine data from two or more tables, for example, matching customer names from one table to their purchase history from another. JOINs appear in almost every SQL interview question.

Subqueries, writing a query inside another query, let you answer layered business questions like show me all customers whose average order value is above the overall average.

Window functions, RANK, ROW_NUMBER, LAG, and LEAD are the advanced SQL features that separate candidates who get shortlisted from those who do not. Practice these in month 2, even if they feel difficult initially.

Practice SQL on free platforms like HackerRank, LeetCode’s database problems section, or SQLZoo. Each of these gives you real tables and asks you to write queries to extract specific answers, exactly how the job works.

The SQL course at Infotech Softnet covers all these topics with live database exercises and guided practice from day one, structured for students with zero prior database experience.

Month 3, Python for Data Analysis

By month 3 you understand data structure from Excel and can query databases with SQL. Now Python gives you the analytical power that takes you from basic reporting to serious data analysis.

Python is the most widely used programming language in data analytics globally. It is also the most beginner-friendly, with clean, readable syntax that non-programmers can learn systematically. You do not need to learn all of Python; you need to learn the specific parts that data analysts use.

Core Python basics, variables, data types, lists, dictionaries, loops, conditional statements, and functions. Get comfortable writing and running Python scripts in Jupyter Notebook before touching data libraries. Spend the first 10 days here.

Pandas is the most important Python library for data analysis. It lets you load a CSV or Excel file into Python as a DataFrame, clean it, filter it, sort it, group it, and summarize it, everything you did in Excel, but faster and on much larger datasets. A Pandas DataFrame is essentially a supercharged Excel spreadsheet that you control through code. Spend at least two weeks on Pandas alone.

NumPy handles numerical operations on large arrays and datasets. It runs underneath Pandas, and you will use it for mathematical computations and statistical calculations.

Matplotlib and Seaborn are Python visualization libraries. Bar charts, line plots, scatter plots, histograms, and heatmaps: learn to create and format these programmatically from your datasets.

The learning method matters here. Do not spend month 3 watching Python tutorials. Work through a real Kaggle dataset using Python, load it, clean it, answer 8 business questions using Pandas, and visualize your findings. Working through real errors and finding real answers is what builds actual competence.

Infotech Softnet’s Python training in Dwarka Mor is structured specifically for data analytics use cases, covering Pandas, NumPy, and visualization with real project work throughout the course rather than isolated exercises.

Month 4, Power BI and Data Visualization

Month 4 is where everything comes together visually. You have clean data from Excel, queried data from SQL, and analyzed data from Python. Power BI is how you present all of it in a format that business stakeholders can actually use.

Microsoft Power BI is the most widely used business intelligence and data visualization tool in India in 2026. It connects directly to Excel files, SQL databases, CSV files, and Python outputs, making it the natural final layer in your data analyst workflow.

Power Query is the data transformation layer inside Power BI. Before building any visualization, you shape and clean your data here. Understanding Power Query makes you significantly faster at building dashboards.

DAX, Data Analysis Expressions, is Power BI’s formula language. CALCULATE, SUMX, DIVIDE, and basic measures are the DAX functions that appear most frequently in interviews and real work. You do not need to master DAX in month 4, but you need to be comfortable with the basics.

Building dashboards is the primary deliverable of month 4. Build at least two complete, interactive dashboards from scratch, one on sales data and one on HR or financial data. Include bar charts, line charts, cards, KPI indicators, slicers for filtering, and page-level navigation. Format them professionally.

Publishing to Power BI Service, the cloud version of Power BI, is the final step. Learn to publish your report, set up automatic data refresh, and share it with a viewer. This completes the full analyst workflow from raw data to a published dashboard.

Infotech Softnet’s Power BI training in Dwarka Mor covers DAX, Power Query, and dashboard building with real business datasets throughout the program, including publishing and sharing workflows.

Month 5, Build a Portfolio That Actually Gets You Hired

This is the month most people skip. It is also the reason most self-taught analysts struggle to get interviews despite knowing all four tools.

In India’s data analytics job market in 2026, recruiters are not impressed by a list of certificates. They want to see candidates who can handle data from the moment they log in on day one. A portfolio of 2 to 3 real analytics projects is worth more in a shortlisting decision than 5 course completion certificates.

Here is what a strong data analyst portfolio looks like:

Project 1, Excel and SQL project: Take a public e-commerce or sales dataset. Write 10 SQL queries to answer specific business questions, top-selling products, city-wise revenue, and monthly growth rate. Import the results into Excel, build a formatted summary report with charts and PivotTable analysis. Document what questions you answered and what the data revealed.

Project 2, Python analysis project: Download a dataset with at least 10,000 rows from Kaggle. Load it with Pandas. Clean it, handle missing values, remove duplicates, and correct data types. Perform descriptive analytics, mean, median, distribution, and correlation. Build 5 visualizations using Matplotlib or Seaborn. Write your findings in a Jupyter Notebook with clear markdown explanations between code cells.

Project 3, Power BI dashboard project: Build a complete interactive dashboard on a business dataset, financial data, HR data, or retail sales. Include at least 6 different chart types, 2 slicers, dynamic KPI cards, and a clear analytical narrative. Publish it to the Power BI Service and include the link in your portfolio.

Upload all three projects to GitHub. Write a clear README file for each one, including what the business problem was, what data you used, what tools you used, and what you found. This GitHub portfolio is what you share with recruiters in addition to your resume.

Month 6, Job Preparation and Applications

Month 6 is where your data analyst career path moves from learning to earning. You have the skills and the portfolio; now, you focus on converting them into offers.

Resume, list your tools clearly: Advanced Excel, SQL, Python (Pandas, NumPy, Matplotlib), Power BI. Under projects, write one bullet point per project describing what you did and what insight you produced. Keep it to one page. Do not include irrelevant skills or soft skill buzzwords; recruiters shortlisting for data analyst roles scan for specific technical terms.

In SQL interview preparation, the technical screening round for data analyst roles in India almost always includes SQL questions. Practice window functions (RANK, ROW_NUMBER, LAG, LEAD), GROUP BY with HAVING, multi-table JOINs, and subqueries on HackerRank’s SQL domain. These four topics cover 80 percent of what you will be asked.

Python and Excel case studies: Many companies send a take-home assignment with a real dataset and ask you to analyze it and present your findings. Practice this format during month 6 by taking a new dataset you have never seen, answering 5 business questions with Python or Excel, and building a Power BI dashboard to present it.

Where to apply, Naukri, LinkedIn, Indeed, and Instahyre are the primary job platforms for data analyst roles in India. Search for data analyst fresher, junior data analyst, MIS analyst, business analyst, and data reporting analyst. All of these are entry-level roles that your 6-month skill set qualifies you for.

Apply to 10 to 15 positions per week consistently. Do not wait for the perfect job description. Apply broadly in month 6, follow up after 7 days, and narrow down based on which role types generate responses.

Data Analyst Salary in India for Freshers in 2026

Understanding what this career pays before you invest 6 months preparing for it is a fair expectation.

Fresh graduates following the data analyst career path in India in 2026 typically land starting packages between ₹3.5 LPA and ₹6 LPA. In Delhi NCR specifically, the range sits toward the higher end because of the concentration of IT companies, analytics firms, and fintech businesses in the region.

The salary difference between candidates who know only Excel versus candidates who know SQL, Python, and Power BI is significant. Freshers with the full tool stack get shortlisted 3 times faster and earn ₹1 to ₹1.5 LPA more at their first job compared to Excel-only candidates. This is the clearest possible signal that completing this full 6-month roadmap, not stopping after month 1 or month 2, directly translates into better compensation.

Salaries in data analytics are growing at 12 to 15 percent annually in India, faster than almost any other IT career track. A fresher who enters at ₹4.5 LPA and continues developing skills in Python, advanced SQL, and cloud-based analytics tools can realistically reach ₹8 to ₹10 LPA within 2 to 3 years, without needing an advanced degree.

Learn Data Analytics in Dwarka Mor and Uttam Nagar, Structured Training at Infotech Softnet

Following a self-study roadmap takes exceptional personal discipline. Many students who start this journey with genuine motivation slow down in month 2 when SQL becomes difficult without someone to ask for help, or in month 3 when Python errors pile up and there is no instructor to guide them through.

Structured classroom training solves this problem directly. You have scheduled sessions, an instructor who clarifies doubts in real time, a computer lab available for daily practice, and a peer group going through the same journey alongside you.

Infotech Softnet’s Data Analytics Course in Dwarka Mor covers this exact 6-month roadmap, Excel, SQL, Python, Power BI, and Tableau, in a structured, lab-based program with certified faculty, real business project work, and dedicated placement support. Students from Dwarka Mor, Uttam Nagar, Janakpuri, Nawada, Tilak Nagar, and Bhagwati Garden attend regularly.

The institute is open 7 days a week from 8 AM to 8 PM with morning, afternoon, evening, and weekend batches available, so there is no schedule that cannot be accommodated.

Book a free demo class and experience the teaching methodology before committing to anything.

📞 76830 19695 | 88267 08404
📍 First Floor, Amar Complex, Metro (Piller. 782, Plot-10, near Grover Sweets, Dwarka Mor, Uttam Nagar, Bhagwati Garden, Uttam Nagar, New Delhi, Delhi, 110059