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 :
Write a problem statement to include an introduction of the company and the factors that have lead to the need for a data warehouse .
Construct a requirements document that details the business user and technical requirements .
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 .
Construct the business and technical metadata that would be necessary for the data warehouse .
Create a schema for the data warehouse . Construct the necessary fact table ( s ) and dimensional table ( s ).
Illustrate the flow of data including both inputs and outputs for the data warehouse .
Recommend and justify a business intelligence ( BI ) solution ; then , depict the probable dashboard needed by expert users .
Use at least five ( 5 ) quality resources in this assignment . Note :