Follow the FIFA World Cup in Power BI

ruthpozuelo — Fri, 27 Jul 2018 23:44:55 GMT

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.

https://www.youtube.com/watch?v=i24MdCAjL68

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

https://www.youtube.com/watch?v=6dwuwPMRXek

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.

https://www.youtube.com/watch?v=tKsbXRE6mIE

In part 4, I show you how to work with inactive relationships using DAX. https://www.youtube.com/watch?v=JGy0xzzHcDk

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

https://www.youtube.com/watch?v=zxtmT64EmiU

In Part 6, we are going to make the knockout phase update dynamically when the games start:

https://youtu.be/Q4kY-oTHAqM

In Part 7 I show you how to install a PowerApp for predictions:

https://www.youtube.com/watch?v=D67QzskoR6g

And Finally in Part 8, I show the final report:

You can download the Power BI file here:

https://curbal.com/blog/follow-the-fifa-world-cup-2018-in-power-bi

SUBSCRIBE to learn more about Power and Excel BI!

https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:

- Join our DAX Fridays! Series: https://goo.gl/FtUWUX

- Power BI dashboards for beginners: https://goo.gl/9YzyDP

- Power BI Tips & Tricks: https://goo.gl/H6kUbP

- Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:

Website: http://www.curbal.com

QUESTIONS? COMMENTS? SUGESTIONS? You’ll find me here:

Linkedin: https://goo.gl/3VW6Ky

Twitter: @curbalen, ruthpozuelo

Google +: https://goo.gl/rvIBDP

Facebook: https://goo.gl/bME2sB

eyJrIjoiMDg2YmVlOWYtMDdmYS00OTg2LWI2MDgtMDU3NDlhYWZjYjVjIiwidCI6IjRmMWNiNzZmLTlhODUtNDc3Mi04MWIwLTVkYWVjZjlmYTQyMCIsImMiOjh9

Re: Follow the FIFA World Cup in Power BI

pawel1 — Fri, 15 Jun 2018 18:59:40 GMT

Great work, Ruth!

topic Follow the FIFA World Cup in Power BI in Data Stories Gallery

Follow the FIFA World Cup in Power BI

Re: Follow the FIFA World Cup in Power BI