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.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Survey data analysis- Government and City dashboard examples

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

survey data analysis

Plugins & Scripts Used