ClementGuerin-wagon/esseyi

Esseyi is the first online platform that allows you to orient yourself, study, and work in Africa # **Esseyi 🌍** Esseyi is the first pan-African portal allowing the youth of the continent to orient themselves, study, and work in Africa - esseyi.com Esseyi, which means "Knowledge" in Ikposso (a language spoken in Togo), aims to digitalize the African student ecosystem: - Orientation, application, and coaching of students - Selection and recruitment by Higher Education Institutions - Validation of diplomas, results, and certificates issued - Improving the employability of students after graduation --- ## Summary - Business Demand Overview - User stories - Data cleaning - Data exploration & transformation - Conversion - Calculated fields - Transformations - Final result - Recommendations --- ## **Business Demand Overview** - **Reporter**: Emeric / CEO - **Esseyi’s objective**: to digitalize the African student ecosystem (secondary education) - **Value of Change** / project objective: to provide an overview of the activity to date + a management tool, to provide business recommendations - **Necessary Systems & Tools:** SQL Server, Power BI, Excel, CRM (Bubble) - **Other Relevant Info**: all data has been extracted in .csv format from Bubble in March 2024. The extract contains 3 tables : Establishments, Cursuses & Students. --- ## **User stories** | No # | As a (role) | I want (request / demand) | So that I (user value) | Acceptance Criteria | | --- | --- | --- | --- | --- | | 1 | CEO | To have an overview of Esseyi's data and activity to date | To manage the activity, Identify top/bottom by category, Guide acquisition strategy | Power BI dashboard with key information (number of countries in the catalog, establishments, courses, students, geographical distribution) | | 2 | CEO | To acquire new institutions | To better meet the needs of students | Power BI dashboard to compare the courses offered with the students' preferences, Completion rate of existing information | | 3 | CEO | To acquire new students | To better meet the needs of institut …