Creating Automated Visual Displays Conference presentation
Conference presentation at the
American Evaluation Association’s conference
During this 45-minute demonstration, Agata Jose-Ivanina and I demonstrated how to automate production of dashboards and reports complete with graphs, tables, and text using only Microsoft Word and Excel.
Download the handout here.
Data dashboards put stakeholders in the driver’s seat by providing instant, understandable evaluation results. In this demonstration, Agata Jose-Ivanina and I presented a process that allows us to create automated, on-demand dashboards that are valuable for programs and save time for evaluators.
We focused our demonstration on using MS Word and Excel — tools that most users already have. The presentation covered the following steps in the process of creating dashboards:
- Designing an easy-to-read template to display findings that program staff need;
- Organizing data to facilitate the creation of multiple dashboards efficiently; and
- Automating dashboard creation to minimize the amount of manual effort necessary.