Question: Design, Implement, Test, Report on a prototype data warehouse. Produce a single MS Word (doc/docx) format file containing all deliverables. Using Kimball's Dimensional Modelling Technique

Design, Implement, Test, Report on a prototype data warehouse. Produce a single MS Word (doc/docx) format file containing all deliverables. Using Kimball's Dimensional Modelling Technique design a suitable Star Schema for the specified data sets. Then using MS SQL Server with T-SQL and 55IS do the necessary ETL operations, and 4 query tasks (programming unctionality) must be implemented. Finally complete with a dashboard built utilising the 4 query tasks in Tableau or Power BI. Finally, a brief 10 min video demo of Tasks 2,3,4 must be recorded using MS Teams. Include the live URL to the Video Demo in your final report. Ensure our lab tutor can access the video

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Table of Contents Main Objective of the assessment 1 Description of the Assessment 1 Learning Outcomes and Marking Criteria. 4 Format of the Assessment 6 Submission Instructions. 7 Avoiding...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Confirming Pages C H A P T E R 19 Analyzing Information and Writing Reports Chapter Outline Using Your Time Efficiently Analyzing Data and Information for Reports Identifying the Source of the Data...

Complete using C code and run through unix terminal: Race To Zombie Mountain is a race-car game that you will implement with the ZDK character-based graphics library. Extended information is provided...

The aim of the assignment is to expose students in variety of problem solutions in terms of the object design concepts and object-oriented constructs. This assignment will allow the students to...

3. Case Study You are required to develop a simple food ordering system for storing the menu details of the hotel, cafe or any restaurant. The system can add the menu, search the foods on a price...

The Task Oman is an employment destination for skilled workers from different countries. To work in the Sultanate, one has to apply through an agency that evaluates an applicant's skills and other...

Determine the interaction energy of the point charges located at the corners of a square with the side a in the circuits shown in Fig. 3.29. 1+4 +4 6- b+. (6) -4 (C) (a)

The times to failure of certain electronic components in accelerate environment tests are 15, 28, 3, 12, 42, 19, 20, 2, 25, 30, 62, 12, 18, 16, 44, 65, 33, 51, 4, and 28 minutes. Looking upon these...

Which one of the following IRC sections governs or regulates qualified plans? a . 4 0 1 b . 4 0 2 c . 5 0 1 d . 5 0 2

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...