How to get hired
Data analyst hiring is test-first. Most employers send a timed assessment before anyone reads your CV properly, so the fastest way in is to be very good at the three things they test and to show one or two dashboards you made yourself.
The three entry points
MIS Executive. The most underrated first job. Banks, NBFCs, logistics firms, hospitals and manufacturers all need someone to pull daily numbers into Excel reports: collections by branch, dispatches by plant, claims by TPA. The pay starts modest, but you learn how a business actually runs, and moving from "MIS Executive" to "Data Analyst" within two years is common if you add SQL and Power BI.
Analytics KPOs and captive centres. Firms that do analytics for overseas banks, insurers and retailers hire graduates in batches as Analyst or Associate – Analytics. They test aptitude, Excel and SQL, and often a guesstimate ("How many two-wheelers are sold in Pune in a month?"). Training is structured, which helps if you are from a non-tech background.
In-house analyst at a company. E-commerce, fintech, quick commerce and consumer brands hire Data Analysts and Business Analysts (in the Amazon sense: SQL plus Excel plus business sense). These roles usually want a year or two of experience, so freshers get in through internships or referrals.
What the tests check
- Excel: XLOOKUP or INDEX-MATCH, pivot tables, SUMIFS, conditional formatting, removing duplicates, and doing it fast without a mouse.
- SQL: joins (including what a LEFT JOIN does to row counts), GROUP BY with HAVING, window functions like ROW_NUMBER and running totals, and "find the second-highest salary in each department".
- Power BI or Tableau: a take-home where you get a CSV and 24 to 48 hours to build a dashboard and write three insights. They read the insights more carefully than the colours.
- Business sense: "Orders are up but revenue is flat. What would you check?" They want you to think of average order value, discounts, returns and the mix of categories before you touch a tool.
Portfolio
Two dashboards on real Indian data are enough. Ideas that work: state-wise GST collections, RBI's DBIE series on credit growth, district rainfall versus crop output from data.gov.in, or your own family shop's sales if they will let you. Publish on Power BI's public web view or Tableau Public, and put the link at the top of your CV with one line on what you found.
Certification
Microsoft's PL-300 (Power BI Data Analyst Associate) is the one employers name most. It is a 100-minute proctored exam; the fee depends on the country you sit it in, and renewal each year is a free online assessment. It won't replace the test, but it gets your CV past keyword filters.
First titles
MIS Executive, Junior Data Analyst, Data Analyst, Analyst, Associate – Analytics, Reporting Analyst, Power BI Developer (once you have a year of dashboards behind you).
A day as an analyst
Expect a morning of fixing yesterday's report because a source file changed format, a few ad-hoc requests from managers ("Can you pull sales by region for last Diwali versus this one?"), and real analysis squeezed in between. Month-end and quarter-end are heavy. Some analytics KPOs that support US or UK clients run afternoon or late shifts.
The ladder: Analyst, Senior Analyst, Lead or Assistant Manager, Manager – Analytics. People also branch into data engineering (if they love SQL and pipelines), data science (if they love statistics) or product analytics. The biggest pay jump usually comes with the first switch after two or three years, especially from MIS into an analytics team.