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
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
Materials and tools
- Computer with Python and pandas, or a spreadsheet
- One public dataset of at least 1,000 rows
Tools and software
Step-by-step roadmap
Start
You will finish with: a notebook or report with five charts, five findings and a limitations section.
- 1
Prerequisites
Know this first: basic Python or spreadsheet skills. Then collect the 2 items in the materials list.
- 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
- 3
Plan
Write the research question, who or what you will study, how many, and the exact questions or measures.
- 4
Build
- Choose a dataset on a topic you care about and read its documentation.
- Check for missing values, duplicates and odd entries.
- Write five questions you want to answer.
- Answer each with one table or chart.
- Write a one-sentence finding under each chart.
- End with what the data cannot tell you.
- 5
Test
Ask a friend to read only the charts and captions; they should be able to state your findings.
- 6
Document
Keep the raw responses or data safe, anonymise names, and build the tables and charts. Report structure
- 7
Present
State the question, the method in one line, the two or three main findings and their limits. Presentation structure · Viva questions
- 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
- BasicDo it in a spreadsheet with pivot tables and three questions.
- This projectExplore a dataset and tell its story
- AdvancedAdd a statistical test for one comparison and an interactive dashboard.
- ResearchCombine two datasets (for example air quality and traffic) and test one specific hypothesis.
- 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).
Use this as the outline of your README or case study.
- Problem
- Exploratory analysis is the core skill of data work: load data, check it, summarise it and find what is interesting.
- Why it matters
- A clear notebook that asks good questions is the most common entry-level portfolio piece, and it needs no advanced mathematics.
- What was built
- A notebook or report with five charts, five findings and a limitations section.
- Technology
- Matplotlib, pandas, Python
- Architecture
- You write thisOne diagram: the parts and how data moves between them.
- Implementation
- You write thisThe 6 build steps in your own words, with one code or design decision you are proud of.
- Challenges
- You write thisThe hardest bug or decision, and how you got past it.
- Results
- Ask a friend to read only the charts and captions; they should be able to state your findings.
- Demo and code
- You write thisA link to a live demo or a short video, and to the GitHub repository.
- Lessons learned
- You write thisWhat you would do differently next time.
- Future improvements
- Add a statistical test for one comparison and an interactive dashboard.
Working as a team
Solo or up to 2. Suggested roles:
Report and presentation
Report structure
- Title
- Abstract
- Introduction and research question
- Review of what is already known
- Method: sample, tools, procedure
- Findings (tables and charts)
- Discussion
- Limitations
- Conclusion and suggestions
- References
- Annexure: questionnaire or data
Presentation structure
- Research question
- Why it matters
- Method and sample
- Finding 1
- Finding 2
- Finding 3
- What it means
- Limitations
- 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 + Statistics and Probability
Test whether a coin or die is fair with statistics
Roll a die 300 times and test whether the results fit a fair die.
Data · Data Visualization
Visualise your own screen time for a month
Log your phone's screen-time figures daily and find your patterns.
Data · Data Engineering
Clean a messy real-world dataset
Take a messy government dataset and produce a clean, documented version with a script.
Data + EdTech and Study Tools
Visualise how a sorting or search algorithm works
Animate bars being sorted so a learner can see each comparison and swap.
Same tools
Programming · Python
Build a Snake game
Program the classic Snake with scoring, growing length and game over.
Cybersecurity + Pure Mathematics
Implement classic ciphers and break them
Write Caesar and substitution ciphers, then crack them with frequency analysis.
Cybersecurity · Authentication
Build a password strength checker
Score a password's strength, explain why, and estimate how long it would take to guess.
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.
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.
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.
Environmental Science + Data
Analyse 50 years of your city's temperature data
Download long-term temperature records and test whether your city has warmed, and by how much.
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.
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.
Artificial Intelligence · NLP
Build a rule-based chatbot for school FAQs
Answer common questions about your school with keyword matching and a fallback reply.
Programming · Python
Build a calculator with a graphical interface
Make a desktop calculator with buttons, a display and keyboard support.
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.