Data Analysis

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

Report 1:

A report has been requested that will show a full list of products in each subcategory and category. Provide the ability to use drill down on both the category and
subcategory. Also provide a count of the number of products in each subcategory. The report will be graded based on the following:

Appropriate fields
Report layout
Grouping on correct fields
Group totals
Report 2:

Produce a report that shows the total sales for each territory. Allow the user to drill down through the territory to see the total sales amounts for individual
categories. The report will be graded based on the following:

Appropriate fields
Report layout
Drill down
Interpretation
Upon completing this lab, you will be able to

create report groups,
use formulas and aggregate functions to produce report totals,
use formulas and aggregate functions to generate group totals,
incorporate drill down features, and
specify paging information – placing page breaks, page numbers, and so forth.
FOR YOUR ASSIGNMENTS TO BE DONE AT A CHEAPER PRICE PLACE THIS ORDER OR A SIMILAR ORDER WITH US NOW