{"id":203158,"date":"2018-09-13T23:21:16","date_gmt":"2018-09-13T23:21:16","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-445-week-3-ilab\/"},"modified":"2018-10-24T08:54:05","modified_gmt":"2018-10-24T08:54:05","slug":"bis-445-week-3-ilab","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-445-week-3-ilab\/","title":{"rendered":"BIS 445 Week 3 iLab"},"content":{"rendered":"<p>Using Lab 3, provide copies of your screen shots and answer the provide a write-up for each Section listed below.\tEach 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:\t\u00b7What do the results tell us?\t\u00b7How could decision makers use the results to improve business performance?\t\u00b7Based on these results, what other data would you recommend that should be considered for further analysis?\t\u00a0\tPart A\u00a0: Use import wizard to import comma delimited file into a SQL 2008 table\tPart B\u00a0: Develop a query to analyze average, minimum and maximum costs for each product\ta.Paste your screen shot of your SQL query code and the results of running your query here\tPart C:\u00a0Determine average sales amount for each salesperson(10 points).\ta.Paste your screen shot of your SQL query code and the results of running your query here\tPart D:\u00a0Determine average cost based upon number of days to manufacture a product\ta.Paste your screen shot of your SQL query code and the results of running your query here\tPart E:\u00a0Analyze the number of purchase orders placed by each vendor\ta.Paste your screen shot of your SQL query code and the results of running your query here<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-445-week-3-ilab\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-203158","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=203158"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203158\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}