Relive Ashes glory with Bob’s PowerPivot
Could there be something in the personality profile of individuals who use Excel a lot that predisposes them to enjoy statistically complicated sports such as cricket and baseball?
Bob Phillips is internationally recognised as an Excel MVP and PowerPivot expert, but may have left his north American fans a bit confused recently when he put the latest data analysis capabilities in Excel 2010 to work on the recent Ashes cricket series.
In Power to the Ashes, the first of a series of posts on the England-Australia match up, Phillips explained how he used PowerPivots to run a performance assessment of the two teams’ bowlers.
“I grabbed the details of all five matches, created a series of tables in Excel, and linked these tables into PowerPivot. Joining the tables in PowerPivot, and I could easily pivot the data to see an overall view.”
There’s “nothing clever about all of this”, he admitted, “but I believe that it is an example of how PowerPivot allows easy analysis of a set of structured data”.