#1 India's Top IT Training Institute
×

About Uncodemy

Know more about who we are and what we stand for.

About Us

About Us

Discover our mission to equip individuals with essential IT skills and industry expertise.

Read More →
UnCodeMy Gallery

UnCodeMy Gallery

Explore highlights from our IT training sessions and success stories.

Read More →
Mentors

Mentors

Meet the industry experts who train and guide you through your course.

Read More →
Free Resources

Free Resources

Free tutorials, interview questions, tools and calculators to help you learn.

Explore →
×

Free Resources

Learn, practice and plan your career — bilkul free.

Tutorials

Tutorials

Step-by-step written tutorials to learn any technology at your own pace.

Read More →
Free Counselling

Free Counselling

Book a free video counselling session and pick the right course for you.

Read More →
Online Compiler

Online Compiler

Write, run and test your code online — no setup required.

Read More →

Free career guide · 480+ tutorials

How to Become a Data Analyst After B.Com and M.Com? Skills, Salary, Jobs & Projects

This is the job‑focused guide: what employers test in an analyst interview, what the role pays in each Indian city, which companies actively hire commerce graduates, and the five projects that get you shortlisted.

Tracks
Career Path Explorer · Live guide Interactive
Role
—
Job title
Avg. Salary (India)
—
Fresher to mid-level
Learning Time
—
From zero to job-ready
B.Com / M.Com → Learn 5 Tested Skills → Build 5 Projects → Apply & Get Hired
Tap a stage to see the pay band. Analyst salaries rise steeply with experience, which is why getting in early at a lower package usually beats waiting another year to study.

Home / Career Guides / Commerce to Data / B.Com / M.Com to Data Analyst

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.

TitleWhat the work usually involvesWhy a commerce degree helps
MIS executive / MIS analystDaily and monthly reports from company systems, mostly in Excel and SQLAccuracy and familiarity with sales, collections and expense data
Reporting analystBuilding and maintaining dashboards in Power BI or TableauYou understand what the numbers mean to finance and sales teams
Financial analyst / FP&A analystBudgets, forecasts, variance reportsDirectly uses cost and management accounting
Credit or risk analystReviewing applications and portfolio data at banks and NBFCsFinancial statement analysis, ratios
Audit or forensic analytics associateTesting large sets of transactions for exceptionsAudit concepts, sampling, internal controls
Data analystWider analysis across sales, operations or customersBusiness context; stronger SQL and statistics expected

The five skills interviews actually test

  1. Excel at speed: XLOOKUP or INDEX-MATCH, SUMIFS, pivot tables and cleaning text and dates. Many companies give a timed Excel test.
  2. SQL: joins, GROUP BY, CASE and, increasingly, window functions. See the example below.
  3. One dashboard tool: Power BI is common in Indian companies. You should be able to explain a DAX measure you wrote.
  4. Business statistics: averages and their traps, percentage change, distributions, correlation versus cause. Your B.Com statistics paper covers much of this.
  5. 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;
branch_trend.sql

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  | 26000

Be 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))
bank_rec.py

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               matched

An 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.

Related resources

Keep going — career guides

Career roadmaps

Plan your data & AI career

Latest articles

Fresh this week