Click here to receive your FREE subscription to Campus Technology
Case Study
Business Intelligence Tool Means Healthy Data at UVA
5/8/2008
University IT groups will recognize the challenge of combining disparate data from more than one department in order to create meaningful reports for various users.At the University of Virginia Department of Medicine, which is overseen by UVA's School of Medicine, data was coming from two very different accounting systems: one used by the university's Health Services Foundation, the other used by the School of Medicine. The use of two accounting systems meant that faculty members--usually physicians--either couldn't get reports with the information they wanted from the two systems or had to ask IT specialists for help, then wait for a report to be generated.
Likewise, a completely different set of users--clinical and department administrators--needed to create consolidated financial reports, clinical billing reports and more that drew on both databases.
To solve the problem, the UVA Department of Medicine streamlined its financial and clinical reporting with a WebFOCUS business intelligence (BI) platform from Information Builders.
The time savings from the BI system have been marked, according to Mike Zang, director of IT for UVA's Department of Medicine. A financial report that might have taken a month to six weeks to create and manipulate previously using Microsoft Excel takes just a couple of hours to load now, though it can still take several weeks to sort through the resulting reports for problems. But there's a key difference, Zang said: Previously, weeks might have been spent just making sure the incoming data was correct.
The rollout was a three-year effort--although what took most of the time wasn't the software installation itself. "The technology end is so easy that we rolled [WebFOCUS] out to the entire department at once," Zang said. Instead, the brunt of project time was spent creating business rules designating how the accounting data should be handled. That was a complex process because the two accounting systems that WebFOCUS accesses--Oracle Financials for the university, and a system called Epicor for outpatient billing by the School of Medicine--are set up to use different fiscal years and different general ledgers. "We had to figure out how to marry up the two," Zang explained.
The IT group also had to deal with items such as different naming schemes for faculty members in the two databases. Zang's team handled that issue with custom programming, although they could also have used Information Builder's ETL (Extract, Transform and Load) tools to manage data mappings between tables.
With the business intelligence system in place, business managers "have [much] more control over what data they see, and how they dig into it," Zang said. That, in turn, points up an advantage of using an ad hoc report generator that accesses live data to create reports on the fly. Before, users tended to import data into Excel, then manipulate it themselves, often extensively. The result: complex user-created formulas with little outside control of either the data or the formulas.
Recommended Reading
- Fixed-Mobile Convergence: Dartmouth Beefs Up Cell Coverage, Cuts Costs
Problems with cell phone coverage aren't uncommon on college campuses. There are two main reasons: The beefy structure of historic buildings can block cellular reception within walls, and, on more remote campuses outside cities, signal coverage can be light.
- Thompson Rivers U Deploys Unified Digital Campus for ERP
Thompson Rivers University (TRU) in British Columbia has selected SunGard Higher Education's Banner Unified Digital Campus (UDC) to integrate its ERP systems.
- DV Kitchen Web Video Publishing System Released
DVcreators.net has released DV Kitchen, a new video encoding and publishing application for Mac OS X designed specifically for creating materials to be posted on the Web.
- NEC Debuts 4 Education Projectors
NEC this week debuted four new projectors targeted toward education applications, along with a new MultiSync LCD display. The new NP-series projectors are entry-level models started at $899 but are designed to provide high light output, support for closed captioning, and built-in networking capabilities.
- Security Researchers Uncover Spring Framework Vulnerability
Software frameworks are enjoying enormous popularity these days among a range of developers. It's popularity well earned; frameworks provide powerful tools for building more flexible and less error-prone applications. They generally enhance developer productivity with out-of-the-box functionality. And they can free developers to focus on features instead of common coding tasks.
- 3PAR Server Arrays Integrate Fat-to-Thin Processing
Utility storage provider 3PAR has announced the release of the 3PAR InServ T400 and T800 Storage Servers. The new hardware is built on the company's third-generation InSpire architecture, featuring the 3PAR Gen3 ASIC with integrated fat-to-thin processing.
