05. Cool work examples

This page provides a non-extensive-but-useful catalog of good work that has bee produced by the Data Solutions team and should be taken as example for future projects.

Cool SQL queries

• GIZ Malawi. Cool because: These queries allow you to flatten out data within JSON columns.
• OpenSRP. Cool because: The query is a recursive query to traverse a tree hierarchy based on the adjacency list model.
• OpenSRP. This script is a good example of the use of the CROSSTAB function. Please notice that when using this function, you need to order the data by the Primary Key so that all data for the same key is grouped within one record. You can find a stackoverflow issue describing this here

Cool Dashboards

• UNICEF Cambodia. Cool because: Use of colors, dynamic % updates of columns based on filters
• HKI dashboard. Cool because: Use of icons (infographic style)
• WHO MNCH. Cool because: Row filtering by role
• UNICEF Zimbabwe ESCT - Data Collection Tracker. Cool because: Concise metrics to track a data-collection activity happening in the field.
• UNICEF Somalia CP Survey Results. Cool because: Use of CSS

Cool Gisida stuff

• TBD

Cool Akuko posts

• Coverage posts. Cool because: use of maps with several layers with coverage analysis from QGIS. Post structure and text.