Data Analysis

Data Analysis
Scenario and Summary
You have been requested to create two reports using the AdventureWorks database.

Report 1:

Products go through cost adjustments; each change in cost is detailed in the ProductCostHistory table. You have been asked to produce a report detailing these product cost changes along with the start date of each change. Rather than display the full list of products, the user will select the category and subcategory of products to display. This report uses parameters. The report will be graded based on the following:

appropriate fields
report layout
grouping on correct fields
group totals
Report 2:

Create a chart that compares total product sales for each category in the years 2002 and 2003. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (three to five well formed sentences) with no spelling or grammatical errors. Is the chart based on adequate data? Is there something lacking? Can you make meaningful deductions? Based on these results, what other data would you recommend that should be considered for further analysis? The report will be graded based on the following:

appropriate fields
report layout
drilldown
interpretation
Upon completing this lab, you will be able to

use parameters in reports;
identify the most appropriate chart format in which to present the data and create the chart; and
modify the chart to change chart colors and add text and arrows.

FOR YOUR ASSIGNMENTS TO BE DONE AT A CHEAPER PRICE PLACE THIS ORDER OR A SIMILAR ORDER WITH US NOW