BUS5WB: Data Warehousing & Big Data- Data Warehouse Design Assignment Help

Data Warehouse Design Assignment Help:

The Case Vigour is a fictitious healthcare provider specialising in geriatrics. Its mission statement is to improve each and every client’s quality of life. This translates into two primary business objectives: promote health and wellbeing, diagnose and treat chronic disease conditions. Vigour operates on a subscription-based model, where clients keen to obtain the health services pay an upfront membership fee and a monthly subscription. Having been in business for the past ten years, the CEO at Vigour is confident that the substantial accumulation of data in transaction systems can be capitalised to improve the effectiveness and efficiency of each business operation. He’s keen to implement an organisation-wide data warehousing solution to explore this potential. He’s approached an analytics consultancy firm to start on this project. The business requirements analysis and feasibility study were completed on a positive note and now you have been recruited as the dimensional model specialist to complete the data warehouse design phase. Tasks 1. Requirements: Identify current and future decision-making needs and information requirements of the organisation. Determine the number of dimensional models required (with justification). 2. SQL: Compile SQL statements, based on given information and ER diagrams, to address five decision making needs identified above. Use of advanced SQL syntax is required as this task aims to assess your knowledge of SQL. 3. Design: Follow Kimball’s dimension design process to create the identified models. Revise each model by applying the fact table and dimension table techniques. Provide a data dictionary (a description of each table in each model outlining the purpose, attributes and data types). 4. Demonstration: Demonstrate how each dimensional model can be used to respond to current and future business questions and decision-making scenarios. Articulate how the dimensional model can lead to effective decisions. Deliverables A professionally written report on the dimensional design activities undertaken for Vigour. This can be compiled as a series of topics of the abovementioned ‘to do’ list or formatted as a design document. 1. The report should be compiled in Microsoft Word, font size 11. 2. Report content should not exceed 8-10 pages (including diagrams). Diagrams have to be in the main body as it is a design document. If the number of pages are insufficient, you may include the data dictionary as an appendix. 3. You are free to make any assumptions with justification. Include these in the report, where applicable. 4. Make realistic assumptions on any information (schema or business requirements) that may be missing in the above description.