Data Warehouse Project Management

High school
Essay
Miscellaneous
Pages 20 (5020 words)
Download 0
Databases and Database theory have been around for a long time now. The earlier databases centered around a single database serving both purposes: transaction processing and decision support. However with the advancement of technology such as 4GL and PC and with the empowerment of the end user to perform his/her own tasks, a more sophisticated version of the databases started to occur…

Introduction

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". ...
Download paper
Not exactly what you need?

Related papers

Data Management Essay
There are many forms of DBMS (database management systems) which include such company areas as accounting, human resources and customer support systems. As large organizations generally only needed these types of DBMSs to handle the large amounts of data exchanged and stored, it is now a commonality in many companies, both large and small, and is a fairly standard part of any company's back office…
Warehouse management systems
The modern warehouse can ill-afford to ignore this important resource.…
Knowledge Management business and economy
Users can view information in a context they understand, providing a more efficient and intuitive way to communicate. To achieve this kind of enterprise-wide information integration, companies need to describe and share, in a common way, the data in their disparate data sources. This should include the business description associated with the information asset, as well as location, connection…
Project management/case-study
Risk has two components, one the possibility of not achieving a particular outcome, and the second is the result of failure to achieve the outcome. The former is the probability of risk and the later is the loss. So Risk management is a set of action that help the project managers plan to deal with uncertain occurrences. It is through risk management, project managers assess risk and manage to…
Data Warehouse Project Management
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…
Data Warehouse Gantt Chart and PERT Chart
The task assignments have overloaded certain resources. This is because, when setting predecessors, only adjacent tasks have been considered in certain cases. For example, some of the tasks to which the resource named Goran has been allocated on the same day are 75, 76, 109 and 110. Task 76 has a dependency on task 75 and task 110 has a dependency on task 109. But, because the same resource is…
Managing Information Systems
Data in a Data Warehouse is arranged by subject not by function. As a result a data warehouse provides a peculiar view of the data that is amenable to manipulation for decision support. Levine and Siegel (2003) identify the key elements of a data warehouse as: "They are subject orientated, integrated, time variant, nonvolatile, and contain a collection of both detailed and summary data."…