CSE5DWD: Data Warehouse Concepts and Design - Heathcote Winery Group - IT Assignment Help

Assignment Task:

Business description 

Heathcote Winery Group 

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 partners 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?clined to USA in value. 

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 management wants to analyse the data every quarter to see 

• the trends of the market such as the average value of the exports to each country/area (*) 

• the arrived date between the ordered date and the payment date between the shipment date, how soon the payment can be received after the shipment? (*) 

• The quarterly percentage of damaged wines against the shipped wines in each country,  

• the consumptions of wins in bottles/ cartons/volumes by each person in any country per quarter regular wine drinkers’ consumption patterns, and 

• the most popular types (sparking, red, white) of wines among the different countries 

• the sales between different countries and the largest volume sales of the country 

• the holiday period in Easter month has increased the sales in Europe comparing with the same period in last year. 

The winery and vineyard are managed by the local owners who supply wines to export department of Heathcote Winery Group. On another hand, the winery owners want to expand the distribution of their wines to eateries or individuals further afield. The local winery generates wine sales in two ways: online orders and its cellar door market stalls. 

1. The web site provides the online sales to customers. Customer can select the name, the brand and the type of the wines for their purchases. The company offers delivery services. The online order can be delivered to the customer door or pick up at the cellar door. The web site is often posting the promotion news and announcements about the new wines and the winner wines from the quarterly competition to stimulate the purchases.

2. The winery wants to increase its bottle sales at the cellar door. It offers market stalls and sales to eateries and visitors in its local area. 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 market stalls and use this as a marketing tool to sell those wines to eateries in the country wide. 

To encourage people to visit the winery, management plans on holding special event days to promote their wines. 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.