Find the total number of calls made by each customer

Reference no: EM13135543

Suppose that a data warehouse consists of the three dimensions time, customer, and cell phone plan, and the two measures number of calls and cell phone bill

a) Draw a schema diagram for the above data warehouse using the star schema.

b) Starting with the base cuboid [month, customer, plan], what specific OLAP operations should be performed in order to

i. Find the total no of calls made by each customer in 2009.
ii. Find the total no of calls made by all the customers in each plan every year.
iii. Find the monthly bill for each customer

Reference no: EM13135543

Questions Cloud

Cross boarder alliances in business enviroment : This solution provides the learner with an understanding of the concept of a cross border alliance in the business environment.

What was alliance''s receivables turnover ratio : Sales and cash collections from customers for the year were $780,000 and $700,000, respectively. Cost of goods sold for the year was $450,000. What was Alliance's receivables turnover ratio (rounded) for 2011?

What is your break-even sales number : Your company has been in business as a supplier or electricity for over 50 years. You have always made a profit. Your current sales, for the past 3 years, have been 10 Million dollars and your variable costs run at 70% of sales, or 7 Million. Your..

Calculate the amount of heat liberated : Calculate the amount of heat liberated (in kJ) from 399 g of mercury when it cools from 73.0°C to 12.0°C.

Find the total number of calls made by each customer : Starting with the base cuboid [month, customer, plan], what specific OLAP operations should be performed in order toi. Find the total no of calls made by each customer in 2009.

Avon in international environment : This solution provides an evaluation of Avon's operations in global markets discussing Avon's use of international cadre development and building company associates along with independent representatives.

Prepare the appropriate journal entries : The overhaul was completed on January 7, 2011 at a cost of $28,000. Because of a slowdown in the economy, the truck only operated for 21,000 km for the remainder of 2011. Instructions Prepare the appropriate journal entries for 2011 relating to t..

What is the specific heat capacity of the alloy : A 33.0-g sample of an alloy at 93.0°C is placed into 258 g of water at 22.0°C in an insulated coffee cup. Assume that no heat is absorbed by the cup. If the final temperature of the system is 31.1°C

International managment teams : This solution provides the learner with a discussion of the role of international management teams relative to the level of a company's goal involvement.

User Account

All Pages