Best Data Transformation & Modeling Tools

“Tools for cleaning, structuring, and modeling data after it lands in the warehouse. SQL-based transformation, semantic layers, and data modeling frameworks.”

9 tools reviewed

9 results

dbt (data build tool)

Industry-standard SQL transformation framework for analytics engineering

FreemiumOpen SourceSQLAnalytics engineering+2

Best for Best for analytics engineering teams wan...

SQLMesh

Scalable SQL transformation framework — dbt-compatible alternative

Open SourceOpen SourceSQLVirtual environments+1

Best for Best for analytics engineers wanting sof...

Coalesce

Visual data transformation platform with column-level lineage

PaidVisualColumn Level lineageTemplates+1

Best for Best for enterprise teams wanting visual...

Dataform (Google)

SQL-based data transformation natively integrated with BigQuery

FreeGCPBigQuerySQL+1

Best for Best for BigQuery-only teams wanting fre...

Prophecy

Visual data transformation platform for Spark and SQL

FreemiumVisualLow CodeSpark+2

Best for Best for enterprise teams wanting visual...

Malloy

Experimental semantic modeling language for analytical queries

Open SourceOpen SourceSemantic modelingGoogle+1

Best for Best for forward-thinking teams explorin...

Alteryx

No-code data preparation and analytics automation platform

PaidNo CodeVisualData preparation+2

Best for Best for business analysts wanting self-...

Cube

Universal semantic layer for data applications

FreemiumSemantic layerOpen SourceMetrics+1

Best for Best for teams wanting consistent metric...

AtScale

Enterprise semantic layer for cloud analytics

Custom PricingSemantic layerEnterpriseOLAP+1

Best for Best for enterprises wanting OLAP-like s...