{"id":947,"date":"2017-10-18T11:52:35","date_gmt":"2017-10-18T17:52:35","guid":{"rendered":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/?p=947"},"modified":"2021-03-15T15:39:32","modified_gmt":"2021-03-15T21:39:32","slug":"hard-data-analysis-ugly-data-part-2","status":"publish","type":"post","link":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/hard-data-analysis-ugly-data-part-2\/","title":{"rendered":"It\u2019s Hard to Do Data Analysis on Ugly Data&#8230; Part 2"},"content":{"rendered":"\r\n<p>People often get stuck before the &#8220;Analyze&#8221; phase of <a href=\"https:\/\/www.qimacros.com\/lean-six-sigma\/DMAIC\/\" target=\"_blank\" rel=\"noopener noreferrer\">DMAIC<\/a> because of ugly data.<\/p>\r\n<p>You can&#8217;t analyze data until it is in the right format for analysis.<\/p>\r\n<p>In this data about medications that might affect patient falls, we have to:\r\n<ol>\r\n \t<li>Transpose the data<\/li>\r\n \t<li>Use <a href=\"https:\/\/www.qimacros.com\/free-excel-tips\/excel-text-to-columns\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel&#8217;s Text-to-column<\/a> feature to split the meds into separate cells<\/li>\r\n \t<li>Use QI Macros <a href=\"https:\/\/www.qimacros.com\/data-mining-analysis-excel\/restack\/\" target=\"_blank\" rel=\"noopener noreferrer\">UnStack Columns<\/a> tool to get all of the meds into a single column<\/li>\r\n \t<li>Use QI Macros <a href=\"https:\/\/www.qimacros.com\/data-mining-analysis-excel\/data-mining-wizard\/\">Data Mining Wizard<\/a> to create a PivotTable and Pareto chart of medications involved in patient falls<\/li>\r\n<\/ol><\/p>\r\n<p>You can watch the video below:<\/p>\r\n\r\n\r\n\r\n<p><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/227917910?title=0&amp;byline=0&amp;portrait=0\" width=\"720\" height=\"405\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><\/span><\/iframe><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>People often get stuck before the &ldquo;Analyze&rdquo; phase of DMAIC because of ugly data. You can&rsquo;t analyze data until it is in the right format for analysis. In this data about medications that might affect patient falls, we have to: Transpose the data Use Excel&rsquo;s Text-to-column feature to split the meds into separate cells Use [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[211,290],"tags":[30,202,168],"class_list":["post-947","post","type-post","status-publish","format-standard","hentry","category-data-mining","category-improvement-insights","tag-data","tag-data-mining","tag-qi-macros"],"_links":{"self":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/comments?post=947"}],"version-history":[{"count":14,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/947\/revisions"}],"predecessor-version":[{"id":4286,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/947\/revisions\/4286"}],"wp:attachment":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media?parent=947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/categories?post=947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/tags?post=947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}