{"id":2072,"date":"2011-04-29T07:00:50","date_gmt":"2011-04-29T15:00:50","guid":{"rendered":"http:\/\/www.formtek.com\/blog\/?p=2072"},"modified":"2011-04-29T07:00:50","modified_gmt":"2011-04-29T15:00:50","slug":"business-intelligence-poor-data-quality-threatens-analytics","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/business-intelligence-poor-data-quality-threatens-analytics\/","title":{"rendered":"Business Intelligence: Poor Data Quality Threatens Analytics"},"content":{"rendered":"<p><a title=\"Garbage in, Garbage Out\" href=\"http:\/\/en.wikipedia.org\/wiki\/Garbage_In,_Garbage_Out\" target=\"_blank\">Garbage in, Garbage out<\/a> (GIGO). \u00a0 It&#8217;s a simple truth that has important implications in the world of business intelligence. \u00a0 While Business Intelligence tools can create beautiful and compelling dashboards and graphics, if the data that the tools rely on is of poor quality, their results are meaningless, or at least potentially badly flawed.<\/p>\n<p>Data cleansing and data quality are important in order to ensure quality results from business intelligence analytics. \u00a0 A <a title=\"Experian report on data quality\" href=\"http:\/\/www.qas-experian.com.au\/register\/1101\/power-of-data\/contact-form.htm\" target=\"_blank\">report <\/a>from <a title=\"Experian QAS home page\" href=\"http:\/\/www.experianplc.com\/\" target=\"_blank\">Experian<\/a> QAS finds that as many as <strong>90 percent<\/strong> of organizations think that the data they are managing is of poor quality, and the reason why organizations can&#8217;t do better is because they rely too much on human input and have limited resources to direct towards improving the situation.<\/p>\n<p>Another survey by <a title=\"Informatica Corporation\" href=\"http:\/\/www.informatica.com\/Pages\/index.aspx\" target=\"_blank\">Informatica Corporation<\/a> came to a similar <a title=\"Informatica on data quality\" href=\"http:\/\/www.informatica.com\/products_services\/data_quality\/Pages\/index.aspx\" target=\"_blank\">conclusion<\/a> as the Experian report. \u00a0It found\u00a0that 83 percent of organizations did not have confidence in the accuracy of their data.<\/p>\n<p><a title=\"Rick Sherman\" href=\"http:\/\/www.athena-solutions.com\/rick-sherman.shtml\" target=\"_blank\">Rick Sherman<\/a>, Founder of <a title=\"Athena IT Solutions\" href=\"http:\/\/www.athena-solutions.com\/index.shtml\" target=\"_blank\">Athena IT solutions<\/a>, said that &#8220;dirty data can really muddy up a company&#8217;s attempt at real-time disclosure and puts the chief financial officer at high risk when signing off on financial reports and even press releases based on incorrect information.&#8221;<\/p>\n<p>Many companies have not even considered that data, like any almost any other product, has a shelf life. \u00a0The Experian survey found that a quarter of organization have never even thought to examine the quality of their data. \u00a0But many organization realize there is a problem, but they yjust don&#8217;t have the time or resources to confront it.<\/p>\n<p><a title=\"Thomas Schutz\" href=\"http:\/\/www.qas.com\/about-qas\/directors\" target=\"_blank\">Thomas Schutz<\/a>, Senior Vice President at Experian, said that &#8220;the first step in dealing with any issue is admitting there is a problem, which we see most businesses doing based on the survey results. \u00a0Now the question becomes whether business will act on the problem, and actually improve data management systems to correct information before it enters business processes, rather than using manually correcting bad data on the back end. We are starting to see more businesses move to these type of systems.\u201d<\/p>\n<div class=\"lightsocial_container\"><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/digg.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/digg.png\" alt=\"Digg This\" title=\"Digg This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.reddit.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/reddit.png\" alt=\"Reddit This\" title=\"Reddit This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.stumbleupon.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/stumbleupon.png\" alt=\"Stumble Now!\" title=\"Stumble Now!\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/buzz.yahoo.com\/buzz?targetUrl=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F&amp;headline=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/yahoo_buzz.png\" alt=\"Buzz This\" title=\"Buzz This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dzone.com\/links\/add.html?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dzone.png\" alt=\"Vote on DZone\" title=\"Vote on DZone\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.facebook.com\/sharer.php?t=&amp;u=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/facebook.png\" alt=\"Share on Facebook\" title=\"Share on Facebook\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/delicious.com\/save?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/delicious.png\" alt=\"Bookmark this on Delicious\" title=\"Bookmark this on Delicious\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dotnetkicks.com\/kick\/?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetkicks.png\" alt=\"Kick It on DotNetKicks.com\" title=\"Kick It on DotNetKicks.com\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/dotnetshoutout.com\/Submit?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetshoutout.png\" alt=\"Shout it\" title=\"Shout it\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.linkedin.com\/shareArticle?mini=true&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F&amp;title=&amp;summary=&amp;source=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/linkedin.png\" alt=\"Share on LinkedIn\" title=\"Share on LinkedIn\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.technorati.com\/faves?add=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/technorati.png\" alt=\"Bookmark this on Technorati\" title=\"Bookmark this on Technorati\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/twitter.com\/home?status=Reading+https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/twitter.png\" alt=\"Post on Twitter\" title=\"Post on Twitter\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.google.com\/buzz\/post?url=https%3A%2F%2Fformtek.com%2Fblog%2Fbusiness-intelligence-poor-data-quality-threatens-analytics%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/google_buzz.png\" alt=\"Google Buzz (aka. Google Reader)\" title=\"Google Buzz (aka. Google Reader)\" \/><\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Garbage in, Garbage out (GIGO). \u00a0 It&#8217;s a simple truth that has important implications in the world of business intelligence. \u00a0 While Business Intelligence tools can create beautiful and compelling dashboards and graphics, if the data that the tools rely<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/formtek.com\/blog\/business-intelligence-poor-data-quality-threatens-analytics\/\">Read more &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2072","post","type-post","status-publish","format-standard","hentry","category-business-intelligence"],"_links":{"self":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/2072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/comments?post=2072"}],"version-history":[{"count":0,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/2072\/revisions"}],"wp:attachment":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/media?parent=2072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/categories?post=2072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/tags?post=2072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}