> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/pre-sales/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/pre-sales/technical-faqs/data-preparation.md).

# Data Preparation

### Does the BDB Platform contain Data Extraction and transformation and management option?

### Does the BDB Platform contain a self-service Data Preparation module?

### Does the BDB Platform provide the option to highlight and clean the data automatically with various rules like; missing value, spaces, inconsistent value, duplicate column/rows, all null/zeros, etc?

### Does the BDB Platform contain various data transformation options based on column data type, change the data type, aggregate data type, etc.?

Yes, the self-service BDB Data Preparation helps in the instant cleansing of data with its excel-like UI. Interactive Interface like Excel for Visual profiling & transformation. Enables non-technical users to perform over 60+ data transformations. Integrated with the Data Pipeline module so that the transformed data can be extracted in a Pipeline Workflow.&#x20;

### Data Preparation Features

* Data in familiar grid format & basic anomaly detection as soon as data is uploaded.
* 60+ data transformations for basic as well as advanced data cleansing.
* Smart features like history tracking of operations for redo/undo/ replay.
* Extract clean data.
* Store or data pipeline for real-time data cleansing.

<figure><img src="https://4072512490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlLFg37sm5677zgZ4m8et%2Fuploads%2F4dEYqdtd8RnfSb1bHlqi%2Fimage.png?alt=media&amp;token=9f33bf9b-a47c-4419-a4c6-4ccccbdaf212" alt=""><figcaption></figcaption></figure>

<figure><img src="https://4072512490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlLFg37sm5677zgZ4m8et%2Fuploads%2Fi1CgnFboXhzIQsExpgbN%2Fimage.png?alt=media&amp;token=4243d7ab-322b-44fd-b69b-02a65e970f74" alt=""><figcaption></figcaption></figure>
