Consultancy in PowerBI At Aga Khan Foundation

A. Background

The Madrasa Early Childhood Programme, an affiliate of the Aga Khan Foundation, was established in Mombasa in 1986 to improve access and quality of Early Childhood care and services in marginalized communities on the Coast of Kenya. Evidence-based success and growing interest across East Africa led to MECP being established in Zanzibar in 1990 and Uganda in 1993. Over the last 35 years, more than 8,000 teachers have graduated from MECP professional development courses and over 1 million children reached through the programming. MECP is seeking to better bring this experience, expertise, and learning and create impact and influence at scale. Evaluations have demonstrated the positive impact MECP has had on access and quality of pre-primary education and on the educational outcomes of boys and girls.

The Aga Khan Foundation (AKF), founded by His Highness the Aga Khan in 1967, is a member of the Aga Khan Development Network (AKDN), one of the world’s leading poverty solutions networks. Aga Khan Foundation currently operates in 18 countries, including Uganda. Aga Khan Foundation leads a range of integrated, innovative and gender sensitive interventions in agriculture and food security; health and nutrition; civil society; climate resilience; early childhood development; and education.
Monitoring and Evaluation is an evolving domain and projects are becoming increasingly complex and dynamic and the power of Business Intelligence in M&E cannot be overstated. PowerBI empowers organisations and projects to make data driven decisions, optimize resource allocation, real-time insights, predictive analysis and ultimately increase the success rate of their projects.
Embracing powerBI is a necessity for projects aiming at succeeding in the competitive landscape of project management and thus the need for capacity building of MERL & Program team in powerBI.

B.Purpose of the Consultancy
To support MECPU/AKF MERL & Program team in creating interactive reports that give insight into underlying project data, offer analysis, visualisation, timely and improved decision making.
C.Specific Objective
To build skills and competencies of the MERL & Program team in designing and applying PowerBI Ms software
To support the MERL team to design dashboards for their projects/agencies

D.Scope of work
The Consultant will be tasked to enhance the capability of the MERL and Programs teams in Data Management, Analysis, Visualizations and Developing Interactive Dashboards for timely reporting using PowerBI.
Specifics tasks will include but not limited to:
a)Design training modules/manuals and materials
b)Conducting the training
c)Hands on support to the team to design interactive dashboards for their respective projects.
d)Supporting teams to integrate the excel data with PowerBI.
e)Supporting the teams to design a brief user manual for their dashboards

E.Duration
The training is scheduled to run for four (4) days starting on Monday 20th November 2023 to Thursday 23rd November 2023. The training will take place in Kampala and the venue will be communicated to the successful Consultant.
F.Expected deliverables.
PowerBI training manual/modules
Training report
Power point presentations of training content

G.Roles of MECPU/AKF
Meet agreed costs related to the Consultancy.
Provide timely communication and feedback to the Consultant.

H.Key Qualifications and Experience
Minimum 5 years of experience of Data Management and analysis using Power BI and developing and conducting learner-centred and experiential trainings on Power BI.
Experience of linking Kobo Collect to Power BI via API for live data syncing.
Experience working with NGOs is added advantage.

I.Budget and payment
The budget is based on need to complete the deliverable but will not exceed the training budget under the Project approved budget. 100% payment will be made after conducting satisfactory training and after submission of expected deliverables.

J.Safeguarding
The Consultant must fully abide by AKF’s Safeguarding Manual, and all members of the Consultancy must sign AKF’s Safeguarding Statement of Commitment upon contracting.

K.Eligibility and Application Criteria
Consultants meeting the above criteria are invited to submit a technical and financial proposal which should include:
An understanding of the assignment based on the training objective.
Proposed training methodology and approaches that will be adopted, proposed training content and training schedule.
The capacity of the firm to deliver on the PowerBI training.
Detailed budget
Three referees for previous work done in the past 3years and their contact details.
Contact details of the consultancy firm (email, telephone, and physical address)

NB; WHT and VAT will be deducted where applicable.
The bid should be submitted by email to the undersigned by Friday 3rd November 2023 with the subject line title “MECPU PowerBI Consultant” to …………….
All materials for submission must be merged into one pdf file.
AKF/ MECPU is an Equal Opportunity Employer and is Committed to Safeguarding and Promoting the Welfare of Children and Vulnerable Adults and Expects all Staff and Partners to Share this Commitment.
The Aga Khan Foundation is an agency of the Aga Khan Development Network (www.akdn.org).