Subject Code : INFO704
Assignment Task:

Learning Outcomes Assessed 
1. Examine and discuss the differences between relational databases and data warehouses concepts 
2. Design and create a data warehouse using the latest technologies to support querying, reporting and analysis tools to support critical business questions 
3. Obtain practical knowledge of Industry-based recent tools for data warehouse and business intelligence 

Design The assessment is based on a case study provided by the Tutor. This will be with the Assessments. A student can choose a business idea but it MUST be approved by the Tutor before beginning the assessment. Please note you must do your own or group work in the assessment. You MUST submit an individual assignment you’re your Data Mart. Groups of 4 are recommended to be able to complete the data warehouse, preferred to have 2 databases and 2 programming students in each group. 
Design your Data Warehouse 

1. Select your case study 

2. Production database (Group submission) 

  •  Production Database design 
  •  Production Database Scripts including DDL and DML statements 
  •  Populate the production database with data with evidence shown in the presentation 
  •  Popular your main Data table into the database using a procedure (e.g. sales table) 
  • 1-page word document discussing requirements & design justification 

3. Provide a list of requirements for your Data Warehouse 

  • Based on the questions you identified for the organization 

4. Provide Excel analysis on the requirements you identified in step 3 

  • Create a spreadsheet with data for all tables 
  • Have Pivot Tables for the requirements suggested in task 3 
  • Have Pivot Charts for the requirements suggested in task 3 

5. Design your Data Mart 

  • Data Mart Design * list provided 
  • Identify the Facts and Dimensions 
  • Design your Data Mart, including (all group members must have a different data mart) 
  • Identify the model type used in each Data Mart 
  • Describe the benefits & disadvantages of using a schema type 
  • Describe why you used the schema type? Add brief Design descriptions for each table 
  • What is stored and why (how it is used in the Data Warehouse analysis) 
  • Data Warehouse Design diagram 
  • Show the data marts in different colors [lines to show each one] 
  • Identify any Conformed Dimensions 

7. 1-page word document discussing requirements & design justification and comparison of relational database and data warehouse designs 
8. Design presentation file (e.g. Powerpoint file) 
9. Present your Design to the tutor (scheduled times will be advised) 

Presentation 
10. Presentation: 

  •  Use a professional PowerPoint or other presentation tools 
  •  Header and footer sections (company name, your name as the client and page numbers) 
  •  Brief description of the business (Introduction to the organization) 
  •  Designs (DB, Data Mart, DW) 

 Requirement Questions 

  • Excel Analysis - link and then findings 
  • Quality and Professional documenting the Data Warehouse 

11. Presentation of your Design task to tutor 

  •  Introduce task and presentation 
  •  Show a larger view of your Data Mart and the Data Warehouse 
  •  Demonstrate the Excel analysis 

This Computer Science Assignment has been solved by our Computer Science Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mia
  • Posted on : March 18th, 2019

Whatsapp Tap to ChatGet instant assistance