Your task is to design a data warehouse for Heathcote Winery Group using multidimensional…

Get perfect grades by consistently using Writerbay.net writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Your task is to design a data warehouse for Heathcote Winery Group using multidimensional

Modelling. Your design needs to encompass the following steps:

(i) First construct a Data Warehouse Bus Matrix to identify the company’s business processes

and any likely Data Marts. (10 marks)

(ii) Identify the grain of each star/snowflake schema to design the dimensional model for business

processes you have identified, ensuring your dimensions are conformed, primary and foreign

keys are clearly labelled, and that your attributes are named using verbose textual

descriptions. You also need to provide three rows of the fact table your designed to explain

the meaning of the rows. (40 marks)

(iii) Create the following table with a row for each fact table in your design, indicating the

granularity of each fact and a brief justification for choosing that granularity.

(12 marks).

Attachments:

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper