Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
Welcome to Forms Ideas - Analyze Your Response Data Smartly in Forms
Published Sep 27 2018 06:34 AM 70.2K Views

We’re excited to announce our new feature, Forms Ideas! We’re rolling out this feature and it will soon be available for all customers!


With Forms Ideas, you don’t have to be a data expert, but can get the most out of the data you collected. Here’s an example of what Forms Ideas can do for you:


You just sent out an event survey and collected a great number of responses. Your next step is to analyze the data and find actionable information buried under the mass amount of responses. How do you get started? Easy! Go to the Responses tab and click on Ideas.


Idea blog_2_entry.png


Forms Ideas will now provide you with various insights about your data.


Cross distribution analysis

In this cross distribution analysis example, you can see how attendees from HR, Legal, and Sales are, in comparison, more satisfied with the event than those from Finance.


Idea blog_3_Distribution customization insight.png
You recall the event has a lot of great sessions around the topics in Sales, HR and Legal, but this event has less sessions about Finance. So the attendees who are interested in Finance did not get the information they’re looking for. With this insight, you can conclude that next year’s event you should learn attendees job roles ahead of time and plan sessions to cover topics for all attendees.


Association rule analysis

This is another Forms Idea provides insights across multiple questions. The association rule analysis discovers patterns between questions in the form. It’s intended to identify strong rules discovered in your form using some measures of interestingness. In your survey data, you find that people who thinks the staff was “Extremely friendly” are very likely to be the Promoters. Such information can be used as the basis for decision about marketing activities.


Idea blog_4_association rule analysis.png


Correlation analysis

Correlation analysis is another Forms Idea that shows how there can be a consistent pattern between two questions. For example, you might see that people who answer high in question A always answer high in question B. Or, people who answer high in question C always answer low in question D.


In your event survey, the data shows that attendees who received information prior to the event have a higher NPS score. And the attendees who did not receive enough information prior to the event have a lower NPS score. From this insight, you can conclude that event details should be communicated with participants well ahead of time.


Idea blog_5_Correlation insights_detail chart.png


Sentiment analysis

A plethora of feedback can be daunting to go through, but Forms Ideas helps organize the feedback into 3 buckets: Negative, Neutral, and Positive. In the example of your event, people feel positive about the experience. Among the positive feedback, your customers thought the speaker gave a great speech, and felt connected with your team. That’s great to know! It’s convenient to have feedback grouped in a way that makes it easy for you to dig around in and dive deeper for insights.


Idea blog_6_Text sentiment insights_positive.png

 Idea blog_7_Text sentiment insights_comments.png


You’re happy to know that your insights keep updating as new responses come in. In the meantime, you save the recommended insights from Forms Ideas, interpret your findings, and prepare a summary and learning deck to send off to your team.


Frequently asked questions

Q. Why I don’t see the “Ideas” entry point from the response page?

A. A form that has more than 10 responses will likely to have the Ideas entry point. This is because we need enough response data to generate interesting ideas. 

For a form that has more than 10 responses, there’s also a chance that you do not have Ideas generated. In such case, it’s because we have not found any meaningful results to show at this point. Please keep collecting responses and come back to check! 


Q. Is this feature available for all languages?

A. Forms Ideas is available for these languages, except for “Sentiment analysis,” which is for English only.


Q. How can I provide feedback?

A. Please share feedback in the Ideas section. You click “like” or “dislike” in the Ideas section. You can also visit Microsoft Forms User Voice and let us know what you think of the Forms Ideas feature. We encourage you to provide suggestions and vote on ideas others have already submitted.

Version history
Last update:
‎Sep 27 2018 04:58 PM
Updated by: