Cohort 4Register
Career Comparison

Data Analyst vs Business Analyst (India): The Work, the Skills, the Interviews, and Which to Choose

A data analyst answers questions with data: SQL, Excel and dashboards. A business analyst works out what a business needs and writes it down so a team can build it: requirements, process maps and user stories. Indian job titles blur the two, so this page compares the work, the tools, the interviews and the routes in, side by side.

By Durgesh Yadav — Senior Data Engineer @ 7-Eleven · Updated 5 Oct 2026. Preparation guidance, not a hiring guarantee.

Data analyst or business analyst: what is the difference, and which should you choose?

A data analyst works with the data: SQL queries, Excel, Power BI dashboards and the numbers behind a decision. A business analyst works with people and processes: gathering requirements, mapping how work flows and writing the specification a tech team builds from. Choose data analysis if you enjoy numbers, business analysis if you enjoy conversations.

Data Analyst Interview Questions See the Data Analytics cohort

Guide

What To Learn And How To Practice

What is the difference between a data analyst and a business analyst?

A data analyst starts from data and ends with an answer: a query, a dashboard or a short analysis that tells a manager what happened and why. A business analyst starts from a problem the business has and ends with a specification: what a new system or process must do, written so developers can build it and users can test it. Both need Excel, clear writing and enough SQL to check a number.

Data analyst vs business analyst: one works with the data, the other with the requirement
DimensionData analystBusiness analyst
Starts fromA question about the numbers: what happened, and whyA business problem: what should change, and what must be built
Main outputQueries, dashboards, reports and short analysesRequirement documents (BRD, FRD), user stories, process maps, acceptance criteria
Core toolsSQL, Excel, Power BI or Tableau; Python in some rolesExcel, Jira, Confluence, Visio or Lucidchart; SQL in some roles
Works most withData tables, and the managers who ask questions of themBusiness users, product owners and the developers who build the solution
Judged onWhether the number is right and it changed a decisionWhether the delivered system does what the business needed
Interview roundsLive SQL, an Excel task, a dashboard or a case questionA requirement-gathering scenario, a process to map, user stories, domain questions
CertificationsMicrosoft PL-300 (Power BI Data Analyst Associate)IIBA's ladder: ECBA at entry level, then CCBA and CBAP
In the India Tech Hiring Report (17,748 postings, 23 Aug to 27 Sep 2026)2,467 data-analyst postings (13.9%)No separate business-analyst family, so no count

What does a data analyst do in a normal week?

Most of the week goes to questions from other teams. Sales wants last month's numbers by region, operations wants to know why delivery times rose, finance wants the dashboard to match its own sheet. The analyst writes the SQL, checks the result against a second source, builds or fixes the report and explains in two lines what the number means. The rest of the week goes to keeping existing dashboards correct when the data underneath them changes.

Ad-hoc SQL for questions that arrive by chat or email
Dashboard upkeep in Power BI or Tableau: refresh failures, new filters, changed definitions
Reconciling a number with finance or operations before anyone acts on it
Short written summaries: what changed, why, and what to watch

What does a business analyst do in a normal week?

A business analyst spends the week between the people who want something and the people who will build it. In an IT services company this is often a client project: workshops with the client's users, a requirement document or a backlog of user stories, answering developers' questions, and checking during user acceptance testing that what was built matches what was asked. In banks, insurers and other in-house teams the work sits closer to the process itself: mapping how a loan or a claim moves today and where it stalls.

Requirement workshops and interviews with users
User stories with acceptance criteria, or a BRD and FRD, depending on the project
Process maps of how work moves today and how it should move
Answering developer questions and running user acceptance testing (UAT)

Which skills overlap, and which are different?

Excel, basic SQL, clear writing and knowledge of the business's domain sit in both jobs. After that they split. The analyst goes deeper on data: SQL with joins and window functions, a BI tool, some statistics and often Python. The business analyst goes deeper on people and process: running a workshop, writing a requirement nobody can misread, modelling a process and working inside an Agile team. For the analyst side there is posting data. In PrepNPlaced's India Tech Hiring Report, the 2,467 data-analyst postings collected 23 August to 27 September 2026 named SQL in 34.6%, Excel in 23.6%, Python in 23.2%, Power BI in 20.1% and Tableau in 12.7%. The report does not count business-analyst postings as a separate family, so there is no matching list for that side.

Shared: Excel, basic SQL, writing, domain knowledge such as banking, retail, insurance or supply chain
Data analyst only: SQL to window-function level, Power BI or Tableau, statistics, Python with pandas
Business analyst only: requirement workshops, process modelling, user stories and acceptance criteria, UAT, Jira and Confluence
Both: explaining a finding or a requirement to someone who does not work with data

