Data Analytics Projects for Final Year Students: 10 Dataset Ideas

Last updated: 13 October 2026 · By the Asuraa Team

Quick answer: Good data analytics projects for final year students use a real public dataset, answer one clear question and end in a written finding. Ten options with free datasets: crop yield by state, city AQI seasons, IPL toss effects, Bengaluru restaurants, monsoon variability since 1901, startup funding, COVID-19 waves, Indian titles on Netflix, India's electricity mix from Our World in Data, and railway network hubs. Python and SQL matter: Asuraa's October 2026 report found them in 35.3% and 20.1% of fresher listings.

Key takeaways

• A strong final year data analytics project answers one clear question with a real dataset and ends in a written finding, not only charts.
• The Rainfall in India dataset on Kaggle covers sub-division monthly rainfall for 115 years from 1901 to 2015, enough for a monsoon variability study.
• The IPL Complete Dataset on Kaggle has been updated through the 2024 season, which lets students test toss and venue effects across many seasons.
• Our World in Data publishes its energy dataset on GitHub with one row per country and year under a CC BY 4.0 licence.
• Asuraa's October 2026 job market report found Python in 35.3% and SQL in 20.1% of fresher listings, so projects should show both.

Which data analytics projects work best for final year students?

The strongest final year data analytics projects use a real Indian or public dataset, answer one clear question, and end in a short written finding, not just a notebook of charts. The ten ideas below each use a dataset you can download today, and each is scoped so a team of two to four students can finish it in one semester.

Pick one that matches your branch or interest: an agriculture-minded team will defend a crop project in the viva far better than a borrowed Netflix analysis.

What does each project involve, step by step?

Each project below lists a goal, four or five steps, what it proves to a recruiter, and an example resume bullet. Replace the bracketed parts with your own results.

1. Crop yield trends by state

Goal: find which states improved yield (production per hectare) for rice and wheat, and which stagnated. Dataset: Crop Production in India.

1. Filter to two or three crops and drop rows with zero or missing area.
2. Compute yield as production divided by area for each state and year.
3. Rank states by change in yield between the first and last five years.
4. Write one paragraph on two states that moved in opposite directions.

What it demonstrates: handling missing values, derived metrics and comparisons across time. Example resume bullet (example only): "Analysed [n] state-year records of Indian crop data in pandas; showed [state] raised rice yield by [x]% while [state] stayed flat."

2. City air quality and seasons

Goal: show how AQI in Delhi, Mumbai, Bengaluru and Chennai changes by season. Dataset: Air Quality Data in India (2015-2020), which has AQI and hourly readings by station and city.

1. Load the city-level daily file and parse dates.
2. Resample to monthly averages and plot one line per city.
3. Count days per city that fall in each AQI category.
4. Compare winter months with monsoon months and explain the gap.

What it demonstrates: time series handling and clear multi-series charts. Example resume bullet (example only): "Built a monthly AQI comparison for four metros from [n] daily readings, showing winter pollution in Delhi averaged [x] times the monsoon level."

3. IPL toss and venue effects

Goal: test whether winning the toss improves the chance of winning at each venue. Dataset: IPL Complete Dataset (2008-2024).

1. Join match-level and ball-by-ball files on match ID.
2. Calculate win rate for toss winners, split by choice to bat or field.
3. Repeat by venue, keeping only venues with enough matches.
4. Chart the venues where the toss mattered most and least.

What it demonstrates: joins, conditional probability and honest sample-size filtering. Example resume bullet (example only): "Joined IPL match and delivery tables across [n] seasons to measure toss impact by venue; found fielding first won [x]% of games at [venue]."

4. Bengaluru restaurant market

Goal: identify under-served cuisine and price combinations in Bengaluru neighbourhoods. Dataset: Zomato Bangalore Restaurants.

1. Clean the rating and cost columns into numbers.
2. Split multi-cuisine strings into one row per cuisine.
3. Count restaurants and average rating by area, cuisine and price band.
4. Flag combinations with high ratings but few outlets.

