Azure Data Factory vs. Tableau Prep

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 8.2 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 8.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
Top Pros
Top Cons
Features
Azure Data FactoryTableau Prep
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
9.1
7 Ratings
9% above category average
Tableau Prep
-
Ratings
Connect to traditional data sources9.17 Ratings00 Ratings
Connecto to Big Data and NoSQL9.07 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.5
7 Ratings
3% above category average
Tableau Prep
-
Ratings
Simple transformations9.17 Ratings00 Ratings
Complex transformations7.97 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.5
7 Ratings
7% below category average
Tableau Prep
-
Ratings
Data model creation8.25 Ratings00 Ratings
Metadata management7.26 Ratings00 Ratings
Business rules and workflow7.27 Ratings00 Ratings
Collaboration6.56 Ratings00 Ratings
Testing and debugging7.27 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.6
7 Ratings
9% below category average
Tableau Prep
-
Ratings
Integration with data quality tools7.27 Ratings00 Ratings
Integration with MDM tools8.07 Ratings00 Ratings
Best Alternatives
Azure Data FactoryTableau Prep
Small Businesses
Skyvia
Skyvia
Score 9.7 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Data FactoryTableau Prep
Likelihood to Recommend
9.2
(7 ratings)
9.0
(7 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(1 ratings)
Usability
-
(0 ratings)
7.0
(1 ratings)
Support Rating
7.0
(1 ratings)
5.3
(3 ratings)
Implementation Rating
-
(0 ratings)
6.0
(1 ratings)
User Testimonials
Azure Data FactoryTableau Prep
Likelihood to Recommend
Microsoft
Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
Read full review
Tableau
If your data sets are coming in without much stewardship then Tableau Prep can help to clean the data before you start trying to create visualizations for your end users. You will save a lot of time this way - rather than seeing problems once you are creating dashboards. If you don't have large data sets or your data is relatively simple, then Tableau Prep may not be needed.
Read full review
Pros
Microsoft
  • It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination.
  • We can use linked service in multiple pipeline/data load.
  • It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool.
Read full review
Tableau
  • Display the raw data coming in from the data warehouse
  • Point out situations that might be erroneous
  • Show the distribution of raw data figures
Read full review
Cons
Microsoft
  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Read full review
Tableau
  • Use of Macros within Workflow (and more types of automation)
  • Join Editor also giving a SQL Update Query
  • More types of visuals
Read full review
Likelihood to Renew
Microsoft
No answers on this topic
Tableau
It is a valuable tool for generating and cleaning files for multiple purposes.
Read full review
Usability
Microsoft
No answers on this topic
Tableau
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.
Read full review
Support Rating
Microsoft
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
Read full review
Tableau
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.
Read full review
Implementation Rating
Microsoft
No answers on this topic
Tableau
Live connections to cloud services (Google Sheets for example) and cloud hosted databases (cloud hosted SIS for example) for scheduled flows are not supported
Read full review
Alternatives Considered
Microsoft
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.
Read full review
Tableau
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 working with the same data. The extracts produced by Prep allow several workbooks to be working from the same data set-up without any additional work, saving time and stress.
Read full review
Return on Investment
Microsoft
  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Read full review
Tableau
  • 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)
Read full review
ScreenShots