MyAssignmenthelp
Get Help From World's No.1 Online Tutoring Company
Get Online Tutoring through WhatsApp
Call Now: (+61) 416-195-006
Get Online Tutoring through WhatsApp
This is an INDIVIDUAL assignment. You ARE NOT permitted to work in a group when writing this assignment.
No extensions will be given:
Penalties are applied to late assignments (5% of total assignment mark given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances that prevent the assignment being submitted on time, an application for special consideration may be made. See the departmental Student Handbook for details. Note that delays caused by computer downtime cannot be accepted as a valid reason for a late submission without penalty. Students must plan their work to allow for both scheduled and unscheduled downtime.
The marking scheme is described in section 3: Your task.
Any queries can be addressed to the Lecturer during the normal consultation time. You will have consultation helping time in the week before this assignment due date:
8 consultation hours in the week. The specific time will be announced on LMS.
Heathcote Winery Group is offering Regional Wine Export and Tourism of vineyard. It aims to help transform the Australian grape and wine industry by showcasing the nation’s wine tourism offering and driving demand for Australia’s wine exports.
The management of Heathcote Winery Group for wine export department has a very big market with hundreds of worldwide business patterners such as northeast Asia (China, Japan, Korea etc), southeast Asian (Indonesia, Vietnam, Thailand, Singapore, Malaysia etc) , Oceania (New Zealand, Fiji, Samoa, etc), Europe (Italy, France, UK, Germany, Poland, Greece etc), North American (Unite State, Mexico, Canada, Cuba, etc), Middle east (Iran, Israel, Turkey, Saudi Arabia, Egypt, Iraq, etc) and rest of world. In recent two years, Australian wine exports to China increase 18% in value and 12% to Canada in volume, but 5% declined to USA in value. The management wants to analyse the data every quarter to see
The winery and vineyard are managed by the local owners who supply wines to export department of Heathcote Winery Group. On another hand, the local winery generates wine sales from its cellar door, market stalls and sales to eateries in its local area. The winery owners want to expand the distribution of
their wines to eateries further afield. They currently have data files containing where each bottle of wine was sold, the quantity in which it was sold and the dollar sales amount. They hope that by looking at this data they will be able to tell which wines were most popular at particular market stalls and use this as a marketing tool to sell those wines to eateries in the country wide.
Each bottle of wine is described by the following information: the name of the winery/trade mark/business or brand name; name of wine, a grape variety name, i.e. 'Shiraz' or a generic wine style,
i.e. 'Dry Red'; a Geographical Indication (zone and/or region and/or sub-region), i.e. 'Yarra Valley'; vintage (year of release), volume (in ml); alcohol content (as a percentage); the number of standard drinks the bottle is equivalent to; an allergens declaration (i.e. egg, milk, nuts etc.); the name and address of the responsible entity; and the country of origin.
The winery also wants to increase its bottle sales at the cellar door. To encourage people to visit the winery, management plans on holding special event days where they provide wine sales discount, light musical entertainment, complimentary cheese platters, etc. Managers want to be able to assess the success of these special event days so information regarding the event: event date; event day name; event day description; music type; food type (cheese platters, luncheon, etc); event cost; and an estimate of the number of people who attended is required. Managers want to analysis the event sales:
Another department of Heathcote winery group is the tours management. Local tour management offers daily tours providing an entertaining, sociable and educational day tour. The winery entry fee is for a fixed fee of $10 for each visitor. The visitors in a group of 10 people or more will get 10% discount. To provide the convince to tourist the winery has facilitated restaurants and cafe for tourist to order for foods and drinks. The tour management wants to keep the expenses of each visitor including the entry fee, dishes, wine and drinks purchased during the day tour in the local winery. Please notes that each visitor may order a number of dishes in the restaurant for a lunch. The number of dishes many not be predicted for each visitor.
Managers want to analyse visitors’ habits in a day tour. They want to
You need to design the data warehouse schema to capture the business processes for the data analysis.
Your task is to design a data warehouse for Heathcote Winery Group using multidimensional Modelling. Your design needs to encompass the following steps:
Fact table name | Fact granularity | Fact table type | Brief justification |
Dimension table name | Brief justification | Attribute hierarchies |
Design feature | Brief description | Brief justification |
From the export sales star schema:
-Facts from export sales: export_location_key, dollar_sales_amount
-Export Location Dimension: country_name/area code
How: Apply sum on dollar_sales_amount for wines from each country and then average it.
From the export sales star schema:
-Facts from export sales: wines_key
-Wines Dimension: grape_variety_name
How: Apply count on all different wines_key, find the highest count and find corresponding grape_variety name.
Dimension Table (Wines):
Dimension Table (time):
Fact Table:
Dimension Table (special events):
Dimension Table (Wines):
Fact Table(Events sale fact less fact table):
Dimension Tables (Bridge Dishes Group):
- dishes_group_key
-dish_key
Dimension Table (dishes)
-dish_key
-dish_ordered_name
Fact Table (Tour Sales):
-dishes_group_key
Dimension Tables (Wine):
Dimension Table (Tours):
Fact Table (Tours Sales)
Dimension Table (Time):
Fact Table (Tours Sales):
Want to contact us directly? No Problem. We are always here for you
Get Online
Online Tutoring Services