Operations, HR and Supply Chain + Data
Analyse sales data to find what sells and when
Use a public retail dataset to find top products, peak days and seasonal patterns.
- DifficultyIntermediate
- Estimated time1–2 weeks
- Budget₹0
- ClassClass 12 to college
- TeamSolo or up to 2
- You needComputer only
Prerequisites: None beyond your class work
Original · by TechnifyedBusiness ProjectData AnalysisFree to doComputer onlyResearch orientedTwo subjects
Overview
Use a public retail dataset to find top products, peak days and seasonal patterns.
Skills you will use
Materials and tools
- A public retail sales dataset
- Spreadsheet
Tools and software
Step-by-step roadmap
Start
You will finish with: a short analysis with charts and three recommendations.
- 1
Prerequisites
Nothing special to know first. Then collect the 2 items in the materials list.
- 2
Learn
Read up on business analytics: public-data, sales analysis, trends. Your textbook chapter and one short video are enough.
- 3
Plan
Write the research question, who or what you will study, how many, and the exact questions or measures.
- 4
Build
- Load the data and check it.
- Find the top ten products by revenue and by units.
- Chart sales by day of week and month.
- Find the share of revenue from the top 20 percent of products.
- Write three recommendations for the store.
- 5
Test
Check a sample of your data by hand, and ask whether another explanation fits your findings equally well.
- 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
- 8
Publish
Share a short paper or poster; offer a summary to the people who took part.
Expected outcome
A short analysis with charts and three recommendations.
Other versions of this project
Advanced version
Forecast next month's sales with a moving average.
Research mode
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
- You write thisDescribe the method in enough detail that someone else could repeat it: sample, tools, procedure.
- 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:
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
Prepare your own answers to these before you present.
- What is the aim of your project, in one sentence?
- What is the principle behind it?
- Why did you choose these materials or tools?
- What result did you get, and was it what you expected?
- What went wrong and how did you fix it?
- How could this be improved or used in real life?
Resources
Decision making with spreadsheetIIT Roorkee · Free course course
33 Spreadsheet Projects Course for Beginners – Excel and Google SheetsfreeCodeCamp · Free video course
Analyzing Spreadsheet Data with PythonIBM · Free course courseLibreOfficelibreoffice.orgOpen Government Data Platform Indiadata.gov.inKaggle datasetskaggle.comSource 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 Operations, HR and Supply Chain projects
Operations, HR and Supply Chain + Data
Create a business dashboard for a small enterprise
Turn a shop's sales register into a one-page monthly dashboard the owner can read in a minute.
Operations, HR and Supply Chain + Psychology
Measure employee or student motivation with a survey
Test Herzberg's two-factor theory with a survey of 40 working people or students.
Operations, HR and Supply Chain · Human Resources
Study recruitment and selection in an organisation
Map how one organisation hires people and compare it with textbook practice.
Operations, HR and Supply Chain · Operations
Improve stock management in a small shop
Record a shop's sales for two weeks, classify items and set reorder levels.
Same tools
Accountancy · Ratio Analysis
Analyse the annual report of a listed company
Compute liquidity, profitability and solvency ratios for a company over five years and explain the trends.
Political Science · Elections
Analyse election results in your constituency
Use official results from three elections to chart turnout, vote share and margins.
Applied Mathematics + Sociology
Model the spread of a rumour
Build a logistic model of how a rumour spreads through a school and test it with a class game.
Macroeconomics · Growth
Analyse your country's growth over 30 years
Chart GDP growth, sector shares and income per person, and explain three turning points.
Two-subject alternatives
Graphic and UI/UX Design + Marketing
Create a brand identity for a local business
Design a logo, colours, type and three applications for a real shop or café.
Industrial and Manufacturing + Operations, HR and Supply Chain
Analyse and reduce waiting time at the canteen
Time each step of the canteen queue, find the bottleneck and test one improvement.
Data + Operations, HR and Supply Chain
Build a sales dashboard
Turn a public retail dataset into a one-page dashboard that answers a manager's questions.
Artificial Intelligence + Marketing
Cluster customers into groups
Group customers by spending behaviour with k-means and describe each group in plain words.
Same difficulty and budget
Entrepreneurship + Mechanical Engineering
Design a business around a science fair invention
Take a working model you have built and work out who would buy it, at what price and at what cost.
Marketing · Market Research
Do market research for a new product idea
Test a product concept with 60 people and decide whether it is worth launching.
Business Studies · International Business
Compare how a product is sold in two countries
Study how one global brand changes its product, price and advertising between two countries.
Accountancy · Accounting Technology
Compare manual and software accounting
Enter the same month of transactions by hand and in free accounting software and compare time and errors.