Assignment Task: Data Modelling and OLAP Techniques for Data Analytics
The aim of this coursework is to design, implement, and test a data warehouse based on a given business case scenario. It consists of 2 parts, Assignment (1) needs to be completed as a team work and Assignment (2) is an individual coursework.
Coursework Specification:
Case Study Scenario: Blue Sky Online Consumer Electronics Retailer
Assignment A: Task 1 below will be completed working as an agile development team and the product will be a design on Conceptual Level; the architecture and the components of the designed architecture needs to be explained clearly and justification needs to be given.
Tasks:
Problem 1: Design dimensional data models based on the business reporting and data analysis requirements of the Blue Sky Consumer Electronics retailer.
A) Identify and define the grain (detail level) of a fact table. Explain the hierarchies, if there are any?
B) Identify measures of the fact table, and attributes of each dimension table. Justify why they have been chosen.
C) Identify dimensions of the fact table.
D) Choose an appropriate schema to define the structure that shows how the fact table is related to its dimensions. Present your schema using Entity Relationship Diagram.
E) Reflection: Needs to be written individually about the team work and the following needs to be answered briefly:
What has been gained by working in an agile team, and what was your individual addition to the team?
Assignment B: From the above Conceptual Design, a physical design needs to be implemented as individual work.
Problem 2: Implement a data warehouse based on the dimensional data models designed in the previous task using SQL Server Management Studio.
A) Create a database.
B) Create dimension tables
C) Create fact tables.
D) Add appropriate primary keys and foreign keys constraints.
Problem 3: Populate the implemented data warehouse based on the provided data sources using SQL Server Management Studio.
A) Implement ETL (extract, transform, and load) processes to populate dimension tables.
B) Implement ETL (extract, transform, and load) processes to populate a fact table.
C) Write SQL statements to test whether the dimensions and fact tables are populated correctly.
Written Report:
The report, which you will submit, should be well written, structured and well-presented and it must include:
A) An introduction section that summarize the objectives of the course work and business case scenario.
B) The Analysis and design of a dimension data model.
C) The implementation, populating and testing of the data warehouse (include screen shots to show SQL commands and their results).
D) Provide a personal reflective conclusion of what you have learnt from your overall coursework.
A number of students fail to precisely deal with the assignments and homework assigned by the university professors and they seek for Data Modelling and OLAP Techniques for Data Analytics Assignment Help service for better academic grades.
Tags: Data Modelling and OLAP Techniques for Data Analytics Assignment Help, Data Modelling and OLAP Techniques for Data Analytics Homework Help, Data Modelling and OLAP Techniques for Data Analytics Coursework, Data Modelling and OLAP Techniques for Data Analytics Solved Assignments, SQL Server Management Studio Assignment Help, SQL Server Management Studio Homework Help, SQL Server Management Studio Coursework
Attachment:- Data Modelling and OLAP Techniques for Data Analytics.rar