Posted: September 16th, 2017

Business Intelligence

Business Intelligence

Using Lab 3, provide copies of your screen shots and answer the provide a write-up for each Section listed below.
Each interpretation must be a minimum of one paragraph (3 to 5 well formed sentences) with no spelling or grammatical errors. Your interpretation should address the

following:
•    What do the results tell us?
•    How could decision makers use the results to improve business performance?
•    Based on these results, what other data would you recommend that should be considered for further analysis?

Part A:  Create a query to determine cost data for manufacturing a product
a.    Paste your screen shot of your SQL query code and the results of running your query here
b.    Write your answer to interpreting the query results here

Part B:  Develop a query to analyze average, minimum and maximum costs for each product
a.    Paste your screen shot of your SQL query code and the results of running your query here
b.    Write your answer to interpreting the query results here

Part C:  Determine average sales amount for each salesperson (10 points).
a.    Paste your screen shot of your SQL query code and the results of running your query here
b.    Write your answer to interpreting the query results here

Part D:  Determine average cost based upon number of days to manufacture a product
a.    Paste your screen shot of your SQL query code and the results of running your query here
b.    Write your answer to interpreting the query results here

Part E:  Analyze the number of purchase orders placed by each vendor
a.    Paste your screen shot of your SQL query code and the results of running your query here
b.    Write your answer to interpreting the query results here

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat+1-631-333-0101EmailWhatsApp