- This event has passed.
Eval Cafe: Agile Reporting of Survey Data
October 9, 2019 @ 6:00 pm - 8:00 pm
From the event description:
Gustavo Miranda, Data Analysis, Program Evaluation and Quality Improvement, at the Etobicoke Children’s Centre will share the following with us:
Online survey services/software like RedCap, SurveyMonkey, and LimeSurvey are a cheap, quick, user friendly way to collect information from an organization’s staff, stakeholders and community partners. This is especially true for organizations with resources too limited to design their own databases and host their own servers.
Unlike the data collected in locally hosted relational databases, however, responses from online surveys can’t always be accessed in a format that lends itself to quick, agile, versatile reporting.
Two little known features available in Excel and the free Power BI Desktop software can mitigate these limitations.
This demo-heavy presentation/discussion will demonstrate how:
1) Power Query’s point-and-click interface as well as its data transformation language, M, can be used to combine several flat files of survey feedback and break them out into a relational table structure in an automated, replicable way ,
and, if we have time
2) how Power Pivot and it’s measurement language DAX can be used to connect those related tables and create quick, interactive reports that can be used to guide decision making and ensure quick responses to client feedback.
Examples of service improvement will be discussed.
This location has a security guard, so we need to supply everyone’s names ahead of time, so please RSVP by 12 PM on Tuesday, October 8, 2019. CES Ontario is a sponsor of Eval Cafe Toronto.