Many working data analysts studied commerce, economics, statistics, management, science or humanities. Analytics is about answering business questions with data, and plenty of that knowledge comes from outside computer science.
Your background is an advantage
- Commerce and finance graduates understand revenue, cost, margin, receivables and financial statements. That is half the battle in finance, banking and insurance analytics.
- Economics graduates already think in terms of incentives, demand, trends and cause and effect.
- Statistics and maths graduates have the foundation many self-taught analysts lack.
- Science graduates are used to experiments, measurement and careful observation.
- Humanities and management graduates often communicate better than technical candidates, and communication is a large part of the job.
Lead with this in interviews: "I understand the business side; I have added the data skills."
What to learn, in order
- Excel properly: lookups, pivot tables, conditional formulas and charts.
- SQL: the most important technical skill for analyst jobs, and very beginner-friendly.
- A dashboard tool: Power BI is a common choice.
- Basic statistics: averages, spread, percentiles, correlation.
- Python with pandas: after you are comfortable with SQL.
You do not need data structures and algorithms, web development or advanced mathematics for analyst roles.
Common worries
"I have never coded before"
SQL reads almost like English: select these columns, from this table, where this condition holds. Start with tiny queries and build up. Most people find SQL easier than they expected.
"Companies want B.Tech candidates"
Some do. Many analyst roles accept any graduate with the right skills, and the skills are what the online test and interview check. A strong project portfolio helps you get past resume filters.
"I am too late, everyone else started earlier"
Analytics rewards steady practice and business understanding, not early starts. Focus on finishing things: questions solved, projects completed.
How to prove yourself
- Solve SQL practice questions regularly and keep a record.
- Complete two or three projects in a domain you understand. A commerce graduate doing a banking or insurance project can talk about it with real confidence.
- Put the projects on GitHub and your resume using the format in how to put projects on a resume.
A first step today
Open the SQL practice track and solve five questions on SELECT and WHERE. Small, consistent steps are the whole strategy.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: