Amaefule5/Future-Pathways-Development-Initiative-Campus-Ambassador-Data-Project

Built a pipeline of 75 young civic leaders across 16 states and 27 campuses in Nigeria. Conducted surveys, stakeholder consultations, and data cleaning using advanced Excel. Designed dashboards to track engagement and trends, enabling data-driven decisions to support youth leadership development. # Future Pathways Development Initiative Campus Ambassador Data Project ## Overview The **Future Pathways Development Initiative (FPDI)** Campus Ambassador Data Project provides a data-driven view into youth engagement with civic leadership across Nigerian campuses. It captures survey responses from student ambassadors who are passionate about governance, advocacy, and policy reform. The data reveals participation patterns, demographic breakdowns, and insights that align with FPDI’s mission to strengthen citizen engagement and leadership systems. ## Objective The main aim of this project was to **collect, analyze, and visualize data** to show how young Nigerians connect with civic leadership opportunities through the FPDI Campus Ambassador Program. The outputs support decisions on recruitment strategy, program design, and stakeholder reporting. ## Key Data Highlights - **Total ambassadors**: 75 students participating in the program - **Geographic reach**: Representatives from 16 Nigerian states - **Campus spread**: Students from 27 campuses across the country - **Age distribution**: Majority aged 18–24 - **Experience levels**: 73% reported prior involvement in governance, advocacy, or volunteering activities - **Gender distribution**: 67% male and 33% female ambassadors - **Academic status**: Most are undergraduates - **Program duration**: 57% have participated for longer than one year ## Tools and Technologies - **Microsoft Excel** for data cleaning, structuring, analysis, and visualization - Pivot tables and charts for interactive dashboards ## Project Dashboard ### Overall Dashboard ### More Insight ## Process 1. **Survey Collection** Collected responses from students interested in the FPDI Campus Ambassador Program, capturing personal, academic, and motivational data. 2. **Data Cleaning and Preparation** Reviewed the dataset for consistency, normalized categories, handled missing values, and prepared variables for analysis. 3. **Analysis and Vis …