You have been engaged by Sunshine Escapes to design a business intelligence application and supporting data warehouse. Using the attached case study documents, you will identify the reporting requirements of the senior management users. You will produce prototype report designs and supporting multi-dimensional model in the form of Thomsen diagrams for a planned business intelligence application. You will then produce a multidimensional model specifying a data warehouse database schema, plan an ETL process and provide recommendations for a technical architecture to support the business intelligence application. The assignment is split into two submissions: the first for the application design, the second expanding on the first to include the data warehouse design. Assignment Due Dates: 1. Assignment 2a: 5pm, Friday (25 April , 2015) Times are local times for on-campus students. For off-campus students, times are Australian Eastern Standard Time. Assignment Value: 1. Assignment 2a: 20% of your overall result for the unit. Learning Objectives: The assignment will allow you to demonstrate and assess your ability to: • In assignment 2a: o analyses a typical business intelligence design problem to identify key decision requirements for senior managers; o select appropriate data visualizations to provide effective decision support; o design a multi-dimensional model to support the identified requirements; o Draw Thomsen diagrams. Tasks: For both assignments: 1. Read through the case study files. 2. You will also be able to ask questions of the stakeholders in the case via a dedicated discussion forum on Moodle. For assignment 2a (Business Intelligence Application Design): 1. Using the information provided, design a series of reports and/or dashboards for the key users to help them find answers to their business questions. You may design these using any software tool you wish. The reports are prototypes only and will be submitted in hard copy, so they do not need to actually work as interactive reports. 2. Design a multi-dimensional schema using Thomsen diagrams to support your prototype design This section should also justify any key design decisions you've made, both in regard to the data visualizations chosen and the design of the multi-dimensional schema. This should be followed by your prototype reports (annotated if necessary to explain your design concepts) and then the multi-dimensional model. You may add further sections to the report if you feel it necessary.