---
schema_version: "1"
id: 75e4b3dcd7dd4ca964fa9a0b21f9dbb5c6bde0746c7da87b4d0388806db3d5a8
title: Predict Missing Values in Dimension Columns
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_recipe_predictvalues.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_predictvalues.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 960a221995377c64e606f2364ef265298e0411279bae535ef4126222ecf2e01d
description: When a dataset or connected object has missing values in a dimension column, CRM Analytics can fill in missing values to complete your data. CRM Analytics intelligently predicts values based on values in other strongly correlated columns in your data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Predict Missing Values in Dimension Columns

When a dataset or connected object has missing values in a dimension column, CRM Analytics can fill in missing values to complete your data. CRM Analytics intelligently predicts values based on values in other strongly correlated columns in your data.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To predict missing values in a Data Prep recipe, see [Predict Missing Values Transformation: Fill In Missing Values](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_predictmissingvalues.htm&release=264.0.0&type=5 "In CRM Analytic, use the Predict Missing Values transformation in a Data Prep recipe to complete your data by filling in missing values in a text column. CRM Analytics Intelligently predicts values based on values in other strongly correlated columns in your data.").

Consider these limitations before using this feature.

- If there aren’t enough records to make accurate predictions, CRM Analytics doesn’t insert predicted values .
- You can't perform column profiling or transformations on predicted columns.
- Recipes that predict values can take longer to run.

To predict missing values in a dimension column:

1. On the dataset recipe page, click the dimension column.
2. In the Einstein Suggestions bar, click **Predict Missing Values**.
    
    ![When you select a dimension, the Predict Missing Values option appears in the Einstein Suggestions box.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_predictMissingValues_Option.png)
3. Select up to three dimension columns to use to predict the missing values for the selected column.
    
    ![The predictive columns appear in the Preview tab after you select the Predict Missing Values transformation.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_predictMissingValues_selectPredictiveColumns.png)
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_tip.png)
    
    Tip To make an accurate prediction, each column must have less than 200 unique values. Also, verify that these predictive columns contain clean, quality data. For example, you have an Education predictive column that contains values such as “Bachelors Degree” and “Bachelors.” Use the bucket transformation to bucket field values with the same meaning. Then use the column with the clean data as a predictive column. For more information about bucketing, see [Bucket a Dimension Field in a Recipe](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_bucket_dim.htm&release=264.0.0&type=5 "Add a field to a recipe to bucket values in a specified dimension field.").
4. Click **Add** to confirm.
    
    The preview shows the original column with the missing values and the new column with “predict” at the end. The preview shows “Prediction TBD” for predicted values in the new column. The predicted values don’t appear until after you run the recipe.
    
    ![The new predict column show "Predict TBD" for values that it will predict.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_predictMissingValues_noPreview.png)
5. Click **Save** | **Save Recipe**.

When you run the recipe to create the dataset, you can include the original column and the new column with the predictions. To review the predictions, view the dataset as a values table.

![The predicted values appear in the dataset.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_predictMissingValues_Results.png)