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 .