Data Warehousing - Analytical SQL - IT Assignment Help

Assignment Task:

Introduction 

This is an individual assignment. Using data models (ER diagrams) developed by your syndicate group and submitted as part of the Assignment 1 report, you are required to design and document two analytical SQL queries that can help business users of a system that implements the data models to gain insights about the performance of their organisation and support strategic decision making. 

Case Descriptions 

Refer to Assignment 1 case description. 

Assessment and Report Requirements 

This assignment is worth 20% of your assessment for the subject. Historically, the average mark for this assignment has been around 15/20 marks. Design two analytical queries over the database schema in Third Normal Form (3NF) and Star Schema your syndicate group has prepared and submitted as part of the Assignment 1 report. The analytical queries should address the data across multiple entities (tables) of your database/star schemas. For examples of analytical queries, please refer to the lecture slides published on Canvas: 1) Data Warehousing - Part 03 - Lecture - Data Warehouse Design Principles - AFTER.pdf (Slide 14) 2) Data Warehousing - Part 04 - Lecture - Dimensional Modelling (Kimball and Ross) - AFTER.pdf (Slide 8) Each of the two analytical queries must be supplied with: 

1) A specification of the query in English language (maximum 150 words);

2) Two SQL queries that implement the English language specification of the query. One SQL query should be implemented over the database schema, while the other SQL query should implement the same logic as the first query but over the star schema;

3) A discussion of decision-making capabilities that the analytical query supports (maximum 250 words). Explain how the results of the query can provide valuable insights into an organisation that implements it. You should use hypothetical query results to exemplify strategic decisions and actions the organisation can take as a response to obtaining them. 

Finally, your report should include a discussion on the benefits and drawbacks of implementing analytical queries over the normalised database schema and denormalised star schema (maximum 350 words). This discussion should demonstrate your understanding of the role of both data designs in organisations.

The submission should be less than 1,000 words in length (excluding figures, tables, SQL statements, and references) and take the form of a report describing and justifying the designs of the analytical queries.

A suggested outline for the sections of the report is listed below1: 

1. Cover sheet containing the title of the assignment, an identifier of your Assignment 1 report (e.g., your syndicate group name or number), your name, and student id.

2. Data models captured as ER diagrams, both the database schema in Third Normal Form (3NF) and Star Schema, that you have submitted as part of the Assignment 1 report.

3. Specification of analytical queries in English language, which presents two analytical queries that can be implemented over both data models presented in Section 2.

4. Specification of SQL queries, which lists SQL queried that implement the analytical queries from Section 3. Implement and list two SQL queries for each analytical query from Section 3, one SQL query over the database schema and one SQL query over the star schema, both implementing the same logic. In total, this section should list four SQL queries.

5. Decision-making capabilities, which presents a discussion of the strategic decisions that the queries from Sections 3 and 4 can support in organisations that decide to implement your data models and queries. You should use hypothetical examples of data and/or query results to demonstrate the added value of your queries.

6. Discussion, which includes a summary of the benefits and drawbacks implementation of analytical queries over normalised and denormalised data model entails.

Quick checklist 

To be certain to acknowledge sources fairly and avoid plagiarising, review this checklist before beginning to write your essay and again after you have completed your first draft. 

1. What type of source are you using: your own independent material, common knowledge, or someone else's independent material?

2. If you are quoting someone else's material, is the quotation exact? Have you used quotation marks for quotations run into the text? Have you set off block quotes with an extra space before and after the quote, single spacing within the quote, and left indenting of all lines of the blockquote? Are omissions shown with ellipses and additions with square brackets?

3. If you are paraphrasing someone else's material, have you rewritten it in your own words and sentence structures? Does your paraphrase employ quotation marks when you resort to the author's exact language? Have you represented the author's meaning without distortion?

4. Have you acknowledged each use of someone else's material? 5. Do all references contain complete and accurate information on the sources you have cited?

This IT Assignment has been solved by our IT Experts at My Uni Paper. 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.