COMP 30014 Data Warehousing Assignment

Reference no: EM132719793

COMP 30014 Data Warehousing - Middle East College

Learning Outcome 1: Use appropriate tools for the operation and management of a data warehouse environment.
Learning Outcome 2: Understanding and applying the data mining principles in a data warehouse.

Assignment Objective
The main objective of this assignment is to make student develop a clear understanding of the above learning outcomes.

Assignment Tasks

Task 1

Submit a work proposal for this assignment or before 23:59 Hrs on 02/12/2020 which must include:
• General overview of initial understanding of solutions to all the tasks
• What you will do with the given tasks and the dates by when they will be completed (timelines)
• Identification of Literature Resources
The work proposal must be submitted in a word file through the link available in Moodle.

Task 2

Scenario and Deliverables: Implementing a Data Integration Solution for the selected organization in assignment 1.

Investigate and devise a data integration solution in order to generate a certain management report. Analyze and make suitable assumptions for the transaction database (OLTP) in the selected organization which holds several tables. Choose two of these in order to consolidate data into the desired management report. Populate these tables by assuming/generating the necessary data in high orders (preferably thousands of rows). Each table must have at least 10 columns each and comprise of data types composed of integer, date, varchar2, etc. Create and use a new OLAP database instead. You are required to design and develop a data warehousing solution to integrate data from OLTP system so as to generate the desired management report.

Task 3

Perform the following steps given below and produce a comprehensive report in your own words about how you achieved the desired solution (do not include all the screenshots, but only the final ones in each step; also briefly explain in your own words all the major steps involved):

• Name the Project; Establish Database Connections - Create Source/Target Location.
• Design the Target Schema
• Design the necessary Extraction, Transformation, Loading (ETL) Logic. Deploy the Design and Execute the scenario you have chosen.

Task 4: Read the research article on" A Comparative Study of Data Mining Classification Techniques using Lung Cancer Data". Critically discuss five popular classifiers considering their qualitative performance for the experiment.

Task 5: MOOC Course. Select any mooc course related to data warehouse or data mining and provide certificate or course completion details with reflective summary.

Attachment:- Data Warehousing.rar

Reference no: EM132719793

Questions Cloud

How do construct the journal entry to record the payment : How do Prepare the journal entry to record the payment. Prepare the journal entry to allocate the gain or loss on realization to the partners' Capital accounts.

What role did interest rates play : What role did interest rates play in the changes in the exchange rate?

Prepare the statement of financial position of the new firm : Prepare the statement of financial position of the new firm as at 1 July 2003, after all of the above arrangements have been completed.

Prepare the journal entries to record retirement of williams : Prepare the journal entries to record the retirement of Williams under Williams sells one-third of his interest to Weston for $37 500 and two-thirds to Ward

COMP 30014 Data Warehousing Assignment : COMP 30014 Data Warehousing Assignment Help and Solution, Middle East College - Assessment Writing Service - tools for the operation and management

Prepare the journal entry to record cain admission : Prepare the journal entry to record Cain's admission to the partnership under each of the Cain pays Eve $15 000 for 50% of her interest.

Implement byselling the forward : A US firm will sell its pharmaceutical products in Britain the next year, but the exact amount of the revenues is uncertain as it will depend on the trade deal

What is contribution margin ratio for kathy lentz company : Suppose Kathy Lentz Company sells hand tatted lace for $25 per yard. Her materials cost $4 per yard. What is contribution margin ratio?

Estimate and record anticipated uncollectible accounts : Why does a company have to estimate and record anticipated uncollectible accounts? Can't we just record the revenues earned when the cash comes in?

User Account

All Pages