NIT6160 : Data Warehousing and Mining

UK Assignment Help

NIT6160 : Data Warehousing and Mining


NIT6160 : Data Warehousing and Mining

Assignment 1

This assignment 1 is worth 20% of the total assessment of this unit and is due by Friday week 7 5 PM.

In this assignment, we are building a data warehouse for an online brokerage company. The company makes money by charging commissions when customers buy and sell stocks. We are planning to have a Trades fact table with the grain of one row per stock trade. We will use the following dimensions: Date, Customer, Account, Security (i.e. which stock was traded), and TradeType. 
The company’s data analysts have told us that they have developed two customer scoring techniques that are used extensively in their analyses. 
Each customer is placed into one of nine Customer Activity Segments based on their frequency of transactions, average transaction size, and regency of transactions. 
Each customer is assigned a Customer Profitability Score based on the profit earned as a result of that customer’s trades. The score can be either 1, 2, 3, 4 or 5, with 5 being the most profitable. 
These two scores are frequently used as filters or grouping attributes in queries. For example: 
How many trades were placed in July by customers in each customer activity segment? 
What was the total commission earned in each quarter of 2003 on trades of IBM stock by customers with a profitability score of 4 or 5? There is a total of 100,000 customers, and scores are recalculated every three months. The activity level or profitability level of some customers’ changes over time, and users are very interested in understanding how and why this occurs. 
Task 1: Data Warehouse Design
Design a data warehouse for the above mention scenario. Implement your data warehouse with SQL Developer. 
Prepare a report of your data warehouse design and demonstrate your design to your tutor.
Task 2: OLAP Queries
Based on your design, write down the queries for the following problem:
How many trades were placed in July by customer “John Alan”?
What was the total commission earned in each quarter of 2003 on trades of IBM stock by customers with a profitability score of 4 or 5?
Submission Instructions
This section is intended for submission instructions in learning systems. 
marketing assignment, marketing management assignment, marketing management assignment help, digital marketing assignment help, marketing assignment help online, marketing homework help, marketing assignment writing, online marketing assignment help, strategic marketing assignment help, online marketing assignment, marketing assignment writing service, international marketing assignment help, marketing mix assignment help, marketing homework assignment


Submit Works

Drop File To Upload Or
Assignment Help Australia

Our Top Experts

Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders