A DU student's two-year plan into data analytics

Why your stream is not the obstacle

Analyst roles are filled by graduates from commerce, economics, statistics, mathematics, the sciences, and increasingly the humanities. What an interviewer tests is whether you can take a messy table, answer a business question with it, and say what the answer means. Your subject gives you the second half of that, the "what it means" part, which many engineering graduates struggle with.

A BCom student already understands ledgers and ratios. An economics student has seen indices, sampling and regression. A psychology student has run surveys and knows what a biased question looks like. A history or political science student knows how to judge a source. Name that strength early and pick projects that use it.

The four-semester map

This assumes you have two years left, for example the third and fourth years of a four-year programme, or the final two years of a three-year one. Shift it if you are earlier.

The hours are guidance for a student carrying a full academic load. Exam months will cut into them; plan for that instead of feeling guilty about it.

Three projects that come from your own degree

Generic projects (a Titanic survival model, a Netflix dashboard) are everywhere and prove little. A project built on your subject shows you can apply analysis to something you understand. Examples by stream:

• Commerce: take published annual reports of three listed companies in one sector, build ratio tables in a spreadsheet, and explain which moved and why.
• Economics: use a public price-index or employment dataset from an official Indian source and show a trend by state, with a short note on what the data cannot tell you.
• Sciences: clean and analyse your own lab or practical readings, with a clear note on measurement error.
• Humanities and social sciences: design a short survey for a college society, collect responses with consent, and report results with the limits of a small, non-random sample.

For each, write a README: the question, the data source, what you did, the answer, and one thing you would do differently. That README is what you will talk through in an interview.

Using your college's calendar instead of fighting it

• Societies and fests. Volunteer to handle registrations, budgets or feedback forms for a society. That produces real data and a real stakeholder. "Built the registration tracker for our department fest and reported footfall by event" is a better resume line than most online certificates.
• Placement cell. Many DU colleges have one. Register early, read which roles recruited last year, and ask what tests they used.
• Internships. The AICTE National Internship Portal at internship.aicte-india.org is free and open to students of UGC institutions as well as AICTE ones. It warns that paying an agent for an internship is a scam. Our guide to data internships in Delhi NCR covers other official portals and red flags.

What to do if you are already in your final year

Compress the plan: spreadsheets and SQL together in the first three months, one strong project, then a BI tool and interview practice. Skip Python until SQL is solid; analysts are far more often tested on SQL than on Python in entry-level screening. Use the free skill check to compare your current resume with an analyst job description and see which gaps matter most.

Deciding between analyst and data scientist

If statistics and modelling excite you more than business reporting, you may be heading towards data science rather than analytics. The difference is explained in data analytics versus data science. The skills in semesters 1 and 2 above are shared by both paths, so you lose nothing by starting here and deciding later.

Where a structured course fits

A student who follows this plan alone can get a long way. What self-study usually lacks is someone reviewing your SQL, telling you which dashboard design misleads, and running mock interviews. That review is what the Data Analyst programme adds over 3–4 months. Classes are live online, so they can sit alongside a college timetable, and the in-person lab days in Noida are optional. Ask a counsellor for batch dates and current fees before planning around it.