CIS 429 RANK Learn Do Live /cis429rank.com CIS 429 RANK Learn Do Live /cis429rank.com | Page 20

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.