BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Page 28

www.bis345mentor.com
a.
a.
a.
a.
Using Lab 5, provide copies of your SQL Statements, results and reports
for each Section listed below
Part AProduct and Category dataset (7 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part B: Product and Category report (10 points)
Paste your report here:
Part C: Sales and Territory dataset (10 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part D: Sales and Territory, report (10 points)
Paste your report here:
Part E: Sales and Territory Report Interpretation (10 points)
Write your interpretation of the results. The interpretation must be a
minimum of one paragraph (3 to 5 well-formed sentences) with no
spelling or grammatical errors. Based on these results, what other data
would you recommend that the business consider for further analysis?
==================================================
BIS 345 Week 6 iLab
FOR MORE CLASSES VISIT
www.bis345mentor.com
a.
b.
1.
2.
a.
a.
b.
a.
Lab 6 Student Answer Sheet
Part A:Product Cost History dataset (7 points)
Paste your SQL Statement here
Screen print your results and paste here:
CategoryList screenshot:
ProductList Screenshot
Part B: Product Cost History report (10 points)
Paste your report here:
Report 1 – Screenshot:
Part C: Yearly Sales by Category Dataset (10 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part D: Yearly Sales by Category Chart (10 points)
Paste your report here:
Part E: Yearly Sales by Category Interpretation (10 points)