Scenario and Summary.

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

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

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.