Custom-Written, AI & Plagiarism-Free with Passing "Guaranteed"

This assignment is intent to measure student ability to design and implement a data warehouse to support decision making.

Assignment 2

This assignment is intent to measure student ability to design and implement a data warehouse to support decision making. Students are given a choice to develop a data warehouse solution to support decision making of certain goals. Students can use Oracle Warehouse Builder (OWB) or any other tool to design and implement data warehouse. This project will be 80 points for the report and 20 points for the presentation.

The report should consist of the following sections:

  1. Introduction (5 points)
    1. Background information about the company and/or the industry related to the project 

    2. Motivation of the project 

  2. Project Objectives (5 points)
    1. Define the objectives of the project? What is/are the problem(s) that the project seeks 
to solve? 

    2. How can DW play a role in achieving these objectives? 

  3. Data Sources utilized (5 points) 


a. What are databases or datasets used in the project
4. Extraction, transformation and loading processes (15 points)

a. How did the data get retrieved? integrated? cleaned? transform? loaded?

  1. Data warehouse design (15 points)
    1. Provide the design approach for the DW? 

    2. Provide DW schema 

  2. DW Implementation steps (15 points)
    1. What is the software used to implement the DW? 

    2. Steps undertaken to implement the DW 

  3. Developing OLAP cubes, front-end application, and reports to support decision 
making (15 points)
    1. Creating OLAP cubes 

    2. Visualizing of the information of the DW 

    3. Answering the questions that support decision making 


8. Conclusion (5 points)

  1. Summary of the project 

  2. What are the lessons learned from the project? 

  3. What kind of issues have you encountered during the project? And have you encountered them? 


100% Plagiarism Free & Custom Written,
tailored to your instructions
paypal checkout

Assignment Experts UK delivers 100% original, custom-written work. We don't use paraphrasing tools, AI content generators like ChatGPT, or any writing software. All content is self-written by our expert writers and guaranteed plagiarism-free.

Discover more


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guaranteed

STILL NOT CONVINCED?

Check out samples from our Academic Writing Service, created by our writers to showcase the high-quality work you can expect!

View Our Samples

We're Open