Power Bi

Last updated on May 14, 2021

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.

Power Bi Microsoft Business Intelligence

comments powered by Disqus

Posts

Training Load Dashboard: Workload Ratio Forecasting

Wanting to see what a workload ratio might look like with forecasted load? Use this trick in Power Bi to add this to your reports.

Last updated on May 14, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

Data Management Basics: Creating an Athlete Table

Time to power up our data management skills, starting with an athlete table you can use in your Power Bi reports!

Last updated on May 14, 2021 1 min read Data Management, Power Bi, Tutorial, Sport Science

Training Load Dashboard: Comparing to Planned Load

We have our team summary, so next lets compare to the load we had planned. In this video, we will do that and help with forecasting!

Last updated on May 14, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

What is that X for? Iterator functions in Power Bi

In this video we discuss Power Bi iterator functions and how they can be used in your reports!

Last updated on May 14, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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!

Last updated on Jan 17, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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!

Last updated on Jan 17, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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!

Last updated on Jan 17, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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!

Last updated on Jan 17, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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!

Last updated on Jan 17, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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.

Last updated on Jan 1, 2021 1 min read Data Exploration, Power Bi, Tutorial, Sport Science

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.

Last updated on Oct 26, 2020 1 min read Data Exploration, Power Bi, Tutorial

Tutorial - Conditional Formatting

In this tutorial, I show you a couple of options you have when conditionally formatting values in Power Bi

Last updated on Oct 18, 2020 1 min read Data Exploration, Power Bi, Tutorial

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.

Last updated on Oct 18, 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.

Last updated on Aug 30, 2020 1 min read Data Exploration, Power Bi, Tutorial

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.

Last updated on Aug 26, 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.

Last updated on Aug 18, 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.

Last updated on Aug 26, 2020 1 min read Data Visualisations, Data Exploration, Power Bi, Tutorial, Visualisations

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.

Last updated on Aug 12, 2020 1 min read Data Visualisations, Data Exploration, Power Bi, Visualisations, Tutorial

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.

Last updated on Aug 7, 2020 1 min read Power Bi, Data Visualisations, Visualisations

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.

Last updated on Aug 1, 2020 1 min read Power Bi, Data Visualisations, Visualisations

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.

Last updated on Aug 1, 2020 2 min read Power Bi, Data Visualisations, Visualisations

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.

Last updated on Aug 1, 2020 1 min read Data Visualisations, Power Bi, Visualisations

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.

Last updated on Aug 1, 2020 2 min read Power Bi, Data Visualisations, Tutorial, StatsBomb

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!

Last updated on Aug 1, 2020 1 min read Power Bi, Tutorial, Data Visualisations

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

Last updated on Jul 4, 2020 4 min read Power Bi, Tutorial

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.

Last updated on Jul 4, 2020 6 min read Power Bi, Tutorial

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.

Last updated on Jul 4, 2020 3 min read Power Bi