Rensselaer global navigation
Rensselaer Polytechnic Institute RPInfo Search RPI Contact RPI Campus Directories Depts/Offices with web sites Degree Programs, Academic Schools

Rensselaer Data Warehouse Project

"The Budget material was consolidated two weeks sooner than in previous years. Many factors contributed to the success, however a significant contributor was the Data Warehouse allowing the Budget Office to provide data and analysis of the data to decision makers faster than in the past. As the use of the tool is rolled out to campus I see the potential for the same experience within portfolios."

--- Eileen McLoughlin, Director of Financial Planning & Budget

testimonial metrics


testimonial metrics from data warehouse users

The following metrics reveal the impact the Data Warehouse is having at Rensselaer. Click here to hear more about what users have to say about the Data Warehouse.

user name task performed pre-datawarehouse implementation post-datawarehouse implementation
Sandi Redemann-Butcher Portfolio YTD Analysis Half-day to retrieve and compile information manually. Seconds to retrieve information from the Data Warehouse.
Gina Ricci Report Analysis Multiple versions of the truth existed across campus due to multiple information sources, which destroyed data integrity and conformity. One version of the truth exists based on one information source, promoting a common understanding of the data and allowing users to derive the same conclusions.
Tanya Struzinsky Available Balance Report 2 weeks to retrieve and compile information manually. 30 minutes to build the report in the Data Warehouse, which can be refreshed daily in seconds.
Donna Tomlinson Org 3-Year Comparison by Account Group Not readily available. Readily available on demand.
Jeff Tanis Research Expenditure Analysis Multiple days to retrieve data from multiple sources and compile information manually. Few hours to retrieve and present information from the Data Warehouse.
Diane Veros Data Integrity Verification Days, weeks, or months to develop reports to ensure data integrity and to perform analysis. Few hours to develop reports in the Data Warehouse to ensure data integrity and to perform analysis.
Tanya Struzinsky Credit Card Transaction Reconciliation 2-3 hours to compile, review, and verify credit card transactions for each user. 5 minutes to retrieve, review, and verify credit card transactions from the Data Warehouse for each user.
Sandi Redemann-Butcher Month-End Report 2 days to retrieve and verify program and activity codes to ensure accurate results. 2 hours to retrieve information from the Data Warehouse. No data manipulation required.
Karen Long Undergraduate Conference Survey 2-3 days to collect and organize necessary information. 1 hour to retrieve the information from the Data Warehouse.