Skip to content
Product Pieces

Insights Dashboard/Reports

Utilise Data Studio
Connect MS SQL database
For all questions:
Show how big sample size is for each question
MCQ
Type:
Pie if equal to or less than 4 answer outcomes
Bar if more than 4 answer outcomes
Multi-select
Display as individual percentages
OR
Pie if equal to or less than 4 answer outcomes
Bar if more than 4 answer outcomes
Open text
Display in table with all open text questions
Group same answers using NLP
Search for keywords in answers. Could also become multi-select
Numbers
Break into categories and display as chart
And/OR show as average
Picture
Voice note
i. Transcribe all voice notes and add into table (same as open text)
Video

Shows percentage responses if MCQ
2. Show percentages on all bar and pie charts
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.