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

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

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

Interested in speaking at an upcoming BA VC webinar?

Contact us today to let us know:

Next Meeting

Thu, Mar 27 2014 12:00 Eastern Daylight Time

Analyzing Road Traffic Accident Data in Power BI


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 is an independent consultant and trainer specialising in Analysis Services, Power Pivot, Power Query, Power BI, DAX, M and MDX. He a co-author of the books "Expert Cube Development with SQL Server 2008 Analysis Services", "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase" and "SQL Server Analysis Services 2012: The BISM Tabular Model", and the author of "Power Query for Power BI and Excel". He blogs about Microsoft BI at

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