High Level Design
OverviewSurveys are a very common tool to acquire information about a field of interest; dashboards are a great tool to gain insights and derive action items from those surveys by finding a correlation between participants’ satisfaction and dissatisfaction in various fields. In this example, the survey is being done in order to learn about the satisfaction and opinions of a community.
Improve residents’ quality of life by improving areas of concern and maintaining satisfying areas.
- Identify common areas of concern for all residents and in particular demographics
- Identify common areas of satisfaction for all residents and in particular demographics
- Understand what specific issues affecting the residents’ quality of life and satisfaction
|Identify common areas of concern and of satisfaction for all residents and in particular demographics||Participants’ Demographics||# Participants by Age Range||Dim Participants|
|# Participants by Gender||Dim Participants|
|# Participants by Area (zip code)||Dim Participants|
|The main concern of the participants regarding the city||# Participants emphasizing the same issue in free-text question||Survey|
|The main satisfaction of the participants regarding the city||# Participants emphasizing the same topic in free-text question||Survey|
|Participants’ Rating per Field||# Participants per rating by question||Transposed Survey|
|Understand what specific issues affecting the residents’ quality of life and satisfaction||Issues that affect the overall rating of the city||# Participants per rating in certain question in correlation to another question||Transposed Survey, Transposed Survey Dup|
Entities Relationship Diagram