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 Tratamientorosacea



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?

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!

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

ABOUT CURBAL:
Website:
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!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin:
► Twitter: @curbalen, @ruthpozuelo
► Google +:
► Facebook:

#SUBSCRIBE #CURBAL

#CURBAL #WORLDCUP2018 #POWERBI .

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

Related Videos

25 comments

Lucky Mane 10/09/2021 - 9:22 Chiều

I have no words such great video

Reply
Swarnali Saha 10/09/2021 - 9:22 Chiều

Can you please copy paste the formula for Custom.1

Reply
Gilson Junior 10/09/2021 - 9:22 Chiều

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)

Reply
clacby 10/09/2021 - 9:22 Chiều

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

Reply
Mahmoud Abu-awwad 10/09/2021 - 9:22 Chiều

Thank you

Reply
MIS Dev Bartwal 10/09/2021 - 9:22 Chiều

😮 wow amezing 💐😘

Reply
Krishna Valapala 10/09/2021 - 9:22 Chiều

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.

Reply
Diego Alex de Assis 10/09/2021 - 9:22 Chiều

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

Reply
golan kakun 10/09/2021 - 9:22 Chiều

Brilliant Ruth!

Reply
Daníel Hjörvar 10/09/2021 - 9:22 Chiều

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

Reply
Chingiz Salkhanov 10/09/2021 - 9:22 Chiều

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

Reply
Josep Romero 10/09/2021 - 9:22 Chiều

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.

Reply
shyam Thakur 10/09/2021 - 9:22 Chiều

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

Reply
Charles D 10/09/2021 - 9:22 Chiều

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:

http://www.goal.com/en-gb/news/world-cup-2018-fixtures-draw-tickets-guide-finals-russia/yqqdomah5xys19yhtw931m98t

Hope this helps…

Reply
Nir Robinson 10/09/2021 - 9:22 Chiều

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 🙂

Reply
Sandip Mukherjee 10/09/2021 - 9:22 Chiều

Awesome!!!

Reply
Jonathan Tovar R 10/09/2021 - 9:22 Chiều

Muy interesante… Gracias Ruth !!!

Reply
Nir Robinson 10/09/2021 - 9:22 Chiều

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

Reply
Cristian Dominguez 10/09/2021 - 9:22 Chiều

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

Reply
Jan Franck 10/09/2021 - 9:22 Chiều

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

Reply
Maurizio Faini 10/09/2021 - 9:22 Chiều

Great! Thanks!

Reply
Z. Vella 10/09/2021 - 9:22 Chiều

Oh dang. This is too awesome!

Reply
Juan Sebastian Grijalba 10/09/2021 - 9:22 Chiều

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

Reply
TheExcelStudio 10/09/2021 - 9:22 Chiều

Great example Ruth!!!

Reply
Ankush kumar Joshi 10/09/2021 - 9:22 Chiều

loved it.

Reply

Leave a Comment