{"id":911,"date":"2021-04-14T05:02:56","date_gmt":"2021-04-14T05:02:56","guid":{"rendered":"http:\/\/puneetkhosla.com\/?p=911"},"modified":"2021-04-14T05:12:34","modified_gmt":"2021-04-14T05:12:34","slug":"einstein-prediction-builder-improving-predictions-by-improving-data-quality","status":"publish","type":"post","link":"https:\/\/puneetkhosla.com\/?p=911","title":{"rendered":"Einstein Prediction Builder : Improving Predictions by improving data quality"},"content":{"rendered":"\n

In my last blog on Einstein Prediction Builder, we were able to improve our prediction score by choosing the right fields for doing the prediction. Link to last blog \u2013 Einstein Prediction Builder : Improving Predictions through choice of fields<\/a><\/p>\n\n\n\n

In this blog, we will understand why data quality is important for improving prediction results.<\/p>\n\n\n\n

Imagine an astrologer predicting your future but doesn’t have your date of birth . Imagine a store predicting the sale in month’s to come, but they count the store and customer’s receipt of bills (i.e. double counting the sale proceeds).<\/p>\n\n\n\n

This is a similar situation that we might encounter in our data. We are now going to talk through steps to improve data quality and thus improve our prediction.<\/p>\n\n\n\n

Just a quick recap, we achieved a score of 47 in the previous module.<\/p>\n\n\n\n

STEP 1 : Remove the Duplicates<\/span><\/strong><\/p>\n\n\n\n

When we prepare the example set, it is important to cleanse the data to remove duplicates. Salesforce Duplicate Rules or products from AppExchange can help in cleaning data and removing the duplicates. Post removing the duplicates, it is important to re-evaluate the score. In our case, the score increased to 53.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

STEP 2 : Validate Data in the example set<\/span><\/strong><\/p>\n\n\n\n

It is important to ensure that our example set has valid data. Try to give meaning to the data, by ensuring the fields are populated with proper and meaningful values. <\/p>\n\n\n\n

Avoid values like etc. , any other reason, none of the above. Such values can result in low scores especially if they appear on large number of records.<\/p>\n\n\n\n

Check if the data is correct and fix the data if there is an issue. This however requires involvement from business users to help in fixing the data and converting it into a meaningful information.<\/p>\n\n\n\n

After completing the above, the score of my prediction became 85<\/span><\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

So with some basics checks, we moved our score from Good <\/span><\/strong>to Great<\/span><\/strong>.<\/p>\n\n\n\n

It is important to note that it was not just improving the data quality that moved the score, it was series of steps that helped in reaching this mark. To reiterate it is<\/p>\n\n\n\n

  • Removing Hindsight Bias.<\/li>
  • Removing fields which are majorly blank (and will not have too much data in future).<\/li>
  • Removing fields which has no impact.<\/li>
  • Removing the Duplicate data.<\/li>
  • Validating the data.<\/li><\/ul>\n\n\n\n

    We will next talk about the Einstein Prediction Builder Component (provided by Salesforce) in my next blog.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In my last blog on Einstein Prediction Builder, we were able to improve our prediction score by choosing the right fields for doing the prediction. Link to last blog \u2013 Einstein Prediction Builder : Improving Predictions through choice of fields In this blog, we will understand why data quality is important for improving prediction results. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[14,11,13,18,16],"class_list":["post-911","post","type-post","status-publish","format-standard","hentry","category-einstein","tag-ai","tag-einstein","tag-einstein-discovery","tag-einstein-prediction-builder","tag-salesforce"],"_links":{"self":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=911"}],"version-history":[{"count":8,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":922,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/911\/revisions\/922"}],"wp:attachment":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}