When it comes to providing reports to the coaching staff or players, the first impression is always important. Within 5 seconds, a coach can decide not to have a look at your report. Within 5 seconds, it is always the design and overall aspect of the report which makes a difference, rarely the underlying analyses. In its brilliant paper Want to see my report, Coach, Martin Buchheit talk about the importance of effective sports science support and rank the attractiveness of the reports among the most important elements to take into account. As such, data needs to be provided to decision-makers in an user-friendly and engaging format 2. As part of our job, we need to compare players performance with previous performance or with pairs daily. In this post, we will try to move step-by-step from the classic 2 bars side-by-side chart to something that provides more insights and which is more engaging.

Figure 1: 2 bars side-by-side chart to compare player A with the average performance

Figure 2: Comparing performance with previous performances – another approach

Importing data

When we open our Tableau software, the first thing is to import our dataset. This dataset is simple – 1 column with the player name, one with date and one with a performance-related variable (here, Mechanical Work during the game).

Visualizing data

We start by moving the ‘Performance variable’ (Mechanical Work (a.u)) into the Column Shelf. The variable is aggregated as the sum of all the data point for this variable and visualized as a bar chart.

My goal is to get a point for each different data point (here, dates). We need to take the Date pill from the Dimension Shelf to Details in the Mark Shelf. Right click on the Date which is automatically aggregated by Year and select Exact date (Date exacte in French!). Tableau has changed your bar chart into multiple points along the x-axis.

To move forward, we need to create a Parameter in tableau to select the date we want to compare with the whole dataset. In the left panel, click on create parameter and set it to Date and allow all values.

The next step is to build a new variable to say “This is the point I want to highlight”. Right click on the Date pills > create > calculated field.

Then, I simply do an If statement, either with a IF xx THEN xx ELSE xx END statement or, easier, IIF formula.

If my date is the same than the one selected in my parameter, we return a string “Selected Date” (or whatever you want), if not we return “Others”.

Right click on the parameter (bottom shelf, Selected_Date pill) and click on Show parameter command.

After selecting a date in the parameter, we need to put the Selected_Date from the Dimension Shelf into Color and Size in the Mark shelf.

We can play with the Color and Size Mark to customize this visualization.

Finally, I use the Analytic panel and drag the Box-plot (french traduction is “Boite à Moustache”!) into my Viz. A customizable box-plot appear in the Viz. I use it often as a way to provide Median and inter-quartile ranges into my Viz. When your players or coaching staff is educated to it, I find it a very efficient way to rank your performance!

Playing with the different formating option and marks and you can easily end-up with a similar visualization. In my opinion, it is as simple as doing 2 bar charts (or 1 bar and a point!) and much more efficient and engaging.

Share This