Power Bi

Match Report Part 2 - Set-Up Page

In Part 2 of our match report series we add a set-up page to filter our report page. This page will help to filter our reports to a given match for a team.

Match Report Part 1 - Data Load

Hi all, Welcome to a new series of videos I am starting this week, creating a match report using StatsBomb event data. This series will run over a few videos, starting with this first video walking through loading data in to Power Bi. As always, subscribe here for more videos and to help you Power Performance Through Data. Enjoy the video and if you have any questions, please leave a comment below.

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.

Tutorial - Categorical Slicers in Power Bi

This is the beginning of a series of posts using Power Bi. I have used Power Bi extensively over the last few years and this tool has improved massively to be the world leader in Bi. This first tutorial demos how to use categorical slicers in different configurations. I hope you enjoy!

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