Data Transformation & Modelling
Transformation and modelling tools turn raw loaded data into clean, documented tables that analysts and dashboards can rely on. Most work in SQL inside the warehouse, with version control and dependency graphs.
Many add data quality tests, lineage and a semantic layer, so every report uses the same definitions for metrics like revenue, conversions and ROAS.
- 7 listings
- Updated weekly
- Editor reviewed
Platforms
Showing 7 platforms
dbt
Data transformation platform for analytics engineering teams.Integrates with AI2 views
Soda
Data quality platform for detection and prevention.Integrates with AI2 views
Alteryx
Automate data workflows, reduce manual work, and deliver trusted AI insights for enterprise teams.Integrates with AIdata governanceworkflow automation1 view
DataForm
Free SQL-based service for developing and operationalizing scalable data transformation pipelines in BigQuery.Integrates with AI1 view
Great Expectations
GX Core is an open source framework for testing, validating, and documenting data quality across modern data pipelines.data pipelinesdata qualityopen source1 view
KNIME
Free and open source with all your data analysis tools.data analysisdata scienceopen source1 view
Datameer
Low-code data transformation and pipeline automation built natively inside Snowflake for teams.Composable / warehouse-native0 views
MCP servers in this category
4 of 7 Data Transformation & Modelling tools offer an MCP server, so AI assistants such as Claude, ChatGPT and Cursor can read their data and act in them. All marketing tools with an MCP server
- AlteryxAlteryx MCP Server(vendor page, opens in a new tab)Checked Oct 2026
- DataFormDataform MCP server(vendor page, opens in a new tab)Checked Oct 2026
- dbtdbt MCP server(vendor page, opens in a new tab)Checked Oct 2026
- SodaSoda MCP(vendor page, opens in a new tab)Checked Oct 2026