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

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

Discussion questionsdatabase programs are used to store and

Discussion Questions Database programs are used to store and to retain data for a variety of applications, and are often used in conjunction with Web content to deliver dynamic Web pages. Please respond to all of the fol ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this a ...

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

Assignmentyou are to design a program that will serve as a

Assignment You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its gen ...

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

  • 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