G2 Vendor Directory

Power Query vs. dbt

A side-by-side comparison based on G2 review data.

MetricPower Query

by Microsoft

dbt

by Fivetran

Overall rating4.54.7
Review count17209
Ease of use9.19.1
Ease of setup8.88.8
Quality of support8.89.0
Meets requirements8.89.3
NPS58.82352981.25
Small Business29.4%27.1%
Mid-Market52.9%56.5%
Enterprise17.6%16.4%
Total page views197780
Total LLM citations5384,329

Power Query

Every company has a mission. What's ours? To empower every person and every organization to achieve more. We believe technology can and should be a force for good and that meaningful innovation contributes to a brighter world in the future and today. Our culture doesn’t just encourage curiosity; it embraces it. Each day we make progress together by showing up as our authentic selves. We show up with a learn-it-all mentality. We show up cheering on others, knowing their success doesn't diminish our own.

Pros

  • Time-saving
  • Intuitive
  • Simple
  • Solution Efficiency
  • Automation
  • Ease of Use

dbt

dbt is a transformation workflow that lets data teams quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone who knows SQL can build production-grade data pipelines.

Pros

  • Ease of Use
  • Features
  • Automation
  • Transformation
  • Productivity Improvement
  • Data Quality