Create data warehouse solution in sql

Assignment Help Data Structure & Algorithms

Reference no: EM132491636

Question 1: CEO of Entertainment Inc. wants to keep track of performance of engagement that each customer and agent have engaged. For each customer and agent, he wants to know total contract length by year, and contract success ratio (calculated by total number of contracts expired each year divided by total amount of contract price each year). In addition, for each customer and agent he wants to know total numbers of contracts expired each week, and total number of contracts still active each week. Provide 4-step dimensional model in the SQL comment section and create data warehouse solution in SQL for the dimensional model that you propose.

Question 2: CEO of Entertainment Inc. wants to keep track of the life cycle of engagement contract. Particularly, he wants to know the total number of agents involved for each engagement contract phrase when the contract is authorized, engaged, monitored and closeout. Provide 4-step dimensional model in the SQL comment section and create data warehouse solution in SQL for the dimensional model that you propose.

Reference no: EM132491636

Questions Cloud

Compute the? bond yield to maturity-fingen : Fingen's 18?-year, ?$1,000 par value bonds pay 12 percent interest annually. The market price of the bonds is ?$910 and the? market's required yield to maturity

Determine annual gross income using the chart provided : Establish your spending categories. Remember, this is your money, so if donations to the Home for Retired Professors is a priority, be sure to include it.

Projected eps after completion of the project : Projected earnings after completion of the project are $2 million and shares outstanding are 200,000. What is the projected EPS after completion of the project?

What is the price of the? bonds of doisneau : Doisneau 25?-year bonds have an annual coupon interest of 9 ?percent, make interest payments on a semiannual? basis, and have a ?$1,000 par value.

Create data warehouse solution in sql : Provide 4-step dimensional model in the SQL comment section and create data warehouse solution in SQL for the dimensional model that you propose

What is the? bond yield to? maturity : The market price is ?$875 for a 12?-year bond ?($1,000 par? value) that pays 12 percent annual? interest, but makes interest payments on a semiannual basis

GEN303 Sociology Assignment Problem : GEN303 Sociology Assignment Help and Solution - Emirates College of Technology, UAE. What are the most important cultural elements of your own social group

What are the drawbacks of patagonia culture : What do you think are the key dimensions of culture that make Patagonia successful? How does the organization help to foster this culture?

Determine enhancing our use of excel : Identify and discuss at least three (3) tools an accountant can use to make the recording and reporting of accounting transactions efficient and effective.

User Account

All Pages