Power BI - Champions League

Elevate your understanding of Champions 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

  


Champions 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 Champions 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 Champions League data.

Case Study #1: Scenario
Analysis Performance for Bayern Munich

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

Case Study #2: Scenario
Performance Analysis for Paris Saint-Germain.

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

Case Study #3: Scenario
Performance Analysis for R. Lukaku.

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

Case Study #4: Scenario
Performance Analysis for FC Barcelona.

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

Case Study #5: Scenario
Performance Analysis for Manchester City.

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

Case Study #6: Scenario
Performance Analysis for André Onana vs. Ederson.

Suppose you currently work as a football analyst in a European team.
You have access to a large number of metrics from all UEFA Champions 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 UEFA Champions League championship that these players took part.
The players you have to compare are André Onana from Inter and Ederson from Manchester City both of them are Goalkeepers.

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

Suppose you currently work as a football analyst in a European team.
You have access to a large number of metrics from all UEFA Champions 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 UEFA Champions League championship that these teams took part.

Case Study #8: Scenario
 Analyzing UEFA Champions League Teams' Defensive Efforts 2022-2023

Suppose you currently work as a football analyst in a European team.
You have access to a large number of metrics from all UEFA Champions 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 UEFA Champions League championship that these teams took part.

Case Study #9: Scenario
MVP Analysis for the Final UEFA Champions League 2022-2023

Suppose you currently work as a football analyst in a European team.
You have access to a large number of metrics from all UEFA Champions League championship matches which took place in 2022-2023.
We want to compare the performance of the players who participated in the final UEFA Champions League 2022-2023 and find the MVP of the match.

Case Study #10: Scenario
Analyzing Milan's Performance in UEFA Champions League 2022-2023

Suppose you currently work as a football analyst in a European team.
You have access to a large number of metrics from all UEFA Champions League championship matches which took place in 2022-2023.
We want you to analyze the performance of Milan on all matches of the UEFA Champions League 2022-2023 championship that Milan took part.