Embedded Files
Project Title: FIFA World Cup - 2022 Information Analysis
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
About Dataset & Files
Dataset Source: Kaggle
Introductory Key Points:
The Dataset is Contained with 7 tables. Those are pointed below:
➡️ 2 dimension tables:
Country Profiles (Primary Key Column Name: Country Name)
Group_fact (Primary Key Column Name: team)
➡️ 3 fact tables:
All_matches_2022_team1 (This table has connection with 3 tables; Country Profiles, Group_fact, and Match Facts)
All_matches_2022_team2 (This table has connection with 3 tables; Country Profiles, Group_fact, and Match Facts)
Player Profiles (This table has relationship with the Group_fact table)
➡️ 2 calculated tables; which are calculated using DAX formulas:
Match Facts (This table also works as a dimensional table with the primary key column named Tournament Stages)
Highest Goal by Player (CT) (This is a single-row table contains with 14 columns)
The report is Contained with 4 Dashboards.
Dashboard - 1: Overall Tournament States
Visual Description:
There are 8 Card visuals with the calculated totals of the different criteria in World Cup (WC) - 2022. Those cards are briefly introduced below:
Total Goals: This card shows the total number of goals happened in WC-2022 tournament.
Total Passes: This card shows the total amount of passes completed by participating team in WC-2022.
Total Free Kicks: This card shows the total number of free kicks done by participating team in WC-2022.
Total Corners: This card shows the total number of corners called by referees in WC-2022.
Total Offsides: This card shows the total number of offsides called by referees in WC-2022.
Total Fouls: This card displays the total number of fouls called by referees in WC-2022.
Total Yellow Cards: This card displays the total number of yellow cards shown by referees in WC-2022.
Total Red Cards: This card displays the total number of red cards shown by referees in WC-2022.
The Funnel Chart, titled "Top 5 Teams with Highest On-Target Goal Attempts", shows the bars of top 5 participating team in WC-2022, representing the number of goal attempts to the opposition team. From this visual, it seems that the highest goal attempt was done by the champion team Argentina (48), although the second highest attempts were performed by one of the quarter-finalist team Brazil (41).
The Table visual, titled "Top 5 Teams with Highest Average Goal Preventions (Per Match)", shows the data of top 5 team who has the highest average of defending goals. This visual shows that the highest average time of the goal prevention was done by Costa Rica, which means that the team Costa Rica (Played 3 games in WC-2022) defended opponent goal attack 63 times, so their average goal prevention per match was 63/3 = 21.
The Waterfall Chart, titled "Top 5 Teams with Highest Goal Chance Conversion Ratio", displays some bars of Top 5 participating team in WC-2022 based on the highest Chance-to-Goal conversion ratio, as a waterfall visual. From this chart, it can be observed that France has converted 0.43% of its chance to goal & possesses the highest goal conversion ratio among all participating countries in WC-2022.
The Aria Chart, titled "Successful vs Unsuccessful Pass Ratios by Teams", shows both successful and unsuccessful pass ratios together for all 32 participating countries in WC-2022. While placing cursor on any country, Report user should be able to see both pass ratios of that country. For instance, Australia has 76.81% and 23.19% successful and unsuccessful pass ratios, respectively; which indicates that out of 100% of passes, Australian player have executed 76.81% of passes successfully & 23.19% of passes were unsuccessful.
Dashboard - 2: Match & Group Stats
Visual Description:
The Slicer visual, titled "Select Group", contains all 8 groups in the WC-2022, mentioned in the "Group_fact" table. Report user should be able to select only one specific group title from this slicer. Based on the selection, some visuals of this dashboard will change accordingly.
There are 3 Card visuals in this dashboard whose values change based on the group selected in the "Select Group" slicer. Those cards are introduced below:
Group Champion: This card shows the champion of the selected group.
Group Runners-Up: This card shows the runners-up of the selected group.
Total Goals Scored in the Group: This card shows the total number of goals scored in matches of the selected group.
The Treemap visual, titled "Goals Scored by Countries in the Group", displays the goals scored by the teams in the group stage matches. This visual contains only the boxes of those teams from the selected group in the "Select Group" slicer. The size of the box varies based on the amount of goals scored by the team.
The Donut Chart, titled "Point Chart of the Group", shows the comparison of points achieved by the 4 teams of the selected group from "Select Group" slicer. In this visual, the larger the point of the team is, the larger is the share in the chart is.
The other visuals in this dashboard are free from the filter context of the slicer "Select Group". Those visuals are briefly described below:
The Table visual, titled "Attacking Attempts in Different Stages of the Tournament", shows the total number of attempts occurred in different positions of different stages in the tournament. There are total 5 columns in this table:
Tournament Stages: This column holds the names of all the tournament stages in WC-2022.
No. of On-target Attempts: This column displays the total number of on-target goal attempts towards the goal post in different stages of the tournament.
No. of Off-target Attempts: This column displays the total number of off-target goal attempts away from the goal post in different stages of the tournament.
No. of Attempts Inside Penalty Area: This column displays the total number of attempts done within inside the penalty line in different stages of the tournament.
No. of Attempts Outside Penalty Area: This column displays the total number of attempts done from outside the penalty line in different stages of the tournament.
There are 2 Card visuals in the last part of the dashboard which are briefly explained below:
Highest Goal Scorer in the Group Stage: This card shows the team in WC-2022 which scores the highest goals in the group stage.
Highest Average Possession in the Tournament: This card shows the team in WC-2022 which has the highest average possession of ball per match.
Dashboard - 3: Country States
Visual Description:
The Treemap visual, titled "Average Goals Scored by Each Continent", displays the number of goals scored by the participating teams from each of the 5 continents of the world. It is noteworthy that there are 7 continents in the world, but "Antarctica" has no country to play & "Australia" is merged with "Asia" continent; hence there stayed only 5 continents (Asia, Europe, Africa, North Americe, and South America). This visual shows that the highest average goal scored per match was recorded for the participating teams in both South America & Europe (7), while Teams from North America (3) has the lowest goal average. Report user should be able to see the Average Goals Scored (Per Match) as well as Number of Team while placing curson on each continent box.
There are total 4 Card visuals just below the treemap visual of this dashboard. Those cards are briefly explained below:
WC-2022 Champion: This card shows the champion team of FIFA World Cup 2022.
WC-2022 Runners-up: This card shows the Runners-up team of FIFA World Cup 2022.
Highest Goal Scorer: This card shows the team who scored the highest goals (including the number of goals) in FIFA World Cup 2022.
Highest Goal Conceder: This card shows the team who conceded the highest goals (including the number of goals) in FIFA World Cup 2022.
The Clustered Column Chart, titled "Top 5 Countries Causing Highest Forced Turnovers", shows the bars of top 5 countries in WC-2022 who performed the highest forced turnovers in the matches. Forced Turnover in a football match is known as the situation when possession of the team lost due to the pressure of the opponent team. This visual clearly shows the top 5 teams who faced the most forced turnovers in the tournament, where Croatia (548 time). faced the highest forced turnovers by the opponent teams.
The Table visual, titled "Defensive Pressures by WC Teams", shows the listed numerical data on defensive pressures created by all the participating teams in the FIFA World Cup 2022. There are 3 columns in this table:
Country Name: This column holds the names of all the participating teams in WC-2022, mentioned in the "Country Profiles" table.
Defensive Pressures in Field: This column displays the total number of defensive pressures created by the team to the opponent teams while playing matches in WC-2022.
% of Total Defensive Pressures: This column displays the ratio of the defensive pressures created by the team and the total number of defensive pressures created in the tournament by all the teams as a percentage value.
Dashboard - 4: Player Stats
Visual Description:
The Text Search Slicer, titled "Enter Player Name (Spelling Must Be Correct)", shows a prompt space for Report user to put a players' name who is participating in the FIFA World Cup - 2022. The important notation is, the spelling of the player name must be correct, otherwise the filter context of this slicer will not work. Based on the input of the Report user in this slicer, some visuals of this dashboard will change accordingly.
There are 4 Card visuals in this dashboard whose values change based on the user input in the "Enter Player Name (Spelling Must Be Correct)" slicer. Those cards are introduced below:
Country: This card shows the country name that the player is currently playing for in WC-2022.
Position: This card shows the playing position of the player in the team.
Age: This card shows the age of the player.
Club Title: This card shows the club name in which the player is currently contracted in.
The other visuals in this dashboard which do not follow the filter context of the "Enter Player Name (Spelling Must Be Correct)" slicer are briefly descripted below:
There are 3 Card visuals in different places of the dashboard:
Highest Goal in Tournament: This card shows the player name who scored the highest goal (including that players' country the number of goals) in WC-2022.
Average Age of Players in Tournament: This card shows the average age of the players participating in WC-2022.
Total Listed Players: This card shows the total number of listed players in WC-2022, mentioned in the "Player Profiles" table.
The Pie Chart, titled "Number of Players by Age Category", shows the comparison of the number of players based on there age category. In this visual, number of players are categorized in three different age groups; Under 25 years old, aged between 25 to 30 years, and over 30 years old. This chart shows that middle-aged players (347 players, aged between 25 to 30 years old) are the highest in this tournament, where aged players (140 players, over 30 years old) are the lowest.
The Clustered Column Chart, titled "Total Listed Players by Number of Games in WC-2022", shows the bars of total nubmer of players in WC-2022 based on the playing matches. In FIFA World Cup 2022, a player from a team could play at most 7 games (if the team can go to the semi-final round), or less. This visual clearly shows that highest number of players played 3 matches (212), and only 23 players played 6 matches.
There are another 3 Table Visuals in this dashboard which do not follow the filter context of the "Enter Player Name (Spelling Must Be Correct)" slicer. Those Visuals are briefly explained below:
The Table visual, titled "Forwards Played More Than 400 Minutes", displays the profiles of the forwards in different teams who played more than 400 minutes in the field in FIFA World Cup 2022. There are total 12 such forwards in this world cup, and there data are represented in 5 different columns:
Forwards: This column holds the names of the forward footballers who played more than 400 minutes in WC-2022.
Country: This column displays the country/team names the forwards are playing for.
Minutes: This column displays the playing time of each forward in minutes (every value is supposedly more than 400 here).
Age: This column displays the age of each forward.
Goal: This column displays the total number of goals done by each forward in WC-2022.
Assist: This column displays the total number of assists done by each forward in WC-2022.
The Table visual, titled "Players With 3 (Highest) Yellow Cards", displays the profiles of the players who got highest 3 yellow cards in FIFA World Cup 2022. There are 2 such players in this world cup whose name & position are denoted in 2 different columns:
Player Name: This column holds the names of the player who got 3 (highest) yellow cards in WC-2022.
Position: This column displays the playing position of the players in their teams.
The Table visual, titled "Players With Red Cards in WC-2022", displays the profiles of the players who got red cards by the referees in FIFA World Cup 2022. There are total 4 players in this world cup whose name & position are denoted in 2 different columns:
Player Name: This column holds the names of the player who got red cards in WC-2022.
Position: This column displays the playing position of the players in their teams.
Page updated
Google Sites
Report abuse