Dashboard Workshop by Shelly Engelman, Ph.D.
Creating dynamic dashboards in Excel is a cost-effective way to view important data with minimal construction time. This workshop takes you through all you need to know to design interactive dashboards from start to finish in Excel. Dr. Shelly Engelman will provide you with practical, hands-on, step-by-step instructions to turn your static data table into a dynamic dashboard that will ‘wow’ your stakeholders. She will demonstrate how to use Pivot Tables, Pivot Charts, and Slicers to create well-designed dashboards that allow your stakeholders to slice-and-dice the data in seconds. You will leave the workshop with clear steps that you can immediately implement to create stunning dashboards that are dynamic and easy to reproduce.
You will learn:
• How to use PivotTables, PivotCharts, and Slicers to create interactive dashboards
• Best practices for designing interactive dashboards to tell your story
• Quick visualization tips and tricks to customize your dashboards for stakeholders
About Shelly Engelman, Ph.D. is Principal Consultant at Custom EduEval LLC in Austin, TX. Dr. Engelman has over a decade of experience leading evaluation and research projects for over 40 federal, state, and local K-16 education programs. Prior to launching her own consulting practice, Dr. Engelman worked as a STEM Program Evaluation and Research Coordinator for the University of Texas at Austin (UT Austin). While at UT Austin, Dr. Engelman directed the Evaluation Fellows Program—a 1-year experiential program designed to train next generation evaluators and education researchers. www.shellyphd.com