INNOVATHERS

🎓 Student Dropout Analysis for Sustainable Education

📖 Project Overview

This project investigates the major factors influencing student dropout using descriptive, diagnostic and prescriptive analytics.

The project was developed using Excel, SQL, Python and Power BI to identify students at risk of dropping out and recommend interventions that improve student retention.

The analysis supports Sustainable Development Goal (SDG) 4: Quality Education by providing data-driven recommendations for improving student success.

---

🎯 Objectives

• Identify factors contributing to student dropout
• Explore relationships between academic, financial and social variables
• Build an interactive executive dashboard
• Recommend strategies for improving student retention

---

🛠 Tools Used

• Microsoft Excel
• SQL
• Python
• Jupyter Notebook
• Power BI Desktop
• Git
• GitHub
• ChatGPT (AI Assistant)

---

📂 Repository Structure

DATA/
EXCEL/
SQL/
PYTHON/
POWER BI/
REPORT/
PRESENTATION/
SCREENSHOTS/
README.md

---

📊 Exploratory Data Analysis

Python was used to analyse:

• Age
• Gender
• Department
• Semester
• GPA
• Semester GPA
• CGPA
• Stress Index
• Scholarship
• Family Income
• Internet Access
• Travel Time
• Part-Time Job
• Parental Education
• Dropout

---

📈 Power BI Dashboard

The dashboard contains:

• Executive KPI Cards
• Student Dropout Analysis
• Academic Performance
• Financial Analysis
• Stress Analysis
• Internet Access Analysis
• Scholarship Analysis
• Department Performance
• Interactive Filters

---

🤖 AI-Assisted Development

ChatGPT was used to assist with:

• Python programming
• SQL query writing
• Exploratory Data Analysis
• Dashboard planning
• Documentation
• GitHub setup
• Report refinement

Examples of AI prompts and responses are available in the SCREENSHOTS folder.

---

📄 Project Report

The detailed report contains:

• Executive Summary
• Key Findings
• Recommendations
• SDG Alignment
• Responsible Use of AI
• Conclusion

See the REPORT folder for the complete documentation.

---

📷 Project Screenshots

Project screenshots including:

• Power BI Dashboard
• Python Visualizations
• SQL Queries
• AI Prompt Examples

are available in the SCREENSHOTS folder.

---

📽 Presentation

The project presentation slides are available in the PRESENTATION folder.

👥 Authors

Team: INNOVATHERS by PATCODEX

Student Dropout Analysis Capstone Project

2026