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

data warehousing documents

The table below contains documents that have accumulated during the course of the data warehouse project at Rensselaer.

Sponsorship Committee
Update Presentation

December 2002
PDF format
353KB
This presentation was given to the Sponsorship Committee in December 2002 as a means to provide status information and help determine future data marts.
Sponsorship Committee
Update Presentation

June 2002
PDF format
139KB
This presentation was given to the Sponsorship Committee in June 2002 as a means to provide status information and lead into a demonstration of the Rensselaer Brio Portal (login required) and executive-level dashboards.
Data Warehouse
Overview Presentation

May 2002
PDF format
504KB
This presentation provides initial training in data warehousing and modeling concepts. It was presented to members of the Financial Analysis Implementation and Financial Analysis Reviewer groups on May 2, 2002.
Data Warehouse
Orientation

March 2002
PDF format
631KB
This presentation was developed and used by John Kolb at the Data Warehouse Orientation Meeting on March 1, 2002. The purpose of this presentation was to communicate the goals of the data warehouse project to members of Rensselaer. Other speakers included Jeff Miner, Sharon Kunkel, Ora Fish, Eileen McLoughlin, and Gary Gabriele.
Financial Analysis
Scope & Data
Audit

February 2002
PDF format
33KB
This document describes the scope and data audit issues of the Financial Analysis data mart, scheduled for delivery in July 2002.
Financial Analysis
Requirements

January 2002
PDF format
51KB
This requirements document summarizes the business requirements of the Financial Analysis data mart, scheduled for delivery in July 2002.
BI Tool Selection
December 2001
PDF format
112KB
This paper documents the selection process used by the Business Intelligence (BI) Tool Selection Committee to choose a BI product for the data warehouse environment.
BI Tool RFP
November 2001
PDF format
54KB
This Request For Proposal (RFP) was used by the Business Intelligence (BI) Tool Selection Committee to help evaluate BI tool vendors.
DecisionWorks
Findings

November 2001
PDF format
136KB
This paper documents the findings of the DecisionWorks consultants, contracted to conduct a business requirements analysis project. Designed to ensure that Rensselaer is taking a requirements-driven approach to building the data warehouse, the goals of this project were to identify data warehouse requirements and facilitate the prioritization of warehouse deliverables.
ETL Tool Selection
October 2001
PDF format
72KB
This paper documents why Informatica was selected to provide the ETL tool for the Rensselaer data warehouse architecture.
ETL Tool RFP
October 2001
PDF format
57KB
This Request For Proposal (RFP) was used to evaluate and ultimately select Informatica as the ETL tool to be used within the Rensselaer data warehouse environment.
Data Warehouse
White Paper

September 2000
PDF format
94KB
This document is an initial proposal for building a data warehouse architecture that consolidates and transforms data into useful information for decision-making and for establishing a new Institute function that eventually offers a broad array of decision support services to all administrative organizations within Rensselaer.

directory listing

If you know the filename of the document you are looking for, you may choose to traverse through the document repository.

see also

what is a data warehouse?
goals of a data warehouse
glossary of data warehousing terms
data warehousing links & books

Data Warehouse Document Source Data Warehouse Document Source