Intro
In order to expedite the process of validating the data curation with the countries, we've created a simple draft data studio dashboard that can be used as a template.
Its purpose is to facilitate a couple of ideas on how to show the data available from the "survey on lab capacity"
How does it work?
The dashboard can be accessed here
The dashboard contains:
- A main filter by city and facility name
- This is helpful to filter specific data, this filter will impact in all the charts and tables in the dashboard
- A pivot table that can relate two or more categorical variables
- it's always helpful to compare frequency from two categorical variables (in the current settings it compares lab complexity with affiliation)
- A map that shows the labs as dots
- Navigating country map and get one dot per lab is a fast way to validate general data
- A piechart for a categorical variable
- categorical variables with more than 3 and less than 8 categories are usually well represented with pie charts. If the number of categories is greater than 8 the user can select the limit of slices and all the smaller categories will be merged into Others.
- A bar char that concentrates 5 booleans (yes/no) variables
- This data set is full of boolean variables, a simple way to display them consist of creating a table that counts only yes (using COUNTIF formula in a spreadsheet) values on each of them and represent them in a bar chart