How do the interviews differ?

Data analyst interviews test whether you can get the number right under time pressure: a live SQL round, an Excel task, and a case where you choose the metric. Business analyst interviews test whether you can find out what someone needs: a stakeholder describes a problem badly, and you are judged on the questions you ask, the process you sketch and the user story you write at the end.

Data analyst question

Revenue in the North region fell last month. Write the SQL that splits the fall by product and by new against returning customers, then say which cut you would show the manager first and why.

Business analyst question

A branch manager says loan approvals take too long. What do you ask first, how do you map the current process, and what user story would you write for the first fix? Strong answers ask who is waiting, at which step and for what, before proposing any software.

Which should you choose, and can you switch later?

Choose by the part of the work you could live with on a bad day. If debugging a wrong total in SQL sounds bearable, data analysis fits. If sitting through a long meeting to find out what a team needs sounds bearable, business analysis fits. Before applying, read the responsibilities and not only the title: some postings called business analyst describe reporting in SQL and Power BI, which is analyst work, and some called data analyst describe requirement work. Switching later is realistic in both directions, because the shared base is large.

Engineering or science graduate who enjoys SQL and numbers: data analyst first
Commerce, BBA or MBA graduate with domain knowledge and strong writing: business analyst, with enough SQL to check data
Working in testing or support on a project: you already see requirements and defects, which is half of business analysis
Business analyst moving to data analyst: add SQL to window-function level and one BI tool, then build a dashboard project
Data analyst moving to business analyst: practise requirement workshops and user stories; your data skills become an advantage

Related Guides

Keep Preparing

Move between roadmaps, interview questions, and tools without losing your preparation thread.

Data Analyst Roadmap 2026

The analyst path in five phases, from spreadsheets to a domain portfolio.

Read guide

Data Analyst Interview Questions

Every round of the analyst loop, with worked SQL and a case method.

Read guide

Business Analyst role guide

Skills, tools and a learning order for the business analyst role.

Read guide

BI Analyst role guide

The dashboard-focused analyst role that is often confused with business analyst.

Read guide

Data Engineer vs Data Analyst

The other comparison analysts make before choosing.

Read guide

SQL Interview Questions

The screening round for analysts, and a useful skill for business analysts.

Read guide

India Tech Hiring Report 2026

The 2,467 data-analyst postings behind the skill shares on this page.

Read guide

Data Analytics Cohort (live, weekend)

18 live classes where SQL takes 40% of the hours, with three projects built in class.

Read guide

Career Roadmaps

Return to the parent resource hub for the full preparation path.

Open hub

FAQ

Common Questions

Which is better for a fresher in India, data analyst or business analyst?

The one that matches how you like to work, because both are entry routes into data and IT teams. Data analyst roles screen on SQL and Excel tests you can prepare for alone. Business analyst roles screen more on communication and domain knowledge, which suits commerce, BBA and MBA graduates. If you are undecided, learn SQL and Excel first; both roles use them.

Does a business analyst need coding?

Usually not in the programming sense. Most business analyst work is requirements, process maps and testing. SQL helps a great deal, because a business analyst who can check the data behind a complaint asks better questions, and some postings ask for it. Python is a data analyst skill more than a business analyst one.

Who earns more, a data analyst or a business analyst?

This page quotes no pay figures. PrepNPlaced's India Tech Hiring Report found that fewer than 300 of its postings disclosed an INR salary, too few to publish honestly, and it has no business-analyst family to compare. Company tier, domain and experience move pay more than the choice between these two titles, so compare actual offers, not averages.

Can a business analyst become a data analyst?

Yes, and the move is shorter than most. A business analyst already knows the domain and the stakeholders. The gap is SQL to window-function level, one BI tool and a portfolio project that answers a business question with data. The reverse move, analyst to business analyst, needs practice in requirement workshops and in writing user stories.

Is a business analyst the same as a business intelligence (BI) analyst?

No. A BI analyst builds dashboards and reports, which is data analyst work centred on a BI tool such as Power BI or Tableau. A business analyst gathers and writes requirements for systems and processes. The similar names cause a lot of wrong applications, so read the responsibilities in the posting before you apply.

Which certification helps: PL-300 or ECBA?

Pick the one that matches the role. Microsoft's PL-300 (Power BI Data Analyst Associate) tests preparing, modelling, visualising and analysing data in Power BI, which suits a data analyst. IIBA's ECBA is the entry certificate in its business analysis ladder, which continues to CCBA and CBAP. Neither replaces a project you can show and explain.

Next Step

Turn The Guide Into Practice

Use PrepNPlaced tools to turn this learning path into resume proof, targeted practice, and interview-ready explanations.

Data Analyst Interview Questions