A data warehouse can be viewed as a storage vault for a set of related data. It is a set of data elements grouped into tables and then joined together into a data model. A well-designed data warehouse, with appropriate reporting tools, allows queries and reports to be run without the assistance of a database programming expert. The evolution of data warehousing has moved access to data directly into the hands of those who need the information.
The sponsored data warehouse contains data from the Office of Sponsored Programs operational data management system and university accounting systems. This data is entered and updated by OSP staff and refreshed each night. The sponsored data warehouse contains historical and current information for sponsored proposals, awards, subcontracts and consulting agreements going back to 1980. The system contains over 87,000 agreements. It is organized into three primary fact tables (what you analyze) and nine dimension tables (how you "slice" the data).
- Proposals and Awards
- Consulting Agreements
- Investigator (Principal Investigators)
- Program Name
- Grant and Contract Officer
Cornell offers a number of different data warehouses across multiple administrative areas and accessible with a common set of reporting and query tools. For sponsored data there are two tools -- the Sponsored Portal and Brio. Access to the sponsored data warehouse is granted at different levels including all Cornell, college, department, PI, project or account. To request access click on the data access link to the left.
Research Administration Information Services
395 Pine Tree Road
Ithaca, NY 14850