Build Self-Updating Dashboards with Excel Power Query and Power Pivot

H-PEA Online Post-Conference Workshop
Sept. 20, 2024 2:15- 3:45 pm HST

Dr. Yao Hill, University of Hawai'i at Mānoa

Workshop Description

Are you a program evaluation or assessment professional who frequently handles recurring data? Tired of the time-consuming and error-prone processes of data analysis and visualization? Join this 90-minute hands-on workshop and discover how Excel's Power Query and Power Pivot can revolutionize your workflow.

Workshop Requirements

• Participants should have Excel 2010 or later installed.
• Familiarity with Excel pivot tables is necessary.
• The demonstration will be conducted using Microsoft Excel 365.

In this workshop, you will learn to:

• Efficiently clean and transform your data.
• Seamlessly merge multiple data sources.
• Generate tables and create dynamic dashboards that update automatically with new data.

By using these tools, you'll save valuable time, allowing you to focus on collaborative data interpretation and stakeholder engagement. Through step-by-step guidance, you will gain practical skills to apply immediately.

Dr. Yao Hill is a specialist in the Assessment and Curriculum Support Center at the University of Hawai‘i at Mānoa. She has 15 years of experience providing resources, consultations, and training on learning assessment techniques and approaches to faculty in higher education and fellow program evaluators.