

Alteryx and dbt both serve the data transformation niche, but their distinct approaches set them apart. Alteryx stands out for its comprehensive features and automation, catering to a broad range of user needs. In contrast, dbt is noted for SQL-focused transformations and efficient data processing.
Features: Alteryx offers advanced analytics capabilities with its user-friendly drag-and-drop interface, coupled with extensive data connectivity and seamless integrations. dbt, on the other hand, focuses on SQL-based transformations with robust testing frameworks and superior data lineage, supported by Jinja templating for streamlined data processing.
Room for Improvement: Alteryx could benefit from enhancing its database connections and reporting tools, as well as improving cloud deployment options. dbt is encouraged to expand Python support and include more comprehensive data ingestion tools, along with refining its debugging features to enhance reliability.
Ease of Deployment and Customer Service: Alteryx supports both on-premises and cloud deployments, offering flexibility and strong community support, though response times can vary. dbt deploys in public and on-premises clouds, backed by robust community resources, albeit with some stability concerns noted by users.
Pricing and ROI: Alteryx is considered expensive, with licensing costs impacting scalability, justified by workflow efficiency and reduced data preparation time. dbt enjoys cost-efficiency with its open-source core modules, offering favorable ROI through streamlined ETL processes and effective project delivery.
Tasks that earlier took hours in Excel or SQL are now completed in minutes.
From a time-saving perspective, we saved 60 to 75 percent of the human workforce needed and eliminated other disparate ETL tools, ultimately saving us over 600,000 dollars.
Alteryx helps familiarize managers with artificial intelligence-driven possibilities.
There is operational efficiency achieved, and data quality and governance have also been achieved with modular SQL and version controlling, which reduced duplication of data and data errors.
I have seen a return on investment as it means we don't have to employ as many people.
Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh.
Customer support from Alteryx has been amazing.
they do have a website for resolving doubts and accessing helpful resources, including various tools and filters.
I contacted customer support once or twice, and they were quick to respond.
If you type your question, you will likely find that someone has already asked it, so we do not need to contact their support directly.
I would rate the technical support a nine out of ten.
We ran dbt Core, which is open-source, so there is no direct vendor support.
Alteryx is scalable for most enterprise analytics and data preparation workloads.
Suggestions for improvements in Alteryx include areas for increasing efficiency, particularly in processing telemetry data, which involves dealing with large volumes of unstructured data.
Alteryx is scalable, and I would give it eight out of ten.
The bottlenecks that we have are not coming from dbt; they are coming from Snowflake.
We were processing large volumes of financial documents, hundreds of trial balances, balance sheets, and invoice sets, and dbt handled the transformation layer without issues.
dbt is quite scalable since it has its own feature set for incorporating business logic.
I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
I have not encountered any lagging, crashing, or instability in the system during these three months of usage.
Alteryx is a reliable tool, but it is also very heavy, requiring good laptop configurations, a minimum of 8GB RAM, and a recent processor such as i10.
Comparing it to tools I have seen in the past, such as Informatica and Alteryx, dbt can easily match up to that rating, specifically for stability.
Every upgrade is a little bit of a risk for us because we do not know if the workarounds that we developed will be available for the next version.
When I conduct dbt tests, the data processed in the data warehouse performs exactly as expected.
The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections.
The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system.
The additional features that Alteryx needs to work on to make it more competitive include better collaboration and easier integration through API.
Improvement is needed in the tool itself in terms of the copilot, in terms of covering outages, in terms of testing, and in terms of quality reasons related to governance and collaboration.
The whole data testing field is not very mature. It is not the same as software testing; for example, you have test suites, test tools, and profilers, but for data testing, it is not yet that advanced.
dbt does not have a native concept of multi-tenant or multi-standard project organization.
The price is very high, with licensing typically starting around five thousand dollars plus user per year.
We found excellent use cases for automation through Alteryx, which provided the means to reduce operational costs and streamline the build of ETL pipelines without extensive coding.
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
The course content that dbt provides is free and excellent for anyone starting out.
dbt is open source for its core modules.
I mentioned the cost as one of the advantages, specifically the license cost.
Alteryx not only represents data but also supports decision-making by suggesting the next steps.
Analysts who do not have any coding experience can still work on the transformation and preparation of data, which is quite useful.
Alteryx includes built-in tools such as drive time analysis and linear regression, which are much harder to achieve in standard BI tools such as Power BI or Tableau.
dbt has positively impacted my organization by allowing us to create our data pipelines much faster, going from ingestion of data to creating a data product in weeks instead of months.
There are the benefits of having code, so you have a software development lifecycle; you can use version control, testing, and documentation.
The tests, especially custom tests for financial data like validating that debits equal credits, caught a lot of our data quality issues early.
| Product | Mindshare (%) |
|---|---|
| Alteryx | 1.2% |
| dbt | 1.4% |
| Other | 97.4% |


| Company Size | Count |
|---|---|
| Small Business | 46 |
| Midsize Enterprise | 20 |
| Large Enterprise | 73 |
| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 3 |
| Large Enterprise | 6 |
Alteryx enhances efficiency by automating data preparation and transformation through a user-friendly drag-and-drop interface, catering to non-technical users and business professionals. It supports data blending, predictive analytics, and diverse data integration capabilities.
Alteryx streamlines data manipulation and complex transformations, benefiting industries such as finance and marketing with its ability to connect to multiple data sources and automate workflows. The platform supports analytics and machine learning model building, reducing manual efforts in ETL processes. Despite its capabilities, improvements are needed in database connectivity, pricing flexibility, and cloud service integration. Users desire enhancements in reporting features, visualization, and technical support to optimize its full potential. Machine learning and predictive analytics features require advancements to improve user experience and broaden accessibility through better connectors and reduced licensing costs.
What are Alteryx's key features?
What benefits and ROI should be looked for in reviews?
In finance and marketing, organizations leverage Alteryx to automate data tasks, connect diverse sources, and generate analytics models and dashboards efficiently. Its no-code approach aids in rapid data preparation, cleansing, and analysis, empowering business users to engage in predictive and prescriptive analytics effectively.
dbt is a transformational tool that empowers data teams to quickly build trusted data models, providing a shared language for analysts and engineering teams. Its flexibility and robust feature set make it a popular choice for modern data teams seeking efficiency.
Designed to integrate seamlessly with the data warehouse, dbt enables analytics engineers to transform raw data into reliable datasets for analysis. Its SQL-centric approach reduces the learning curve for users familiar with it, allowing powerful transformations and data modeling without needing a custom backend. While widely beneficial, dbt could improve in areas like version management and support for complex transformations out of the box.
What are the most valuable features of dbt?
What benefits should you expect from using dbt?
In the finance industry, dbt helps in cleansing and preparing transactional data for analysis, leading to more accurate financial reporting. In e-commerce, it empowers teams to rapidly integrate and analyze customer behavior data, optimizing marketing strategies and improving user experience.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.