Assessfy Foundation Projects Lab Beginner 5 milestones 100 marks

Simple Air Quality Trends Dashboard for Indian Cities

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 basic interactive dashboard that shows how air quality (measured by AQI) has changed over time in a few major Indian cities, using open data and simple charts.

Why it's a good starter: This project is beginner-friendly, with small, clear steps and no advanced code. You'll use easy, free tools to work with real-world data, helping you gain confidence in basic data analysis and visualization.

What you'll learn: You'll practice finding and cleaning data, making simple charts, and building a dashboard that lets people explore air quality trends. This is a great way to learn hands-on data skills that you'll use in many future projects!

Milestones

1. Setup & Plan

10 marks 5d

Submit a short plan (half page) listing 3-4 Indian cities, which open AQI dataset you'll use, and which tool (e.g. Google Sheets or Python) you will use. This milestone is complete when you have shown you can access the data and outlined your steps.

2. Core Build: Data Cleaning & First Chart

28 marks 8d

Submit your cleaned data for at least one city and a basic line chart showing AQI over time. This milestone is complete when you show the data imported, cleaned (no missing/duplicate rows), and a simple chart.

3. Core Build: More Cities & Dashboard Features

32 marks 10d

Submit an updated dashboard/report that includes at least two more cities and simple features (e.g. dropdown to select city or side-by-side comparison). This milestone is complete when your dashboard shows multiple cities and basic interactivity.

4. Testing & Polish

15 marks 5d

Submit your checked and improved dashboard with at least one improvement (e.g. better labels, color, or a summary statistic), and a short checklist of what you tested (e.g. chart updates, data correctness).

5. Demo & Short Report

15 marks 5d

Deliver a 2-minute demo (video or slides with screenshots) showing your dashboard and a 1-page summary explaining what trends you found. Submit both files. This milestone is complete when the project is clearly presented and summarized.

Open internships using this project -->

Skills you'll learn

Data AnalysisImporting and cleaning simple CSV datasetsBasic data visualization with line chartsCalculating simple statistics (averagestrends)Building a basic dashboard or interactive reportPresenting findings clearly to others

Tools used

Google Sheets or Microsoft Excel (free online)OpenAQ or similar public AQI datasetsOptional: Python with pandas and matplotlib (for those who want to try code)Google Slides or PowerPoint (for the final report/demo)

Prerequisites

Basic programming (e.g. Python or spreadsheet formulas)School-level maths (averagesplotting graphs)

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

Simple Air Quality Trends Dashboard for Indian Cities

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

Simple Air Quality Trends Dashboard f…

Assessfy

Auto-issued on completion One-click LinkedIn add