Business Intelligence in schools–PowerPivot and PowerView in Excel 2010/2013

Rod Colledge, is a Microsoft Most Valued Professional (MVP) for SQL Server, and an expert on the technology side of the use of Business Intelligence in education in Australia. For a living, he helps Microsoft customers with their own business intelligence projects, through his business at StrataDB. But in his role as a Microsoft MVP one of the things that he’s been able to do is record a series of short videos of examples of using business intelligence in education, to show some of the simple things that are useful for school leaders and teachers.

Today’s video is in two parts:

  • The first part shows you how you can take a complex data set, containing both central data and a user’s own data – in this case, a spreadsheet of their own data.
  • The second part shows you how users can visualise it together in a number of different ways.

Part One – Creating and connecting the education data sources in PowerPivot

Part Two – Reporting education data using PowerView


If you’d like to know more about Rod and his projects, you can find out more on the StrataDB website or email Rod directly