Project Everest

Work Update

Measuring Success: Designing a Database Dashboard

by
Sunny Commandeur
Sunny Commandeur | Dec 4, 2017 | in Knowledge Base

Fiji FarmEd POC has had the idea that the entire project would benefit greatly from a central database of project related information. This would then feed into a simple dashboard of visualised graph/trend information on FarmEd. The main page would have a few important visualisations, but the plan is to have further speciality pages accessible from the main dashboard.

The vision behind this is that we could have an easy way to quantitatively measure the performance and impact of FarmEd as a whole, as measurement is currently difficult due to a large amount of variables/considerations. Being able to quickly assess where FarmEd is, and it's strengths and weaknesses would streamline handovers with future teams and provide them with goals or direction to facilitate decision-making.

A downside of this is that teams will be forced to input a lot of data into the system as they work. Currently, teams are recording some data into separate entities. For a MVP, switching input into the new system should take the same or less effort once protocols are in place, but the final database will likely require more data from teams, and new collection forms and data collection standards should be developed to ensure teams can successfully record it.

We are looking into different database management systems, particularly towards an open source or Google product, to ensure compatibility with other PE data. We also have a team member familiar with the Google ecosystem.

Currently, the metrics we are considering for the dashboard are:

  • Revenue FarmEd
  • Yield FarmEd
  • Project Outreach / Expression of interest
  • Farm Location
  • Crops per farmer  
  • Crop type and production variances
  • Time spent on farm
  • On-farm costs
  • Market Analysis

Does anyone have any suggestions or recommendations?

 

Wade Tink Dec 4, 2017

100% on-board with this. "data collection standards" and having open information on FarmEd data is particularly key. This moves towards PE's mission: Democritising Development. As it enables a more informed understanding of the information so people external to the organisation can contribute.
The more detail you can go into the permaculture methods would be beneficial as well.
Project Outreach / Expression of interest- I see that you can build a pipeline for where you are at with users and the revenue being the end of that pipeline.
Amber may be able to help you with dashboard software but placing it all in the Google ecosystem I'm a mad fan of.

Users tagged:

Reply 0

Seth Coetzee Dec 4, 2017

Fantastic idea! It sounds like you're envisioning that the dashboard is split into 3 categories: FarmEd (Business), Farmer (Internal farming factors), and Farmer (External production/logistics factors). In addition to what variables you already mentioned: In terms of the FarmEd category, you could look at measuring conversion rate (which would look at what proportion of farmers/organisations we are pitching to are interested, and how many actually end up as customers). In terms of the internal factors, you could look at how crop health is improving, trends in crop types, as well as their income increase. In terms of external factors and market analysis, you could look at: who are the major exporters, who are the common distributers and what channels do they use, where do Fijian crops end up (local + foreign markets).

Reply 0

Mallory Dobner Jul 1, 2018

Status label added: Work Update

Reply 0