Ask Question, Ask an Expert


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.


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:

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

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 ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Football association of zambia faz super leaguethe faz has

Football Association of Zambia (FAZ) Super League The FAZ has recently decided to reorganise their operations to support both existing and possibly expanded league operations in Zambia and part of preparation for the 201 ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Analytic reportpurpose the purpose of this task is to

Analytic Report: Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given ...

Database design amp development assignment -assignment

Database Design & Development Assignment - Assignment title - Design and Implement a Relational Database for a local Print and Ink Refill Business. Learning Outcome - Use an appropriate design tool to design a relational ...

  • 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