User Account

All Pages

Design and build a prototype data warehouse

Assignment Help Data Structure & Algorithms
Reference no: EM13204692

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: EM13204692

Questions Cloud

Briefly compare the strengths and weaknesses of graphical : Briefly compare the strengths and weaknesses of the graphical, substitution, and elimination methods as applied to the solution of two equations in two variables? Which method do you like best? Why? Be sure to include an example that supports your..
How much will australia trip cost you in us dollars : You are planning a trip to Australia. Your hotel will cost you A$145 per night for seven nights. You expect to spend another A$2,800 for meals, tours, souvenirs, and so forth. How much will this trip cost you in US dollars given the following exch..
Determine the optimal daily production mix : The profit per ton is $40 per sheet and $35 per bar. Determine the optimal daily production mix.
Experience digging for dinosaur bones : According to your textbook, if you quoted your cousin about her experience digging for dinosaur bones last summer, you would be using ____________ testimony.
Design and build a prototype data warehouse : 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).
Presentation grading for records management presentation : You have been hired as the records manager for Happy Health Medical Clinic, a medium-sized, general practice about to start up business. Whereas this medical facility hopes to have everything computerized at some point in the future, that is not curr..
Would the tax be proportional-progressive or regressive : Suppose a special tax was introduced that used the value of one's automobile as the tax base. Each person would pay taxes equal to 10 percent of the value of his or her car. Would the tax be proportional, progressive, or regressive
Why didnt perceive play things as potential learning tools : Many Indian mothers weren't willing to make an investment in the company's educational toys because research showed they didn't perceive the play things as potential learning tools. But a shift in attitude began about two years ago.
Consistent with a contemporary definition of wellness : Janice describes herself as confident and trusting, and she displays both high self-esteem and high self-efficacy. The concept most consistent with a contemporary definition of wellness is

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Question about java hashtables

Prompt the user for a string, and display the corresponding number. For example, if the user types "five", the program would output "5". This must be done using the hashtable as created in the previous step.

  Creating a class for services

Make a class for services offered by a hair styling salon. Information fields with a String to hold the service description, a double to hold the price, and an integer to hold average number of minutes it takes to perform the service.

  Preparing a java program

Prepare a program that asks the user how many automobiles are to be explained, and for each automobile it inputs the user's selection of make and color.

  Decision tree to help someone

Create a decision tree to help someone determine what meal to buy at a fast food restaurant. The structure of your tree should be similar to the one on page 699.

  Clerical office placement setting

Determine what other databases would be known to benefit a clerical or job placement organization using databases?

  Explaining effective customer relationships and loyalty

Paws'n Tails is an online pet shop that wants to influence what customers buy and builkd effective customer relationships and loyalty.

  Steps of asymmetric encryption algorithms to read message

Using only asymmetric encryption algorithms write down any steps taken by Bob which permit him to read the message.

  Create divide and conquer algorithm to solve problem

Create a divide and conquer algorithm to solve problem. The time complexity of your algorithm must be O(nlgn) or better.

  Java program to make choice for a coffee cup size

Create an application that prompts the user to make a choice for a Coffee cup size, S for Small, T for Tall, G for Grande and V for Venti the rates of cup sizes will be stored in a parallel double array as $2, $2.50, $3.25, and $4.50 respectively.

  Using command line options in bash shell script

Design a script that will permit the user to enter one of several choices from the command line. The specific requirements are as follows:

  Algorithm for locating nth successor in circlar linked list

Write algorithm or code segment for locating nth successor of an item in circlar linked list (the nth item that follows the given item in the list).

  Writing a c program

Create a C program that has a declaration in main() to store the following numbers into an array named channels: 2, 4, 5, 7, 9, 11, 13. There should be a function call to display().

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