CIS 429 All Assignments CIS 429 All Assignments | страница 7

Term Paper: Data Warehouse Project Plan
Due Week 10 and worth 200 points
Imagine that the CIO has been impressed with your past performance and has promoted you to
database administrator. Your first project is to create a data warehouse project plan that will
merge five (5) disparate operational data sources into a common warehouse and associated
data marts. The project plan will address the technical design for the future implementation of
the data warehouse. Your company has realized that there is a great amount of data within the
company’s disparate data sources and a data warehouse with a robust interface is needed to
provide quality information. You approach the project plan with the understanding that a data
warehouse is a system that:
Gathers data from three (3) internal organizational systems and two (2) external sources.
Combines the data into one database.
Manipulates and conforms it to common and organizational standards.
Restructures it for easy exploration, reporting, and data mining.
Using your knowledge of requirements gatherings, architectural framework, the ETL system,
and testing methodologies for data warehouse projects, develop a project plan which details
the implementation concepts and strategy that will lead to a successfully deployed data
warehouse.
Write a twelve to fifteen (12-15) page paper in which you: