This blog post was authored by Marc Reguera, Finance Director, Microsoft
After the success and interested generated by my first post, Visualizing the World Cup history with Excel and Power BI, I decided to update the model with data from the 2014 Brazil World Cup and analyze how the history of the world cup changed based on the results. The concept was exactly the same: use Power Query to get the latest data into Excel, update the Power Pivot model and visualize with Excel dashboards using Power View to analyze 2014 data vs. historic data from previous world cups. I used the same visualizations to unlock insights on how team performance changed, how the attendance stacks up vs. previous tournaments and other interesting facts around goals, goal average and number of games. So let's dig in! remember: all of these dashboards were created with Excel, tapping into online data with Power Query and updating the model that I created.
Here are eleven brand new insights I learned after exploring the updated world cup data using Excel interactive dashboards and Power BI features:
Just like last time, here's a live demo of the model for you to play around that includes all the data from the 2014 World Cup.
Thanks for reading / watching and I can't wait to see you all again for the 2018 World Cup!