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.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]