University of Stellenbosch - Education Sector
Streamlining academic donor reporting
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.
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.