Assessfy Foundation Projects Lab Beginner 5 milestones 100 marks

Track Your Spending: A Beginner's Data Analysis Project

Discipline: Data Analysis Level: Foundation Industry: Analytics Function: Business Analytics Team: up to 3 Assessment: 5 milestones (100 marks)

Real-world project · AICTE-aligned · AI-graded · Audit-ready certificate

Enroll as Student Mentor this project

Milestones

Available mentors

Enrolled students

Core skills

About this project

What you'll build: You'll create a simple analysis of your own bank-statement CSV file, discovering how much you spend in different categories (like food, transport, entertainment) each month. You'll use easy tools to explore and visualize your spending habits.

Why it's a good starter: This project uses your real-life data, making it relevant and interesting. The steps are clear and manageable, focusing on basic data handling and simple summaries. No advanced coding or statistics needed!

What you'll learn: You'll gain confidence working with CSV files, using spreadsheet or Python tools, organizing data, and making basic charts. This is a great foundation for future data analysis skills.

Milestones

1. Setup & Plan

10 marks 5d

Submit a short plan (1 page): how you'll get your bank CSV, which tool you'll use (Excel/Sheets or Python), and your chosen spending categories. Outcome: Clear project scope and data ready to use.

2. Core Build - Import & Organize Data

30 marks 10d

Submit your cleaned CSV file and a screenshot or code showing import and basic organization. Outcome: Data is loaded, with columns labeled and unnecessary rows removed.

3. Core Build - Categorize & Visualize

30 marks 10d

Submit your categorized spending table and 1-2 simple charts (bar/pie). Outcome: Each transaction is assigned a category, and monthly totals per category are shown visually.

4. Testing & Polish

15 marks 6d

Submit a checklist and final data file/chart, after double-checking for errors, missing values, and tidy presentation. Outcome: Data is accurate, charts are clear, and everything is ready for sharing.

5. Demo & Short Report

15 marks 6d

Submit a 1-page summary explaining your main findings (e.g. biggest spending areas, surprises) plus a brief demo (screenshots or 1-min video). Outcome: Clear communication of results and simple reflection.

Open internships using this project -->

Skills you'll learn

Data AnalysisImporting and cleaning CSV dataBasic data categorization and summarizationCreating simple charts (bar/pie charts)Using spreadsheet formulas or Python pandas basicsWriting short explanations of your findings

Tools used

Microsoft Excel or Google Sheets (free)Python (optional; with pandas and matplotlib libraries)Any free CSV bank statement from your own accountGoogle Colab (freefor Python version)

Prerequisites

Basic computer skillsSchool-level maths (additionpercentages)Intro to programming (optionalnot required for spreadsheet version)

Available mentors

No mentors have signed up for this project yet.

Be the first to mentor

You'll earn — Certificate (PDF)

AICTE-aligned Project Completion Certificate

A formal, audit-ready PDF certificate issued by Assessfy + your institute on successful completion. Includes AICTE credit hours, your evaluator's signature, and a QR code for third-party verification.

AICTE-aligned

Certificate of Project Completion

This is to certify that

has successfully completed the project

Track Your Spending: A Beginner's Data Analysis Project

Scan to Verify

Date

Signature

Auto-issued on completion QR-verifiable

You'll earn — Digital Badge

Shareable LinkedIn / Resume Skill Badge

A compact, verifiable Open-Badges-2.0-compliant digital credential. Add to your LinkedIn profile, GitHub README, or resume in one click. Recruiters can validate authenticity via a unique URL.

Beginner

Track Your Spending: A Beginner's Dat…

Assessfy

Auto-issued on completion One-click LinkedIn add