Research and Infographics for Athletic Performance, Sport Science, and Health

In this video, we first build a dashboard to monitor a single key performance indicator (KPI) metric by comparing athletes’ current performances with their all-time best. We use vertical jump height as the KPI, but any metric (where an increase in the metric is akin to better performance) will suit. Then, we take it to the next level and allow ourselves to change the metrics, whether it be jumping, sprinting (where a decrease is akin to better performance), or weightlifting performance.

This is an example end product. Created by Adam Virgile.

Dataset Download (#1)

Below, you can download the dataset we will be using for building this interactive KPI monitoring dashboard. I encourage you to download the dataset and follow along!

Video #1

In this video, we first build a dashboard to monitor a single key performance indicator (KPI) metric by comparing athletes’ current performances with their all-time best. We use vertical jump height as the KPI.

How to quickly create a Key Performance Indicator (KPI) monitoring dashboard in Excel.

Dataset Download (#2)

Below, you can download the dataset we will be using to expand upon our initial dashboard. We added more metrics, which we will be able to select from. I encourage you to download the dataset and follow along!

Video #2

In this video, we transfer the new dataset into our existing dashboard framework (from Video #1) to add more metrics to our dataset. Don’t worry, it only takes a minute.

How to update the dataset in the Performance Monitoring Dashboard in Excel video series.

Video #3

In this video, we integrate the additional metrics into our dashboard. Although we chose 10-meter sprint time, vertical jump height, and trap-bar deadlift 1RM loads, these metrics could be anything. We allow ourselves to change the metric of interest on the dashboard to focus on whichever metrics interests us most, at that time.

How to add multiple KPIs to select from on a dashboard.

So, how did it go? I’d love your feedback. Send me an email at adam.virgile@gmail.com to let me know how it went!