In this Garage Series episode, Power BI and Excel go to Spain, to expose data patterns in past matches between Real Madrid and FC Barcelona.
“By combining historical El Clásico and player data, outside forces like temperature, humidity and moon phases, Jeremy tries to predict the outcomes and puts these predictions to the test among fans in Barcelona.”
They didn’t use good hair as one of the factors, but they predict 2-1 for Madrid, in the Oct. 25th match. (The final score was 3-1 for Madrid.)
You can watch the video below, or on YouTube: Power BI takes on El Clásico
Contextures Posts
Here’s what I posted recently, on my Contextures site and blogs:
- Roger Govier shows how to create custom report layouts with pivot tables and GetPivotData function
- See what scares people about pivot tables, and who won the giveaway. If you didn’t win, you can get 25% off the Xtreme Pivot Tables course, if you use the coupon code CONTEXTURES, by Friday, Nov 21, 2014.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
There is a poll at the end, so please vote for your favourite tweet.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Chandoo released his new Excel Dashboard Templates kit, and these ready-to-use templates look great. Do you use dashboard templates, or start from scratch each time?
- If you create your first budget in Excel, is it a sign that you’re growing up? Carmen Guzmán wants to know, and I’d be interested too!
- Oz de Soleil wonders why there is an on-going debate about VLOOKUP vs. INDEX/MATCH. So many Excel questions this week!
- Do you use VBA? Dick Kusleika looks at the future of VBA development.
- The November update for Office 365 has been released, and there were a few enhancements to Excel Power Map. Have you used that feature yet?
- Jeff Bennion explains why Excel is the most underappreciated program in a law office.
- If you want to use your data in a Power Map, Steven Nichols shows how to format it, for best results.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!