Lab 4 Student Answer Sheet  complete solutions correct answers key

Find the solution at

DeVry University

Student Lab Activity

BIS 445 Business Intelligence and Data Analysis with Lab

Student Name:                                                                                                      

Using Lab 4, answer the questions and provide copies of your SQL Statements and results for each Section listed below      

Step 1:

a.    Print Screen of the SQL Statement

b.    Print Screen of SQL Results

Step 2:

a.    Print Screen of the SQL Statement

b.    Print Screen of SQL Results

Step 4:

a.    Print Screen of the SQL Statement

b.    Print Screen of Report Results

Answer the following:

·         Do item C sales increase from 2005-4 to 2006-1 for state of Illinois?

·         Does item T sales increase from 2005-4 to 2006-1 for state of Illinois?

·         Does the total sales of state of Illinois increase from 2005-4 to 2006-1?

·         Do item C sales increase from 2006-1 to 2006-2 for state of Illinois?

·         Does item T sales increase from 2006-1 to 2006-2 for state of Illinois?

·         Does the total sales of state of Illinois increase from 2006-1 to 2006-2?

·         Do you find that overall, almost all of the states if the 2006-2 sale exists, that 2006 second quarter sales are much lower than regular?

a.    Why from your observation?

·         Can we make a conclusion by saying that the item type T sales are better than item Type C?

·         Can we make a conclusion by saying that 2005 last quarter sales are better than 2006 first quarter?