This dashboard is an attempt to visualize the TV and commercial revenue spread among the 20 teams. It also tries to provide insights into the following aspects:
- Revenue composition
- Top team revenue share (Pareto chart)
- Revenue rankings vs league position
The revenue data is provided by the Premier League. The link to the dashboard is here: http://t.cn/RPx3Eqh
1.Revenue Composition
Each team gets 5 different revenues. 3 of them are equal among all the clubs. The merit payments create the biggest spread between clubs because it's linear to a club's position.
2.Top team share of the total league revenue
Using Pareto analysis, we see that top 9 teams took half of the total revenue, and top 15 teams took 80% of the total revenue. This is consistent with the 2012 data. Comparing to La Liga in Spain, Premier League is doing a much better job in distributing its revenue evenly among the teams.
3.Revenue rankings vs league position
4 of the 5 revenue types are predictable according to a team's league position. One of them is not so much dependent on the position: facility fees. It is paid to a club if its matches are broadcast in the UK. So it is a testament of this club's popularity.
As a result, the total revenue per team is not always in line with its league position.
There are 3 smaller graphs below.
3.1 Revenue rankings and league position
The diagonal is the league position for each team. We see that the revenue rankings are oscillating around the diagonal. Those teams with revenue rankings to the lower right of the diagonal are doing better than their league positions indicate.
3.2 Facility fees ranking vs league position
The 2nd graph shows that some lower positioned clubs are more popular than those above it. Those clubs to the right of zero are doing better than their places in the league. Noticeable are Aston Villa and Manchester United. They are getting unusually high facility fees relative to their positions in the league. Positioned at No.15, Aston Villa is getting as much as that of Everton whose position is No.5. Villa must be playing an exciting season. Everton, Southampton and Stoke City must be boring in their play. They didn't get broadcast as much as their league positions promised. Also noticeable is the fact that 8 clubs are getting the same bottom facility fees, among them are No.8 Southampton and No.9 Stoke City.
3.3 Total revenue ranking vs league position
The 3rd graph shows that even though Man City is the top dog in the 13-14 season, it made less money than the 2nd placed Liverpool. The Reds must start missing Luis Suarez already. Again, those clubs to the right of zero are doing better than what their league position indicates. Newcastle made more money than two clubs above it. Its game was not particularly spectacular. It got higher revenue ranking only because the two clubs above it weren't that popular. Everton and Crystal Palace are ranked in revenue lower than two clubs below them. It seems that they didn't get what they deserve.
(Refresh the page if you want to view the gif image multiple times. Or go to Tableau Public and click the button at the top-right corner.)
The key idea is to float a semi transparent worksheet on top of the dashboard, where a help text box is strategically placed on top of each chart. This way, we can explain how to view each chart and what data points are important, etc. This worksheet is collapsible by a show/hide button.
Below I would like to show how this worksheet can be constructed.
1. Sheet with a single data mark.
- Double click the empty space in Marks panel and add two single quotes. Make the null pill a text label. This creates a single null mark.
- Set the view as "Entire View"
2. Create an show/hide button
- Go to the target dashboard
- Drag a floating vertical container to the dashboard, making it cover all the area of interest.
- Drag the Single Null Mark sheet and drop it into the above container. Hide the sheet title.
- Create an open/close button for the container and place the button at the top-right corner.
3. Add annotations
- Format the sheet background opacity as 70% in the layout manager
- Select area annotations and place them anywhere of interest.
- Write help text and format it to highlight important messages.
- The text can serve as functional guide and/or insight guide.
Here is an example. Feel free to download the workbook and explore. Click the "i" button at the top-right corner to view the in-place help.
0
Add a comment