Danny Quelch

Analyse Excel survey ratings with Power Query, Power Pivot & slicers




Survey data form software often has “rate 1-5” questions or rate 1-10 such as Microsoft Forms, Google Forms, Survey monkey etc. It’s not really easy to analyse them without leveraging Power Excel which consists of Power Pivot & Power Query. This video walks through the process, for even people who haven’t used the tools before. For advanced users, I bet you’ll learn a new transformation or two!

We also walk through other tools in Modern Excel, including Bos & Whisker plots, slicers, and advance Pivot options.

One thought on “Analyse Excel survey ratings with Power Query, Power Pivot & slicers

Leave a Reply

Your email address will not be published. Required fields are marked *