technifyed

Data · Data Analytics

Explore a dataset and tell its story

Pick a public dataset, ask five questions of it and answer each with a chart.

  • DifficultyEasy
  • Estimated time2–7 days
  • Budget₹0
  • ClassClass 10 to college
  • TeamSolo or up to 2
  • You needComputer only

Prerequisites: Basic Python or spreadsheet skills

Original · by TechnifyedData AnalysisPortfolio ProjectBeginner friendlyFree to doComputer onlyResearch orientedPortfolio focusedWell documented

My projects

Overview

Exploratory analysis is the core skill of data work: load data, check it, summarise it and find what is interesting. Any public dataset works, whether on cricket, films, air quality or exam results.

Why build this?

A clear notebook that asks good questions is the most common entry-level portfolio piece, and it needs no advanced mathematics.

What you will learn

  • How to load and clean a table
  • How to summarise with groups and averages
  • How to pick a chart for each question
  • How to write a finding in one sentence

Skills you will use

Choosing the right chartData cleaningSummary statistics

Materials and tools

  • Computer with Python and pandas, or a spreadsheet
  • One public dataset of at least 1,000 rows

Tools and software

MatplotlibpandasPython

Expected cost₹0Nothing to buy
Estimated duration2–7 days6 build steps, plus the report

Step-by-step roadmap

  1. Start

    You will finish with: a notebook or report with five charts, five findings and a limitations section.

  2. 1

    Prerequisites

    Know this first: basic Python or spreadsheet skills. Then collect the 2 items in the materials list.

  3. 2

    Learn

    • How to load and clean a table
    • How to summarise with groups and averages
    • How to pick a chart for each question
    • How to write a finding in one sentence
  4. 3

    Plan

    Write the research question, who or what you will study, how many, and the exact questions or measures.

  5. 4

    Build

    1. Choose a dataset on a topic you care about and read its documentation.
    2. Check for missing values, duplicates and odd entries.
    3. Write five questions you want to answer.
    4. Answer each with one table or chart.
    5. Write a one-sentence finding under each chart.
    6. End with what the data cannot tell you.
  6. 5

    Test

    Ask a friend to read only the charts and captions; they should be able to state your findings.

  7. 6

    Document

    Keep the raw responses or data safe, anonymise names, and build the tables and charts. Report structure

  8. 7

    Present

    State the question, the method in one line, the two or three main findings and their limits. Presentation structure · Viva questions

  9. 8

    Publish

    Share a short paper or poster; offer a summary to the people who took part.

Expected outcome

A notebook or report with five charts, five findings and a limitations section.

Other versions of this project

Beginner version

Do it in a spreadsheet with pivot tables and three questions.

Advanced version

Add a statistical test for one comparison and an interactive dashboard.

Research version

Combine two datasets (for example air quality and traffic) and test one specific hypothesis.

Portfolio version

Publish the notebook on GitHub with a short README summarising the story.

Make this project better

  1. BasicDo it in a spreadsheet with pivot tables and three questions.
  2. This projectExplore a dataset and tell its story
  3. AdvancedAdd a statistical test for one comparison and an interactive dashboard.
  4. ResearchCombine two datasets (for example air quality and traffic) and test one specific hypothesis.
  5. PortfolioPublish the notebook on GitHub with a short README summarising the story.

Ways to do this project

Text marked "You write this" is a prompt for your own work; everything else is specific to this project.

Research question
You write thisOne question you can answer with data, narrow enough to finish in the time you have.
Hypothesis
You write thisWhat you expect to find, and why.
Variables
You write thisWhat you change or compare, what you measure, and what you hold constant.
Methodology
Combine two datasets (for example air quality and traffic) and test one specific hypothesis.
Data collection
You write thisSay what you will record, how many times, and how you will keep the records safe.
Analysis
You write thisChoose the table, chart or test that answers the question; report averages with their spread.
Limitations
You write thisList what could have affected the result: small sample, instrument limits, things you could not control.

Literature review

Find five to eight sources (your textbook, review articles, reports) and note what each says about your question. Group them by idea, not one after another, and end with what is still not known.

References

List every source you used in one style throughout (author, year, title, where it was published, link and the date you opened it).

Working as a team

Solo or up to 2. Suggested roles:

Research and readingData collectionAnalysisWritingPresentation

Report and presentation

Report structure

  1. Title
  2. Abstract
  3. Introduction and research question
  4. Review of what is already known
  5. Method: sample, tools, procedure
  6. Findings (tables and charts)
  7. Discussion
  8. Limitations
  9. Conclusion and suggestions
  10. References
  11. Annexure: questionnaire or data

Presentation structure

  1. Research question
  2. Why it matters
  3. Method and sample
  4. Finding 1
  5. Finding 2
  6. Finding 3
  7. What it means
  8. Limitations
  9. Conclusion

Viva questions

Try answering before you open each one.

How did you handle missing values?

Explain what you removed or filled and why.

Why did you choose that chart?

Match the chart to the question: comparison, trend, distribution or relationship.

What is the difference between mean and median?

The median is the middle value and is less affected by extremes.

What can your data not tell you?

Name one limit, such as correlation not proving cause.

Resources

Source and attribution

Original

Written by Technifyed. Free to use for your own school or college project; write the report in your own words. Added 1 Oct 2026.

Similar projects

More Data projects

Data · Data Engineering

Clean a messy real-world dataset

Take a messy government dataset and produce a clean, documented version with a script.

  • Intermediate
  • 2–7 days
  • Free
Data Analysis · Computer onlyView

Same tools

Programming · Python

Build a Snake game

Program the classic Snake with scoring, growing length and game over.

  • Easy
  • 2–7 days
  • Free
Game · Computer onlyView

Cybersecurity + Pure Mathematics

Implement classic ciphers and break them

Write Caesar and substitution ciphers, then crack them with frequency analysis.

  • Easy
  • 2–7 days
  • Free
Software Project · Computer onlyView

Cybersecurity · Authentication

Build a password strength checker

Score a password's strength, explain why, and estimate how long it would take to guess.

  • Easy
  • 2–7 days
  • Free
Software Project · Computer onlyView

Programming · Python

Make a to-do list app that saves to a file

Build a command-line task manager that adds, completes, deletes and saves tasks between runs.

  • Easy
  • 2–7 days
  • Free
Software Project · Computer onlyView

Two-subject alternatives

Earth Science + Data

Map earthquakes from live data

Download a month of world earthquakes and show that they trace the plate boundaries.

  • Intermediate
  • 2–7 days
  • Free
Data Analysis · Computer onlyView

Literature and English + Data

Analyse word use in a novel with a computer

Count words and character mentions in a public-domain novel and see what the numbers reveal.

  • Intermediate
  • 1–2 weeks
  • Free
Data Analysis · Computer onlyView

Electronics and Communication + Data

Filter noise from an audio recording

Record speech with a hum, find the hum's frequency and remove it with a digital filter.

  • Intermediate
  • 1–2 weeks
  • Free
Software Project · Computer onlyView

Same difficulty and budget

Programming · Python

Automate a boring task with a script

Write a script that renames and sorts a messy folder of files by type and date.

  • Easy
  • 2–7 days
  • Free
Software Project · Computer onlyView

Artificial Intelligence · NLP

Build a rule-based chatbot for school FAQs

Answer common questions about your school with keyword matching and a fallback reply.

  • Easy
  • 2–7 days
  • Free
Software Project · Computer onlyView

Software Development · Frontend

Make a personal portfolio website

Design and publish a fast, mobile-friendly site that shows who you are and what you have built.

  • Easy
  • 2–7 days
  • Free
Web App · Computer onlyView

Enter your email and the official page opens. Phone is optional.