Home » FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data [keyword

FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data [keyword

by Tratamien Torosace

You are viewing this post: FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data [keyword

It is world’s cup fever: FIFA world cup 2018 in Russia!!! And we dont want to miss anything right?

That is where Power BI comes to the rescue 🙂

I am going to build a Power BI file to follow the world cup and I decided to show you how I create it while creating it 🙂

In the first video, I downloaded in Power Bi the world cup data from FIFA world cup 2018 website and cleaned it to know when the matches occur, the groups and the flags.

In the second part, we built the first tab on matches:

1. When is my favourite group playing?
2. When is my country playing?
3. Which matches will be sent today and at what time?

See also  How to Achieve Your Goals: 3 Science-Backed Strategies That Work [keyword

In the third part, I will show you how to adjust the match times for your local time and some other improvements.

In part 4, I show you how to work with inactive relationships using DAX.

And in Part 5 video, I will show you how to download and visualize the knockout phases in Power BI.

You can download the Power BI file here:

Looking for a download file? Go to our Download Center:

SUBSCRIBE to learn more about Power and Excel BI!

– Join our DAX Fridays! Series:
– Power BI dashboards for beginners:
– Power BI Tips & Tricks:
– Power Bi and Google Analytics:

See also  Financial Analysis Sample Reports Recommendations - Analysis of Financial Statements, Ratio-Analysis [keyword

Contact us:


If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

Many thanks in advance!



What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!


► Linkedin:
► Twitter: @curbalen, @ruthpozuelo
► Google +:
► Facebook:

See also  Best auszubildende beurteilen ausbilder bzw abteilungen muster New Update



Images related to the topic financial modeling world cup

FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data

FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data

Search related to the topic FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data

#FIFA #World #Cup #Part #Power #Download #data
FIFA World Cup 🏆 2018 (Part 1) in Power BI: Download data
financial modeling world cup
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here

Articles compiled by Tratamientorosacea.com. See more articles in category: FINANCE

Related Videos


Lucky Mane 10/09/2021 - 9:22 PM

I have no words such great video

Swarnali Saha 10/09/2021 - 9:22 PM

Can you please copy paste the formula for Custom.1

Gilson Junior 10/09/2021 - 9:22 PM

Hi Ruth ! I am not able to see operators in Conditional Column like "contains". I can see only "equals" and "does not equal"….Can you help me ? Version: 2.59.5135.781 64-bit (junho de 2018). PS.: I did the same way inserting the command in formula…..= Table.AddColumn(#"Added Index", "Custom", each if Text.Contains([Column1], "Group") then [Column1] else null)

clacby 10/09/2021 - 9:22 PM

Great video. Plenty of PBI tricks!!! Thanks a lot.

Mahmoud Abu-awwad 10/09/2021 - 9:22 PM

Thank you

MIS Dev Bartwal 10/09/2021 - 9:22 PM

😮 wow amezing 💐😘

Krishna Valapala 10/09/2021 - 9:22 PM

Hi Ruth. . Thanks for amazing video on FIFA. It would be good if you can show how you have downloaded the data to excel. I am unable to download it properly.

Diego Alex de Assis 10/09/2021 - 9:22 PM

Parabéns pelos Ótimos videos sobre Power Bi – Sucesso

golan kakun 10/09/2021 - 9:22 PM

Brilliant Ruth!

Daníel Hjörvar 10/09/2021 - 9:22 PM

on 15:20 the filter expression writes out as MP = 0 meaning that on 14th Russia and Saudi Arabia will be filtered out :s

Chingiz Salkhanov 10/09/2021 - 9:22 PM

Thank you!
Didn't expect to find such a useful info on data transformation in FIFA video =D

Josep Romero 10/09/2021 - 9:22 PM

Hi Ruth,
Still can not understand the Custom.1 column creation. "try" is clear as Daniel already explained on PQ Challenge 3 but really hard for me understand how works the rest of the formula.
Any suggestion for deep understanding?
As always, thank so much.

shyam Thakur 10/09/2021 - 9:22 PM

Hi could you please explain custom 1 formula syntax " means criteria of condition"

Charles D 10/09/2021 - 9:22 PM

Great stuff Ruth. Thanks for sharing.

Rather than all that data cleansing, which is very useful to know, I found a link on goal dot com which has much cleaner tables to link to/scrape:


Hope this helps…

Nir Robinson 10/09/2021 - 9:22 PM

In minute 14, you load and append groups A-H , I think it better (cleaner for sure :-)) :

1 – load only one group (A for example)
2 – delete the last 2 step (keep only source )
3 – filter the document caption
4 – expand data
5 – regular cleaning

Please tell me what you think .

Thanks again and again 🙂

Sandip Mukherjee 10/09/2021 - 9:22 PM


Jonathan Tovar R 10/09/2021 - 9:22 PM

Muy interesante… Gracias Ruth !!!

Nir Robinson 10/09/2021 - 9:22 PM

Thanks for the great topic and video.
Can you please explain how you get the excel file with the URL? when I press view source on my browser I get very very long code

Cristian Dominguez 10/09/2021 - 9:22 PM

Love it !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Jan Franck 10/09/2021 - 9:22 PM

Great video – we need more on Power Query cleansing. Thanks Ruth

Maurizio Faini 10/09/2021 - 9:22 PM

Great! Thanks!

Z. Vella 10/09/2021 - 9:22 PM

Oh dang. This is too awesome!

Juan Sebastian Grijalba 10/09/2021 - 9:22 PM

Hi, this is a great video. Love the full comprehensive example showcasing some amazing Power Query techniques.

TheExcelStudio 10/09/2021 - 9:22 PM

Great example Ruth!!!

Ankush kumar Joshi 10/09/2021 - 9:22 PM

loved it.


Leave a Comment