User Account

All Pages

Prepare a report of your data warehouse design

Assignment Help Other Subject
Reference no: EM132365089

Assignment - Data Warehousing and Mining

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?

Verified Expert

The analysis of the online brokerage system is done in this task.The datawarehouse design of the system is made to get insights of the system. The olap queries are specified.

Reference no: EM132365089

Questions Cloud

Presents strategy for communicating new social media : Prepare one page briefing statement for company's CISO that presents strategy for communicating new "social media" policy to field office employees-and managers
Create a competitor analysis grid : Create a competitor analysis grid that includes company information, product/service information, customer information, and sources of competitive advantage
Assessment of the IT policy system : CSIA 413-Prepare one page briefing statement for IT Governance board of Red Clay Renovations which explains the purpose of the audit
Dod cybersecurity culture and compliance initiative : Choose one of policy implementation documents from this week's readings DHS Risk Management Fundamentals OR DoD Cybersecurity Culture and Compliance Initiative.
Prepare a report of your data warehouse design : NIT6160 - Data Warehousing and Mining - Victoria University - Prepare a report of your data warehouse design and demonstrate your design to your tutor
Five or more risks which require financial investment : Use the company profile and enterprise architecture diagrams to identify five or more risks which require a financial investment.
About the future of collaboration systems : BBA 3551-After reading about the future of collaboration systems, how do you envision collaboration in your industry in the year 2027?
Do bit of research on the methodologies : Using the Web or other resources, do a bit of research on the methodologies that Microsoft Windows firewall uses.
Develop business continuity plan for your organization : Develop a business continuity plan for your organization. Describe the basic activities that must be managed by the BCP.

Reviews

len2365089

9/3/2019 1:35:54 AM

Submission Instructions This section is intended for submission instructions in learning systems. Grading Report Section Max. points Theoretical discussion and data warehouse design 10% OLAP Queries 10% Total 20%

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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