Got a tricky question? Receive an answer from students like you! Try us!

Data Warehouse Project Management - Essay Example

Only on StudentShare
Author : qabshire

Summary

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…

Extract of sample
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 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

Related Essays

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 system.…
40 pages (10040 words)
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 details, data type details, and the information's relationship with other resources. Sharing this information leads to an increased visibility of information across an enterprise, shorter development…
5 pages (1255 words)
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 involved, there is a dependency between tasks 76 and 109 as well. Ignoring dependencies such as these has resulted in that resource been overloaded. Hence tasks assignments need to be reworked.…
2 pages (502 words)
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."…
15 pages (3765 words)
Case Studies of Data Warehousing Failures
ent), lack of focus or difficulty in identifying the scope of the Project (a business case for the data warehouse not clearly defined), poor data warehousing tool selection process, unproven technology (new or inappropriate software), internal politics within organization, end user involvement/participation in determining information requirements, incomplete functionality, unsatisfied end users, data warehouse tool implemented too complicated for users, below standard or unacceptable performance, not expandable once made, quality of report and data, management not recognizes the benefits of…
5 pages (1255 words)
Data Warehouse Project Management
To understand the various nuances of Data Warehouses in real time implementation, we studied the data warehouse implementation of DePaul university. 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…
20 pages (5020 words)
Data warehouse
ehouse is a silo of data gathered from multiple data sources that is coming from wide-ranging sources and forming an all-inclusive database by filtering the old and new data based on business logic and the need of the organization. Data warehousing is the concept of using data from the data warehouse for further processing and getting business intelligence information in an organization. In a data warehouse the flow of data and information has to be continuous, systematic and structured in a manner so that decision makers at every level in the organization can do data mining, query the data to…
8 pages (2008 words)