Product canva

Census databased & dashboard

Problem

WRI internal socio-economic data users encounter difficulties in using socio-economic data at different geographical scales: where to find the data, data documentation, data updates, different data schemas...

Solution

Provide users access to processed and harmonized census data at different geographical levels in tabular and geospatial views through an interactive dashboard.

Features

• Data:
  • Harmonized geo census data at different levels
  • Metadata and census variables description
  • Data storage (s3)
  • Data storage (API)
  • Data processing scripts
• Dashboard:
  • Table view and download of census data
  • Geo view and download of census data
  • multi-variables selection
  • Deploy in shiny apps
  • Deploy in ec2

To discuss:

• Viz summary statistics
• Viz Charts: variable distribution...
• Language management

Roadmap

Nomenclature:

• To do: 🔴
• In progress: 🚧
• Done: ✔️

Census	data collection	data processing	s3 storage	s3 dashboard	api storage	api dashboard
Mexico (2010)	✔️	✔️	✔️	✔️	✔️	✔️
Mexico (2020)	✔️	✔️	✔️	✔️	🔴	🔴
Brazil	✔️	✔️	✔️	✔️	🔴	🔴
Colombia	✔️	✔️	✔️	✔️	🔴	🔴
India	✔️	🚧	🚧	🚧	🔴	🔴

KPIs

How can we evaluate the use of the dashboard:

• Quantitative: Number of connection to the dashboard, duration of exploration, number of data downloaded...
• Qualitative: Survey answers analysis, interviews...

Equity databased & dashboard

Problem

Solution