πYes, You Can Start With No Experience
Data analyst is one of the most accessible tech roles in India. You do not need a computer science degree or a coding background. Companies hire freshers, commerce and arts graduates, and people switching from sales, operations, finance, support or teaching, because the job is about asking good business questions and answering them with data.
What employers do need is proof. With no work experience, your proof is skills you can demonstrate and projects you can explain. This guide shows how to build both. For the detailed skill order, also read the data analyst roadmap.
πWho This Path Works For
Your background is not a weakness. A BCom graduate who understands margins and receivables, or an operations person who knows why deliveries are late, can ask better questions than someone who only knows tools.
πThe Skills to Learn, In Order
1. Excel
Cleaning data, XLOOKUP, SUMIFS, pivot tables and simple charts. Our Excel for data analysis guide covers exactly what to learn.2. SQL
The most tested skill in data analyst interviews. Learn SELECT, WHERE, GROUP BY, HAVING, joins, subqueries, CTEs and window functions. Practise daily on real datasets.3. Statistics basics
Averages and medians, spread, distributions, percentages and growth rates, correlation, and the idea behind A/B testing. You need practical understanding, not heavy maths.4. A BI tool
Power BI is most common in Indian companies, Tableau is also widely used. Learn one properly: data modelling, measures and a clean dashboard.5. Python basics (after the above)
pandas for cleaning and analysis gives you an edge and opens a path towards data science later. Start with the Python course or our pandas tutorial.6. Business communication
Presenting a finding in three sentences with one chart is a skill interviewers test directly. Practise it from day one.πA Realistic Self-Study Plan
This is a self-study plan for someone giving 10 to 15 hours a week. Go faster or slower as your schedule allows.
Consistency matters more than speed. An hour every day beats a long session once a week.
πTwo Portfolio Projects That Work
Project 1: Sales or business performance analysis
Take a public retail or e-commerce dataset. Clean it, write SQL queries to answer questions such as which regions and products drive revenue and where returns are high, and summarise three findings with recommendations.Project 2: An interactive dashboard
Build a Power BI or Tableau dashboard on a dataset close to the domain you want to work in: HR attrition, loan defaults for finance, delivery times for logistics, or student performance for edtech. Include KPIs, trends, filters and a short written summary.For each project, write a short README: the business question, the data, your steps, the results and what you would do next. Publish the dashboard (Tableau Public or a Power BI screenshot set) and put the SQL and files on GitHub.
πResume Tips for Freshers and Switchers
πMake LinkedIn Work for You
πWhere to Apply
πWhat the Interview Process Looks Like
Prepare with our data analyst interview questions and SQL interview questions.
πWhat Salary to Expect
Freshers typically start around βΉ3.5 to 6 LPA, with higher offers at product companies and GCCs, and growth is quick once you have a year or two of experience. Our data analyst salary guide has city and company detail. These are indicative ranges, not guarantees.
πTips by Background
Freshers and final-year students
Use your college projects, internships and any club or event data you have handled. Apply for trainee and internship roles early, and practise aptitude and SQL tests, because many fresher hiring drives start with an online assessment.BCom, BBA and MBA graduates
Lean into finance, sales and marketing datasets. A dashboard on receivables, budget versus actuals or campaign performance shows you understand the business side as well as the tools. Business analyst and MIS analyst roles are natural first steps.Non IT graduates
Start with Excel, because it builds confidence, then move to SQL. Explain in interviews how your subject trained you to reason with evidence, whether that is lab data in science or surveys in social science.Career switchers
Your domain is your edge. An operations professional analysing delivery delays, or an HR professional analysing attrition, brings context that pure tool learners lack. Look for analyst openings inside your current company first, internal moves are often the easiest.πA Week in the Life of a Junior Analyst
Knowing what the job looks like helps you prepare for it. A typical week includes refreshing weekly sales or operations reports, answering a few ad hoc questions from managers ("why did returns rise in the South?"), writing SQL to pull data for a new request, cleaning a messy file someone sent over email, updating a Power BI dashboard, and presenting a short summary in a team meeting. Most of the work is careful, repeatable data handling, with a few moments of insight that make the role rewarding.
πCommon Mistakes to Avoid
πFAQ
Can a BCom or BBA graduate become a data analyst?
Yes, and many do. Commerce graduates understand business metrics well. Add Excel, SQL and a BI tool, build two projects, and you are a strong candidate.Do I need to learn Python to get my first analyst job?
Not always. Many entry roles ask only for Excel, SQL and Power BI or Tableau. Python helps you stand out and is needed if you later move towards data science, see data analyst vs data scientist.Is a certificate necessary?
A certificate helps with screening, but projects and SQL skill decide interviews. Treat certificates as a supplement, not the goal.How many applications does it usually take?
It varies, but dozens of tailored applications before the first offer is normal for freshers. Track each application, follow up politely, and treat every interview as practice that improves the next one.Is age or a career gap a problem?
Not if you can show current skills. Explain the gap briefly and focus on what you have built recently.πLearn It Live
If you want structure and feedback, Prakalpana's Data Analytics course is taught live online with an optional 1-on-1 track, two portfolio projects, resume reviews and mock interviews. See the data analytics path, then WhatsApp or call +91 9180377502 for a free demo.