Rensselaer's Enterprise Data Warehouse
Currently supporting many of the core business functions, the Data Warehouse is refreshed nightly, integrating data from Banner and Advance operational systems supporting Finance, Position Control & Labor, Research Administration, Student Enrollment and Student Academic History, Institutional Advancement, Procurement, Enrollment Management and Undergraduate and Graduate Financial Aid.
Leveraged by various departmental representatives, a user interacts with the Data Warehouse via published dynamic reports and robust dashboards, and for the more advanced user, creating their own individualized adhoc reports is possible. The fundamental objective of Rensselaer’s Enterprise Data Warehouse is to continuously evolve in response to business need, serving as the primary hub of integrated business information in support of each institutional portfolio.
A New Data Warehouse User Experience
Since the initial release of the Data Warehouse in 2002, the primary reporting tool serving the user community has been “Brio”. Although this tool has gone through its share of name changes and is currently called Interactive Reporting, most still refer to it as “Brio”.
Beginning in 2017, the Data Warehouse team has begun the exciting transition to a new reporting tool, “OBIEE”. Short for Oracle Business Intelligence Enterprise Edition, this new platform will serve as the next generation tool used to access Rensselaer’s Data Warehouse. This new tool offers business users a modern, intuitive and highly visual look and feel, supported by a robust and scalable technology infrastructure sustainable for the long term.
As we make this necessary transition, we recognize the impacts and challenges this will have on our user community. Fortunately, we are able to retain the underlying Data Warehouse table structures, processes and security infrastructure, greatly helping in the transition. However, we will be required to migrate the most widely used Brio reports, “BQYs”, to the new environment. The Data Warehouse team plans to work by functional area, developing and transitioning Brio reports to OBIEE. Additionally, we will be conducting information and training sessions to assist business users in the transition. We expect this initiative to take approximately two years. During this time, many will have access to the current Brio tool along with the new OBIEE environment.
We are very excited about revitalizing the Data Warehouse and look forward to working with the business community to make this transition. As always, if you would like to learn more about the Data Warehouse or the new OBIEE platform, please contact the Data Warehouse team: