BIS 345 Matrix Reports

Lab 7 of 7: Creating Matrix Reports

You have been requested to create two reports using the AdventureWorks database.

Report 1:

Create a matrix report showing territory sales totals by year and quarter. 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. You should answer the following question 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

·grouping on correct fields

·group totals

·interpretation

Report 2:

Create a matrix report showing total sales amounts and the total quantity ordered by category and subcategory per year and month. 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. You should answer the following question 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

·totals

·drilldown

·interpretation

Upon completing this lab, you will be able to

1.create a matrix (pivot table) report;

2.identify appropriate data to be used for row and column headings;

3.include suitable aggregate functions;

4.add multiple grouping levels;

5.use date fields to allow groupings on week, month, quarter, and year aggregates; and

6.modify the chart to change chart colors and add text and arrows.

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

Following along with an instruction file, you will document your completion of the following tasks:

Connect to the iLab here.

1.DownloadGuide_to_SQL_Server_Management_Studio_2008.docxfrom Doc Sharing.

2.DownloadBIS345_Lab7_Questions.docxfrom DocSharing and save a copy using the naming structureLastName_FirstName_Lab7_Questions.docx. You will answer the questions and provide screen prints as required for each part of the lab.

3.To login to the Citrix remote lab, follow the instructions located in the iLab item under Course Home.

4.Follow the steps inGuide_to_SQL_Server_Management_Studio_2008.docxto

ostart SQL Server Management Studio;

ocreate a new project;

oadd a query file; and

oget the required output.

Complete the steps for this lab as directed inBIS345_W7_iLab_instructions.docx.

Submit your completedLastName_FirstName_Lab7_Questions.docxto the Week 7 iLab Dropbox.

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions.