Utilise Data Studio
Connect MS SQL database
For all questions:
Show how big sample size is for each question
Pie if equal to or less than 4 answer outcomes Bar if more than 4 answer outcomes Display as individual percentages Pie if equal to or less than 4 answer outcomes Bar if more than 4 answer outcomes Display in table with all open text questions Group same answers using NLP Search for keywords in answers. Could also become multi-select Break into categories and display as chart i. Transcribe all voice notes and add into table (same as open text)
Shows percentage responses if MCQ 2. Show percentages on all bar and pie charts