Try it Now
CALUMO Product Tour
Buy Now

Using Microsoft for Business Intelligence in Universities

In a recent blog post by Ray Fleming (Microsoft Education Blog), Ray raises the question of using Microsoft SQL Server for Business Intelligence in the education sector, Thinking about BI in Education? Want to know more about Business Intelligence programming in Microsoft SQL Server?”.

From my experience, it seems that Universities are the only place that I come across where comments are made that Microsoft SQL Server is NOT Industrial Strength” – usually within the IT department. In most corporate environments, it is generally accepted that SQL Server provides both performance and scalability that is more than comparable with the other databases out there, especially Oracle (which has a strong presence in the Higher Education Sector in Australia).

Over the last couple of months I have attended a number of conferences on Higher Education in Australia and as can be expected, one of the most prevalent themes is inadequate funding and the drop in Overseas Students, which translate into  the need to reduce and managing costs.  IT costs in Universities are significant, especially the staff and consulting costs.  In a number of discussions with University CIOs, they are aware the costs of maintaining a MS SQL Server environment are significantly lower that Oracle, especially from a staff cost perspective.

In addition, there is a much higher availability of skilled staff on the Microsoft platform.   In a white paper published by Greg Shanker from Alinean, the cost of administering Oracle its almost 5 x more expensive than SQL. image Microsoft SQL Server and Oracle® Database:  A Comparative Study on  Total Cost of Administration (TCA) http://www.alinean.com/PDFs/Alinean-MicrosoftAndOracleTCAStudy.pdf

The free eBook (how to get it below) Ray blogs about Introducing Microsoft SQL Server 2008 R2” is a good read for anyone who needs to understand the capability and scalability of Microsoft’s offering.  I would suggest that the Extract from Chapter 6, on Scalable Data Warehousing is used as a preface for all discussions within a University Environment.

From our experience, effective BI in Universities needs to combine the following data sources and  structures:

  • Financial Data, including projects and commitments (Accounts Payable)
  • HR Data for all categories of staff, including award information
  • Student Data with EFTSL information as well as course and program revenue
  • Student learning systems and resource utilization
  • Facilities information, which can expand on the basic space requirement to other factors for sustainability reporting
  • Research data
  • Alumni and  Donations

It doesn’t all have to be delivered on day 1, its more of an incremental approach.

A number of our education clients have varying volumes of data in their current environments, and are generally adding data all the time to obtain more information and provide significant self-service capabilities to their users.

How to get the free eBook
The good news is that the eBook is free, and available in a number of different formats
0 comments on “Using Microsoft for Business Intelligence in Universities
1 Pings/Trackbacks for "Using Microsoft for Business Intelligence in Universities"
  1. […] * Mike Henegan, at Calumo (one of our BI partners in education here in Australia), has weighed in with his thoughts on this too – take a look over on his blog. […]

Leave a Reply

Your email address will not be published. Required fields are marked *

*

1. Save significant time for finance people.

2. Remove key man risk. Report should not be dependent on 1 or 2 people.

3. Self-service BI – business users access their reports and can answer questions themselves.

1. Built and run by Finance People.

2. Dramatically reduce the time and cost involved in the budget process.

3. Significantly increase accuracy. Remove the risk of human error involved in manual data handling.

1. Instant access for Instant visibility.

2. Analyze with ease.

3. Built for finance people and business analysts.

1. Reforecast at a moment’s notice.

2. Remove the constraint of financial year end for decision making.

3. Decrease time required for the budget process.

1. Get answers Instantly, save hours of efforts.

2. Reduce spend on audit fees.

3. Reduce Finance’s investigation time.

1. Access all your data. Make decisions now.

2. Access to your data at any time

3. Don’t wait for other people for information

1. Save days, weeks and months while dramatically improving user satisfaction

2. No more dumping 1,000’s of transactions and massaging in the hope of finding answers.

3. No more waiting for IT or Finance to produce special analysis

1. Get answers Instantly, save hours.

2. Reduce spend on audit fees.

3. Reduce Finance’s investigation time.

1. Dynamic, live and interactive.

2. Month-end is complete when the last journal is posted.

3. No more printing required.

1. Professional and really good looking

2. Use data from any source

3. Always have the very latest data

1. No bottlenecks. You are not dependent on other people.

2. Build Reports with speed and ease

3. Use your existing knowledge of Excel for fast report building

1. Keep Excel as your report authoring tool

2. Remove the excess workbooks you don’t need with Excel

3. Convert Excel sheets to dynamic web pages

1. Fast report building – Finance people and Business Analysts can build and share reports in minutes.

2. Self Service BI i.e. no reliance on IT to produce reports.

3. Trusted and enterprise grade database.

Caas-Network
Web Users have read and write (reporting, budgeting and forecasting) access to all CALUMO Web Portal content.
Office Connected Users have access to CALUMO Office integration with Microsoft Excel, Word and PowerPoint.
CALUMO Private Cloud Server Subscription