Part 1 - report write a 2000-word report that describes a

Assignment Help Data Structure & Algorithms

Reference no: EM13381304

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

a) Design and build a prototype data warehouse using the data on Spend over £500 in the Department of Energy and Climate Change 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: EM13381304

Questions Cloud

Raise or lower tuition suppose that in an attempt to raise : raise or lower tuition? suppose that in an attempt to raise more revenue nobody state university increases its tuition.

Question 1 this part has 30 marks allocated to itrecord the : question 1 this part has 30 marks allocated to it.record the following transactions from june for centinal electronics

Use the provided appbdbcreatesql sql script to create the : use the provided appbdbcreate.sql sql script to create the database to be used when working on this assignment.question

Part 11 the following data is collected from customer : part 11. the following data is collected from customer complaints about service problems at a hotel. complaint types

Part 1 - report write a 2000-word report that describes a : part 1 - report write a 2000-word report that describes a suitable methodology from the literature for the purpose of

Q1 - technical essay describe and critically evaluate the : q1 - technical essay describe and critically evaluate the similarities between the windows and unix operating systems

Q1should the united states allow mexico to have water from : q1should the united states allow mexico to have water from the rio grande and colorado river both of which originate in

1 what is a bioindicator what ecological and biological : 1 what is a bioindicator? what ecological and biological aspects make lichens good indicators of poor air quality? in

Q1what do you think about cooperative breeding when is it : q1what do you think about cooperative breeding? when is it advantageous to be a helper to your kin versus going off to

User Account

All Pages