Caserta partnered with one of the largest private non-profit institutions of American higher education. The university is an internationally ranked American research university based in New York City that has academic centers throughout the world. It is the alma mater of Nobel Laureates, heads of state, Fortune 500 founders, and CEOs, in addition to many other notable alumni.
The university’s Office of the Provost needed a Data Warehouse/Business Intelligence solution that focused on data visualization on assessments and measurements. Their internal IT department had been working on a solution for months and was anticipating another 18 months to complete it. In order to expedite the process, the team decided to seek outside help from Caserta to leverage our expertise and best practices frameworks.
Caserta was engaged to redesign and implement an Oracle-based Data Warehouse and Business Intelligence solution that would provide performance metrics across schools and departments. Our solution extracted data from five main source systems including PeopleSoft HR and Oracle ERP as well as several other informal data sources like spreadsheets maintained by various departments.
Caserta worked closely with the university to carefully define the business rules to ensure fair and accurate reporting on proposals and success criteria. A complete security model was built in to ensure proper data governance and security.
In addition, Caserta developed multiple information-rich Business Intelligence dashboards featuring enrollment and grant visualizations. The initial project focused on grant management with additional subject areas including human resources added to the solution.
The Business Intelligence program and dashboards that Caserta created marked the first time that academic leadership could easily visualize and access assessments and measurements and gauge academic performance.
In addition, Caserta completed the project in nine weeks, 16 months less than the university’s in-house team predicted, demonstrating incredible value. Because of how much Caserta accomplished, the university presented their work to the provost, securing additional funding for the organization.
According to the project leader at the university, the entire project was highly praised and well-received on campus, by both academic leadership and by the provost.