Excel Dashboard Creation

Help Water Access Rwanda set up an accessible template to track key performance indicators to help measure their success.
Water Access Rwanda
kigali, Rwanda
Unfollow
Log in to follow
Water Access Rwanda
kigali, Rwanda

0

Live Projects

38

Matched Projects
22 Followers

Posted May 11th

Share this project:

Project details

What we need
  • A dashboard in Excel or Google Sheets that visualizes key performance indicators (KPIs), with data from up to 3 sources
  • Training on how to consistently update the dashboard for ongoing use
  • Optional: Training on how to edit dashboard and execute on formulas and functions that will allow for its evolution
What we have in place
  • We currently have Excel skills, and raw data records, which should make it easy for you to get started. We also have access to internet, and the ability to provide any other information you need.
How this will help
This project will save us $4,828 , allowing us to the project will save us money that is lost through non-revenue water

this project is about water loss tracking and management in order to minimize it.

Project plan

P
Prep: Goals & Data for the Dashboard
  • Volunteer Manager gives overview of the current data the organization has available, the desired KPIs they would like to track and the dashboard audience
  • Professional and Volunteer Manager discuss what is feasible for the dashboard given the current state of the organization’s data
  • Professional and Volunteer Manager outline next steps and timeline for the project
  • Volunteer Manager shares the necessary raw data files with the Professional
1
Milestone 1: Dashboard Creation & Feedback
  • Professional creates a draft of the dashboard based on initial conversation with Volunteer Manager
  • Professional shares the dashboard with the Volunteer Manager and explains how the dashboard depicts the desired KPIs
  • Volunteer Manager provides any feedback on the dashboard (up to two rounds)
  • Professional implements feedback and provides a revised dashboard
2
Milestone 2: Training
  • Professional creates guidelines for continued maintenance and update of the dashboard
  • Professional reviews the guidelines with Volunteer Manager
  • Professional is available for up to four weeks to address questions and troubleshoot as Volunteer Manager starts to regularly use the dashboard
3
Milestone 3 (Optional): Additional Advanced Training
  • Professional trains the Volunteer Manager on the key formulas, tables and charts that are used to create the dashboard, and how to make edits to them if needs evolve
  • Professional directs the Volunteer Manager to further relevant resources or an Excel Training project
Show more

About the org

Water Access Rwanda
Unfollow
Our mission

Water Access Rwanda is a Rwandan-based social enterprise that offers simple, durable and affordable water solutions to Rwanda and in East Africa in a bid to address the water crisis while creating employment for youth. The company is primarily focused on the bottom of the pyramid's need for affordable and safe water and deploys models of access that provide clean water in a convenient manner. Our mission is to be a self-sustained enterprise employing young people as solution providers in the water sector.
Our vision to revolutionize the water industry by providing simpler, affordable ways to obtain clean water.

What we do

Our Solutions
The company deploys innovative and next-level services and systems to provide clean and purified clean water. All living beings are water dependent and over 72% of productive sectors require water, there is no one-fit-all solution when it comes to providing clean water. Water Access Rwanda seeks to be a solution for different segments of the market. The solutions offered are bundled through four different offerings each targeted to a different customer segment. Each of the solutions is complemented with our capacity to conduct geophysical surveys and other feasibility studies.

1) INUMA(tm)
INUMA creates a borehole-fed micro-grid piped safe water network where purified safe water is available at public points and piped into households for private access. All water is purified through a treatment process, pumped using solar and AC and sold via pre-paid water meters activated through a token. INUMA(tm) points can be made from rehabilitated existing handpumps and create jobs locally in the community.

2) amazi
In a bid to increase rain-water harvesting and ensure all taps in urban households provide safe water, Amazi provides first flush diverter systems and point of entry and point of use filtration systems. With this solution, households, schools, camps, clinics can save on their water bill in the rain season while reducing the amount of run-off water that would otherwise cause flooding. The systems come with a one-year warranty. Filters include in-line filters, table-top, portable and Aquatabs Chlorinators.

3) uhira
Targeted at farmers and off-grid businesses, uhira includes a borehole, a solar pump, a pipeline, elevated storage system and an optional cattle trough or tap system from the tank. This system is offered on credit with 25% down-payment, followed by equal monthly payments for 12 months.

4) voma
The full company's technical capacities can be re-arranged and bundled up to achieve other project objectives for custom-designed projects ran by NGOs, Carbon Credit Project Developers, government, CSR partnerships, etc. With VOMA projects, we also offer WASH trainings, baseline surveying and M&E aspects through smart surveying tools.

Testimonials

(No testimonial has been submitted by BYISHIMO)
(No testimonial has been submitted by Deepti)