{"id":10418,"date":"2017-03-01T02:01:41","date_gmt":"2017-03-01T02:01:41","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/masterybusiness2xngcxmasterspring2016\/?post_type=chapter&#038;p=10418"},"modified":"2017-07-18T22:02:58","modified_gmt":"2017-07-18T22:02:58","slug":"mining-warehousing-and-sharing-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/chapter\/mining-warehousing-and-sharing-data\/","title":{"raw":"Mining, Warehousing, and Sharing Data","rendered":"Mining, Warehousing, and Sharing Data"},"content":{"raw":"<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/143\/2017\/03\/01172731\/10946801506_c924c39b76_k.jpg\"><img class=\"wp-image-10421 aligncenter\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/143\/2017\/03\/01172731\/10946801506_c924c39b76_k-300x192.jpg\" alt=\"Photo of many multicolored candles.\" width=\"600\" height=\"384\" \/><\/a>\r\n<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Differentiate between data and information<\/li>\r\n \t<li>Explain\u00a0how data mining is used by operations<\/li>\r\n \t<li>Explain\u00a0how data warehousing is used by operations<\/li>\r\n \t<li>Explain\u00a0how organizations support operations by sharing data<\/li>\r\n<\/ul>\r\n<\/div>\r\nBefore we discuss how organizations and operations managers use data to make informed decisions about production processes, we need to specify what data means. The terms <em>data<\/em> and <em>information<\/em> are often used interchangeably as though they were\u00a0the same thing. However, there is an important difference between them. <strong>Data<\/strong>\u00a0refers to a collection of facts, such as numbers, words, measurements, observations, or even just descriptions of things. Data aren't particularly useful on their own, and don't become meaningful until they have been analyzed. The result of data analysis is information.\u00a0<strong>Information<\/strong> is that which informs\u2014the answer to some kind of question, for instance. Data represents the values attributed to things, whereas information, like knowledge, represents an assessment or understanding of those values.\r\n\r\nOrganizations use data all the time to help them understand things like processes, products, customers, finances, and markets. To understand how data are collected and used, we'll follow a small candle company\u00a0called\u00a0Scentfully Yours.\r\n\r\nScentfully Yours collects data from a variety of sources:\r\n<ul>\r\n \t<li><strong>Processes:<\/strong>\u00a0As each jar is filled with scented wax, the jars are weighed by an automated scale on the production line. The\u00a0data are recorded and stored in the scale\u2019s memory, where they can later be retrieved by the quality-assurance team.<\/li>\r\n \t<li><strong>Retail sales:<\/strong>\u00a0Data are collected about which candles the sales department sold during the previous month. The retail point-of-sale system (POS) captures data about each transaction, including the candle\u2019s scent and size. These data are\u00a0transmitted to the national sales manager at the end of each month.<\/li>\r\n \t<li><strong>Customers:<\/strong>\u00a0A customer satisfaction survey is included on customers' sales receipts. If they complete a brief online survey, they are entered into a drawing for a $250 gift certificate, redeemable for Scentfully Yours Candles.<\/li>\r\n \t<li><strong>Suppliers:<\/strong>\u00a0Data on delivery time, materials cost, and shortages are captured by the purchasing manager in their material requirement planning (MRP) system.<\/li>\r\n \t<li><strong>Customer service:<\/strong>\u00a0The customer service department collects data from every customer who calls the 1-800 number. The type of data they collect are zip code, reason for the call (complaint or question), product purchased, and the date of purchase. These data are entered into the company\u2019s customer resource management (CRM) system, where management can access it.<\/li>\r\n<\/ul>\r\nHow does Scentfully Yours turn\u00a0these different kinds of\u00a0data into information that are useful for planning and executing the operations?\" Most companies enter\u00a0their production data\u00a0in an enterprise resource planning (ERP) system, where they\u00a0transformed into useful planning information. This information is used to answer the following questions:\r\n<ul>\r\n \t<li><strong>Start\u00a0with a question<\/strong>: Is the new line of Tub-o-Wax Candles performing as well as the marketing department projected?<\/li>\r\n \t<li><strong>Identify the data needed\u00a0to answer the question<\/strong>:\u00a0Access data from customer surveys, customer service, and retail sales regarding Tub-o-Wax Candles.<\/li>\r\n \t<li><strong>Analyze the data<\/strong>: The company is looking for trends, so it might compare Tub-o-Wax Candles and other products and analyze actual sales versus the original marketing projections.<\/li>\r\n \t<li><strong>Act<\/strong>: Based on what the data analysis shows, the company might want to make changes to the Tub-o-Wax Candles. For example, they might decide to address repeated customer complaints that the candles are so large they smoke up the house when burned or drop the \"lumber\" scent because it just isn't selling.<\/li>\r\n<\/ul>\r\nThe key takeaway is that making changes to the Tub-o-Wax Candle line is informed by the data, but the data (facts and figures) have been transformed into information (sales trends)\u2014and that information provides\u00a0the knowledge needed to improve the\u00a0outcomes. For a small company, turning data into information is a simple process, but how does a company with vast amounts of data like General Motors or Apple do it? Much in the same way Scentfully Yours does but on a much bigger\u00a0scale.\r\n\r\nLarge firms make use of their data and gain knowledge about their processes through data mining. <strong>Data mining<\/strong> is the practice of automatically searching large stores of data to discover patterns and trends that go beyond simple analysis. Data mining uses sophisticated mathematical algorithms to segment the data and evaluate the probability of future events. The key features\u00a0of data mining are the following:\r\n<ul>\r\n \t<li>Automatic discovery of patterns<\/li>\r\n \t<li>Prediction of likely outcomes<\/li>\r\n \t<li>Creation of actionable information<\/li>\r\n \t<li>Focus on large data sets and databases<\/li>\r\n<\/ul>\r\nData mining can answer questions that cannot be addressed through simple query and reporting techniques, as Scentfully Yours did above. Also, because large firms have so much more data, they must consider how to store it. Managers in large companies consider the issue of data warehousing essential to efficient operations. <strong>Data warehousing<\/strong> is the electronic storage of a large amount of data by a business. Warehoused data must be stored in a manner that is secure, reliable, easy to retrieve, and easy to manage.\r\n\r\nAt the same time, to provide the greatest benefit to an organization, data needs to be sharable. It's no good if the collection, analysis, warehousing, and mining of data takes place within a bubble. <strong>Data sharing <\/strong>is the ability to share the same data resource with multiple applications or users. Having this capability is crucial for operations managers, who rely on inputs from many different part of the organization. Data sharing implies that the data are stored in one or more locations in a network and that there is some software mechanism that prevents the same set of data from being changed by two people at the same time. Data sharing is a primary feature of a database management system (DBMS). These systems can range from the very simple (single server) to complex Cloud-based systems. In a small firm, such as Scentfully Yours, sharing data is easy because their size allows them to pass data and information among the departments that need to answer questions. For larger companies, whose data needs and uses are complex, data sharing usually necessitates some sort of database management system.\r\n<h2>Check Your Understanding<\/h2>\r\nAnswer the question(s) below to see how well you understand the topics covered above. This short quiz does <strong>not<\/strong> count toward your grade in the class, and you can retake it an unlimited number of times.\r\n\r\nUse this quiz to check your understanding and decide whether to (1) study the previous section further or (2) move on to the next section.\r\n\r\nhttps:\/\/assessments.lumenlearning.com\/assessments\/3043","rendered":"<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/143\/2017\/03\/01172731\/10946801506_c924c39b76_k.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10421 aligncenter\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/143\/2017\/03\/01172731\/10946801506_c924c39b76_k-300x192.jpg\" alt=\"Photo of many multicolored candles.\" width=\"600\" height=\"384\" \/><\/a><\/p>\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Differentiate between data and information<\/li>\n<li>Explain\u00a0how data mining is used by operations<\/li>\n<li>Explain\u00a0how data warehousing is used by operations<\/li>\n<li>Explain\u00a0how organizations support operations by sharing data<\/li>\n<\/ul>\n<\/div>\n<p>Before we discuss how organizations and operations managers use data to make informed decisions about production processes, we need to specify what data means. The terms <em>data<\/em> and <em>information<\/em> are often used interchangeably as though they were\u00a0the same thing. However, there is an important difference between them. <strong>Data<\/strong>\u00a0refers to a collection of facts, such as numbers, words, measurements, observations, or even just descriptions of things. Data aren&#8217;t particularly useful on their own, and don&#8217;t become meaningful until they have been analyzed. The result of data analysis is information.\u00a0<strong>Information<\/strong> is that which informs\u2014the answer to some kind of question, for instance. Data represents the values attributed to things, whereas information, like knowledge, represents an assessment or understanding of those values.<\/p>\n<p>Organizations use data all the time to help them understand things like processes, products, customers, finances, and markets. To understand how data are collected and used, we&#8217;ll follow a small candle company\u00a0called\u00a0Scentfully Yours.<\/p>\n<p>Scentfully Yours collects data from a variety of sources:<\/p>\n<ul>\n<li><strong>Processes:<\/strong>\u00a0As each jar is filled with scented wax, the jars are weighed by an automated scale on the production line. The\u00a0data are recorded and stored in the scale\u2019s memory, where they can later be retrieved by the quality-assurance team.<\/li>\n<li><strong>Retail sales:<\/strong>\u00a0Data are collected about which candles the sales department sold during the previous month. The retail point-of-sale system (POS) captures data about each transaction, including the candle\u2019s scent and size. These data are\u00a0transmitted to the national sales manager at the end of each month.<\/li>\n<li><strong>Customers:<\/strong>\u00a0A customer satisfaction survey is included on customers&#8217; sales receipts. If they complete a brief online survey, they are entered into a drawing for a $250 gift certificate, redeemable for Scentfully Yours Candles.<\/li>\n<li><strong>Suppliers:<\/strong>\u00a0Data on delivery time, materials cost, and shortages are captured by the purchasing manager in their material requirement planning (MRP) system.<\/li>\n<li><strong>Customer service:<\/strong>\u00a0The customer service department collects data from every customer who calls the 1-800 number. The type of data they collect are zip code, reason for the call (complaint or question), product purchased, and the date of purchase. These data are entered into the company\u2019s customer resource management (CRM) system, where management can access it.<\/li>\n<\/ul>\n<p>How does Scentfully Yours turn\u00a0these different kinds of\u00a0data into information that are useful for planning and executing the operations?&#8221; Most companies enter\u00a0their production data\u00a0in an enterprise resource planning (ERP) system, where they\u00a0transformed into useful planning information. This information is used to answer the following questions:<\/p>\n<ul>\n<li><strong>Start\u00a0with a question<\/strong>: Is the new line of Tub-o-Wax Candles performing as well as the marketing department projected?<\/li>\n<li><strong>Identify the data needed\u00a0to answer the question<\/strong>:\u00a0Access data from customer surveys, customer service, and retail sales regarding Tub-o-Wax Candles.<\/li>\n<li><strong>Analyze the data<\/strong>: The company is looking for trends, so it might compare Tub-o-Wax Candles and other products and analyze actual sales versus the original marketing projections.<\/li>\n<li><strong>Act<\/strong>: Based on what the data analysis shows, the company might want to make changes to the Tub-o-Wax Candles. For example, they might decide to address repeated customer complaints that the candles are so large they smoke up the house when burned or drop the &#8220;lumber&#8221; scent because it just isn&#8217;t selling.<\/li>\n<\/ul>\n<p>The key takeaway is that making changes to the Tub-o-Wax Candle line is informed by the data, but the data (facts and figures) have been transformed into information (sales trends)\u2014and that information provides\u00a0the knowledge needed to improve the\u00a0outcomes. For a small company, turning data into information is a simple process, but how does a company with vast amounts of data like General Motors or Apple do it? Much in the same way Scentfully Yours does but on a much bigger\u00a0scale.<\/p>\n<p>Large firms make use of their data and gain knowledge about their processes through data mining. <strong>Data mining<\/strong> is the practice of automatically searching large stores of data to discover patterns and trends that go beyond simple analysis. Data mining uses sophisticated mathematical algorithms to segment the data and evaluate the probability of future events. The key features\u00a0of data mining are the following:<\/p>\n<ul>\n<li>Automatic discovery of patterns<\/li>\n<li>Prediction of likely outcomes<\/li>\n<li>Creation of actionable information<\/li>\n<li>Focus on large data sets and databases<\/li>\n<\/ul>\n<p>Data mining can answer questions that cannot be addressed through simple query and reporting techniques, as Scentfully Yours did above. Also, because large firms have so much more data, they must consider how to store it. Managers in large companies consider the issue of data warehousing essential to efficient operations. <strong>Data warehousing<\/strong> is the electronic storage of a large amount of data by a business. Warehoused data must be stored in a manner that is secure, reliable, easy to retrieve, and easy to manage.<\/p>\n<p>At the same time, to provide the greatest benefit to an organization, data needs to be sharable. It&#8217;s no good if the collection, analysis, warehousing, and mining of data takes place within a bubble. <strong>Data sharing <\/strong>is the ability to share the same data resource with multiple applications or users. Having this capability is crucial for operations managers, who rely on inputs from many different part of the organization. Data sharing implies that the data are stored in one or more locations in a network and that there is some software mechanism that prevents the same set of data from being changed by two people at the same time. Data sharing is a primary feature of a database management system (DBMS). These systems can range from the very simple (single server) to complex Cloud-based systems. In a small firm, such as Scentfully Yours, sharing data is easy because their size allows them to pass data and information among the departments that need to answer questions. For larger companies, whose data needs and uses are complex, data sharing usually necessitates some sort of database management system.<\/p>\n<h2>Check Your Understanding<\/h2>\n<p>Answer the question(s) below to see how well you understand the topics covered above. This short quiz does <strong>not<\/strong> count toward your grade in the class, and you can retake it an unlimited number of times.<\/p>\n<p>Use this quiz to check your understanding and decide whether to (1) study the previous section further or (2) move on to the next section.<\/p>\n<p>\t<iframe id=\"lumen_assessment_3043\" class=\"resizable\" src=\"https:\/\/assessments.lumenlearning.com\/assessments\/load?assessment_id=3043&#38;embed=1&#38;external_user_id=&#38;external_context_id=&#38;iframe_resize_id=lumen_assessment_3043\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:400px;\"><br \/>\n\t<\/iframe><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-10418\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Reading: Mining, Warehousing, and Sharing Data. <strong>Authored by<\/strong>: Linda Williams and Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><li>Check Your Understanding. <strong>Authored by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Shared previously<\/div><ul class=\"citation-list\"><li>Candles. <strong>Authored by<\/strong>: Chrissie. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/www.flickr.com\/photos\/109144586@N08\/10946801506\/\">https:\/\/www.flickr.com\/photos\/109144586@N08\/10946801506\/<\/a>. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-nd\/4.0\/\">CC BY-NC-ND: Attribution-NonCommercial-NoDerivatives <\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":26,"menu_order":7,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Reading: Mining, Warehousing, and Sharing Data\",\"author\":\"Linda Williams and Lumen Learning\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"cc\",\"description\":\"Candles\",\"author\":\"Chrissie\",\"organization\":\"\",\"url\":\"https:\/\/www.flickr.com\/photos\/109144586@N08\/10946801506\/\",\"project\":\"\",\"license\":\"cc-by-nc-nd\",\"license_terms\":\"\"},{\"type\":\"original\",\"description\":\"Check Your Understanding\",\"author\":\"Lumen Learning\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"3f2edd69-901d-4467-aaee-d4d35014c230, 43af445c-c929-42a0-a466-49f3f47b8233, d89d3cfd-0670-4c4e-bf1e-505b1bca8342, 19b0e44f-8bd2-476e-b3f7-3ce8320acf9c, 815d356a-d71c-4d51-bd31-d521601c0790","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-10418","chapter","type-chapter","status-publish","hentry"],"part":91,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapters\/10418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/wp\/v2\/users\/26"}],"version-history":[{"count":15,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapters\/10418\/revisions"}],"predecessor-version":[{"id":11563,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapters\/10418\/revisions\/11563"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/parts\/91"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapters\/10418\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/wp\/v2\/media?parent=10418"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/pressbooks\/v2\/chapter-type?post=10418"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/wp\/v2\/contributor?post=10418"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wmopen-introbusiness\/wp-json\/wp\/v2\/license?post=10418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}