{"id":2011,"date":"2016-09-29T18:19:29","date_gmt":"2016-09-29T22:19:29","guid":{"rendered":"http:\/\/ibit.temple.edu\/analytics\/?p=2011"},"modified":"2020-10-27T12:05:39","modified_gmt":"2020-10-27T16:05:39","slug":"can-small-independent-pharmacies-compete-with-the-big-chains","status":"publish","type":"post","link":"https:\/\/ibit.temple.edu\/analytics\/can-small-independent-pharmacies-compete-with-the-big-chains\/","title":{"rendered":"Does speed matter in E-commerce?"},"content":{"rendered":"<p><a href=\"https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2347 aligncenter\" src=\"https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh-276x300.png\" alt=\"\" width=\"184\" height=\"200\" srcset=\"https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh-276x300.png 276w, https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh-768x835.png 768w, https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh-942x1024.png 942w, https:\/\/ibit.temple.edu\/analytics\/files\/2017\/09\/QVCHigh.png 1200w\" sizes=\"auto, (max-width: 184px) 100vw, 184px\" \/><\/a><\/p>\n<p>QVC provides its customers with a variety of product offerings around the globe. The largest market for QVC is currently the US.\u00a0 In the US alone, QVC ships millions of packages each year to enrich its customers\u2019 lives.\u00a0 The future of fulfilling customer orders and meeting or exceeding their expectations is always at the forefront of QVC\u2019s decisions.\u00a0 One expectation is related to delivery speed.\u00a0 Some retailers, primarily online retailers, focus primarily on quick turnaround on shipping goods to customers.\u00a0 The faster the turnaround the more extensive the logistics\/delivery network or the more costly it is.\u00a0 QVC doesn\u2019t just provide its customers with products, it prides itself on top notch customer service and a rich and rewarding overall experience.<\/p>\n<p>Your challenge is to analyze QVC\u2019s customer geography, distribution network, and product mix, purchase patterns and develop a visualization that contains useful information for QVC to use to understand what the relationship between speed of product\/package delivery and customer loyalty is.<\/p>\n<p>Your analysis should address one or more of the following questions:<\/p>\n<ul>\n<li>Does the current distribution network maximize customer penetration (spend)?\u00a0 If not, what should QVC do to increase customer penetration with the current distribution network?<\/li>\n<li>Are there specific products or product categories that should be located in specific distribution centers?<\/li>\n<li>Do customers that receive their product sooner purchase more than customers with longer delivery times?<\/li>\n<\/ul>\n<h3><span style=\"text-decoration: underline\"><strong>Data:<\/strong><\/span><\/h3>\n<p><span style=\"text-decoration: underline\"><strong>Click here for QVC Data<\/strong><\/span><\/p>\n<p>This data is extracted and anonymized from QVC.<\/p>\n<p>There are two options for using the data.\u00a0 Those with experience and the technology needed to work with a large data set should choose option 2 below.\u00a0 Those that are working just in excel should chose option 1 below.<\/p>\n<ol>\n<li>A sample population was pulled from the larger data set and placed into the excel spreadsheet named &#8220;Smaller Sample set of QVC data&#8221;.\u00a0<\/li>\n<li>The large data set was broken up into six excel spreadsheets (named QVC data 1, 2, 3, etc) with less than 1 million rows each.\u00a0 You may combine these spreadsheets and do your analysis on the larger set if you have the technology needed to do so.\u00a0\u00a0<\/li>\n<\/ol>\n<p>There are also excel spreadsheet with the following information in them which applies to option 1 and 2 above:<\/p>\n<ul>\n<li>distribution center data<\/li>\n<li>order type data<\/li>\n<li>data dictionary<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>QVC provides its customers with a variety of product offerings around the globe. The largest market for QVC is currently the US.\u00a0 In the US alone, QVC ships millions of packages each year to enrich its customers\u2019 lives.\u00a0 The future of fulfilling customer orders and meeting or exceeding their expectations is always at the forefront [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[33,34],"tags":[],"class_list":{"0":"post-2011","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-33","7":"category-challenge-2017","8":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ROyF-wr","_links":{"self":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/2011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/comments?post=2011"}],"version-history":[{"count":27,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/2011\/revisions"}],"predecessor-version":[{"id":4575,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/2011\/revisions\/4575"}],"wp:attachment":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/media?parent=2011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/categories?post=2011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/tags?post=2011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}