This report aims at presenting the various data warehouse development and management features that were put in to effect while developing the data warehouse for the university. Certain roles specific to data warehouse development such as DW SDLC, construction of Data Marts when needed, ETL, Optimizations and Reporting are analyzed in detail. No data warehouse comes with a certain guarantee off success. The volume of implementation itself is many a times a reason for a DW failure. Therefore this paper also looks at the various risk factors involved in the development of the data warehouse for De Paul University.
DePaul was founded in 1898 and is named for a 17th-century French priest, St. Vincent De Paul. The university has an enrollment of 23,149 students, 1,521 full time and part time professors and more than 125,000 alumni worldwide. At DePaul, students, faculty and alumni come together to form an environment that is welcoming and inclusive. The rich mix of heritages, experiences, interests and aspirations of its students and faculty help make the DePaul community one of a kind. To credit all its worth, in 1999 and 2003, the Princeton Review ranked DePaul students as "the happiest in the nation". ...Show more