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.

Paul Bakker

Evaluation Cafe Ontario

Hobbies & Passions

Evaluation and Personal Feedback

Researchers

Nonprofit

Government

Organization Development

Applied Statistics

Public Policy

Public Service

Healthcare Professionals

Agile Reporting of Survey Data

222 Bay St.

Share

Evaluation Cafe Ontario

Agile Reporting of Survey Data

Evaluation Cafe Ontario

Details

Members are also interested in