What it demonstrates: text cleaning and turning analysis into a business recommendation. Example resume bullet (example only): "Segmented [n] Bengaluru restaurants by area, cuisine and cost; identified [x] high-rated, low-supply segments for a hypothetical new outlet."

5. Monsoon variability since 1901

Goal: measure which sub-divisions have the most unreliable monsoon rainfall. Dataset: Rainfall in India, sub-division monthly data for 1901-2015.

1. Sum June to September rainfall per sub-division per year.
2. Compute mean, standard deviation and coefficient of variation.
3. Mark deficit years where rainfall fell well below the long-run mean.
4. Map or rank sub-divisions by variability.

What it demonstrates: descriptive statistics on a century of data. Example resume bullet (example only): "Analysed 115 years of sub-division rainfall; ranked [n] regions by monsoon variability and flagged [x] deficit years."

6. Startup funding concentration

Goal: check how concentrated Indian startup funding is by city and sector. Dataset: Indian Startup Funding.

1. Standardise city names (Bangalore and Bengaluru) and investor names.
2. Convert amount strings to numbers and handle undisclosed rounds.
3. Build a Pareto table of funding share by city and sector.
4. Summarise what share the top few cities take.

What it demonstrates: patient cleaning of messy real-world data, the skill employers test most. Example resume bullet (example only): "Cleaned [n] funding records with inconsistent city and currency fields; showed the top [x] cities took [y]% of disclosed funding."

7. COVID-19 waves by state

Goal: compare the timing and size of COVID-19 waves across states. Dataset: COVID-19 in India.

1. Convert cumulative counts to daily new cases.
2. Apply a seven-day rolling average.
3. Normalise by state population for fair comparison.
4. Identify each state's peak date and plot them side by side.

What it demonstrates: time series transformation and per-capita thinking. Example resume bullet (example only): "Converted cumulative state case counts to 7-day averages per lakh population, showing peaks in [state] lagged [state] by [n] weeks."

8. Indian titles on Netflix

Goal: profile Indian movies and shows on Netflix by genre, rating and year added. Dataset: Netflix Movies and TV Shows.

1. Split the country and genre fields into separate rows.
2. Filter titles listing India.
3. Compare genre mix and maturity ratings with the full catalogue.
4. Plot titles added per year.

What it demonstrates: string parsing and comparison against a baseline. Example resume bullet (example only): "Parsed multi-value genre and country fields for [n] titles; found Indian titles skewed [x] points more towards dramas than the catalogue average."

9. India's electricity mix

Goal: track how India's electricity generation shares changed versus China and Brazil. Dataset: Our World in Data energy data, one row per country and year.

1. Filter to the three countries and the share-of-electricity columns.
2. Reshape from wide to long format.
3. Plot coal, solar and wind shares over two decades.
4. Write three findings with the exact years they refer to.

What it demonstrates: working with a codebook, reshaping and peer benchmarking. Example resume bullet (example only): "Reshaped OWID energy data to compare electricity mix for three countries, showing India's solar share rose from [x]% to [y]% over [n] years."

10. Railway network hubs

Goal: find the stations that connect the most routes. Dataset: Indian Railways Dataset.

1. Load stations and train schedules.
2. Build a graph with stations as nodes and consecutive stops as edges.
3. Compute degree and betweenness with NetworkX.
4. Map the top hubs and compare them with the busiest stations you would expect.

What it demonstrates: geospatial plotting and graph analysis, rare in fresher portfolios. Example resume bullet (example only): "Modelled [n] stations as a graph in NetworkX; ranked junctions by betweenness and mapped the top [x] hubs."

Which tools should final year students use for these projects?

Use Python with pandas for cleaning, SQL for at least one project, and one dashboard tool such as Power BI or Tableau for presentation. Asuraa's October 2026 job market report found Python named in 35.3% of fresher listings and SQL in 20.1%, so showing both in your projects maps directly to what employers ask for. If you are unsure which tool to learn first, the data analyst roadmap for India sets out an order.

