Non-IT Background? How to Become a Data Analyst in 6 Months

From B.Com, BA, BBA or B.Sc? Follow this 6-month plan to become a data analyst from a non-IT background, with month-wise skills, projects and job tips.

18 Nov 2026 · 8 min read · Brillica Services
Non-IT Background_ How to Become a Data Analyst in 6 Months
18 Nov 2026

If you studied commerce, arts, management or science and keep hearing that "data analytics is the future", you have probably asked yourself one question: can someone from a non-IT background really become a data analyst?

The short answer is yes. Data analytics is one of the few tech careers where your degree matters less than what you can actually do with data. Companies hire analysts who can clean a messy spreadsheet, write a clean SQL query, build a dashboard a manager understands, and explain what the numbers mean. None of that needs an engineering degree.

This guide is written specifically for non-IT students and working professionals. It covers what you already bring to the table, what you need to learn, and a realistic month-by-month plan to become job-ready in about 6 months.

Why Non-IT Students Make Good Data Analysts

Most people assume IT graduates have a head start. In coding, maybe. But data analysis is about understanding the business as much as handling tools, and that is where non-IT backgrounds shine.

Your Background

What You Already Bring

Where It Helps in Analytics

B.Com / Accounting

Financial statements, ratios, Tally/Excel basics

Finance, banking, FP&A and MIS analyst roles

BBA / MBA

Marketing, HR and operations concepts

Business analyst, marketing analytics, sales reporting

BA (Economics, Psychology, etc.)

Research, surveys, critical thinking

Market research, customer insights, policy data

B.Sc (Maths, Stats, Biology)

Statistics, scientific method

Healthcare analytics, research and statistical analysis

Working professional (sales, ops, support)

Real industry knowledge

Domain analyst roles in your own industry

An analyst who understands why sales dropped is more valuable than one who can only produce the chart. Your background is an advantage. Use it.

What You Actually Need to Learn

You do not need to become a software developer. A job-ready data analyst usually needs these five skills:

  • Advanced Excel: formulas, lookups, PivotTables, data cleaning and basic dashboards. Read our guide on using Advanced Excel for data analytics.

  • SQL: pulling and filtering data from databases. It is simpler than most people expect, close to writing structured English.

  • Power BI or Tableau: turning data into interactive dashboards.

  • Basic statistics: averages, distributions, correlation and simple trend analysis.

  • Python (basics): Pandas for cleaning and analysing larger datasets. Useful, but it comes later in the plan.

Not sure which tool to start with? See Excel vs Power BI vs SQL: what a beginner should learn first.

The 6-Month Plan for Non-IT Beginners

This plan assumes 2–3 hours of focused learning a day. Working professionals with less time can stretch each phase a little. The order matters: it starts with tools that feel familiar and builds towards coding only once your confidence is up.

Month 1: Excel and Data Thinking

  • Master formulas: IF, SUMIFS, COUNTIFS, XLOOKUP/VLOOKUP, TEXT and DATE functions

  • Learn data cleaning: removing duplicates, fixing formats, handling blanks

  • Build PivotTables and PivotCharts

  • Start asking questions of data: "Which product sells most?", "Which month is weakest?"

Milestone: A simple sales report in Excel built from a raw dataset.

Month 2: Statistics and Excel Dashboards

  • Mean, median, mode, standard deviation and percentiles, explained practically

  • Correlation vs causation, plus spotting outliers

  • Build an interactive Excel dashboard with slicers

Milestone: A one-page dashboard you can explain to a non-technical person.

Month 3: SQL

  • SELECT, WHERE, ORDER BY, GROUP BY and HAVING

  • JOINs: combining customer, order and product tables

  • Subqueries and basic window functions

  • Practise on real-style business datasets every day

Milestone: Answer 20 business questions using SQL queries alone.

Month 4: Power BI

  • Importing and transforming data with Power Query

  • Data modelling and relationships

  • DAX basics: measures, CALCULATE and time intelligence

  • Designing clean, readable reports

Milestone: A complete Power BI dashboard connected to a SQL or Excel source.

Month 5: Python Basics and AI Tools

  • Python fundamentals: variables, lists, loops and functions

  • Pandas for cleaning and analysing data, and Matplotlib for charts

  • Using AI tools such as ChatGPT and Copilot to speed up analysis and to explain code and errors

Milestone: Clean and analyse a dataset in a Jupyter notebook.

Month 6: Portfolio, Resume and Interviews

  • Build 3–4 portfolio projects (see below)

  • Rewrite your resume as an analyst, not as your old role

  • Optimise your LinkedIn profile and publish your projects

  • Practise interview questions and mock interviews

Milestone: Start applying for internships and junior analyst roles.

Portfolio Tip: Use Your Background as Your Edge

The biggest mistake non-IT learners make is building the same generic projects as everyone else. Instead, pick projects from the domain you already know. It makes your portfolio stand out and gives you a better story in interviews.

  • B.Com: expense analysis, profitability dashboard, GST or invoice data analysis

  • BBA / MBA: marketing campaign performance, HR attrition analysis, sales funnel dashboard

  • BA: survey analysis, census or social data insights

  • B.Sc: healthcare or patient data analysis, experiment result analysis

  • Working professionals: a real (anonymised) problem from your current job

For more ideas, see our list of top data analytics portfolio projects.

Common Myths That Stop Non-IT Students

"I'm bad at maths, so I can't do analytics."

Day-to-day analytics needs school-level maths and basic statistics. If you can calculate percentages and averages, you can learn the rest.

"I need to be good at coding first."

No. Excel, SQL and Power BI cover most entry-level analyst work. Python comes later, and AI tools now make learning it far easier.

"Companies only hire B.Tech graduates."

Many analyst job listings ask for "any graduate" with the right skills. Recruiters look at your projects, your tools and how you explain your work.

"I'm too old to switch careers."

Career switchers with industry experience are often preferred for domain analyst roles because they understand the business from day one.

How to Present Yourself to Recruiters

  • Lead with skills, not your degree: put a "Technical Skills" section and a "Projects" section at the top of your resume.

  • Reframe past experience: "Prepared monthly sales reports for 5 regions" is analytics experience. Say so.

  • Show, don't tell: link your Power BI dashboards and GitHub or portfolio in your resume and LinkedIn.

  • Prepare your switch story: a clear 30-second answer to "Why data analytics?" builds instant credibility.

Get ready for interviews with our data analyst interview questions with answers.

Self-Learning vs a Structured Course

You can learn everything above for free online, and some people do. But most non-IT learners struggle with three things: knowing what to learn in what order, getting stuck with no one to ask, and turning skills into an actual job.

A structured course with live mentors, real projects and placement support solves all three. That is especially valuable when you are switching fields and cannot afford to spend a year figuring it out alone.

Start Your Data Analytics Journey with Brillica Services

Brillica Services' Advanced Data Analytics Course in Dehradun is a 6-month program designed for beginners, including students and professionals from non-IT backgrounds. You learn Excel, SQL, Power BI, Python and AI tools through hands-on projects, with mentor guidance and placement support.

  • Beginner-friendly curriculum, no coding background needed

  • Live, practical classes with real business datasets

  • Portfolio projects, resume building and mock interviews

  • Placement support to help you land your first analyst role

Prefer Delhi or online? Explore our Data Analytics Course in Delhi (Tagore Garden) or the Data Analytics Online Course.

Not sure if data analytics is right for you? Book a free career counselling session. Call 088821 40688 or visit our Dehradun or Delhi centre to talk to a counsellor and see a live class before you decide.

Conclusion

A non-IT background is not a barrier to a data analytics career. It can be your biggest strength. With a clear 6-month plan, consistent practice and projects built around what you already know, you can move from "I'm not technical" to "I'm a data analyst." The best time to start is now.

Frequently Asked Questions

Can a non-IT student become a data analyst?

Yes. Students from B.Com, BA, BBA, B.Sc and other non-IT backgrounds regularly become data analysts. Employers focus on practical skills like Excel, SQL and Power BI, plus a strong project portfolio, more than on a technical degree.

Is 6 months enough to become a data analyst?

For most beginners, 6 months of consistent, structured learning (2–3 hours a day) is enough to learn the core tools, build a portfolio and start applying for internships and junior analyst roles.

Do I need coding to become a data analyst?

Not at the start. Excel, SQL and Power BI cover most entry-level work. Basic Python is helpful and can be learned later in your journey, and AI tools make it easier.

Is data analytics hard for commerce or arts students?

No. Data analytics uses school-level maths and basic statistics. Commerce and arts students often do well because they understand business, finance and research, which helps them interpret data.

Which data analyst jobs suit non-IT graduates?

Popular entry roles include MIS executive, junior data analyst, business analyst, reporting analyst, marketing analyst and finance or operations analyst, especially in the industry you already know.

Does Brillica Services offer data analytics courses for non-IT students?

Yes. Brillica Services offers beginner-friendly data analytics courses in Dehradun, Delhi and online, with hands-on projects and placement support. You can book a free counselling session by calling 088821 40688.

Want to learn this with mentors, projects and placement support? See the Agentic AI program →

Not sure which course fits you?

Book a free 20-minute call with a Brillica career expert. Get a personalised roadmap, batch dates and an EMI plan.

WhatsApp us