An overview of how the final file will work and the key features of the data set that we will be using throughout the course.
The Inner Workings: Part 13:21
The Inner Workings: Part 25:08
The Inner Workings: Part 311:10
Building a Database
We learn how to set up a fitness testing database in Microsoft Excel that allows for an interactive dashboard experience.
Data Set Overview8:42
Dynamic Scoring Framework
We learn how to build a custom a dynamic scoring framework whereby each metric is associated with an easily digestible score; we give ourselves the ability to choose how each metric score is calculated from an array of options.
Dynamic Scoring System Setup, Part 144:03
Dynamic Scoring System Setup, Part 220:07
Dynamic Scoring System Setup, Part 343:12
Connecting Custom Scores to the Data, Part 117:40
Connecting Custom Scores to the Data, Part 24:15
Metric Categories and Weightings8:35
Controlling for Athletes Who Didn’t Complete All Tests22:02
We create visual elements for our interactive team fitness testing dashboard using our well-organized database structure and dynamic scoring system.
Building Our First Interactive Dashboard Component: A Table of Results41:15
Adding Colors (Conditional Formatting), Part 139:41
Adding Colors (Conditional Formatting), Part 238:08
Interactive Graphs and Charts: The Setup30:01
Interactive Graphs and Charts: Building Them Out23:42
The Finale: Interactions and Design
We organize our dashboard into a nice design, facilitate the interactions, and include features such as Freeze Panes to enhance workflow.
Dynamic Drop-downs, Group Averages, and Making Things Pretty1:10:15
We create more visual elements for our interactive team fitness testing dashboard, including interactive charts that are controlled by our table, and calling out the top and bottom performers for our metrics of interest.
Dynamic Graphs Using Table Filters, Part 141:10
Dynamic Graphs Using Table Filters, Part 228:08
Calling Out the Best and Worst Performers38:49
A Confidential Chart Hack: Dynamic Average Lines and Horizontal Bar Charts9:38