Data Preparation Capabilities
Get your data ready faster with visual tools for joining, filtering, and transforming—no coding needed. Our AI assistant makes it even easier: just describe your goal, and it builds the configuration for you.
Overview & AI
Three powerful modes to prepare your data, enhanced with AI assistance
- ✓3 Preparation Modes: Standard, Merge, and Pivot
- ✓AI Configuration: Natural language instructions
- ✓Smart Suggestions: AI-generated configurations
Standard Mode
Join multiple sources and transform data points to create one unified data source
- ✓Data Joins: Inner, left, right, and outer joins
- ✓Data Transformations: Filters, aggregations, derived fields
- ✓Column Operations: Advanced column operations
Merge Mode
Align source schemas to merge all sources into one comprehensive data set
- ✓Schema Alignment: Automatic field mapping and validation
- ✓Data Union: Stack datasets vertically with consistency
Pivot Mode
Pivot source data to transform rows into columns for better analysis
- ✓Dynamic Pivoting: Transform rows to columns automatically
- ✓Aggregation Support: Sum, count, average, and more
- ✓Schema Detection: Intelligent field identification
AI-Powered Configuration
Simply add your data sources and tell AI what you want to achieve using natural language
Natural Language Instructions
Example: "Join sales data with customer data, filter for Q4 2023, group by region, and calculate total revenue per customer"
AI-Generated Configuration
AI automatically creates the optimal data preparation workflow based on your requirements