University of Stellenbosch - Education Sector

Streamlining academic donor reporting

Challenge

Stellenbosch University’s Institutional Advancement division focuses on building relationships, creating awareness and generating support for teaching and research within the university, engaging alumni and donors. The application used for tracking donations was limited in terms of on-screen queries and reporting, creating inconsistencies and challenges in year-end reporting to donors.

Solution

EOH built a new BI solution using Microsoft SQL 2012 and SharePoint 2013, enabling the division to import and track donor data and generate comprehensive reports. EOH imported data from the source donor database into a staging database using SQL Server Integration Services, cleaned the data using TSQL, imported the data into the data warehouse using SQL Server Integration Services, built a multi-dimensional cube using SQL Server Analysis and created additional calculations using MDX. Dashboards were created on the cube using Performance Point Services in SharePoint, and displayed to the user via a web browser. The solution will form part of a broader initiative to collate all of the university’s data sources into a single data warehouse for analysis.

EOH delivers solutions that address real-world business challenges