I needed to conduct a survey regarding what social events our employees would like to have on the 2024 calendar. The results needed to be combined with other known data and displayed in more detail than the Microsoft Forms summary.

With PowerQuery, I was able to clean the data from both files, parse where needed, merge the queries, and create Pivot Tables to display the data we wanted to analyze.

This included:

• Who voted for which pre-listed event (handy when asking for volunteers to organize it)
• Which events were popular with specific departments
• Review the list of event suggestions