The FIFA Males’s World Cup is a worldwide occasion with abundant history.
In this task I explored the complete history of the Globe Mug making use of Power BI.
The goal was to build an interactive control panel that answers usual questions:
Which country scored the most objectives?
That reached one of the most finals?
Which year had the most goals?
Do host countries have a benefit?
Task Objective
Turn raw historical information into an exploratory and tale driven control panel that works for fans and for data students.
Just how I Constructed It:
Data prep work
I made use of Power Question to cleanse the information, standardize group codes and take care of days.
Data modeling and metrics
With DAX I computed host win portion, finals gotten to by nation, and objective circulations by competition year.
Layout
The report has two web pages.
Page one is an Overview with broad view fads.
Page 2 is By Event for comprehensive expedition of any single Globe Cup.
Page 1 Summary
Summary of 21 World Cups. Finals gotten to by team, host win price, and goal circulations by year.
Secret takeaways on this page:
• Overall competitions 21
• Host win portion 28 6 percent
• Germany leads last appearances with 8 Brazil and Italy follow
• Box plots show how scoring patterns altered across time
Page 2 By Event
Pick any kind of World Mug. See host nation, objectives by group, and a map of suit areas.
This web page lets you select a competition and explore the host country, group objectives, and where suits were played.
For example, in 1938 France organized the occasion. Hungary and Brazil were leading scorers, and matches occurred in cities such as Paris, Marseille, and Bordeaux.
Interactivity. Tooltips that include context
Customized tooltip for the city A Coruña with a small checklist of suits and final scores.
I developed a record web page tooltip that appears when you float over the map and place visuals.
The tooltip shows the city name and a tiny table with each suit and its result.
This assists readers get context rapidly without altering web pages.
Exactly how it works:
• A devoted tooltip web page with Tooltip readied to On and page size set to Tooltip
• The City area filters the tooltip. A table visual listings Suit and Result
Insights
• Germany shows long-term consistency with 8 last looks
• The host advantage is genuine. Nearly one third of competitions are won by the host
• Some years have a lot more goals. These peaks typically align with rule or format modifications
• Suits are usually in larger cities with solid stadium facilities
Why it matters
This job demonstrates how data visualization can turn decades of info into a clear and interactive tale. The exact same method benefits any kind of sector that tracks efficiency across time.
Skills shown
– Power BI control panel style
– DAX for personalized calculations
– Power Query for ETL
– Sports analytics narration