Create matrix report showing territory sales totals by year

Assignment Help Database Management System

Reference no: EM13810768

Assignment- Creating matrix reports

Overview

Using the AdventureWorks database, you have been requested to create two matrix style reports. The AdventureWorks database contains many tables; we will be using only some of those tables in this course. Below is an ER diagram showing the tables in the AdventureWorks database that we will be using. NOTE: Not all the relationship lines are drawn between the tables in this diagram. To find relationships between tables, you may have to look for matching field names:

Use the Citrix Server to start SQL Server Business Intelligence Development Studio and create a new Report Server project.

Part 1: Territory Sales Totals by Year and Quarter Report

Create a matrix report showing territory sales totals by year and quarter. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (3 to 5 well-formed sentences) with no spelling or grammatical errors. Based on these results, what other data would you recommend considering for further analysis?

Part 2 Sales by Category and Year Report

Create a matrix report showing total sales amounts and the total quantity ordered for each category and subcategory per year and month. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (3 to 5 well-formed sentences) with no spelling or grammatical errors. Based on these results, what other data would you recommend considerimg for further analysis?

Reference no: EM13810768

Questions Cloud

Ethical issues related to reproduction : Ethical Issues Related to Reproduction

Potential ethical issues that could be associated : Identify potential risks associated with financials, leadership/governance, and workforce. Consider if there are potential ethical issues that could be associated with risks

Build a dynamic and functional model : Write 2 to 3 page paper that explains the difference in steps used to build a dynamic and functional model as each relates to object-oriented modeling

Anthropology paper about south east asia : Anthropology Paper About South East Asia

Create matrix report showing territory sales totals by year : Create a matrix report showing territory sales totals by year and quarter. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (3 to 5 well-formed sentences) with no spelling or grammatical errors. Based..

What methods could you use to resolve the conflict : What methods could you use to resolve the conflict

Assess how the different approaches to contract financing : Assess how the different approaches to contract financing can impact the company. Determine which contract financing approach will best suit the organizational needs. Ascertain what policies the organization will need due to presence of The Defense C..

Analyze at least three challenges of succession planning : Analyze at least three challenges of succession planning for your selected agency. Propose at least three components of effective implementation of succession planning.

Website design and development : Website Design and Development - List at least three interactive features that could be added to your site and what purpose each would serve for your site and its visitors. The form created in Part Two of this assignment can be included as one of ..

User Account

All Pages