TrustRadius

Azure Data Factory vs. Tableau Prep

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 8.9 out of 10
N/A
Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.N/A
Tableau Prep
Score 7.6 out of 10
N/A
Tableau Prep enables users to get to the analysis phase faster by helping them quickly combine, shape, and clean their data. According to the vendor, a direct and visual experience helps provide users with a deeper understanding of their data, smart features make data preparation simple, and integration with the Tableau analytical workflow allows for faster speed to insight. Tableau Prep allows users to connect to data on-premises or in the cloud, whether it’s a database or a…
$15
per month billed annually per user
Pricing
Azure Data FactoryTableau Prep
Editions & Modules
No answers on this topic
Viewer
$15
per month billed annually per user
Explorer
$42
per month billed annually per user
Creator
$70
per month billed annually per user
Offerings
Pricing Offerings
Azure Data FactoryTableau Prep
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Azure Data FactoryTableau Prep
Considered Both Products
Azure Data Factory
Verified User
Anonymous
Chose Azure Data Factory
Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a …
Rajarshi Maitra PMI™- ASM®, ACP® and CAPM® | TrustRadius Reviewer
Rajarshi Maitra PMI™- ASM®, ACP® and CAPM®
Director/Client Engagement Leader- P&C Insurance (Digital Transformation)
Chose Azure Data Factory
Azure Data Factory helps us automate to schedule jobs as per customer demands to make ETL triggers when the need arises. Anyone can define the workflow with the Azure Data Factory UI designer tool and easily test the systems. It helped us automate the same workflow with …
Niloofar Keshvari Nia | TrustRadius Reviewer
Niloofar Keshvari Nia
IT Operations and Support Specialist
Chose Azure Data Factory
The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Marco Urrea | TrustRadius Reviewer
Marco Urrea
DevOps Engineer
Chose Azure Data Factory
I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.
Verified User
Anonymous
Chose Azure Data Factory
Azure Data Factory is a relatively new player in the space, and its feature set marks it as such. It does not have the full features of a more mature product set such as any of the above. However, it does allow for the creation of ETL/ELT flows/pipelines with minimal initial …
Tableau Prep
Verified User
Anonymous
Chose Tableau Prep
Tableau Prep is a good tool to use in tandem with Tableau. You can use Tableau by just plugging in an excel sheet or other form of dataset, but the tools that Tableau Prep has specifically makes the data set work better with Tableau. The extra time to optimize is worth it.
Verified User
Anonymous
Chose Tableau Prep
Tableau Prep is covered in our license whereas Alteryx required additional fees and a separate license. Tableau Prep is similar to Tableau Desktop which a lot of our team is comfortable with so it wasn't difficult to get a feel for Tableau Prep. However, Alteryx would have been …
Verified User
Anonymous
Chose Tableau Prep
Selected Tableau Prep because it came with out Tableau license.
Verified User
Anonymous
Chose Tableau Prep
We use both Tableau Prep and Alteryx and, although Tableau Prep integrates better with Tableau desktop, I find that more often then not I open up Alteryx to do most of my data prep prior to bringing my data into analysis as it is just so much more robust. Not that this makes …
Verified User
Anonymous
Chose Tableau Prep
Before Prep, we had to do all the data joining and connecting in a Tableau Workbook. Not only did this cause workbooks connected with live data to run frustratingly slowly, a new connection and set-up had to be established every time a new workbook as created, even if you were …
Features
Azure Data FactoryTableau Prep
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
9.0
Ratings
7% above category average
Tableau Prep
-
Ratings
Connect to traditional data sources9.00 Ratings00 Ratings
Connecto to Big Data and NoSQL9.00 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.5
Ratings
4% above category average
Tableau Prep
-
Ratings
Simple transformations9.00 Ratings00 Ratings
Complex transformations8.00 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.2
Ratings
10% below category average
Tableau Prep
-
Ratings
Data model creation8.00 Ratings00 Ratings
Metadata management7.00 Ratings00 Ratings
Business rules and workflow7.00 Ratings00 Ratings
Collaboration6.00 Ratings00 Ratings
Testing and debugging7.00 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.5
Ratings
8% below category average
Tableau Prep
-
Ratings
Integration with data quality tools7.00 Ratings00 Ratings
Integration with MDM tools8.00 Ratings00 Ratings
Best Alternatives
Azure Data FactoryTableau Prep
Small Businesses
Skyvia
Skyvia
Score 9.9 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.1 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Data FactoryTableau Prep
Likelihood to Recommend
9.0
(0 ratings)
9.0
(0 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(0 ratings)
Usability
-
(0 ratings)
7.0
(0 ratings)
Support Rating
7.0
(0 ratings)
5.3
(0 ratings)
Implementation Rating
-
(0 ratings)
6.0
(0 ratings)
User Testimonials
Azure Data FactoryTableau Prep
Likelihood to Recommend
In a data pipeline, you will be able to add different kinds of activities for example connect from your on-premise SFTP and move CSV files to storage accounts. As well data factory has its own data flow if you are an ETL developer who experimented with maybe you have worked with SSIS, thus, you will start quickly with this new feature of the data factory.
Rajarshi Maitra | TrustRadius Reviewer
Rajarshi Maitra
Director/Client Engagement Leader- P&C Insurance (Digital Transformation)
Read full review
Tableau Prep is a very powerful tool when it comes to creating workflows to monitor each stage for data analysis and quality issues. Also, it is convenient to explore the data with the wealth of operators and checking work at each stage of the process. Also, some areas that would help is if there are more types of automation provided.
Verified User
Anonymous
Read full review
Pros
  • Creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code.
  • Hybrid data integration is easily and agilely possible through this software.
  • It has lot of various useful components
Niloofar Keshvari Nia | TrustRadius Reviewer
Niloofar Keshvari Nia
IT Operations and Support Specialist
Read full review
  • Display the raw data coming in from the data warehouse
  • Point out situations that might be erroneous
  • Show the distribution of raw data figures
Verified User
Anonymous
Read full review
Cons
  • Learning curve for pipeline creation interface.
  • Alerting isn't necessarily built in. Had to work around this to meet team needs.
  • With GIT enabled, some features can only be done via git, while some need to be done via the portal.
Verified User
Anonymous
Read full review
  • Use of Macros within Workflow (and more types of automation)
  • Join Editor also giving a SQL Update Query
  • More types of visuals
Verified User
Anonymous
Read full review
Likelihood to Renew
No answers on this topic
It is a valuable tool for generating and cleaning files for multiple purposes.
Verified User
Anonymous
Read full review
Usability
So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.
Verified User
Anonymous
Read full review
It works well and is user friendly for the basics but needs more options for bring in data (using SQL queries for example) and export format options.
Verified User
Anonymous
Read full review
Support Rating
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Verified User
Anonymous
Read full review
I have not really had to reach out for any kind of customer support for Tableau Prep, so I can't really say. However, the support that Tableau has given for their other products has been great, so I would assume it would be the same here. They are also constantly adding new features and providing software updates, and that is always a plus.
Verified User
Anonymous
Read full review
Implementation Rating
No answers on this topic
Live connections to cloud services (Google Sheets for example) and cloud hosted databases (cloud hosted SIS for example) for scheduled flows are not supported
Verified User
Anonymous
Read full review
Alternatives Considered
Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a visual interface for designing ETL workflows, but our team found Azure Data Factory's interface more intuitive.
Verified User
Anonymous
Read full review
Tableau Prep is covered in our license whereas Alteryx required additional fees and a separate license. Tableau Prep is similar to Tableau Desktop which a lot of our team is comfortable with so it wasn't difficult to get a feel for Tableau Prep. However, Alteryx would have been a totally new platform.
Verified User
Anonymous
Read full review
Return on Investment
  • Limiting the amount of data moving up and down from the cloud for cloud-native applications.
  • Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.
Verified User
Anonymous
Read full review
  • Quicker data sets for online reports
  • More efficient data cleaning Ad Hoc reports
  • Costly if using data management to schedule data pull and cleaning (priced per viewer accounts not creator accounts)
Verified User
Anonymous
Read full review
ScreenShots