What are data banner or pivot table
Banner tables, or pivot tables, allow you to visualize and view your survey response data relative to a single question. For example, one of your questions may be, “Where are you from?” Possible answers might include:
- West Coast
- Mountain States
- East Coast
Research banner tables can allow you to visualize how respondents from each answer option responded to all of the questions without having to create groups and segments for each option. The question that you used to segment the rest of the survey is referred to as the Pivot Question.
How can I create a table banner?
To create your pivot table in the QuestionPro software, go to:
- Login » Surveys » Reports » Advanced » Cross-Tabulation
- Step 1: Choose the Pivot Question. This is the question that you want to use to create your table. In the example above, this would be the question, “Where are you from?”
- Decide if you want to include a Secondary Pivot or a Nested Pivot or both. Check the box next to each option desired.
- A secondary pivot question further subsegments your data based on responses to both questions. These secondary questions produce a banner table for each distinct item within that custom variable. For example, you may want to see the sales regions as your secondary pivot. Choosing that as your variable automatically segments your data based on the regions in your dataset.
- If you choose a Custom Data Segment, you’ll need to provide the Groups, or data-segments, that you want to use to produce your banner point table.
- Select how you would like to Filter Results. Options for result filtering include:
- Started but not Completed
- Terminated via Branching.
- Step 2: The Output Format option is Excel.
- The Filter Question option allows you to crate a banner table for a single question. By selecting the Filter Question option your banner table is created between the question you choose and your original Pivot question selected at the beginning of the process.
- Toggle Orientation: If Filter Question is selected you can choose to change the orientation of the Banner Table.
- Select the type of Data Table to view.
- Frequency: This will show you numbers of responses. For example, the number of respondents who selected North-West who also selected an option in another question.
- Percentage: This is the default selection. This will show you the number of responses as a percentage of the total number of responses to the pivot question.
- Select the Display Option desired.
- Data Table + Charts. This option will give you tables, along with a chart for each table.
- Data Table Only. This option provides only data tables with no charts. If you have a lot of data, this option is the fastest option for generating the table display banner.
- Data Table + Charts + Mean. This option will give you the tables, charts for each table, and the mean calculation for each answer option column.
- Click Create Banner Table. The banner/pivot tables will be generated and emailed to the email address on the account.
Can I see an example of the Excel Report?
Below is an example of a banner table with the display option Data Table + Charts chosen. The survey questions are listed in the first column of the Excel sheet, showing the answer options and the overall responses below the question. The pivot question answer options are displayed directly below the questions. The percentages shown are the percentages of those who answered both the survey question listed and the pivot question.
Can I have a data banner table for multiple pivot questions?
Yes. You can have multiple Pivot questions using the Secondary Pivot and/or Nested Pivot option. This feature allows you to dive deeper into your survey responses and cross-reference the answers to related questions. Using multiple pivot questions can help you better understand the thought process and responses of your participants.
- Secondary Pivot. The Secondary Pivot allows you to Pivot on more than one question. For example, if you wanted to produce a Banner Table that pivots on Gender AND Race, you can choose Gender as the primary Pivot and Race as the secondary pivot. The secondary pivot is optional. In the data tables, the secondary pivot will appear as another set of columns next to the pivot question.
- Nested Pivot. The Nested Pivot allows you to Pivot on more than one question combined. For example, if you wanted to produce a Banner Table that pivots on Gender combined with Race, you can choose Gender as the primary Pivot and Race as the Nested pivot. In the data tables, you will see the nested pivot as “Pivot Answer/Nested Pivot Answer,” rather than a new set of columns.
Can I integrate Custom Variables with Banner tables?
Yes. Choose the Custom Variable you want to use for segmenting (in step 1) and the system will automatically create a banner table for every available data point.
Are there limitations I should be aware of when creating research banner tables?
For simple (non-nested) tables, there is no limit to the number of columns that can be used in the tables. This includes tables with a primary pivot question and a secondary pivot question.Please keep in mind, however, that if your data set is large or if there are a lot of questions in your survey it may take a longer to generate your table. Lots of data can slow the system down and increase the time it takes to create your banner table.
For Nested Pivot Tables, there is a limit of a total of 64 columns. This is to prevent our system from being over-utilized, which could potentially slow the service for other users. This is a system limitation and, unfortunately, no exceptions can be made.
Custom Variables cannot be included as either the original Pivot Question or the Nested Pivot. One you choose your pivot Question, you are able to select a Custom Variable to further refine your data.
License & Access Options
The features and tools described in this article are available with the following license(s):
- Corporate Edition:
- Unlimited Surveys, Questions, Responses
- Advanced Toolset and Features
- No Long Term Commitment