Charles-star-sys/Kenya-Community-College-Dashboard

# Community College Program Performance Data Mart ## Project Overview This project simulates a **data warehouse for a community college** focused on tracking student participation, financial support, and employment outcomes after training programs. The system is designed to support **Monitoring, Evaluation, and Learning (MEL)** by enabling structured reporting, cohort analysis, and data quality validation using SQL. --- ## Objectives The project aims to: * Track student enrollment and completion across training programs * Monitor financial aid distribution (stipends, grants, refunds) * Measure post-training employment outcomes * Enable cohort-based analysis of student success * Ensure data integrity through validation checks --- ## Data Model (Schema Overview) ### 1. beneficiaries (Students) Stores student demographic and registration data. **Key Fields:** * `beneficiary_id` (Primary Key) * `full_name` * `gender` * `date_of_birth` * `registration_date` * `vulnerability_score` (proxy for financial need/support level) --- ### 2. training_enrollments Tracks student participation in training programs. **Key Fields:** * `enrollment_id` (Primary Key) * `beneficiary_id` (Foreign Key) * `training_type` (e.g., Digital Skills, Entrepreneurship) * `status` (enrolled, completed, dropped) * `enrollment_date` * `completion_date` --- ### 3. payments (Financial Aid) Captures financial support provided to students. **Key Fields:** * `payment_id` (Primary Key) * `beneficiary_id` (Foreign Key) * `amount` * `payment_type` (stipend, grant, refund) * `payment_status` (paid, pending, failed) * `payment_date` --- ### 4. employment_outcomes Tracks student employment status after training. **Key Fields:** * `outcome_id` (Primary Key) * `beneficiary_id` (Foreign Key) * `employment_status` (Employed, Self-Employed, Unemployed) * `monthly_income` * `recorded_date` --- ## 🔗 Relationships * One student can have multiple enrollments * One student can receive multiple …