Copy
View this email in your browser
Dear All,

Happy Easter to you all. It was great to have met you in March at Akosombo where we shared with you the Ghana VIFAA dashboard and its functions. Your feedback on the dashboard was really insightful and will be used by the DG team to update the dashboard accordingly.

Prototype Dashboard Feedback and Improvement

The Development Gateway (DG) team has synthesized your feedback and categorized them into two; those that will be implemented and those that will not be implemented at this stage. Below is a table that provides details on status on the feedback you made for the improvement of the dashboard; 

Recommendation to be Implemented
1. Fertilizer Plant Directory 

  • Rename Heading of Plant Directory to “Fertilizer Plant Directory” instead of “Plant Directory. Response: Agreed to rename it to Fertilizer Plant Directory
  • Correct the source name as Nigeria Customs Service on the chart (Fertilizer Plant Directory) in the home page, to Ghana Revenue Authority. Response: Will correct source name to Ghana Revenue Authority
  • Add a scale (distance measuring key) on the Fertilizer Plant Directory Map to enable viewers know the distances required to get to each plant. Response: Scale will be added to the Fertilizer Plant Directory Map
2. National Average Fertilizer Consumption by Nutrient Ton
  • In the National Average Fertilizer Consumption - by Nutrient Ton graphic “It is difficult to tell how much quantity of nutrient is consumed-the graph is misleading. Response: DG Technical Team will “Change chart name to National Average Apparent Fertilizer Consumption - by Nutrient Ton”
 

3. Apparent Fertilizer Consumption 

  • In the Apparent Fertilizer Consumption “all graphs on the platform should maintain the same color scheme for each product which should run throughout the platform”. Response: DG Technical Team has agreed to make these changes in color scheme

  • There should be Totals of volumes of products per year before the overall totals in the download excel sheet of the Apparent Fertilizer Consumption graphic. This will give a snapshot of products per year at a glance. Response: DG will work on this. This will be same as monthly imports downloads
4. The Fertilizer Retail Price Map 
  • The Fertilizer Retail Price Map should be limited to Ghana. We recommend you take out the other countries surrounding Ghana. Response: DG Technical Team will "Zoom in a few levels further. This will also be implemented for plant registry"
  • Improve locations (data point accuracy) on the Fertilizer Retail Price Map. e.g., Tarkwa is in Western Region and not Ashanti. Response: It's only the accuracy of location for Tarkwa which is a problem and will be corrected
5. Evolution of Average Retail price Over Time
  • On Evolution of Average Retail price Over Time graphic-ensure that
  1. Average prices should show on the axis (Y). Response: DG team will change Price in GHS/50kg bag to "Average Price in GHS/50kg bag"
  2. Monthly Prices should be specific to locations. Response: In location dropdown - DG team will change all to national average
  3. Include yearly average prices per location. Response: Just like retail map, DG team will have monthly/annual change buttons, and have start and end date"      
6. Comparison of Commercial and Subsidized Prices at the Retail Level
  • There should be an option for trend comparison over a period of time. Response: "Add line chart, with single select product, multiselect years and remove monthly" to allow for trent comparison over a period of time
  • The graphic for Comparison of Commercial and Subsidized Prices at the Retail Level shows that in 2020, NPK 15-15-15 has subsidized prices for Ghana but this is not the case. How did it appear on the dashboard? There is the need to check to confirm it is not an error. Response: Retail price data set shared with DG shows there is subsidy price for NPK 15-15-15 in May 2020 for two locations i.e., Tamale and Sege
  • There is the need to cross check with AFO to confirm that “there are no subsidized prices for NPK 23-10-5 in the Comparison of Commercial and Subsidized Prices at the Retail Level graphic. We however expect subsidized prices to be available’. Response: Checked with AFO and it's confirmed that NPK 23-10-5 has no subsidy for 2020. The subsidy price is rather with the NPK 23-10-5 with micro nutrients that is NPK 23-10-5 +MgO+3S+0.3Zn for 2020. NPK 23-10-5 however has subsidy prices for years before 2020
7. Monthly Fertilizer Imports
  • Rename the source of information for the Monthly Fertilizer Imports chart in the home page, from Kenya Revenue Authority to Ghana Revenue Authority. Response: DG Technical Team will make the necessary changes to Ghana Revenue Authority

Recommendations that won't be implemented

