{"id":22789,"date":"2025-08-13T12:26:01","date_gmt":"2025-08-13T12:26:01","guid":{"rendered":"https:\/\/www.cleverrepublic.com\/?post_type=blog&p=22789"},"modified":"2025-12-29T12:31:08","modified_gmt":"2025-12-29T10:31:08","slug":"how-to-define-data-quality-rules-from-your-data-product","status":"publish","type":"blog","link":"https:\/\/www.cleverrepublic.com\/nl\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/","title":{"rendered":"Terugredeneren: hoe definieert u Data Quality-regels vanuit uw dataproduct?\u00a0"},"content":{"rendered":"
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Most organisations still treat Data Quality as a checklist. Something to sort out after the data lands in a warehouse. But that approach no longer fits. Today, data plays a strategic role as a Data Product. It is built with purpose, owned with intent, and expected to deliver trust.<\/span>\u00a0<\/span><\/p>

At Clever Republic, we define Data Quality rules by starting at the end. We use backwards thinking. Instead of beginning with data pipelines or technical structures, we begin with what the business needs. What outcome should the Data Product achieve? What can go wrong if the quality is poor? Those questions shape the rules that matter.<\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Begin With the Outcome <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Traditional Data Quality methods focus on source data. Our approach does the opposite. We start from the business decision that depends on the Data Product. Then we ask what the product must guarantee, and which quality rules protect that outcome.<\/span>\u00a0<\/span><\/p>

Let us look at three example Data Products built for our fictional online supermarket company, Groove. Each supports a different business goal. Each requires a different approach to Data Quality. But all benefit from the same backwards logic.<\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Data Product: Pension Payout<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

This Data Product calculates monthly pension payments for Groove employees. It transforms payroll and HR data into trusted financial outcomes. The business promise is clear: each employee must receive the correct amount, on time, every month.<\/span>\u00a0<\/span><\/p>

We start by identifying what could break that promise. An ineligible employee might receive funds. An employer could over-contribute, causing regulatory issues. Or an investment might be undervalued, leading to accounting errors.<\/span>\u00a0<\/span><\/p>

That is why we work backwards from these outcomes and define targeted rules using <\/span>SODA<\/span><\/b>, a Data Quality monitoring tool designed for operational pipelines.<\/span>\u00a0<\/span><\/p>

To protect eligibility logic, we enforce a minimum retirement age:<\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t- failed rows: \n\nname: \"Employee age should match the assigned cohort age range\" \nfail condition: (YEAR(CURRENT_DATE()) - YEAR(Date_Of_Birth)) NOT BETWEEN MIN_AGE AND MAX_AGE <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02e39e3 elementor-widget elementor-widget-text-editor\" data-id=\"02e39e3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW264025242 BCX0\" lang=\"NL-NL\" xml:lang=\"NL-NL\" data-contrast=\"auto\"><span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">To<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">ensure<\/span><span class=\"NormalTextRun SCXW264025242 BCX0\"> financial <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">limits<\/span><span class=\"NormalTextRun SCXW264025242 BCX0\"> are <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">respected<\/span><span class=\"NormalTextRun SCXW264025242 BCX0\">, we cap <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">employer<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW264025242 BCX0\">contributions<\/span><span class=\"NormalTextRun SCXW264025242 BCX0\">:<\/span><\/span><span class=\"EOP SCXW264025242 BCX0\" data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9569a9e elementor-widget elementor-widget-code-highlight\" data-id=\"9569a9e\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>- failed rows: \n\nname: \"Employer match must not exceed 5% of annual salary\" \nfail condition: Employer_Match > 0.05 * (SELECT Salary FROM Employees WHERE Employees.Employee_ID = Investment_Contribution.Employee_ID) <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a252f elementor-widget elementor-widget-text-editor\" data-id=\"41a252f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW75298047 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW75298047 BCX0\">To avoid misstatements in investment value, we check:<\/span><\/span><span class=\"EOP SCXW75298047 BCX0\" data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16aa41c elementor-widget elementor-widget-code-highlight\" data-id=\"16aa41c\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>- failed rows: \n\nname: \"Current value of investment must not be lower than the invested amount\" \nfail condition: Current_Value < Invest_amount <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ced894 elementor-widget elementor-widget-text-editor\" data-id=\"9ced894\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW83698668 BCX0\" lang=\"NL-NL\" xml:lang=\"NL-NL\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW83698668 BCX0\">These <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">rules<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> do <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">not<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> start <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">from<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> column-level checks. <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">They<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> start <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">from<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">the<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">value<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">this<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> product must <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">deliver<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\">, <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">and<\/span> <span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">the<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> trust <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">it<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\"> must <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW83698668 BCX0\">uphold<\/span><span class=\"NormalTextRun SCXW83698668 BCX0\">.<\/span><\/span><span class=\"EOP SCXW83698668 BCX0\" data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b0c992a e-flex e-con-boxed e-con e-parent\" data-id=\"b0c992a\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b794714 elementor-widget elementor-widget-heading\" data-id=\"b794714\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Product: Greenhouse Gas Impact<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0fbb0a1 elementor-widget elementor-widget-text-editor\" data-id=\"0fbb0a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">This product helps Groove report emissions across Scope 1, 2, and 3. It supports regulatory compliance under CSRD and shapes sustainability strategy. Errors in this product can lead to legal risk and reputational damage.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">To define Data Quality rules here, we start with what must be reported. All emission sources need to be tracked. Factors must align with approved standards. Reporting must happen every quarter, without gaps.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">To protect against sudden and unexplained drops in emissions reporting that might indicate missing data or incorrect calculations we use:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-049e637 elementor-widget elementor-widget-code-highlight\" data-id=\"049e637\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>WITH emissions_with_lag AS (  \n\t\tSELECT  \n\t\t\tyear,  \n\t\t\tTotal_TCO2e,  \n\t\t\tLAG(Total_TCO2e) OVER (ORDER BY year) AS prev_year_TCO2e  \n\t\tFROM @gold.ghg_emissions_total_GreenhouseGasImpact )  \n\tSELECT \t*  \n\tFROM emissions_with_lag  \n\tWHERE Total_TCO2e < 0.8 * prev_year_TCO2e <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0650301 elementor-widget elementor-widget-text-editor\" data-id=\"0650301\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW98427380 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW98427380 BCX0\">And we prevent incomplete or invalid emissions values from entering reports:<\/span><span class=\"NormalTextRun SCXW98427380 BCX0\">\u00a0<\/span><\/span><span class=\"EOP SCXW98427380 BCX0\" data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbc14d9 elementor-widget elementor-widget-code-highlight\" data-id=\"cbc14d9\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>SELECT *  \n\tFROM @gold.ghg_emissions_total_GreenhouseGasImpact  \n\tWHERE otal_TCO2e IS NULL OR Total_TCO2e < 0 <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb38c99 elementor-widget elementor-widget-text-editor\" data-id=\"fb38c99\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW59380182 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW59380182 BCX0\">These rules ensure traceability, consistency, and audit readiness. They do not exist to serve the data team. They exist to serve legal teams, compliance officers, and sustainability managers who depend on <\/span><span class=\"NormalTextRun SCXW59380182 BCX0\">accurate<\/span><span class=\"NormalTextRun SCXW59380182 BCX0\"> reporting.<\/span><\/span><span class=\"EOP SCXW59380182 BCX0\" data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fe14ee1 e-flex e-con-boxed e-con e-parent\" data-id=\"fe14ee1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-531ffd3 elementor-widget elementor-widget-heading\" data-id=\"531ffd3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Product: Customer Churn<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d05b6ef elementor-widget elementor-widget-text-editor\" data-id=\"d05b6ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">Groove\u2019s churn model does more than crunch numbers. It forecasts which customers are about to leave and helps marketing intervene with tailored campaigns. But if the underlying data is off\u2014even slightly\u2014the model misses the mark. Predictions fail, budgets are wasted, and trust evaporates.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">That is why we do not start with features or model accuracy. We begin by asking: <\/span><b><span data-contrast=\"auto\">what must go right for this prediction to be useful?<\/span><\/b><span data-contrast=\"auto\"> From there, we define what data must be protected, measured, and monitored.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">Using <\/span><b><span data-contrast=\"auto\">Collibra Data Quality<\/span><\/b><span data-contrast=\"auto\">, we map those expectations to targeted checks. Take tenure, for example. A negative value here would suggest a customer has been with the platform for negative time. It sounds absurd, but it happens\u2014and it breaks downstream logic.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-88c8da1 elementor-widget elementor-widget-code-highlight\" data-id=\"88c8da1\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>SELECT *   \nFROM @customer_churn  \nWHERE TENURE <= 0 <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f262c15 elementor-widget elementor-widget-text-editor\" data-id=\"f262c15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW238690521 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW238690521 BCX0\">Another red flag is around categorical fields. Marketing relies on segmentation\u2014device type, payment preferences, shopping <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW238690521 BCX0\">behaviour<\/span><span class=\"NormalTextRun SCXW238690521 BCX0\">. <\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW238690521 BCX0\">So<\/span><span class=\"NormalTextRun SCXW238690521 BCX0\"> we lock down those fields to known values. For instance:<\/span><\/span><span class=\"EOP SCXW238690521 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db7e254 elementor-widget elementor-widget-code-highlight\" data-id=\"db7e254\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>SELECT *   \nFROM @customer_churn  \nWHERE PREFERRED_PAYMENT_METHOD NOT IN ('Cash on Delivery', 'Credit Card', 'PayPal', 'Debit Card', 'Bank Transfer') <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa43450 elementor-widget elementor-widget-text-editor\" data-id=\"aa43450\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW147229239 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW147229239 BCX0\">We also check that satisfaction scores are realistic. This is a key feature in the model and a strong signal for churn. If the values fall outside expected bounds, the predictions quickly become unreliable.<\/span><\/span><span class=\"EOP SCXW147229239 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1cfe7ad elementor-widget elementor-widget-code-highlight\" data-id=\"1cfe7ad\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>SELECT *   \nFROM @customer_churn  \nWHERE SATISFACTION_SCORE < 1.00 OR SATISFACTION_SCORE > 10.00 <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ebedd7 elementor-widget elementor-widget-text-editor\" data-id=\"0ebedd7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW63566339 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW63566339 BCX0\">These checks ensure the Customer Churn Predictor delivers more than just probabilities. They protect the quality of its decisions. Every validation supports a business-critical goal<\/span><span class=\"NormalTextRun SCXW63566339 BCX0\">.<\/span><\/span><span class=\"EOP SCXW63566339 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-15e472e e-flex e-con-boxed e-con e-parent\" data-id=\"15e472e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7802580 elementor-widget elementor-widget-heading\" data-id=\"7802580\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Rules With Purpose <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b42d6db elementor-widget elementor-widget-text-editor\" data-id=\"b42d6db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">When you define Data Quality rules from the Data Product backwards, you create rules that protect outcomes. These rules are not generic. They are specific to what the business needs from each product.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">A Data Product is a promise. Data Quality rules protect that promise. They prevent small data issues from turning into large business risks. They give teams confidence to act based on data.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">This approach ensures every rule has a purpose. It creates visible value. It gets buy-in from business stakeholders because they see how quality supports their goals.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-39dd19d e-flex e-con-boxed e-con e-parent\" data-id=\"39dd19d\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e95acf6 elementor-widget elementor-widget-heading\" data-id=\"e95acf6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">A Better Way to Define Quality <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37f4f3c elementor-widget elementor-widget-text-editor\" data-id=\"37f4f3c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">Too often, organisations apply the same set of rules to every dataset. The result is a bloated list of checks with no clear benefit. Teams lose motivation. The business sees no impact.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">Backwards thinking changes that. By focusing on the product, the purpose, and the people who rely on the data, we define smarter rules. Each one is traceable to an outcome. Each one improves trust.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">At Clever Republic, we embed this mindset into every project. We connect Data Quality with Data Governance and Data Intelligence to create products that deliver value from day one.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-308ebf7 e-flex e-con-boxed e-con e-parent\" data-id=\"308ebf7\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8f705c0 elementor-widget elementor-widget-heading\" data-id=\"8f705c0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Time to Rethink Your Rules? <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b72db01 elementor-widget elementor-widget-text-editor\" data-id=\"b72db01\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">If you are still defining Data Quality from the top down, now is the time to flip the approach. Start with the outcome. Identify what must go right. Then define the rules that ensure it does.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">Want help applying this approach to your Data Products? We are ready to support you.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">At Clever Republic, we bring strategy, governance, and technology together to make your Data Products trusted and future-proof.<\/span><span data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Most organisations still treat Data Quality as a checklist. Something to sort out after the data lands in a warehouse. But that approach no longer fits. Today, data plays a strategic role as a Data Product. It is built with purpose, owned with intent, and expected to deliver trust.\u00a0 At Clever Republic, we define Data&hellip;<\/p>","protected":false},"author":39,"featured_media":22791,"template":"","categories":[148],"class_list":["post-22789","blog","type-blog","status-publish","has-post-thumbnail","hentry","category-data_quality"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cleverrepublic.com\/nl\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic\" \/>\n<meta property=\"og:description\" content=\"Most organisations still treat Data Quality as a checklist. Something to sort out after the data lands in a warehouse. But that approach no longer fits. Today, data plays a strategic role as a Data Product. It is built with purpose, owned with intent, and expected to deliver trust.\u00a0 At Clever Republic, we define Data&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cleverrepublic.com\/nl\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/\" \/>\n<meta property=\"og:site_name\" content=\"Clever Republic\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-29T10:31:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/\",\"url\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/\",\"name\":\"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic\",\"isPartOf\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg\",\"datePublished\":\"2025-08-13T12:26:01+00:00\",\"dateModified\":\"2025-12-29T10:31:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage\",\"url\":\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg\",\"contentUrl\":\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.cleverrepublic.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cleverrepublic.com\/#website\",\"url\":\"https:\/\/www.cleverrepublic.com\/\",\"name\":\"Clever Republic\",\"description\":\"Implementing Data Intelligence\",\"publisher\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cleverrepublic.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cleverrepublic.com\/#organization\",\"name\":\"Clever Republic\",\"url\":\"https:\/\/www.cleverrepublic.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/www.cleverrepublic.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/05\/Logo_CleverRepublic_color-5.png\",\"contentUrl\":\"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/05\/Logo_CleverRepublic_color-5.png\",\"width\":1224,\"height\":646,\"caption\":\"Clever Republic\"},\"image\":{\"@id\":\"https:\/\/www.cleverrepublic.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/clever-republic\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic","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:\/\/www.cleverrepublic.com\/nl\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/","og_locale":"nl_NL","og_type":"article","og_title":"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic","og_description":"Most organisations still treat Data Quality as a checklist. Something to sort out after the data lands in a warehouse. But that approach no longer fits. Today, data plays a strategic role as a Data Product. It is built with purpose, owned with intent, and expected to deliver trust.\u00a0 At Clever Republic, we define Data&hellip;","og_url":"https:\/\/www.cleverrepublic.com\/nl\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/","og_site_name":"Clever Republic","article_modified_time":"2025-12-29T10:31:08+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"5 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/","url":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/","name":"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0 - Clever Republic","isPartOf":{"@id":"https:\/\/www.cleverrepublic.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage"},"image":{"@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg","datePublished":"2025-08-13T12:26:01+00:00","dateModified":"2025-12-29T10:31:08+00:00","breadcrumb":{"@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#primaryimage","url":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg","contentUrl":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/10\/yumu-HQH-GOZ6K2c-unsplash-scaled.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/www.cleverrepublic.com\/resources\/blog\/how-to-define-data-quality-rules-from-your-data-product\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cleverrepublic.com\/"},{"@type":"ListItem","position":2,"name":"Backwards thinking: How to define Data Quality Rules from your Data Product\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/www.cleverrepublic.com\/#website","url":"https:\/\/www.cleverrepublic.com\/","name":"Clever Republic","description":"Implementing Data Intelligence","publisher":{"@id":"https:\/\/www.cleverrepublic.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cleverrepublic.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/www.cleverrepublic.com\/#organization","name":"Clever Republic","url":"https:\/\/www.cleverrepublic.com\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/www.cleverrepublic.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/05\/Logo_CleverRepublic_color-5.png","contentUrl":"https:\/\/www.cleverrepublic.com\/wp-content\/uploads\/2025\/05\/Logo_CleverRepublic_color-5.png","width":1224,"height":646,"caption":"Clever Republic"},"image":{"@id":"https:\/\/www.cleverrepublic.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/clever-republic"]}]}},"_links":{"self":[{"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/blog\/22789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/users\/39"}],"version-history":[{"count":5,"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/blog\/22789\/revisions"}],"predecessor-version":[{"id":23119,"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/blog\/22789\/revisions\/23119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/media\/22791"}],"wp:attachment":[{"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/media?parent=22789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cleverrepublic.com\/nl\/wp-json\/wp\/v2\/categories?post=22789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}