Career Guide · Commerce · Jobs & Salary
How to Become a Data Analyst After B.Com and M.Com: Skills, Salary, Jobs and Projects
A commerce graduate applies for an "MIS Executive" opening, clears the HR round, and is handed a laptop with a test: join two tables, find the month-on-month change for each branch, and explain why one branch dropped. Many candidates with good marks fail exactly here, not because the task is hard but because nobody told them this is what the job tests. This guide is about that gap: the jobs B.Com and M.Com graduates can realistically target, the skills interviews check, projects that use your accounting background, and how to research pay without being misled.
If you are still in college, the B.Com student roadmap from Excel to Python sets out a year-by-year plan. This page assumes you have graduated, or are about to, and want a job.
Job titles to search for
"Data Analyst" is only one of the titles open to commerce graduates. Searching only for it hides many suitable openings.
| Title | What the work usually involves | Why a commerce degree helps |
|---|---|---|
| MIS executive / MIS analyst | Daily and monthly reports from company systems, mostly in Excel and SQL | Accuracy and familiarity with sales, collections and expense data |
| Reporting analyst | Building and maintaining dashboards in Power BI or Tableau | You understand what the numbers mean to finance and sales teams |
| Financial analyst / FP&A analyst | Budgets, forecasts, variance reports | Directly uses cost and management accounting |
| Credit or risk analyst | Reviewing applications and portfolio data at banks and NBFCs | Financial statement analysis, ratios |
| Audit or forensic analytics associate | Testing large sets of transactions for exceptions | Audit concepts, sampling, internal controls |
| Data analyst | Wider analysis across sales, operations or customers | Business context; stronger SQL and statistics expected |
The five skills interviews actually test
- Excel at speed: XLOOKUP or INDEX-MATCH, SUMIFS, pivot tables and cleaning text and dates. Many companies give a timed Excel test.
- SQL: joins, GROUP BY, CASE and, increasingly, window functions. See the example below.
- One dashboard tool: Power BI is common in Indian companies. You should be able to explain a DAX measure you wrote.
- Business statistics: averages and their traps, percentage change, distributions, correlation versus cause. Your B.Com statistics paper covers much of this.
- Explaining findings: a two-minute verbal summary of a chart or table, in plain English, often in the final round.
Python is a strong addition, especially for data analyst titles, but many MIS and reporting roles do not require it at entry level. Read the job description rather than assuming. This list of SQL skills for analytics jobs is useful to check yourself against.
A typical SQL test question
"Show each branch's monthly revenue and the change from the previous month." It needs a join and a window function:
CREATE TABLE branches (branch_id INTEGER, city TEXT);
CREATE TABLE monthly_sales (branch_id INTEGER, month TEXT, revenue INTEGER);
INSERT INTO branches VALUES (1,'Jaipur'),(2,'Indore'),(3,'Lucknow');
INSERT INTO monthly_sales VALUES
(1,'2026-07',410000),(1,'2026-08',385000),(1,'2026-09',452000),
(2,'2026-07',298000),(2,'2026-08',331000),(2,'2026-09',305000),
(3,'2026-07',365000),(3,'2026-08',372000),(3,'2026-09',398000);
SELECT b.city, s.month, s.revenue,
s.revenue - LAG(s.revenue) OVER (PARTITION BY b.city ORDER BY s.month) AS change_vs_prev
FROM monthly_sales s
JOIN branches b ON b.branch_id = s.branch_id
ORDER BY b.city, s.month;
Result (SQLite 3.45):
city | month | revenue | change_vs_prev
Indore | 2026-07 | 298000 | NULL
Indore | 2026-08 | 331000 | 33000
Indore | 2026-09 | 305000 | -26000
Jaipur | 2026-07 | 410000 | NULL
Jaipur | 2026-08 | 385000 | -25000
Jaipur | 2026-09 | 452000 | 67000
Lucknow | 2026-07 | 365000 | NULL
Lucknow | 2026-08 | 372000 | 7000
Lucknow | 2026-09 | 398000 | 26000Be ready to explain why the first month shows NULL (there is no previous month) and what you would check before calling Indore's September dip a problem: returns, a holiday, a late invoice posting. That second part is where accounting knowledge shows.
Where M.Com adds something
An M.Com does not automatically put you ahead for analyst jobs, but some parts help if you use them. Research methodology and the dissertation give you practice in framing a question, collecting data and testing a hypothesis. Papers on advanced statistics or econometrics, where your university offers them, cover regression. Mention these concretely: "my dissertation analysed survey data from 180 retailers using regression" says more than "M.Com, first division". If your M.Com had none of this, treat it as a commerce degree plus two more years of maturity, and let your projects carry the weight.
Projects that use your accounting knowledge
Bank reconciliation is a task you know by hand. Here it is in Python, which is also how audit analytics teams test thousands of entries at once:
import pandas as pd
ledger = pd.DataFrame({
"ref": ["CHQ-4411", "NEFT-882", "CHQ-4412", "UPI-3091"],
"amount": [25000, 14200, 8000, 3500],
})
bank = pd.DataFrame({
"ref": ["CHQ-4411", "NEFT-882", "UPI-3091", "CHG-OCT"],
"amount": [25000, 14200, 3500, 590],
})
rec = ledger.merge(bank, on=["ref", "amount"], how="outer", indicator=True)
rec["status"] = rec["_merge"].map({
"both": "matched",
"left_only": "in books, not in bank",
"right_only": "in bank, not in books",
})
print(rec[["ref", "amount", "status"]].to_string(index=False))
Output (pandas 3.1):
ref amount status
CHG-OCT 590 in bank, not in books
CHQ-4411 25000 matched
CHQ-4412 8000 in books, not in bank
NEFT-882 14200 matched
UPI-3091 3500 matchedAn accountant recognises the result immediately: an uncleared cheque and a bank charge not yet booked. Build on this with a few hundred rows, amount mismatches and date tolerances, and you have a portfolio project that interviewers in finance and audit understand at once.
Other project ideas: a budget-versus-actual dashboard with commentary, an expense-claim exception report (duplicates, weekend claims, round amounts), or a sales analysis of a public retail dataset. These data analytics portfolio projects give more starting points.
Salary: how to read the numbers honestly
This guide does not quote salary figures, because entry pay for these roles varies too much by city, company type, title and skills for a single number to be useful, and figures go out of date quickly. To get a realistic picture:
- Check the same job title on two or three sources, such as AmbitionBox, Glassdoor and Naukri, and note the date and sample size each shows.
- Compare the same title in your target city; Bengaluru, Gurugram, Noida, Pune and Mumbai often differ from smaller cities.
- Separate fixed pay from variable pay and joining bonuses when you compare offers.
- Treat any course or website that promises a specific package after training with caution.
Explaining your background in interviews
Do not apologise for a commerce degree. Say what it gave you: comfort with financial data, an eye for things that do not reconcile, and an understanding of how a business earns and spends money. Then show the technical side through a project. For resume wording, this guide to data analytics resumes has examples.
Frequently asked questions
Is B.Com enough, or do I need an MBA or M.Com for analyst jobs?
Many entry analyst and MIS roles accept any graduate who passes the skills tests. A postgraduate degree can help with some employers and later promotions, but it does not replace Excel, SQL and project experience.
Should I choose CA or data analytics?
They lead to different careers. CA is a professional qualification for accounting, audit and tax; analytics is a skill set used across functions. Some people combine them, for example in FP&A or audit analytics. Choose by the work you want to do daily.
I scored low marks in B.Com. Can I still get an analyst job?
Some large employers filter by marks, so you may be screened out by a few. Many others care more about the test result and projects. Apply widely, including to mid-sized firms, and let your skills test speak.