How do you select the optimal fantasy team line-up to beat your friends at fantasy Formula 1? With over 1/4 million combinations of teams and drivers and a complex points scoring scheme, your odds aren’t much better than a lottery.

In this session we’ll create a PowerPivot model from scratch, import and transform data from the web using PowerQuery, and create DAX calculations including many to many relationships for some complex analysis and great interactive dashboards.

Guarantee yourself eternal glory as a braniac petrol head, and become a PowerBI and DAX pro in the process.
Presented by Alex Whittles at SQLBits XIV