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:
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:
1. Write a problem statement to include an introduction of the company and the factors that have lead to the need for a data warehouse.
2. Construct a requirements document that details the business user and technical requirements.
3. Use Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, or OpenOffice to complete the following. Note: The graphically depicted solution may not exceed five (5) pages toward the required page length. Ensure that each depiction has a written explanation that explains the illustration.
a. Construct the business and technical metadata that would be necessary for the data warehouse.
b. Create a schema for the data warehouse.
c. Construct the necessary fact table(s) and dimensional table(s).
d. Illustrate the flow of data including both inputs and outputs for the data warehouse.
4. Recommend and justify a business intelligence (BI) solution; then, depict the probable dashboard needed by expert users.
5. Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more