Survey Data Dashboard

High Level Design

Overview

Surveys 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.

Goals

Improve residents’ quality of life by improving areas of concern and maintaining satisfying areas.

Objectives

• 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

KPI Architecture

Objectives	KPIs	Measures	Data Source
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

Plugins & Scripts Used

• Widget Title Style plugin
• Word Cloud plugin
• Open Ended Survey Analysis plugin
• Custom Filter plugin
• Tabber plugin