How do you turn a data analytics project into a final year report?

Structure the report around the question, not the tools, and keep every chart tied to a finding. A sequence that works for most university formats:

1. Problem statement: one paragraph on who cares about the question and why.
2. Data: source link, licence, rows, columns and known gaps.
3. Method: cleaning steps, metrics defined in plain words, tools used.
4. Findings: three to five results, each with one chart.
5. Limitations: what the data cannot tell you.
6. Next steps: what you would do with more time or data.

The same structure becomes a strong GitHub README. The projects and portfolio guide for India covers how to present it beyond your college submission.

What do most guides on data analytics projects get wrong?

Most lists treat the dataset as the project, but recruiters judge the question you asked and the decision your answer supports. Two students can both analyse the Zomato data; the one who ends with "open a mid-priced South Indian outlet in [area]" and shows why will be remembered.

A second mistake is choosing a dataset that is too clean. Pre-cleaned competition files hide the work analysts spend most of their time on. Projects 6 and 7 above are useful precisely because the raw files need fixing first.

Finally, many guides suggest ten small projects. Two or three finished projects with a written summary, a clean repository and a short video walkthrough say more than ten half-done notebooks.

How should you show these projects to recruiters?

Publish each project as a GitHub repository with a README, a cleaned data script and one summary chart, then link the best two from your resume. The step-by-step guide on how to build a portfolio for jobs explains the layout, and how to list projects on a resume covers wording. Before you apply, run your resume through the Asuraa resume reviewer against a real analyst job description to see whether your project bullets use the skills that listing asks for.

Related guides

• Projects and Portfolio Guide for Freshers: Data, Software and AI
• Data Analyst Projects for Your Resume: 8 Ideas and How to Present Them
• SQL Projects for a Data Portfolio: 6 Projects With Free Datasets
• Python Projects for Freshers: 8 Resume-Ready Ideas by Level

FAQ

Which data analytics project is best for a final year student in India?

The best project is one you can defend in the viva and connect to your interests. Agriculture or environment-minded students do well with crop yield or monsoon rainfall analysis; business-minded students with startup funding or Bengaluru restaurant data. Choose a dataset with some messiness, a clear question and a finding that would change a decision.

Where can I find free datasets for a data analytics project?

Kaggle hosts many Indian datasets such as Crop Production in India, Air Quality Data in India 2015-2020 and Rainfall in India 1901-2015. Our World in Data publishes energy and emissions data on GitHub under CC BY 4.0, and the World Bank and data.gov.in publish official indicators. Always note the source and licence in your report.

How many projects should a final year student put on a resume?

Two or three finished projects are enough for a fresher data analyst resume. Each should have a GitHub repository with a README, a cleaning script, a summary of findings and one or two charts. Depth beats volume: a recruiter will open one link, so make the first project listed your strongest and most relevant to the role.

Should a data analytics final year project use Python or Excel?

Use Python with pandas for cleaning and analysis, and add SQL and a dashboard tool if you can. Excel works for small datasets but struggles with files like hourly air quality readings. Asuraa's October 2026 job market report found Python in 35.3% and SQL in 20.1% of fresher listings, so showing both helps.

How do I write a data analytics project on my resume?

Write one or two bullets per project that name the dataset size, the tools, the method and a specific finding. For example: Analysed [n] state-year crop records in pandas and showed [state] raised rice yield by [x]%. Replace the brackets with your real numbers and never invent results you did not find.

Is a Kaggle dataset acceptable for a final year project?

Yes, as long as you credit the source, check the licence and add your own question and analysis. Examiners and recruiters care about what you did with the data. Choosing a less common dataset, such as the Indian Railways or startup funding files, also helps your project stand out from copied notebooks.

Final thoughts

Pick one project that fits your interests, finish it properly with a written finding, and only then start a second. A semester spent on two well-documented projects beats a folder of copied notebooks. When your bullets are ready, map the skills you still need with the Asuraa career path planner.