Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Adventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are mainly based, is a big, multinational manufacturing company. The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. While its base operation is positioned in Bothell, Washington with 290 employees, several regional sales teams are located all through their market base.

Task:

You are needed to design a dimensional model for analyzing Purchases for Adventure Works Cycles and implement it as cubes by using SQL Server Analysis Services. The AdventureWorks OLTP sample database is a data source for you BI analysis. Description of the AdventureWorks databases is accessible at:

http://msdn.microsoft.com/en-us/library/ms124825(v=sql.100)

Part A: Business requirements

Discuss the background and objectives of your BI project. Clearly describe the subject areas for your analysis and the data source tables in the OLTP system.

Part B: Key facts

Describe the key facts to accomplish the objectives of your analysis. You should comprise at least two key facts relating to purchases. Elaborate on the granularity for the facts.

Part C: Dimensions

describe the dimensions for analyzing the key facts as laid out in Part B. Especially you should discuss:

• The hierarchy for each dimension

• Discuss if there are any conformed dimensions, and then describe the reasons why there are or are not conformed dimensions.

Part D: Multidimensional Schema

You should present your complete design of multidimensional database design as a Star schema or Snowflake schema

Part E: Implementation

Document your implementation of multidimensional cubes by using SQL Server Analysis services. You should load your data cubes with source data tables in the AdventureWorks OLTP database, as identified in part A. Your implementation must comprise precisely the dimensions and facts as describeed in Parts A to D. Your documentation must comprise screenshots from SQL Server Analysis Services.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M996

Have any Question? 


Related Questions in DBMS

Question 1 unified communications system eg email

Question: 1. Unified Communications System (e.g., email, conferencing, and messaging) - The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment a ...

Question team project submission - submit to the unit 4

Question: Team Project Submission - Submit to the Unit 4 Group Project Area This version of the capstone project assignment is FOR GRADING this week. Submit to the group area the document containing completed Sections On ...

Sqlwrite a select statement that returns one column from

SQL Write a SELECT statement that returns one column from the Vendor table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Format it as follows: last name, comma, first nam ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Question as explained throughout this course entity

Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...

Question lab 1 creating a database designthis assignment

Question: Lab 1: Creating a Database Design This assignment contains two (2) Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Not ...

Assignment -scenario setup a mock phase 3 clinical trial

Assignment - Scenario: Setup a Mock Phase 3 Clinical Trial for evaluating the efficacy of a Blood Pressure/Weight Loss/ or Muscle Strength Enhancement supplement. Assume that the testing takes place at a physician's offi ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As