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
Contact us: http://www.curbal.com/contact
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
