PBI Senior Consultant

Other information

As part of the implementation of its activity to strengthen the capacity of analysis and use of health data, STRIDES supports the Ministry of Public Health and Ministry of Livestock in order to improve the exploitation of programmatic and surveillance data for decision-making. Also, a license in Power-Bi is supported for the use of MSANP at the central level by STRIDES, and by other partners at the decentralized level. Technical directorates produce and use a large volume of data from DHIS2, epidemiological surveillance systems (DVSSER), the Expanded Vaccination Program (EVP) and Family Health Programs (FHP). However, capabilities in advanced analysis, data visualization and interactive dashboard development remain limited. In order to strengthen the strategic use of data, STRIDES plans the recruitment of a specialized consultant or firm to train and support the technical executives of the Directorate of Family Health (DSFa), the Directorate of the Expanded Programme of Vaccination (DPEV), the Directorate of Health Watch, Epidemiological Surveillance and Response (DVSSER), the Directorate of Veterinary Health and decentralized teams in Advanced Excel and Power BI.

- 2. OVERALL OBJECTIVE

Strengthen the capacities of the technical cadres of the Ministry of Public Health and the Ministry of Livestock in analyzing, visualizing and using health data through the advanced use of Excel and Power BI.

- 3. SPECIFIC OBJECTIVES

At the end of the mission, participants will be able to:

• Clean, validate and structure complex databases;
• Use the advanced features of Excel for data analysis;
• Build successful data models;
• Develop interactive dashboards under Power BI;
• Use DAX and Power Query functions;
• Produce visualizations and decision-making indicators;
• Carry out advanced analyses of MNCH data, vaccination and human surveillance than veterinary;
• Leverage data for evidence-based decision making;
• Develop standardized analysis and reporting tools.

- 4. SCOPE OF CONSULTANCY

The consultant or firm will be responsible for: A. Preparation and development of media (5 days)

• Scoping meeting with STRIDES and the beneficiary directorates;
• Analysis of specific needs;

Education / Qualifications

• Development of training modules;
• Preparation of data sets, practical exercises and evaluations;
• Preparation of training materials. B. Power BI and Excel Advanced Training Module 1: Family Health Directorate (DSFa / MNCH) 4 days Main themes:
• Data management and quality;
• Analysis of MNCH indicators;
• Advanced Excel;
• Power BI;
• Development of MNCH dashboards;
• Mapping of indicators and vulnerability analyses. Module 2: Expanded Vaccination Programme (EPVP) 4 days Main themes:
• Analysis of vaccination coverage;
• Analysis of abandonment;
• Monitoring of vaccine performance;
• Power BI applied to vaccination;
• Development of vaccine dashboards. Module 3: Epidemiological Surveillance (DVSSER) 4 days Main themes:
• Analysis of surveillance data;
• Detection and monitoring of alerts;
• Analysis of epidemiological trends;
• Monitoring dashboards;
• Mapping and monitoring of public health events. Module 4: Veterinary Health Directorate (VHS) 4 days Main themes:
• Analysis and interpretation of animal surveillance data;
• Management, cleaning and validation of veterinary databases;
• Early detection and monitoring of animal health alerts;
• Analysis of trends in priority animal and zoonotic diseases;
• Development of Power BI dashboards for veterinary surveillance;
• Mapping of animal health events and zoonotic risks;
• Monitoring of monitoring performance at central, regional and district levels;
• Using data for decision making in a One Health approach;
• Preparation and automation of veterinary surveillance reports;
• Development of a cascading training plan for regional and district teams. Module 5: Waterfall Training At the end of the training, DSV participants will be accompanied to:
• Adapt training materials to the operational context;
• Training of regional veterinary surveillance focal points;
• Strengthen the capacities of district veterinary teams;
• Harmonize analysis, visualization and reporting tools;
• Ensure the sustainability of the use of dashboards and tools developed. Thus, the device will allow the constitution of a national core of trainers able to deploy and to support the upskilling of regional and district teams in the use of Advanced Excel and Power BI for veterinary surveillance. C. Coaching and post-training support (10 days)
• Remote technical support;
• Finalization of dashboards;
• Practical strengthening of teams;
• Integration of the recommendations of the beneficiaries;
• Finalization of deliverables.

- 5. DELIVERABLES EXPECTED

The consultant or firm should provide:

• 1. Detailed work plan;
• 2. Validated training materials;
• 3. Pre-tests and post-tests;
• 4. Harmonized datasets;
• 5. Power BI and Excel user manual;
• 6. Dashboard MNCH;
• 7. Vaccination dashboard;
• 8. Central, regional and peripheral monitoring dashboard;
• 9. Veterinarian Surveillance Dashboard
• 10. Report of each workshop;
• 11. Final mission report including recommendations and sustainability plan.

- 6. EXPECTED RESULTS

• The analytical capacities of the beneficiary directorates are strengthened;
• At least three functional dashboards are developed;
• Participants master the advanced features of Power BI and Excel;
• Data is used more for planning and decision-making;
• A core of trainers and analysts is available within the Department.

---

[Click the Apply button below to apply, and Create my CV to build a CV tailored to this offer, professionally]