WorldCup Dashboard

Dashboard and reports of interesting data and facts about all FIFA World Cup editions (1930-2018) with a timeline to highlight and describe main events and facts of each edition using Microsoft Power BI.

Content

• Overview
• Project Snapshots
• Files
• Sources
• Used Tools
• Learned Concepts
• Contribution

---

Overview

This report answers some interesting questions with data using charts and numbers, questions like:

• How many world cup editions were played?
• Who was the winner on each of them and how many times it was the winner?
• How many world cup editions the hosting country was the winner on them, what were these teams, and in what year?

  (Discover if there is any correlation between being the winner team and the hosting country at the same time)

• How many overall goals were scored and matches were played for each edition?
• Whats is the percentage that the coach of the winner team has the same nationality?

  (Discover if there is any correlation between being the winner team and having a national coach)

• What was the official poster and logo of each world cup edition?
• Who were the runner-up and the third teams of each edition?
• Who was the coach of the winner team in that year?
• What were the cities and stadiums of each match of each world cup edition?
• How many attendance to each edition (min, max and total)?
• What is the details of every match thas was held in each edition (home and away teams, referee, final result, the winner, ... etc
• What were the squad of home and away teams and even the shirt number of each player in this match? (except for 2018 World Cup edition)

And other interesting questiions you will enjoy it ^_^

---

Project Snapshots

Main Dashboard

Winner Tool Tip Page

World Cups Tool Tip Page

Details of Matches

for more snapshots

---

Files

The project mainly contains: It is preferable PUT all the project files TOGETHER in the same folder

1. Power BI File:

   • WorldCup.pbix: the main PROJECT file that contains all data analysis, reports, sheets and dashboards

2. CSV Datasets:

   • WorldCups.csv: all FIFA World Cup editions (1930-2018)
   • WorldCupMatches.csv: all FIFA World Cup matches of all editions (1930-2018)
   • WorldCupPlayers.csv: all FIFA World Cup players who played (1930-2014)

3. LOGOs Folder: all the official logos of the FIFA World Cup editions (1930-2018), an image of the old trophy and the logo of FIFA organization itself

        Note: You MUST download and install Microsoft Power BI Desktop to be able to view use the project
   

Microsoft Power BI Desktop

---

Sources

1. Kaggle's FIFA World Cup (1930-2014) Dataset
2. Data World FIFA World Cup 2018 Dataset

Thank you for who made them!

---

Used Tools

1. Microsoft Power BI:
   • Integration and Transformation
   • Modelling
   • Analyzing
   • Visualization
2. Microsoft Excel 356:
   • Some cleaning
   • Some appending of data
3. Microsoft Power BI Serivce:
   • Uploading the datasets
   • Deploying the report
   • Making an app (contains dashboard and reports)
4. Photoshop:
   • Some visualizations
   • Some formatting and color selection
5. GitHub:
   • Documentation of the project
   • Share the project
   • Receiving feedback

---

Learned concepts, tools and techniques

There are different things have learnt, such as:

• Business Intelligence concepts
• Data Anlysis and Data Mining fundmentals:
  • Data cleaning
  • Data Integration
  • Data Transformation
• Data Visualization:
  • Asking right questions
  • Data accuracy matter
  • Using suitable charts to describe the data
  • Tell a story about the data
• DAX format and M-Language
• Professional working sheets
• Documentation

---

Contribution

It would be very appreciated if you can:

• Give a constructive feedback even it is technical or user prospective one that would make this project a way better
• Contribute on filling the missing data to give more answers
• Ask more interesting and new questions that we can answer using data, it would be such a fun!