Career Guide · Commerce to Analytics

Data Analytics Career for B.Com Students: The Complete Roadmap from Excel to Python and AI

SECTION 01Why B.Com is a strong starting point

Analytics teams are full of people who can write a query but cannot tell you whether the resulting number makes business sense. That is the gap a commerce graduate fills.

• You read financial statements. Balance sheet, P&L and cash flow are the source of most corporate reporting requirements.
• You know the vocabulary. Gross margin, contribution, accrual, provision, working capital — these appear in dashboard specifications, not in engineering courses.
• You already use Excel. Most commerce students have done more spreadsheet work than a typical engineering fresher.
• You understand controls. Reconciliation and audit habits translate directly into data validation.
• You can talk to finance teams. A large share of analytics demand comes from finance, and communication there is easier when you speak the language.

SECTION 02The tool order — and why it matters

Learning tools in the wrong order wastes months. This sequence keeps you employable at every stage.

SECTION 03Stage 1 — Advanced Excel, done properly

“I know Excel” means very little in an interview. What counts is whether you can restructure a badly built workbook and produce a reconciled report without manual copy‑paste.

What you’ll learn

• Lookups — XLOOKUP, INDEX‑MATCH, multi‑criteria matching
• Conditional aggregation — SUMIFS, COUNTIFS, AVERAGEIFS
• Pivot tables, slicers, grouped date analysis
• Power Query — repeatable cleaning without formulas
• Financial functions — NPV, IRR, PMT, XIRR
• Dashboard building and simple macro automation

Job titles

MIS Executive Accounts & MIS Analyst Reporting Analyst Operations Analyst

' Excel / Google Sheets - the formulas that get asked about in interviews

' 1. Lookup a value from another sheet (modern, safe version)
=XLOOKUP(A2, Customers!$A:$A, Customers!$D:$D, "Not found")

' 2. Conditional total with two criteria
=SUMIFS(Sales[Amount], Sales[Region], $A2, Sales[Month], B$1)

' 3. Count unique customers
=SUMPRODUCT(1/COUNTIF(Sales[Customer], Sales[Customer]))

' 4. Month-on-month growth %
=IFERROR((C2-B2)/B2, "")

' 5. Clean text before analysis
=TRIM(PROPER(CLEAN(A2)))

' Master these five and pivot tables, and Excel stops being a blocker.

SECTION 04Stage 2 — SQL, the independence skill

SQL is what separates a report preparer from an analyst. Once you can query the source system yourself, you stop waiting for extracts and start answering questions the same day.

What you’ll learn

• SELECT, WHERE, ORDER BY on real tables
• JOINs across customers, invoices, payments and products
• GROUP BY, HAVING — the shape of every management report
• CTEs — building a receivables ageing query step by step
• Window functions — running totals, ranks, month‑on‑month change
• Data quality checks — duplicates, orphan rows, date gaps

Job titles

Data Analyst SQL Analyst Finance Analyst BI Analyst

-- SQL: the single most important skill for an analyst
-- Question: which product category earned the most last quarter?

SELECT
    p.category,
    COUNT(DISTINCT o.order_id)      AS orders,
    ROUND(SUM(o.amount), 2)         AS revenue,
    ROUND(AVG(o.amount), 2)         AS avg_order_value
FROM orders o
JOIN products p ON p.product_id = o.product_id
WHERE o.order_date >= '2026-04-01'
  AND o.order_date <  '2026-07-01'
  AND o.status = 'completed'
GROUP BY p.category
HAVING SUM(o.amount) > 100000
ORDER BY revenue DESC
LIMIT 10;

-- If you can read this query, you can already do 40% of an analyst's daily work.

# Python + pandas: clean a messy sales file and answer a business question
import pandas as pd

df = pd.read_csv("sales_2026.csv")

# 1. Clean
df.columns = df.columns.str.strip().str.lower()
df["order_date"] = pd.to_datetime(df["order_date"], errors="coerce")
df["amount"] = pd.to_numeric(df["amount"], errors="coerce")
df = df.dropna(subset=["order_date", "amount"])

# 2. Answer: monthly revenue per region
monthly = (
    df.groupby([df["order_date"].dt.to_period("M"), "region"])["amount"]
      .sum()
      .unstack(fill_value=0)
      .round(0)
)
print(monthly.tail(6))

