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". In 2007, Entrepreneur magazine ranked DePaul's undergraduate program seventh and graduate program fifth, among the nation's top entrepreneurship programs. DePaul is the ninth-largest private, not-for-profit university in the nation. Among those 10, all except DePaul are classified as "research extensive" universities, making DePaul the nation's largest university with a primary mission of teaching and service.
DePaul intends to become one of the finest urban, Catholic universities of the United States. Resolute in its Vincentian mission to make an extraordinary education accessible, DePaul will focus its energies on creating nationally recognized, rigorous programs of study; preparing women and men to be at the forefront of their chosen fields as ethical and socially engaged leaders; and building the financial and operational foundations to make our cherished mission permanent and truly effective.
The Information Systems department of DePaul university take up the task of developing and maintaining the information technology tasks of the university. Information Services, commonly known as IS, is an administrative division of DePaul University with primary responsibility for the university's hardware, software, network infrastructure and telecommunications systems. IT is extremely crucial for the efficient functioning of the university as a whole. The university relies heavily on IT for its day to day activities. Spam Control, Disaster Recovery, and Voice over IP are just some of the extensive IT projects on going in the campus. However, the biggest achievement in the IT sector for De Paul university was the implementation of an Enterprise Resource Planning (ERP) System. DePaul university has implemented PeopleSoft financial module that takes care of all the financial