Power BI - Liga Portugal

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

  


Liga Portugal 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 Liga Portugal 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 Liga Portugal data.

Case Study #1: Scenario
Analysis Performance for Vizela

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

Case Study #2: Scenario
Performance Analysis for Braga

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

Case Study #3: Scenario
Performance Analysis for Otávio

Suppose you currently work as a football analyst in a Portuguese team.
You have access to a large number of metrics from all Liga Portugal championship matches which took place in the past three seasons. We want you to analyze the performance of a player in the Liga Portugal championship of the season 2022 - 2023.
The player you have to evaluate is Otávio.

Case Study #4: Scenario
Performance Analysis for Paços de Ferreira

Suppose you currently work as a football analyst in a Portoguese team.
You have access to a large number of metrics from all Liga Portugal championship matches which took place in the past three seasons. We want you to analyze the performance of a team in the Liga Portugal championship of the season 2022 - 2023.
The team you have to evaluate is Paços de Ferreira.

Case Study #5: Scenario
Performance Analysis for Benfica

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

Case Study #6: Scenario
Performance Analysis for Odysseas Vlachodimos and Diogo Costa

Suppose you currently work as a football analyst in a Portuguese team.
You have access to a large number of metrics from all Liga Portugal 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 Liga Portugal championship that these players took part.
The players you have to compare are Odysseas Vlachodimos  from Benfica and Diogo Costa from Porto both of them are Goalkeepers.

Case Study #7: Scenario
Teams Performance Analysis for the Liga Portugal in 2022-2023

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

Case Study #8: Scenario
Analyzing Liga Portugal Teams' Defensive Efforts 2022-2023

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

Case Study #9: Scenario
MVP Analysis for the match Benfica- Porto on October 21st

Suppose you currently work as a football analyst in a Portuguese team.
You have access to a large number of metrics from all Liga Portugal championship matches which took place in 2022-2023.
We want to compare the performance of the players who participated in the match between Benfica and Porto on October 21st and determine the Most Valuable Player (MVP) of the match.

Case Study #10: Scenario
Performance Analysis for Hidemasa Morita

Suppose you currently work as a football analyst in a Portuguese team.
You have access to a large number of metrics from all Liga Portugal championship matches which took place in the past three seasons. We want you to analyze the performance of a player in the Liga Portugal  championship of the season 2022 - 2023.
The player you have to evaluate is Hidemasa Morita.