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 in his spare time he speaks at conferences, writes books, and shares his knowledge freely.
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, and the new features in SQL Server 2012 and Microsoft Office 2013, to show some of the simple things that are useful for school leaders and teachers. I’ll share one video every day for the next week, as I think they are ideal for showing to colleagues to start a discussion about how they’d like to use data in your institution, and whether they can start to use some of the features of the latest software releases.
Today’s video is a demonstration of a key feature for an business intelligence in education project – the ability to set alerts automatically, to allow you to ‘manage by exception’, rather than having to trawl reports looking for outliers and identify performance issues manually.
The example that’s used here (with a dummy dataset) is using student absences to generate alerts, and uses Microsoft SQL Server 2012, and PowerPivot reports.