Day 1

CLASSIC dashboard:

Click on the dashboard image to download the Excel file.

CLASSIC DESIGN

Slides:

Click HERE to download the slides.

POWERPOINT SLIDES

eXCEL Practice data set:

practice_data_set_1.xlsx
File Size:	1172 kb
File Type:	xlsx

Download File

---

---

**Optional homework**

Download the homework assignment and try your hand at building a sample dashboard for a client. Instructions are included in the Excel file:

homework_optional.xlsx
File Size:	26 kb
File Type:	xlsx

Download File

---

---

Day 2

MULTI-CONSTRUCT dashboard:

Click on the dashboard image to download the Excel file.

MULTI-CONSTRUCT DESIGN

Slides:

Click HERE to download the slides. 

POWERPOINT SLIDES

Practice data sets

practice_data_1_split_image.xlsx
File Size:	1156 kb
File Type:	xlsx

Download File

---

qual_dashboard_ii.xlsx
File Size:	814 kb
File Type:	xlsx

Download File

---

---

Additional resources & Reflection questions

• Color wheel: https://www.noissue.co/blog/color-psychology-myth-or-marketing-tool
• Colorblindness Simulator: https://www.color-blindness.com/coblis-color-blindness-simulator/
• ​Color Palette Generator: ​https://www.canva.com/colors/color-palette-generator/​
• Sample Dashboards:  https://www.shellyphd.com/sample-dashboards.html
• Step-by-Step PARCS method: https://www.shellyphd.com/tips--tricks/tip-1-use-the-parcs-method-to-create-an-interactive-dashboard-in-excel