BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Canadian Evaluation Society - Ontario Chapter - ECPv6.15.15//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Canadian Evaluation Society - Ontario Chapter
X-ORIGINAL-URL:https://evaluationontario.ca
X-WR-CALDESC:Events for Canadian Evaluation Society - Ontario Chapter
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Toronto
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20180311T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20181104T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20190310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20191103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20200308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20201101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Toronto:20191009T180000
DTEND;TZID=America/Toronto:20191009T200000
DTSTAMP:20260902T063658
CREATED:20210616T173321Z
LAST-MODIFIED:20210616T173321Z
UID:5669-1570644000-1570651200@evaluationontario.ca
SUMMARY:Eval Cafe: Agile Reporting of Survey Data
DESCRIPTION:From the event description:  \nGustavo Miranda\, Data Analysis\, Program Evaluation and Quality Improvement\, at the Etobicoke Children’s Centre will share the following with us: \nOnline 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. \nUnlike 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. \nTwo little known features available in Excel and the free Power BI Desktop software can mitigate these limitations. \nThis demo-heavy presentation/discussion will demonstrate how: \n1) 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 \, \nand\, if we have time \n2) 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. \nExamples of service improvement will be discussed. \nThis 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. \nTickets: https://www.meetup.com/Evaluation-Cafe-Toronto/events/265386723/.
URL:https://evaluationontario.ca/event/eval-cafe-agile-reporting-of-survey-data/
LOCATION:Ontario
CATEGORIES:EvalCafe,Membership,Social Networking
END:VEVENT
END:VCALENDAR