BIS 345 Matrix Reports
BIS 345 Matrix Reports
ORDER NOW FOR THE ORIGINAL PAPER: BIS 345 Matrix Reports
BIS 345 Matrix Reports
Lab 7 of 7: Creating Matrix Reports
iLab Overview
Scenario/Summary
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.
Deliverables
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:
Section | Deliverable | Points |
Part A | Territory Sales Dataset | 5 |
Part B | Territory Sales Report | 10 |
Part C | Territory Sales Report Interpretation | 7 |
Part D | Category Sales Dataset | 5 |
Part E | Category Sales Report | 10 |
Part F | Category Sales Report Interpretation | 8 |
Total Points | 45 |
Remember This!
Connect to the iLab here.
Lab Steps
Preparation
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.
Steps
Complete the steps for this lab as directed inBIS345_W7_iLab_instructions.docx.
Submit your work
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.
Use the following coupon code :
TOPCLASS