Sometimes I encounter attitudes such as “this KPI is in the ballpark” or “not matching exactly but in tolerance”. Would that suffice if the question was about the balance of your bank account, salary payment, or tax bill?<\/p>\n\n\n\n
Oh but your inventory level or exact billing rate isn’t just that critical?<\/p>\n\n\n\n
Well, if there’s a small recognizable error, how can you trust other numbers or maybe that same KPI but on different sub-selection?<\/p>\n\n\n\n
<\/div>\n\n\n\n
Why \u201cclose enough\u201d numbers are a problem<\/h2>\n\n\n\n
Remember that the law of big numbers conceals errors! Big aggregates converge to about right. That works in insurance pricing but not in discovering who’s working more productively than others or when evaluating quality of a product batch.<\/p>\n\n\n\n
Perhaps the most important, jeopardized thing is trust in reports. As with trust in general, it’s easy to lose and next to impossible to regain. Do you really want to start your reporting renovation with just-almost-reliable numbers? Unfortunately, many do. Good luck leading change in your organization if the reports meant to support it have already given people reason not to trust them.<\/p>\n\n\n\n
Way trickier situation is when wrong numbers are not recognized for being wrong. It’s not uncommon at all to discover later on that some calculation logic is not robust, and thus the business has been using wrong numbers for quite some time. It’s always a delicate issue to critically evaluate someone’s doings and faults, but it is something that has to be done, nevertheless. I bet many errors are ignored simply because of conformism and avoiding inconvenience.<\/p>\n\n\n\n
This is not about predictions or otherwise inherently uncertain numbers but about numbers that can and should be logically and undisputably derivable. This is about erroneous logic, bad data, or both.<\/p>\n\n\n\n
You can’t fix everything within a reasonable time frame and costs, but digging your head into the sand is a terrible choice.<\/p>\n\n\n\n
Especially with ERP, CRM or otherwise human input data, there’s an endless stream of typing errors, missing data etc., but that is not actually bad data (even though I just used that phrase) but an important piece of reality.<\/p>\n\n\n\n
Hand-in-hand with your KPI analytics endeavor, you should be getting tons of information about your data-generating processes. That is, about the ways Pekka and Tanja are filling values into those systems. Same but different goes for your IoT devices of course.<\/p>\n\n\n\n
<\/div>\n\n\n\n
There are no shortcuts to data quality<\/h2>\n\n\n\n
I don’t have any magic bullets left in my clip, but I do have a few ordinary ones:<\/p>\n\n\n\n
\n- Verify results in reports vs. database vs. source systems\u00a0<\/li>\n\n\n\n
- You\u00a0should\u00a0practically always\u00a0have row-level data as the basis in your Power BI\u00a0data model\u00a0so that you can verify numbers and\u00a0utilize\u00a0all the richness of data. If the volume is hundreds of\u00a0millions of\u00a0rows, there are ways for\u00a0optimization,\u00a0e.g.\u00a0conditional aggregation.\u00a0<\/li>\n\n\n\n
- Don’t\u00a0hide outliers, “duplicates”\u00a0etc.\u00a0lazily. Inspect their true origin and correct them at the source if possible. Document and set monitors for what you\u00a0can’t\u00a0fix completely.\u00a0<\/li>\n\n\n\n
- There’s\u00a0no shortcut to quality and deep systemic understanding.\u00a0I’m\u00a0a humble\u00a0student of Ferrari and Russo and their book “The Definitive Guide to DAX”.\u00a0Ten years of solving problems with wits, YouTube and GPT\u00a0doesn’t\u00a0necessarily teach you about the\u00a0whole system, or more importantly, what you\u00a0don’t\u00a0know.\u00a0Think\u00a0it this way: is it better to learn physics on your own or according to\u00a0a\u00a0high school curriculum? Very few of us are so passionately curious\u00a0about\u00a0this\u00a0kind\u00a0of\u00a0subject\u00a0that the first is\u00a0a\u00a0better\u00a0option.\u00a0The rest of us should learn the big picture from a curated comprehensive source.\u00a0<\/li>\n<\/ul>\n\n\n\n
If you need analytics that are accurate, traceable and built to be trusted – rather than a collection of isolated solutions – let’s have a chat!<\/p>\n\n\n\n
– Lauri Nuotio, Senior Analytics Engineer<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes I encounter attitudes such as “this KPI is in the ballpark” or “not matching exactly but in tolerance”. Would that suffice if the question was about the balance of your bank account, salary payment, or tax bill? Oh but your inventory level or exact billing rate isn’t just that critical? Well, if there’s a […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-10140","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"yoast_head":"\n
Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia<\/title>\n<meta name=\"description\" content=\"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia\" \/>\n<meta property=\"og:description\" content=\"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/\" \/>\n<meta property=\"og:site_name\" content=\"Etlia\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-17T10:53:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-17T10:58:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/etlia.fi\/wp-content\/uploads\/2026\/01\/Etlia-logo-700px_Musta-DE.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"705\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dina Pynssi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dina Pynssi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/\"},\"author\":{\"name\":\"Dina Pynssi\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#\\\/schema\\\/person\\\/f9c65bcd77e0acc37c713cdf28c68adb\"},\"headline\":\"Why you\u00a0mustn’t\u00a0settle on close enough numbers\u00a0\",\"datePublished\":\"2026-09-17T10:53:29+00:00\",\"dateModified\":\"2026-09-17T10:58:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/\"},\"wordCount\":662,\"publisher\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/\",\"url\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/\",\"name\":\"Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#website\"},\"datePublished\":\"2026-09-17T10:53:29+00:00\",\"dateModified\":\"2026-09-17T10:58:54+00:00\",\"description\":\"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/data-quality-close-enough-numbers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/etlia.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why you\u00a0mustn’t\u00a0settle on close enough numbers\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/etlia.fi\\\/en\\\/\",\"name\":\"Etlia\",\"description\":\"Kriittiset analytiikkaratkaisut yrityksellesi\",\"publisher\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/etlia.fi\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#organization\",\"name\":\"Etlia\",\"url\":\"https:\\\/\\\/etlia.fi\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/etlia.fi\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/etlia_logo_full_for-white-background-3.jpg\",\"contentUrl\":\"https:\\\/\\\/etlia.fi\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/etlia_logo_full_for-white-background-3.jpg\",\"width\":850,\"height\":374,\"caption\":\"Etlia\"},\"image\":{\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/etlia\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/etlia.fi\\\/en\\\/#\\\/schema\\\/person\\\/f9c65bcd77e0acc37c713cdf28c68adb\",\"name\":\"Dina Pynssi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g\",\"caption\":\"Dina Pynssi\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia","description":"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/","og_locale":"en_US","og_type":"article","og_title":"Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia","og_description":"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.","og_url":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/","og_site_name":"Etlia","article_published_time":"2026-09-17T10:53:29+00:00","article_modified_time":"2026-09-17T10:58:54+00:00","og_image":[{"width":1000,"height":705,"url":"https:\/\/etlia.fi\/wp-content\/uploads\/2026\/01\/Etlia-logo-700px_Musta-DE.jpg","type":"image\/jpeg"}],"author":"Dina Pynssi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dina Pynssi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/#article","isPartOf":{"@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/"},"author":{"name":"Dina Pynssi","@id":"https:\/\/etlia.fi\/en\/#\/schema\/person\/f9c65bcd77e0acc37c713cdf28c68adb"},"headline":"Why you\u00a0mustn’t\u00a0settle on close enough numbers\u00a0","datePublished":"2026-09-17T10:53:29+00:00","dateModified":"2026-09-17T10:58:54+00:00","mainEntityOfPage":{"@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/"},"wordCount":662,"publisher":{"@id":"https:\/\/etlia.fi\/en\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/","url":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/","name":"Data Quality: Why \u201cClose Enough\u201d Numbers Aren\u2019t Enough | Etlia","isPartOf":{"@id":"https:\/\/etlia.fi\/en\/#website"},"datePublished":"2026-09-17T10:53:29+00:00","dateModified":"2026-09-17T10:58:54+00:00","description":"Why does data quality matter? Lauri explains why \u201cclose enough\u201d numbers can undermine trust in reporting and how to build more reliable analytics.","breadcrumb":{"@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/etlia.fi\/en\/data-quality-close-enough-numbers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/etlia.fi\/en\/"},{"@type":"ListItem","position":2,"name":"Why you\u00a0mustn’t\u00a0settle on close enough numbers\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/etlia.fi\/en\/#website","url":"https:\/\/etlia.fi\/en\/","name":"Etlia","description":"Kriittiset analytiikkaratkaisut yrityksellesi","publisher":{"@id":"https:\/\/etlia.fi\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/etlia.fi\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/etlia.fi\/en\/#organization","name":"Etlia","url":"https:\/\/etlia.fi\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/etlia.fi\/en\/#\/schema\/logo\/image\/","url":"https:\/\/etlia.fi\/wp-content\/uploads\/2021\/03\/etlia_logo_full_for-white-background-3.jpg","contentUrl":"https:\/\/etlia.fi\/wp-content\/uploads\/2021\/03\/etlia_logo_full_for-white-background-3.jpg","width":850,"height":374,"caption":"Etlia"},"image":{"@id":"https:\/\/etlia.fi\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/etlia\/"]},{"@type":"Person","@id":"https:\/\/etlia.fi\/en\/#\/schema\/person\/f9c65bcd77e0acc37c713cdf28c68adb","name":"Dina Pynssi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea9fcaeb51aa624138ff4e6b726eb65a77913297039ddb23faa37f34980b5509?s=96&d=mm&r=g","caption":"Dina Pynssi"}}]}},"_links":{"self":[{"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/posts\/10140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/comments?post=10140"}],"version-history":[{"count":1,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/posts\/10140\/revisions"}],"predecessor-version":[{"id":10141,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/posts\/10140\/revisions\/10141"}],"wp:attachment":[{"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/media?parent=10140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/categories?post=10140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlia.fi\/en\/wp-json\/wp\/v2\/tags?post=10140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}