Power BI - Super League

Elevate your understanding of Super League with Microsoft Power BI.

This micro course enables you to harness real-time datasets to craft dynamic dashboards that monitor live match statistics, player movements, and team strategies.
Dive into the intricate details of the tournament and learn to visualize them effectively, making it easier for coaches, players, and fans to comprehend and appreciate the game's nuances.


Power BI Bootcamp

  


Super League Data Lab  

The Intro course is free

  • Video Introduction
  • Paid Section Preview
  • Theory
  • Case Study Preview
  • Exercises

#2 Power Query Editor

  Power Query
 Text Based Query Editing
 Split & Merge Text Format
 Standard & Scientific
 Statistics
 Grouping & Aggregating Data
 Group By Query
 Advanced Group By Query
 Pivoting & Unpivoting Data
 Pivot

#3 Visualizations

 Merging Queries
 Application of Merging Queries
 Video
 Lookup Table vs Data Table
 Table Relationships
 Autodetect Relationships
 Create/Edit New Relationships
 Model Schema
 Snowflake Schema
 Visualization with PBI
 Power BI's Report View
 Card Reason
 Bar Chart
 Cards
 Donut Charts
 Advanced Column Charts
 Treemaps
 Maps
 Slicer Filters
 DashBoard
 Matrices

#4 Power Bi DAX

 Data Analysis Expressions (DAX)
 Math & Statistics Functions
 Count Functions
 Text Functions
 Date & Time Functions
 DAX Calculated Columns
 AX Conditionals - IF
 DAX Conditionals & Columns
 DAX Conditionals - IF OR
 DAX Measures - Maths
 DAX Text Functions
 DAX Count
 DAX Date & Time - WEEKDAY()
 DAX Date & Time - DATEDIFF()
 DAX CALCULATE()
 DAX ALL()
 DAX RELATED()

Data Labs

#5 Case Studies

A Data Lab is essentially a dynamic learning environment where we put into practice the latest skills we've acquired in Power BI through the League of your choosing.

In this section, our focus shifts to the realm of Super League data.

Data Lab serves as a practical course where we immerse ourselves in hands-on Case Studies, applying our knowledge to gain insights and make data-driven decisions.

With each Case Study, we explore new dimensions of data analysis, allowing us to delve into the latest trends and uncover hidden patterns within the world of Super League data.

Case Study #1: Scenario
Analysis Performance for PAS Giannina

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a team in the Stoiximan Super League championship of the season 2022 - 2023.
The team you have to evaluate is PAS Giannina.

Case Study #2: Scenario
Performance Analysis for PAOK

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a team in the Stoiximan Super League championship of the season 2022 - 2023.
The team you have to evaluate is PAOK.

Case Study #3: Scenario
Performance Analysis for I. Konstantelias

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a player in the Stoiximan Super League championship of the season 2022 - 2023.
The player you have to evaluate is Ioannis Konstantelias.

Case Study #4: Scenario
Performance Analysis for Levadiakos

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a team in the Stoiximan Super League championship of the season 2022 - 2023.
The team you have to evaluate is Levadiakos.

Case Study #5: Scenario
Performance Analysis for AEK Athens

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a team in the Stoiximan Super League championship of the season 2022 - 2023.
The team you have to evaluate is AEK Athens.

Case Study #6: Scenario
Performance Analysis for Alexandros Paschalakis and Dominik Kotarski

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan League championship matches which took place in 2022-2023.
We want you to compare the performance of 2 players based on all matches of last season's Stoiximan Super League championship that these players took part.
The players you have to compare are Alexandros Paschalakis from Olympiakos Piraeus and Dominik Kotarski from PAOK both of them are Goalkeepers.

Case Study #7: Scenario
Teams Performance Analysis for the Stoiximan Super League in 2022-2023

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in 2022-2023.
We want you to compare the performance of the teams on all matches of last season's Stoiximan Super League championship that these teams took part.

Case Study #8: Scenario
Analyzing Stoiximan Super League Teams' Defensive Efforts 2022-2023

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Syper League championship matches which took place in 2022-2023.
We want you to compare the defensive performance of the teams on all matches of last season's Stoximan Super League championship that these teams took part.

Case Study #9: Scenario
MVP Analysis for the match Panathinaikos - AEK Athens on April 30th

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in 2022-2023.
We want to compare the performance of the players who participated in the match between Panathinaikos and AEK Athens on April 30th and determine the Most Valuable Player (MVP) of the match.

Case Study #10: Scenario
Performance Analysis for Rubén Pérez

Suppose you currently work as a football analyst in a Greek team.
You have access to a large number of metrics from all Stoiximan Super League championship matches which took place in the past three seasons. We want you to analyze the performance of a player in the Stoiximan Super League championship of the season 2022 - 2023.
The player you have to evaluate is Rubén Pérez.