Skip to Content
0
K P
May 03, 2018 at 04:41 PM

How to analyze survey data in Webi 4.2 with numerous records for each person?

292 Views Last edit May 03, 2018 at 05:04 PM 4 rev

I need to analyze and report survey data. Each respondent provides responses to questions, such as, name, age, gender, birth date, state, etc. Collected data is available in three dimensions in Webi 4.2: Respondent (ID), Question, and Answer as shown in the screenshot below:

Survey Data Analysis Sample

As you would notice in the screenshot above, there are many rows for each respondent. It makes it difficult to provide simple analysis, such as average age of respondents or respondent gender distribution or ranking respondents by state etc. In reality, there are 100+ questions and thousands of respondents and years' worth of data to analyze and Webi queries max out the record limit and fetching only partial results.

I believe one row should represent one record and each column should represent one attribute of the data. I would like to have each question transposed to as a Dimension, as shown below, so that it would be easy to analyze the data.

Ideal Survey Data Structure

What would be the best practice to create Webi documents so that analysis and reporting can be done more efficiently?


Attachments