CIS 429 All Assignments CIS 429 All Assignments | Page 8

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: Wikipedia and similar Websites
do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all
sides; citations and references must follow APA or school-specific format. Check with your
professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s
name, the course title, and the date. The cover page and the reference page are not included in
the required assignment page length.
Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such
as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into
the Word document before the paper is submitted.