Analysis

Tutorial - Team Shot Dashboard

Hi guys, In this weeks tutorial, we are expanding on the shot plot we created in R by adding some extra information to easily understand the plot and some context around it. This will include cards which total up shots and are coloured based on the if this game was above or below an average for the season. We will also have a matrix at the bottom, highlighting how the shots were created such as from a corner or open play.

Tutorial - Ranking Player Performance

Hi all, In this video I am going to show you an easy way of ranking players within a given context. For this I will create a measure that defines the percentile of players within the positional and season context of your choosing. For this, I will also be using one of the external tools recently added to Power Bi called Tabular Editor. Tabular Editor allows you to add new measures and monitor the performance of your queries.

Tutorial - Plotting Shots With R Part 2

Hi all, In my next video, I build upon the shot plot we created a couple of videos ago using R. This plot was built using ggplot2 and ggsoccer, which allows us to more accurately plot our data. In this video, I add segments to the points allowing you to see the direction of the shots and where they end up. I hope you enjoy! As always, subscribe here for more videos and to Power Performance Through Data.

Tutorial - Rolling Average Measure

Hi all, I thought I would follow on from my calculated column a few days ago and present a method for creating this as a measure as well. This measure uses the same DAX with a few minor differences due to how measures work and what they require in Power Bi. As always, subscribe here for more videos and to Power Performance Through Data. Import Notes for Measures There are a few important things to keep in mind when working with measures.

Tutorial - Rolling Average Across Matches

Hi all, Today I am going to focus more on a calculation rather than the visual. For this video, I will focus on a rolling average across matches, rather than days. This requires an extra step to calculate an index value for the match date. In a future video I will show a different method for doing this as well for different types of data. As always, subscribe here for more videos and to Power Performance Through Data.

Tutorial - Plotting Shots in Power Bi using R

Hi all, last time we created a nice shot plot using the built-in scatter plot for Power Bi. Today we will take things a step further, using the R Custom Visual in Power Bi. This visual allows you to use R code to create a visual however you want, with that visual interacting with the slicers on your page. Use base ggplot2, these visuals will not have any interaction ability, such as tooltips, but they provide a neat way of creating visuals not possible with the built-in set provided by Microsoft.

Tutorial - An Easy Way of Plotting Shots in Power Bi

Hi all, following on from my last tutorial, I have now created something more football specific using the built-in scatter plot in Power Bi. This tutorial will take you through building a basic shot plot with shots coloured by outcome. The video can be found at the bottom of the page, but I will also take you through a step by step process here as well. As always, (subscribe here)[https://www.

Comparing Players in the FA WSL

This post is aimed at walking through one method of comparing players upon specific metrics within a league setting. For this example I will use a couple of different metrics from the free StatsBomb FA WSL dataset.

Creating a Jitter Chart in PowerBi

For this post, I will run through a method of creating a jitter chart using only DAX in caluclated columns

Power Bi - Importing Data

For this new post I decided to make a video tutorial of importing data from a csv in to Power Bi. The video itself is basic, and will appear at the bottom of this post, but I will accompany it below with a few steps and a guide of how I import data in to Bi. For those eagle eyed viewers, you will notice the data I am importing and use is from the recently released StatsBomb Messi dataset, which you can find more about here and can read my tutorial on importing StatsBomb data in to R here.