Data Preparation with Dataiku

Connect, cleanse, and prepare data for analytics and AI projects at scale.


AI Data Preparation

Preparing data has traditionally been the domain of data analysts, but with new Generative AI Data Preparation (coming soon), analysts and business users describe the preparation steps they want, and the system automatically creates those steps as part of visual recipes. The results are easy to review for everyone using the data preparation job.


Visual Flow

The Dataiku flow provides a visual representation of a project’s data pipeline and is the central space where coders and non-coders view and analyze data, add recipes to join and transform datasets, and build predictive models.

The visual flow also contains code-based and plugin elements for added customization and extensibility.


Connect to Leading Data Sources

Dataiku provides pre-built connectors to dozens of leading data sources both on-premises and in the cloud, including Amazon S3, Azure Blob Storage, Google Cloud Storage, Snowflake, Databricks Lakehouse, SQL databases, NoSQL databases, HDFS, and more.


Data Preparation and Enrichment

Dataiku provides easy-to-use visual interfaces to join datasets, group and aggregate, clean, transform, and enrich data, all with a few clicks. You can even incorporate the latest Generative AI techniques without code. Best of all, Dataiku automatically documents all steps in a recipe as part of the visual flow.

If you’d rather code than click, create code recipes using familiar languages such as Python, R, and SQL, developed and edited in your favorite IDE.


100 Built-in Data Transformers

The powerful prepare recipe includes 100 built-in data transformers for common data manipulations like binning, concatenation and strings manipulation, currency and date conversions, geo-enrichment, and reshaping.

Dataiku even suggests relevant functions for you based on the data’s type and values.

For custom transformations, write formulas using a spreadsheet-like expression language or Python code for ultimate flexibility.


No-Code Generative AI Recipes

Dataiku now offers visual, no-code recipes including entity extraction, sentiment analysis, text summarization and classification running on your preferred Generative AI services.

Building real AI-powered projects with LLMs is fast and easy with Dataiku recipes.


Specialized Data Preparation & Annotation

Dataiku offers a wide variety of functions and tools to parse and enrich specialized data types such as geospatial data, time series, images, and text with additional metadata and structure.

Examples include geo joins and geocoding, time series resampling, text vectorization, a managed framework for image and text annotation, and much more.

Go Further

Discover how Dataiku Enables Business Experts

Beyond data preparation, explore how Dataiku helps analysts and business experts.


Watch a Demo

Discover how analysts use Dataiku to access, cleanse, transform, and visualize data — all in a single, easy to use platform.

Watch Now

Dig Deeper With a Sample Project

Review an example of how to use visual data preparation to clean a dataset.

Sample Project

Data Prep Tips & Tricks

Download an e-book containing practical solutions to common data preparation mistakes.

Get the ebook

Get Started with Dataiku

Start Your Dataiku 14-Day Free Trial
or Install the Free Edition of Dataiku

Get Started