1. Apparent Fertilizer Consumption 

  • Add a new graph to the Apparent Fertilizer Consumption graphics that gives yield analysis per hectare and nationally. Reason: We believe this is misleading to tie yield data to fertilizer use, because other factors affect yield, for example seeds quality
  • Provide an option to filter data in apparent fertilizer consumption graphic on quarterly and annual basis. Reason: AFO currently provides data only annually as the FTWG is carried
2. National Average Fertilizer Consumption - by Product Ton
  • Provide an option to disaggregate data in National Average Fertilizer Consumption - by Product Ton graphics by month/quarterly and by location. Reason: AFO currently provides data only annually as the FTWG is carried out on an annual basis
  • Remove National Average Fertilizer Consumption - by Product Ton graphic as it is expected to compare against the Abuja declaration which is supposed to be calculated in nutrients. But the chart is in product tons which is misleading as calculation is not in nutrient tons. Reason: We will move National Average Fertilizer Consumption- by Nutrient Ton graphic above National Average Fertilizer Consumption- by Product Ton graphic
3. National Average Fertilizer Consumption - by Nutrient Ton 
  • Provide option to disaggregate data in National Average Fertilizer Consumption - by Nutrient Ton graphic by region/district. Reason: AFO currently collects this information at the national level and annually through FTWG and so data cannot be disaggregated by region/district at the moment
4. Imports by Country of Origin and Year
  • Add a new chart to the Imports by country of origin and year graphics as we want to know which products and the quantities that were imported from different countries. Reason: This has been catered for by the Imports by Country of Origin and Product graphic in the dashboard
  • Consider integrating the data of the Imports by Country of Origin and Year (Sankey Chart) graphic into the Country-of Origin map as the current form of the Sankey chart is not user friendly. You could possibly Change Imports by Country of Origin and Year chart. Reason: Integrating data from Sankey Chart to country of origin and product map will be complicated. The DG Technical team will make changes to the Sankey chart by making the color schemes sharper
5. Monthly Fertilizer Imports by Products
  • There should be an option to disaggregate imports of products in the Monthly Fertilizer Imports by Product graphics. Reason: This has already been catered for in the same monthly fertilizer imports by products chart in the dashboard
  • Add country of origin to the bar graph (Monthly Fertilizer Imports by Product chart) depicting import. Reason: No need to add a country of origin to the monthly fertilizer imports by product chart as the country of origin of products has been catered for in Imports by Country of Origin and Product graphic. some graphics of the dashboard
  • Add names of importers of fertilizer products and their volumes in the Monthly Fertilizer Imports by Product graphics. Reason: For data privacy reasons, won’t be advisable to add this information
6. Imports by Country of Origin and Product
  • Add names of importers of fertilizer products and their volumes in Imports by Country of Origin and Product graphics. Reason: Not good for building trust with private sector, we don’t publish names
7. Monthly International Price
  • FoB Prices depicted in Monthly International Price graphic should be more location specific to help in decision making especially for sourcing. Reason: Data received is not location specific in most cases
8. Evolution of Average Retail Price Over Time
  • Information provided in the Evolution of Average Retail price Over Time graphic can be presented in multiple graphs like bar chats, histogram etc. Reason: Not very specific enough. At the best the line graph is more appropriate
9. All graphics
  • There should be alternative graph for each data for all the graphics in the dashboard to provide the trend at a glance for policy makers. Reason: Reviewed charts and a number have alternative views
The Development Gateway (DG) technical team is currently working on the improvement of graphics we have agreed to implement, while discussions are ongoing to take decisions on feedback that need further discussions and information. Further details will be provided in subsequent updates on progress.   Please find the link to a blog published on the feedback workshop for your reading https://developmentgateway.org/blog/one-step-closer-to-the-ghana-vifaa-dashboard/   

Stakeholder Engagement and Mapping of New Stakeholders
  • DG and AFO have seen the need to map out stakeholders of the project to understand and engage stakeholders who have not yet been engaged.t. The purpose is to ensure the dashboard impacts on as many stakeholders as possible who will require the dashboard to make decisions
  • To strengthen the use of the dashboard among stakeholders, we anticipate engaging you on how you intend to use the dashboard and to get your recommendation on which other new stakeholders to bring onboard.  
DG is open for questions and comments. 

Kind regards,

Raymond
Wekem Raymond Avatim
Senior Associate, Agriculture Ghana
ravatim@developmentgateway.org
Office: + 233 54 011 3255
Skype: Raymagma1
www.developmentgateway.org
Twitter
Facebook
Website
Copyright © 2021 Development Gateway, All rights reserved.


Want to change how you receive these emails?
You can update your preferences or unsubscribe from this list.