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
