Ask Question, Ask an Expert

+1-415-315-9853

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

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

Listed the five important software components of a dbms the

Listed the five important software components of a DBMS: the DBMS engine, the data definition, data manipulation, application generation, and data administration subsystems. Which of those are most and least important to ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Data analysis projectyou have contracted with a local

Data Analysis Project You have contracted with a local school district to help them decide whether to use an interactive computer program or a standard chapter from a textbook to teach students to use fractions. The scho ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Movie theater database entity-relationship modeldevelop a

Movie Theater Database: Entity-Relationship Model Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. You ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro