Big Australian winemaker with sites in different Australian states

  You work for a big Australian winemaker with sites in different Australian states. The company operates different types of sites: Vineyards (that can be grouped into areas), bottling plants, and warehouses. The warehouses are always located in cities while the other two types are located in rural areas. The company is now designing a DW and has put you in charge of the Site dimension. Different attributes are relevant for the different kinds of sites. Sketch a design for the dimension (you do not have to list all attributes – just assume/show some relevant attributes). If details are missing in the text, you can make your own assumptions. Please list the assumptions in your solution. 2.2) You are designing a data warehouse to keep track of employees’ time usage. There should be snapshot facts with the granularity of one fact per employee per project per week (or finer). a. We must track the time spent on internal meetings, meetings with customers, reporting, research & development, and any other business. Unfortunately, the different managers cannot agree about which time unit to use. One wants to see all numbers in person months (1 PM = 135 hours); another wants to see all numbers in days (1 day = 7.5 hours); and a third wants to see all numbers in hours. How do you recommend handling this? b. The salary costs for the different activities should also be considered. The company is headquartered in Denmark, but does also have offices and employees in Norway and Sweden. How do you recommend handling this? c. Sketch the fact table(s) you suggest the company to use. Please list any assumptions you make. 2.3) We travel in time to year 2024 and realize that Denmark soon will start using euros. You are in charge of the data warehouse for a small company that sells stuff and until now only has used Danish kroner. Which SCM type do you recommend to use? Why? List any assumptions you make. 2.4) Sketch a (simple) data vault design for a software company where registered users can rent online access to applications for a varying number of days. List any assumptions you make.