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

Required(*) Message

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

User Account

All Pages