Scope of Work & Deliverables
Episcopal Relief & Development’s Global Programs Department is seeking a consultant with deep knowledge in PowerBI to demonstrate and develop how we can maximize the potential of PowerBI for data interpretation and results dissemination. The consultant will use project M&E data to produce data visualizations and design dashboards for two types of data use: program interpretation and use of key findings (exploratory data visualization) and results dissemination (explanatory data visualization) for selected sector results frameworks. The consultancy has a first phases with a possible second phase:

Phase 1: Develop data visualizations in PowerBI using project data from one climate resilience integrated program for data analysis, synthesis and reporting. The visualizations will be used by internal staff and implementing partners to help make program decisions for learning and greater impact in our work and the communities we serve; develop key results data visualization for dissemination by the partner and our organization.

Phase 2: Design findings dashboards and results dashboards for a set of program sector results frameworks and their indicators.

The dates of delivery will be agreed upon at the time of signing the agreement, but below is the estimated timeline.

Phase 1 Deliverables (Approximately July 2024 – to be confirmed)
1. Create visualizations for one project’s participant data, output and outcome indicators showing baseline and endline values and the change per indicator.
2. Create one dashboard of data that can be updated and shared with project partners and Episcopal Relief & Development staff.
3. Create one dashboard of key results for dissemination by project partners and Episcopal Relief & Development (for accountability, marketing and fundraising purposes)

Phase 2 Deliverables (Approximately August/September 2024 – to be confirmed)
1. Advise on PowerBI’s features and capabilities for integrating indicator data from Stata and the DHIS2 platform into PowerBI for automated data visualizations.
2. Design standard visualization dashboards per sector and Focus Area to illustrate participant, output and baseline and endline outcome data and the percentage change using project data.

To apply, please email the following information by July 1, 2024 to Chou Nuon at cnuon@episcopalrelief.org:
1. Letter of Interest – summary of consultant’s experience and skills related to this scope of work and availability from July through September 2024
2. Resume/Curriculum Vitae
3. Sample of data visualizations created using PowerBI
4. Consulting rate and three references

Please name all your documents starting with your last name.

Organization Background
Episcopal Relief & Development is a 501(c)(3) international nonprofit organization working together with supporters, partner organizations and communities for lasting change for more than 80 years. Each year more than 3 million people struggling with poverty, hunger, disease, and disaster participate in relief and development processes and develop healthier, more fulfilling lives. The organization works with Anglican program partners to deliver measurable and sustainable change in three signature program areas: Women, Children and Climate Resilience.