Describes a suitable methodology from the literature

Assignment Help Database Management System

Reference no: EM13266897

Part 1 - Report

Write a 2000-word report that describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company. You should evaluate the changes that have taken place since the beginning of data warehousing and show how these changes have affected the hardware and software that would be used for such a project over the last 40 years.

Part 2 - Case study

a) Design and build a prototype data warehouse using the data on Spend over £500 in the Department of Energy and Climate Change (data.gov.uk/dataset/financial-transactions-data-decc) for the financial year 2012-2013 (April 2012 to March 2013 inclusive).

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

Show the top three expense types and the total amount spent on these for the year and for each of the four quarters April-June, July-September, October-December and January-March.
Show the top five expense areas and the totals amount spent on these for the year and for each of the two half-years April-September and October-March.
Show the four suppliers who received the most money and the totals they received for the year and for each of the four quarters April-June, July-September, October-December and January-March.

c) On paper, design a simple dashboard for your data warehouse.

This should be accompanied by a 1000-word report which describes the creation and use of your data warehouse. You should include the following:

A description of the source data used.
An explanation of any design decisions you have made.
An explanation of your ETL process, highlighting any particular problems you had to overcome and including examples of any SQL queries you have used.
A relationship diagram or database schema.
A description of how the analyses were performed, illustrating the results of the analyses with screenshots.
Sketches of your dashboard design and the reasons for your design choices.

Reference no: EM13266897

Questions Cloud

Is there any advantage or disadvantages to a type of memory : A new 24-bit processor is being designed for operation in a cell phone (you can assume the word-size is 24 bits). Suppose the following memory values are being stored in memory that is organized where each location is 8-bits wide (byte addressable..

What is the value of a one-year european call option : A stock price is currently $100. Over each of the next two six-month periods it is expected to go up by 10% or down by 10%. The risk-free interest rate is 8% per annum with continuous compounding. What is the value of a one-year European call opti..

Explain the original pressure before the compression : A gas in a container is expanded by 0.25 of the original volume to a total of 15 dm^3 at constant temperature. The resultant pressure is 20 bar. What was the original pressure before the compression assuming perfect gas behavior

Indicate the inputs and final result in decimal : Computer the following assuming each number is a two's complement number and indicate the inputs and final result in decimal. Also, indicate if the number overflows. a. 01 + 1011 b. 11 + 01010111 c. 1101 + 110 d. 01 + 10 e. 111 + 111111

Describes a suitable methodology from the literature : Describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company.

Explain oxygen act like a perfect gas : It was determined in an experiment that a balloon filled with O2 gas with mass 32.0g in a 1.0 dm^3 volume exerts 21.6 atm of pressure at 0 degrees Celsius. Does Oxygen act like a perfect gas

Determine a minimal sop expression for f : Construct a truth table for a three variable function that includes minterms 1,4,6,7. Construct the corresponding K map and use it to find a minimal SOP expression for F.

How many groundhogs are in the wooded area today : Two years ago, a certain wooded area contained 100 groundhogs. If the population of these animals increase at an annual rate of 120 percent, approximately how many groundhogs are in the wooded area today?

State the formulas of any precipitates that should form : For each of the following pairs of ions, determine whether a precipitate would form when solutions containing these ions are mixed and write the formulas of any precipitates that should form. Indicate the color of any precipitate that should form.

User Account

All Pages