This project will focus on Power Bi, a business intelligence software created by Microsoft. Power Bi is very similar to other software on the market at a much lower price point. The software can be used for big data and provides the user with a cloud based environment to view data dynamically based on the filters (slicers) you decide to use.
Josh Trewin
Data Scientist
I’m a data scientist, learning my way through R / Python and applying to football data from StatsBomb, provided for free through GitHub. Follow my journey on here or Twitter to find out when I add new content.
Posts
Training Load Dashboard: Viewing your team status at a glance
We have our training load dashboard, but how do we see the team at a glance? We create a summary page thats how!
Can I add pop ups to my report? You sure CAN using bookmarks!
Are you wondering how to create pop ups in your PowerBi reports? I will show you how using bookmarks!
Training Load Dashboard: Visualising Warnings
Have you started your training load dashboard and want to know how to make decisions? You can add warnings using conditional formatting and I am going to show you how!
Create a jitter scatter plot with 1 measure in PowerBi
Have you ever wanted to create a Jitter Scatter Plot in Power Bi but you are unsure how? In this PowerBi for Sport Tutorial I will show you how using a single measure!
Creating your very own training load monitoring dashboard with PowerBi
Are you looking to create your very own training load monitoring dashboard? In this PowerBi for Sport Science tutorial I show you how to get started!
Yes, YOU can merge queries in Power Bi with Power Query
Have you been trying to figure out how to join new data to a table in Power Bi? Well you can merge queries in Power Query and I will show you how in this weeks Power Bi for Sport Tutorial.
Tutorial - Scatter Plot Size
In this tutorial, we change the size of a scatter chart point using a disconnected table and a couple of measures.
Tutorial - Conditional Formatting
In this tutorial, I show you a couple of options you have when conditionally formatting values in Power Bi
Match Report Part 4 - Recent Performance
In Part 4 of our match report series we will show performance over recent matches to help visualise how the team is trending.
Oct 15, 2020
1 min read
Data Visualisations, Data Exploration, Power Bi, StatsBomb, Tutorial, Visualisations
Tutorial - Common PowerQuery Errors
In this tutorial I walk through some of the errors I often encounter in PowerQuery and hwo to fix them.
Match Report Part 3 - Today's Performance
In Part 3 of our match report series we add some stats to show the performance of the team in the given match.
Aug 27, 2020
1 min read
Data Visualisations, Data Exploration, Power Bi, StatsBomb, Tutorial, Visualisations
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.
Aug 24, 2020
1 min read
Data Visualisations, Data Exploration, Power Bi, R, StatsBomb, Visualisations
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 - 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
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.
Power Bi - What is it and how useful could it be?
What is Power Bi?
Today I would like to introduce something new on to my blog, Power Bi. Some of you might have heard of this software, but for those who haven’t, Power Bi was developed by Microsoft to provide Business Inteligence software to compete with Tableau and others on the market. Power Bi uses a drag and drop based interface providing an easy to pick up interface for users.