About 120 administrators and researchers receive that information. The system also is used to plan staffing and facilities needs. "People can understand the business better now," Orechia says. He plans to develop real-time alerting capabilities that will let administrators know when a clinic is overbooked.
The data warehouse also contains clinical information, including data from an outside company that provides laboratory services and information from Dana-Farber's pharmacy system. Researchers tap into this data store to generate aggregate numbers on topics such as the kinds of cancers treated at the institute, treatments employed, and how many patients smoke. That information is used to write research papers, apply for grants, and identify patients who might benefit from experimental treatments.
The data warehouse has even become Dana-Farber's central source for information used in mailings to patients about new treatment options, educational seminars, and changes in procedures. That previously was done by the departments, but the decentralized approach resulted in conflicts when data in some departments wasn't up to date.More Software Insights
White Papers
Webcasts
Reports
Videos
So Orechia's team began regularly downloading data from patient scheduling, registration, and billing systems into an Oracle data warehouse. Using reporting software from Business Objects SA, Orechia can develop reports that identify the best times to schedule patient visits.

![]()
![]()
Dana-Farber Cancer Institute gets a big-picture scheduling view, Orechia says![]()
BP seeking Regional Desktop Coordinator in Houston, TX
Agilent Technologies seeking Marketing Manager in Melbourne, AU
Advancement Project seeking Junior Web Developer in Los Angeles, CA
Johns Hopkins Univ Carey Business School seeking Asst Dean for IS in Baltimore, MD
City of Westland seeking MIS Director in Westland, MI
For more great jobs, career-related news, features and services, please visit our Career Center.
The Greening of IT - Saving Resources Helps the Environment and Cuts Costs
Virtualization, energy-efficient storage and multifunction devices all contribute to a more eco-friendly infrastructure. Hereŭs how your business can get greener and save money at the same time.
read more 
NOTE: Offer valid for U.S., U.S. possessions, & Canada only