2023 NEED THIS WITHIN 24 HOURS SQL screentshots will be needed Scenario and Summary You have been | Assignment Collections
Computer Science 2023 computer data analysis
2023 NEED THIS WITHIN 24 HOURS SQL screentshots will be needed Scenario and Summary You have been | Assignment Collections
NEED THIS WITHIN 24 HOURS
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.
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.