The following is a post that I have preserved in its original form. It was the 5th of 6 posts that I created for a computer science class at Northwestern.
I loaded my data set into Tableau directly from Google BigQuery. I then generated two charts: a Bar Chart and a Pie Chart.
The generation of the Bar Chart was relatively an easy process because my Google Big Query categories were pre-loaded by Tableau. All I needed to do was drag one “Dimension” and one “Measure” into the Columns and Rows fields. After dragging the categories, Tableau auto-populated the graphs for me. The bar chart can be seen below.
I chose to sort the Top 100 Market Values by club. The club name went to the x axis and the market value on the y axis. This shows which clubs have the most value out of the Top 100 valued players according Transfmarkt. While I imagined that most of the value would be in the top 6 “Big Clubs”, I was surprised to see that there were another 6 clubs that made up the rest of the Top 100 market values.
The next chart was a little bit more difficult to generate. I knew that I wanted to use a different variable to experiment with, so I chose to sort Market Value by Position. In order to do this, I had to experiment for a good 45 minutes to an hour in order to figure out how to label the graph correctly. I ended up finding the magic formula below:
I use the Market Value as the dependent variable, and the Position as the independent variable. The chart is sorted from greatest to least value by position in counter-clockwise direction.
The Pie Chart shows that, as explained in a previous post, Center Forwards carry the most value. Somewhat unsurprisingly, the next most valuable player group is the Center Back, presumably in order to prevent those valuable forwards from scoring.
After the Center Back, there are 5 midfield groups that cumulatively overwhelm the chart. While some classify Wingers as forwards, they tend to fit more snugly in the midfield than as forwards.
Finally the least valuable parts of the chart show defenders and (unmarked) goalkeepers.