1.
Rank Ordered List of Top 10 Countries with Most Players
● Step-by-Step:
○ Load the FIFA 2018 dataset into Power BI.
○ Group the data by the 'Country' column and count the number of players in each
country.
○ Create a descending order of countries based on the player count.
○ Visualization: Create a bar chart or column chart to show the top 10 countries by
the number of players.
2. Distribution of Overall Rating vs. Age of Players
● Step-by-Step:
○ Plot 'Age' on the X-axis and 'Overall Rating' on the Y-axis.
sahinursanu64@[Link]
OM19C76FBJ ○ Use a scatter plot to visualize the distribution.
○ You may want to fit a trendline to interpret the age at which players stop
improving.
○ Visualization: Scatter plot with age on the X-axis and overall rating on the
Y-axis.
○ Interpretation: Based on the plot, identify the age where the overall rating starts
to plateau or decline, typically after 28 years.
3. Offensive Player Wages Comparison: Striker, Right-Winger, Left-Winger
● Step-by-Step:
○ Filter the data to show only offensive players (Striker, Right-Winger, Left-Winger).
○ Create a box plot or scatter plot with 'Wages' on the Y-axis and 'Position' on the
X-axis.
This file is meant for personal use by sahinursanu64@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
○ Compare the wages of different positions.
○ Visualization: Box plot or scatter plot comparing the wages of strikers,
right-wingers, and left-wingers.
4. Top 5 Players for Every Preferred Position (Overall and Potential Points)
● Step-by-Step:
○ Filter the data by preferred positions (e.g., forward, midfielder, defender,
goalkeeper).
○ Sort players by 'Overall' rating and 'Potential' and select the top 5 players in each
position.
○ Visualization: You can use a stacked bar chart or table to display the top 5
players for each position with their overall and potential ratings.
5. Clubs with the Maximum Share of Players from England, Spain, and
Germany
sahinursanu64@[Link]
OM19C76FBJ
● Step-by-Step:
○ Filter data by 'Country' (England, Spain, Germany).
○ Group by 'Club' and count the number of players for each club from these
countries.
○ Visualization: Create bar charts or pie charts for each country showing which
clubs have the most players.
6. Do Wages of a Player Get Influenced by Their Potential?
● Step-by-Step:
○ Filter players aged between 16 and 28.
○ Create a scatter plot where 'Potential' is on the X-axis and 'Wages' is on the
Y-axis.
This file is meant for personal use by sahinursanu64@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
○ Look for any correlation between potential and wages.
○ Visualization: Scatter plot comparing wages vs. potential for players aged 16-28.
7. Aggression Comparison Between Strikers and Defenders (Overall 80-85)
● Step-by-Step:
○ Filter data for players with an overall rating between 80 and 85.
○ Separate players by position (Striker vs. Defender).
○ Calculate the average aggression for each group.
○ Visualization: Create a bar chart or column chart to compare the average
aggression of strikers vs. defenders.
8. Positional Profiling for Different Roles/Classes (Aggression,
Acceleration, Agility, Balance, Ball Control)
sahinursanu64@[Link]
OM19C76FBJ ● Step-by-Step:
○ Filter players by position (Strikers and Goalkeepers).
○ Plot the metrics (Aggression, Acceleration, Agility, Balance, Ball Control) for both
positions in one chart.
○ Visualization: Create a line or bar plot to compare these attributes between
Strikers and Goalkeepers.
9. Clubs Consisting of Best Future Players (Overall <86 and Potential >=86)
● Step-by-Step:
○ Filter players with 'Overall' <86 and 'Potential' >=86.
○ Group the data by club and count the number of best future players in each club.
○ Visualization: Create a bar chart to display the top 10 clubs with the most future
stars.
This file is meant for personal use by sahinursanu64@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
10. Wages of Top Clubs (FC Barcelona, Real Madrid, PSG, etc.)
● Step-by-Step:
○ Filter data for players from the top clubs: FC Barcelona, Real Madrid, PSG,
Manchester City, Liverpool, Juventus, Bayern Munich.
○ Create a box plot to visualize the distribution of wages for players in these clubs.
○ Visualization: Box plot comparing the wages of players across these top clubs.
Power BI Steps Overview:
1. Load the Data: Import your FIFA 2018 dataset into Power BI (use Excel, CSV, or other
supported formats).
2. Data Cleaning: Check for any missing values or outliers and clean the data accordingly.
3. Create Relationships: If needed, create relationships between different tables (e.g.,
sahinursanu64@[Link]
Player Info, Club Info).
OM19C76FBJ
4. Visualization: Use the appropriate charts for each analysis (bar charts, scatter plots,
box plots, etc.).
5. Dashboard: Combine all the visualizations into a single dashboard that answers the
questions in a structured manner.
This file is meant for personal use by sahinursanu64@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.