Posted: September 9th, 2015

Business Intelligence and Data Warehouse Design.

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.
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
Assignment Two – Business Intelligence Application Design
FIT5195 Business Intelligence & Data Warehousing 3
3. Present your designs in a design specification report. Make sure to present
your report professionally. You should include a proper cover-page, table of
contents, and an introductory overview of your design that outlines your
understanding of the key business requirements and provides an overview of
your solution.
This section should also justify any key design decisions you’ve made, both in
regard to the data visualisations chosen and the design of the multidimensional 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.
For assignment 2b (Data Warehouse Design):
1. Design a data warehouse schema using the star-schema approach based on
your Thomsen diagrams in assignment 2a.
2. Consider options for the technical architecture for the data warehouse,
recommending a structure with justifications.
3. Prepare a data dictionary for your star schema design that includes plainlanguage definitions for all entities and attributes. Further, for each attribute,
you should indicate how the data for that attribute is obtained or derived,
where relevant making reference to the source systems’ database schemas (see
attached transaction processing system database schemas).
4. Supplement your design report from assignment 2a by adding in your data
warehouse design.
Assignment 2a:
1. Quality of support for the business requirements
2. Quality of the prototype reports, in particular the appropriateness of the data
visualisations chosen.
3. Correctness of the Thomsen diagrams in providing an appropriate multidimensional structure to support the included prototypes.
4. Quality and professionalism of presentation, including layout, structure and
grammar.
Assignment 2b:
1. Correctness of schema construction, including data sourcing
2. Quality of design and justification
3. Identification of business requirements
4. Quality of discussion of architectural options.

Looking for the best essay writer? Click below to have a customized paper written as per your requirements.