Tosa-omokhoa/LearnEdge-Dropout-Intelligence

Full-stack EdTech dropout analysis project using Python, SQL, and Power BI. Explores learner retention patterns across 100,000 records in an African EdTech context — covering data cleaning, EDA, SQL querying, dashboard design, and stakeholder reporting. ALX Data Analytics # 🎓 LearnEdge Dropout Intelligence > **Analytical Report on Learner Retention in African EdTech** > ALX Data Analytics Capstone — Group 6 | Analyst: Omokhoa Oshose Tosayoname | April 2026 --- --- ## 📌 Project Overview Online education is expanding rapidly across Africa, but learner dropout remains one of the industry's most persistent and costly challenges. High dropout rates reduce the social return on education investment, undermine institutional credibility, and limit long-term platform sustainability. **LearnEdge Dropout Intelligence** is a full-stack data analytics project that investigates learner dropout patterns across the LearnEdge online education platform. Using two datasets — a primary dataset of **100,000 learner records** and a supplementary dataset of **40,000 African EdTech learner profiles** — this project delivers actionable, evidence-based insights for EdTech decision-makers. --- ## 🎯 Key Questions Explored | # | Business Question | |---|---| | 1 | What percentage of learners complete the course? (Retention Rate) | | 2 | Do learners drop out due to poor internet access, course difficulty, or time constraints? | | 3 | How does time constraint affect Students vs. Workers vs. Mothers? | | 4 | Is there a mismatch between learner satisfaction and actual performance? | | 5 | Which learner profiles are most at risk of dropping out? | --- ## 📊 Key Findings at a Glance | Metric | Value | |---|---| | **Total Learners Analysed** | 100,000 | | **Overall Completion Rate** | 49.03% | | **Overall Dropout Rate** | 50.97% | | **At-Risk Learners (flagged)** | 1,926 (1.93%) | | **Avg Satisfaction Score** | 4.13 / 5.0 | | **Highest At-Risk Profile** | Worker + Low Internet + Mobile → **12.13%** | --- ## 🔍 The 5 Core Findings ### Finding 1 — Dropout Is the Majority Outcome Over **50.97%** of enrolled learners do not complete their course. For every 2 learners who enrol, 1 will not finish. Dropout is the modal outcome across all learner groups and …