skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Follow the FIFA World Cup in Power BI

    Follow the FIFA World Cup in Power BI

    06-15-2018 07:38 AM - last edited 07-27-2018 16:44 PM

    ruthpozuelo
    Kudo Kingpin
    6802 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    ruthpozuelo
    ruthpozuelo Kudo Kingpin
    Kudo Kingpin
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Follow the FIFA World Cup in Power BI

    ‎06-15-2018 07:38 AM

    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

    Preview file
    547 KB
    Labels:
    • Labels:
    • Sports
    Message 1 of 2
    6,802 Views
    8
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    pawel1
    pawel1 Skilled Sharer
    Skilled Sharer
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-15-2018 11:59 AM

    Great work, Ruth!

    Message 2 of 2
    6,771 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices