What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: BIS 445 DeVry Week 3 I Lab
Select a size
BIS 445 DeVry Week 3 I Lab
Downloading is very simple, you can download this Course here: http://wiseamerican.us/product/bis-445-devry-week-3-ilab/
Contact us at: SUPPORT@WISEAMERICAN.US
Using Enterprise Data to Create Pivot Tables
Note! Submit your assignment to the Dropbox located on the silver tab at the top of this page. (See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)
Remember This! Connect
Downloading is very simple, you can download this Course here:
Contact us at:
Remember This! Connect to the I Lab here.
I LAB OVERVIEW
Scenario and Summary
You are working as a data analyst for a large manufacturing firm. You have been asked to develop a series of pivot table queries, which will present aggregated views of corporate data that can be used for decision support and trend analysis by decision-makers.
Using SQL, you can create aggregated views of your data. Pivot tables are especially useful if you are analyzing large volumes of data. For example, if you wanted to determine the average value of sales for each sales person in your database, you could use a pivot table to aggregate thousands or millions of sales records. This is much faster than attempting to scroll through all of the available records.
You will log into our Citrix Server, access SQL Server, and the BIS445_AdventureWorks database, and then develop five pivot tables.
Submit the YourName_Lab3_Questions.docx to the Week 3 I Lab Dropbox.
Create a query to determine cost data for manufacturing a product.
Develop a query to analyze average, minimum, and maximum costs for each product.
Determine average sales amount for each salesperson.
Determine average cost based upon a number of days to manufacture a product.
Analyze the number of purchase orders placed by each vendor.
I LAB STEPS
Back to Top
Download the Week3_Lab3_Questions.docx from Doc Sharing. You will answer the questions and provide screen prints as required for each part of the lab.