University of Arizona

Giving deans, administrators and professors 90 percent faster access to data

Published on 20 Dec 2011

Now our business managers, administrators and deans have the information needed to answer questions they couldn’t answer before.

Manav Mehra, ETL Team Lead, Enterprise Information and Analytics Department, Office of the CIO, University of Arizona

Customer
University of Arizona

Industry
Education

Deployment country
United States

Overview

In 2008, University of Arizona leaders recognized that to stay competitive with other universities they had to replace aged administrative computer systems. But replacing these source systems was only the first step in expanding the availability of business information to school staff. The University’s Business Intelligence (BI) team used IBM InfoSphere Information Server software to expand its data warehouse.

Business need
University leaders sought to expand the availability of business information to authorized users. Decision makers routinely depended on IT experts to compile data, sometimes waiting for days or weeks for information to answer business and operational questions.

Solution
The University used IBM InfoSphere Information Server software to understand, cleanse, transform and deliver data from source systems into its enterprise data warehouse, providing a single source of information for business intelligence.

Benefits
- Increased data warehouse demand to over 1,900 users and growing - Improved time to compile report data from weeks to seconds—more than 90 percent faster - Reduced time to run more than 22,000 nightly ETL jobs by almost 70 percent with upgrade to IBM InfoSphere Information Server 8.5

Components

IBM products and services that were used in this case study.

Software
InfoSphere Data Architect, InfoSphere DataStage, InfoSphere FastTrack, InfoSphere Information Server, InfoSphere Metadata Workbench

Solution
Information Integration

Legal information

ContactUs Case Studies on your mobile device

Join the Conversation

TwitterGoogleYouTube

Case Study resources