User Account

All Pages

Design a prototype data warehouse schema

Assignment Help Database Management System
Reference no: EM131474623

Assignment Tasks - Prototype Data Warehouse & Technology Review Report

a) Use Dimensional Modelling Technique to design a prototype data warehouse schema. Use the data on invoices for Spend over £25,000 in the Department for Business, Innovation and Skills (https://data.gov.uk/dataset/financial-transactions-spend-data-bis) for the Period April 2014 to Mar 2015 inclusive). Negative values in the AMOUNT column represent refunds and as such are valid and must be kept. For refunds, only amounts of £50 or more are valid."

b) Use SSIS to perform ETL on the invoice data to populate the data warehouse, in doing so you should demonstrate the use of SSIS transformations/expressions and SQL where appropriate.

c) Create an OLAP cube from your data warehouse and perform the following analyses:

1. Show the top three Suppliers and the total amount spent on these for the year and far each of the four quarters e.g. April-June, July-September, October-December and January-March. Ensure that any refunds are appropriately deducted in your calculations.

2. Show Expense Types that have a hag year spend amount less than the average half-year Expense Type spend. For each of the half-years April-September and October-March.

3. Show a monthly tap 10 ranking for spend on Expense Areas. For each Expense area indicate the number of places it has moved (up/down the rankings) since the previous month.

d) Design a simple BI dashboard for your data warehouse, reporting on a specific business theme of your choice.

e) Using a minimum of THREE published academic journal papers as reference sources; write a short technology review report (min 1000 - max 1400 words) on the following topic.

"Contemporary and future applications of Security Analytics or similar technologies".

Attachment:- Assignment Files.rar

Reference no: EM131474623

Questions Cloud

Redesign the memory cell of given figure : Redesign the memory cell of Figure to make it suitable for coincident decoding (i.e., two enable signals).
What you have learned about the changes in culture : Draw upon what you have learned about the changes in culture thus far when forming your answer. Do you believe the public was overreacting to these paintings?
How management information or decision support : Briefly describe how management information or decision support systems can assist you when analysing information and identifying trends and patterns?
Implementation of new innovative products : It is required for Samsung to focus upon implementation of new innovative products and services so as to sustain their competitiveposition and growth in the targeted emerging market of India.
Design a prototype data warehouse schema : Use Dimensional Modelling Technique to design a prototype data warehouse schema. Create an OLAP cube from your data warehouse
What do you consider to profound change in western culture : Thinking back to what you have learned, what do you consider to be the most profound change in Western culture from 1500 to the present?
Design the decoding circuitry : Arrange the 16 chips needed in the design of Problem (b) as a 4 x 4 array and design the decoding circuitry.
Draw the product structure with low-level coding : Draw the product structure with low-level coding. Draw the corresponding time-phased diagram showing lead times to scale.
Qualitative-quantitative and mixed methods : Compare and contrast the following three research designs: qualitative, quantitative, and mixed methods. Explore the benefits and drawbacks to each.

Reviews

len1474623

4/26/2017 3:19:40 AM

I have attached the assignment specification to below as well as some of the data sets needed to be used. I have others which need to be worked upon within the assignment. Your technology review report must be formatted/presented in the style of an academic journal paper. Your journal paper reference sources must have been published between: Jon- and Mar. Take care to properly cite and reference all content from external sources. Supporting Narratives — Tasks: A-D (max 1600 words) Each task: A-D must be accompanied by a brief evaluative narrative (max 400 words per task). Each narrative must reflect on how you completed the task any issues that you overcame or could not fix. The whole document must be checked for spelling & grammar.

Write a Review

Database Management System Questions & Answers

  Case study queensland liquor national online trader

case study queensland liquor national online trader databasequeensland liquor national better known as qln owns an

  Importing namespace system. io. import system. io

Create an application that stores people's names and birthdays in a file (Fig. 23.40). The user creates a file and inputs each person's first name, lastname and birthday on the Form. The information is then written to the file.

  Develop basic tools to expedite use of oracles dictionary

Write a script that provides all of the information in, and duplicates the formatting of, Oracle's SQL*Plus describe command. Additionally, the output should add the comments on the rows. Input: owner and table name. Output: columns for Name, Null..

  Method to change column name

Hhow can you change column name or what is a different way to write statement in SQL so it displays the amount column as money.

  Importing and analyzing data for johnson equipment

Importing and Analyzing Data for Johnson Equipment-Johnson Equipment, the medium-sized laboratory equipment manufacturing company where you work, is in the process of acquiring Sloan Manufacturing, a smaller equipment /manufacturer in the same indu..

  Review the advantages of database management systems

Review the advantages of database management systems? Which two advantages do you think are the most important? Why?

  Order results by customers last name in ascending order

Only demonstrate those customers that have the word/partial word "mail" somewhere in the EmailAddress. Order the results by the customer's last name in ascending order.

  Describe basic mechanisms for accessing relational databases

Determine the technical provisions that would be required to ensure data integrity. Evaluate whether the use of a distributed DBMS structure is appropriate.

  Create the primary key and foreign keys using a uml class

Create the primary key and foreign keys using a UML Class diagram for each table. Describe the data structure that will store all data elements.

  Create a corresponding xmlschema file

A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour

  Implement a good information systems plan

Implementation of business analytics, an organization will also need to implement a good information systems plan in order to collect, manage, and organize all of the data.

  Recognize and examine any potential physical

you are the information security officer for a small pharmacy that has recently been opened in the local shopping mall.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd