Click here to receive your FREE subscription to Campus Technology
News
Rensselaer Polytechnic Institute Turns to Oracle BI for Decision-making
4/11/2008
Rensselaer Polytechnic Institute said it is using Oracle business intelligence applications to help users define, analyze and interpret data stored in its Oracle data warehouse. Rensselaer has created dashboards that deliver data to 650 users for planning, forecasting and decision-making.A research institution with campuses in Troy, NY and Hartford, CT, Rensselaer previously used a paper-based system, which produced inaccuracies in data and often resulted in duplicative efforts, according to the school. Also, various departments couldn't agree on basic definitions, such as what was considered a full-time student, leading to inaccuracies when comparing data between departments.
Rensselaer built a data warehouse on Oracle Database, which required cleansing and unifying data across the institution and storing it in one location. Over time, the school developed business intelligence dashboards in a number of critical areas to provide users with real-time, role-based access to data from the 130 GB data warehouse.
"Our data warehouse and business intelligence project is unique because of its scope," said Ora Fish, acting director, Integrated Administrative Computing Services. "Our entire culture is evolving from crunching numbers to measuring performance and asking, 'What does this data mean to us, now and in the future?'"
Rensselaer's dashboards provide users with data on current and past years, enabling them to view high-level information and drill down into specific data points. Dashboards include:
- Admissions, which provides information on applicant demographics and statistics, enabling users to analyze trends such as admissions quality and selectivity, student retention rates and inquiry-to-application rates.
- Student registration, which provides information on enrollment, courses and grades, allowing the university to examine classroom capacities and teaching loads.
- Financial aid, which monitors student financial aid, indicating type, duration, source and amount of assistance for each student and providing university-wide figures.
- Financials, which compares actual performance to budgets, providing users from all departments with daily insight into remaining budget. This dashboard also displays a breakdown of labor expenses, especially helpful for work performed against research grants where the project lead needs to track administrative vs. teaching labor expenses.
- Human resources, which displays data about faculty and staff, helping the university track trends such as diversity, turnover rates and workforce aging.
- Research, which presents data on research income, expenditures, yields and cost sharing by sponsoring agencies, disciplines, schools and departments.
- Advancement, which provides staff with insight into which alumni are donating and how much, as well as tracking specific campaign totals.
- Compliance, which monitors compliance against internal processes and identifies instances where an administrator needs to correct errors before distributing suspicious data.
Rensselaer selected Oracle for its data warehouse and business intelligence project through an evaluation process involving 20 staff members from various university departments.
Cite this Site
copy text (above) for proper citation
Recommended Reading
- Gates Highlights R&D at CES08, Unveils Microsoft Touch Wall
Microsoft's Chairman Bill Gates spent a lot of time Wednesday talking about "empowering the workers" at the Microsoft's 12th annual CEO Summit 2008 in Redmond, WA, where he gave a keynote speech. However, Gates wasn't talking about political revolutions or even pay raises for office workers before the CEO crowd. Instead, he was referring to new software technologies that can better enable collaboration, social networking and decision-making on the job.
- Vista Vulnerability Study Puts Microsoft on Defensive
Microsoft and some independent security researchers had the blogosphere buzzing Wednesday over a series of denunciations after one company claimed that the Vista operating system was more vulnerable to malware and other exploits than previous operating systems.
- New Blackboard Sync Application Leverages Facebook
Blackboard Inc. today announced Blackboard Sync, an application that allows students to receive course updates and communicate with classmates while logged on to Facebook.
- Standards: The Sooner the Better
Technology solutions work best when they well together. That is why the nonprofit group IMS Global Learning Consortium is developing learning tools interoperability standards for the education technology community...
- U.K. Education Group Escalates Microsoft Complaints
A consultancy to the U.K. government has forwarded complaints about Microsoft's licensing and interoperability practices to the European Commission (EC), according to an announcement issued by the Becta consulting group Monday.
- University Students and Researchers Enjoy JavaOne
The JavaOne conference, held May 6-9 in San Francisco, brought together developers from industry, education, and other markets, filling the Moscone Convention Center with a wide array of sessions and exhibits for the open source Java developer community.