# 3. Flag the drop that a manager will actually ask about
change = monthly.pct_change().iloc[-1] * 100
print(change[change < -10].sort_values())

SECTION 05Stage 3 — Power BI for management reporting

Finance reporting is the most common Power BI use case in Indian companies, which makes this an unusually good fit for a commerce graduate.

What you’ll learn

• Connecting to Excel, CSV, SQL and folder sources
• Power Query transformations and refresh scheduling
• Data modelling — fact and dimension tables, relationships
• DAX — measures, CALCULATE, YTD and prior‑year comparisons
• Building a P&L or MIS dashboard that ties to the accounts
• Row‑level security for department‑wise access

Job titles

BI Analyst Power BI Developer MIS Manager FP&A Analyst

SECTION 06Stage 4 — Python and AI tools

Python is where commerce graduates often stop, and it is worth pushing through: it is the difference between a ₹6 LPA and a ₹10 LPA analyst profile.

What you’ll learn

• Python basics — variables, loops, functions, files
• pandas — reading dozens of files, cleaning, merging, exporting
• Automating a monthly report end to end
• Basic statistics — variance analysis, trend, correlation
• Using LLM APIs to classify invoice descriptions or customer feedback
• Verifying AI output before it reaches a report

Job titles

Data Analyst Automation Analyst Finance Data Analyst Junior Data Scientist

# Working with an LLM API - the everyday skill in AI-era analytics
import os, json, requests

def classify_feedback(text):
    """Turn free-text customer feedback into structured data."""
    prompt = (
        "Classify the customer feedback below.\n"
        "Return ONLY JSON with keys: sentiment (positive/neutral/negative), "
        "topic (delivery/pricing/quality/support/other), urgent (true/false).\n\n"
        f"Feedback: {text}"
    )
    r = requests.post(
        "https://api.example-llm.com/v1/messages",
        headers={"x-api-key": os.environ["API_KEY"]},
        json={"model": "small-fast", "max_tokens": 200,
              "messages": [{"role": "user", "content": prompt}]},
        timeout=30,
    )
    return json.loads(r.json()["content"][0]["text"])

rows = [classify_feedback(t) for t in open("feedback.txt")]
print(rows[:3])
# 2,000 rows of text become a table you can chart. That is the new analyst workflow.

SECTION 07Roles where a commerce degree is an advantage

These are the teams that specifically prefer a candidate who understands accounts.

SECTION 08Four projects that use your commerce knowledge

Choose projects an interviewer in a finance team will recognise. That is your edge over a generic portfolio.

• Project 1 — P&L dashboard. Take twelve months of transaction data, build a Power BI report with revenue, gross margin, expense heads and variance against budget. Reconcile the totals and say so in the README.
• Project 2 — Receivables ageing and collection risk. Write SQL that buckets invoices by days outstanding, identifies the customers carrying most of the risk, and estimates the cash impact of a 15‑day improvement.
• Project 3 — Sales and discount analysis. Quantify how much margin discounting cost last year, by product and salesperson, and recommend a discount ceiling with the numbers behind it.
• Project 4 — Automated monthly close report. A Python script that reads several raw exports, cleans and merges them, and outputs a formatted Excel pack. Include the before‑and‑after time saving.

SECTION 09Step‑by‑step roadmap — eight months

Written for a B.Com student giving 10 hours a week alongside college or articleship.

1. Month 1: Advanced Excel — lookups, SUMIFS, pivots, Power Query. Deliverable: rebuild a messy workbook into a clean reporting sheet.
2. Month 2–3: SQL — joins through window functions on an invoices and payments schema. Deliverable: Project 2, the receivables ageing analysis. Start applying for MIS roles now.
3. Month 4: Power BI — modelling and DAX. Deliverable: Project 1, the P&L dashboard.
4. Month 5: statistics and analysis thinking — variance, trend, correlation, distribution. Deliverable: Project 3, the discount and margin study.
5. Month 6–7: Python — pandas and automation. Deliverable: Project 4, the automated monthly pack.
6. Month 8: AI tools, portfolio and interviews — LLM‑assisted classification, GitHub tidy‑up, timed SQL practice, and ten applications a week.

SECTION 10Interview Q&A — for commerce graduates

SECTION 11Test yourself — B.Com to analytics readiness

SECTION 12Frequently asked questions

SECTION 13Continue from here