SQLBits 2015

Using PowerBI and DAX to predict and win Fantasy F1

Using PowerQuery, PowerPivot, PowerView and DAX to model, analyse and win a Fantasy Formula 1 league. Guarantee yourself eternal glory as a braniac petrol head, and become a PowerBI and DAX pro in the process.
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.