What is this? It’s a video series where we build a dynamic, interactive team performance dashboard, from scratch! After downloading the dataset below and watching the videos, you’ll have:
Below, you can download the dataset we will be using for building this Ultimate Player Dashboard. I encourage you to download the dataset and follow along!
Video #1: Overview
We review the dataset we use for this video series and go over our dashboard plan. And yes, it’s extremely important to have a plan before trying to build your dashboard!
Video #2: In-table Calculations & Joining Datasets
We create Readiness Scores and Session Rating of Perceived Exertion (sRPE) formulae in our table from the raw data. We also join our athletic performance, daily training load/readiness, and player profile data together into a single table (although collected separately).
Video #3: Profile Info and Injury Status for Specified Player and Date
We discover how to dynamically display the profile data for the athlete we select in our dashboard, as well as his or her injury status for a specified date (that we dynamically control)
Video #4: Dynamic Cohort Comparisons
Do we want to compare the athlete’s data to himself, the position group, or the team? Well, now we have a choice that we can manipulate with a click of a button.
Video #5: Formula Beast Mode!
We create formulae to not only encompass the cohort we want to compare the athlete with, but we’ve also added the ability to change the date range for which the player, position, or team average should be based on. This is a very powerful, but complex video. Have your coffee on-hand for this one – big formula ahead!
Video #6: Athletic Performance KPIs
We create KPIs which display the athlete’s most recent athletic performances. We get the latest Trapbar Deadlift, Bench Press, Countermovement Jump, and Body Fat Percentage outcomes, as well as the dates associated with these performances, to display on our dashboard.
Video #7: Dynamic Images and Headshots
We review how to display headshots (or images) for our athletes. We pick an athlete, and their headshot (or image) automatically displays on our visualization dashboard, too.
Video #8: Drop-down Menus and Date MADNESS
We create a few dynamic drop-down menus that automatically update to accommodate for added or removed items. We also set up a structure that lets us get a series of latest dates in a dynamic fashion.
Video #9: Dynamic Rolling Averages and Supermetric Selector
We create a pretty intense formula that allows us to visualize a metric that we select from a list of metrics, and also, we create a formula that allows us to dynamically control the number of days we use in a rolling average calculation with the click of a button.
Video #10: Dynamic Athletic Performance Graph and Getting Visual
We start the visualizations via, well, doing a little bit of everything. We create a few dynamic graphs, apply some conditional formatting to injury status and participation status, and we organize our dashboard layout.
Video #11: Dynamic Gauge Charts
Currently, there is no audio in this video. I’ll re-shoot it ASAP. In the video, we build gauges to identify how an athlete’s training load and readiness correspond to their norms.
Video #12: Conditional Formatting and Visual Organization
We create a really cool conditional formatting visualization using data bars, and we drastically enhance the organization of our dashboard design.
Video #13: More Graphs and Finishing Touches
We create another graph and put the finishing touches on our stunning dashboard design. See the level-up videos to incorporate more features that not only will add tremendous value to your dashboard, but will give you a ton of practical Excel knowledge.
Video #14 (LEVL UP): Scrollbars for Dates
We make changing dates a lot easier on ourselves by adding multiple date scrollbars (really spin buttons) that all talk to one another, and we go over some neat graphing tricks.
Video #15 (LEVL UP): Text-based Logic and Communication
We learn how to apply text-based logic to tell us (and the dashboard viewer) what data is being compared. We have a lot of ways we can manipulate our data, and we create a way to automatically display the types of data we are comparing, based on our dashboard manipulations.
Video #16 (LEVL UP): Awesome Injury Status Over Time Graph
We create an awesome graph that lets us see color-coded injury status over time along with a metric that we select. We also go over a little bit more text logic and using shapes/illustrations in Excel.
Video #17 (LEVL UP): Adding Multiple Teams and Big-time Fixes
We create the ability to assign teams to athletes, create a dynamic drop-down list of teams that then filters our athlete list to only athletes on that team. But first, we go over a nifty trick that allows us to make quick, holistic adjustments to many areas of the dashboard at one time.
So, how did it go? I’d love your feedback. Send me an email at firstname.lastname@example.org to let me know how it went!
If you enjoyed your experience and got something out of it, show off your well-deserved new team dashboard and share the experience with your friends!