Home Business IT Business Telecommunications Brisbane school takes Microsoft's DIY BI route

A large part of Microsoft's business intelligence (BI) strategy is about putting BI into the hands of end-users by making it part of the platform - notably in SQL Server 2008 R2.


A prime example of this can be found at Brisbane's John Paul College. The school's BI manager, Scott Carpenter, said a wide range of data had been captured from various sources and while it was already useful, it could be put to even better use. One example involved the desire to spot differences in classroom methods that led to different (hopefully better) student performance.

The data collected includes individual subject results (across multiple criteria), external testing results (eg, learning style analysiss, NAPLAN scores), behavioural information (as recorded by teachers, plus any 'escalations' that were deemed appropriate), involvement in co-curricular and external activities, notes made by the counselling department, account balance and parents' marital status (the latter two being used as in indication of family stress).

Being able to analyse these sorts of data may provide insights such as realising that it is counterproductive to nag certain students when they fail to submit drafts on schedule, or alerting teachers of the need to adapt to the learning style of a particular cluster of students.

Clearly, some of the data stored by the school is sensitive, so "the whole space we've designed is bound by security," said Carpenter. For example, teachers cannot access information collected by the counselling department, but the head of school can. However, there may be some benefit in alerting teachers to an issues in one of their student's lives before "I left my homework at Dad's" is tendered as an excuse.

"When you find something that can make a difference, it's exciting," said Carpenter.

CONTINUED

Wardy IT implemented a proof of concept for John Paul College in a few days of consulting time. The college did not need to buy any additional software, as SQL Server 2008 R2 and Office 2010 provided the necessary capabilities. However, the BI functions have been separated from the other production systems for performance reasons.

Carpenter noted that there was little pressure to deliver immediate results. This allowed the project to develop steadily, addressing what was actually needed in a way that allowed for future flexibility rather than choosing whatever gave quick and easy results.

Donald Farmer, from Microsoft's SQL Server team, noted that Microsoft's approach means it is possible to experiment with the tools that already exist within a school. Teachers can do their own exploration, and the most successful analyses can be put into production.

Farmer noted that the alignment between features of SQL Server 2008 R2, SharePoint 2010 and Office 2010 provides in 'in' to millions of potential BI users around the world. Microsoft is ready to put BI into the hands of users, he said, noting that IT departments are suffering cutbacks despite growing data volumes. If users can't do BI, it probably won't get done at all.

HOW TO OFFER 4G TO YOUR CUSTOMERS

Download an information pack to learn more about how you can offer competitive 4G plans to your customers.

> everything you need to operate your own 4G telco

> support for you and your customers

> billing, back-end and full compliance.

DOWNLOAD NOW!

HOW TOP MANAGERS MOTIVATE, ENERGISE EMPLOYEES

Download an in-depth guide to managing a healthy, motivated and energetic workforce without breaking the bank.

DOWNLOAD NOW!

Stephen Withers

joomla visitors

Stephen Withers is one of Australia¹s most experienced IT journalists, having begun his career in the days of 8-bit 'microcomputers'. He covers the gamut from gadgets to enterprise systems. In previous lives he has been an academic, a systems programmer, an IT support manager, and an online services manager. Stephen holds an honours degree in Management Sciences, a PhD in Industrial and Business Studies, and is a senior member of the Australian Computer Society.

 

 

 

 

Connect

Join the iTWire Community and be part of the latest news, invites to exclusive events, whitepapers and educational materials and oppertunities.
Why do I want to receive this daily update?
  • The latest features from iTWire
  • Free whitepaper downloads
  • Industry opportunities