Power BI - Liga I

Elevate your understanding of Liga I 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 I 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 I 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 I data.

Case Study #1: Scenario
Analysis Performance for FCSB

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

Case Study #2: Scenario
Performance Analysis for U Craiova

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

Case Study #3: Scenario
Performance Analysis for Ciprian Deac

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

Case Study #4: Scenario
Performance Analysis for Sepsi OSK

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

Case Study #5: Scenario
Performance Analysis for Farul Constanta

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

Case Study #6: Scenario
Performance Analysis for FC Petrolul Ploieşti

Suppose you currently work as a football analyst in a Romanian team.
You have access to a large number of metrics from all Liga I championship matches. We want you to analyze the performance of a team for the Liga I championship of the season 2022 - 2023.
The team you have to evaluate is FC Petrolul Ploieşti. 

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

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

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

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

Case Study #9: Scenario
MVP Analysis for the match Farul Constanta and CFR Cluj

Suppose you currently work as a football analyst in a Romanian team.
You have access to a large number of metrics from all Liga 1  championship matches which took place in 2022-2023.
We want to compare the performance of the players who participated in the match between Farul Constanta and CFR Cluj on January 23rd and determine the Most Valuable Player (MVP) of the match.

Case Study #10: Scenario
Performance Analysis for Florinel Coman

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