---
schema_version: "1"
id: 527fab28ad06100902744544e4b6cf79651ef4bff3247749051ef3119c03bb02
title: Collect, Cleanse, and Optimize Your Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_edd_prep_cleanse.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prep_cleanse.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f352a5ad7d2bbf462160f3d2ceb40947c551c15454238f6f8bc37c53cf22fe39
description: All data prep efforts are oriented toward providing the best data you can for the business outcome you want to examine or predict. CRM Analytics provides the tools you need to consolidate, clean, and prepare your data for analysis. This topic describes approaches to consider when preparing data for your solution.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Collect, Cleanse, and Optimize Your Data

All data prep efforts are oriented toward providing the best data you can for the business outcome you want to examine or predict. CRM Analytics provides the tools you need to consolidate, clean, and prepare your data for analysis. This topic describes approaches to consider when preparing data for your solution.

- **[Considerations for Preparing Data](https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prep_considerations.htm&release=264.0.0&type=5)**  
    Consider these guidelines when preparing your data for Einstein Discovery.
- **[Address Common Data Issues](https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prep_data_issues.htm&release=264.0.0&type=5)**  
    Handle common issues that you encounter during data prep for Einstein Discovery.
- **[Adding Calculated Columns into Your Dataset](https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prep_fields.htm&release=264.0.0&type=5)**  
    Create calculated columns in your dataset to extract more useful information, such as a ratio or aggregation. A calculated column uses a formula to derive its value from other data (such as fields, expressions, and values).

#### See Also

- [Prepare Data for Analysis](https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prep.htm&release=264.0.0&type=5 "Effective data preparation is key to getting great results with your insights, predictions, and improvements. Engage the data integration power of CRM Analytics to load and transform data from one or more data sources into a dataset for Einstein Discovery to analyze. You can pull data from Salesforce and external sources. You can also use third-party tools and utilities to further expedite data cleansing and wrangling tasks.")