The PASS Business Analytics Group provides virtual training on the tools and architecture patterns required to create world-class Business Analytics solutions.

Login to Subscribe

News and Updates

Join us today - become a member of the Business Analytics Virtual Group.

Sign up for a free PASS membership and choose the option to join the BA Virtual Group in the myPASS portal. We'll keep you posted of all upcoming meetings, learning opportunities and the latest and greatest info from Microsoft.

Interested in speaking at an upcoming BA VG webinar?

Send us your information by completing the Call for Speaker survey here and we will follow up with you or you can contact us today to let us know by email using


Analyzing Road Traffic Accident Data in Power BI

Thu, Mar 27 2014 16:00 UTC

Analyzing Road Traffic Accident Data in Power BI

In this session I’ll walk through the lifecycle of a Power BI project, showing how you can download and import open data on British road traffic accidents into Excel using Power Query; model that data using Power Pivot; query the data using PivotTables; construct more complex visualizations using Excel cube formulae and Power Query; plot the data on a map using Power Map; and then finally query that data in English using Q&A. This is the same data that I used in my Power BI competition entry, but with an hour rather than just ten minutes I’ll be able to go into a lot more detail.

Chris Webb

Chris Webb is a member of the Power BI CAT team. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase".

Follow us on Twitter: @PASSBAVC | Contact us: PASSBAVC@SQLPASS.ORG
Back to Top