The Alteryx AI Platform gives organization automated data preparation, AI-powered analytics, and machine learning with embedded governance and security. Its self-service functionality, with self-service data prep, machine learning, and AI-generated insights, gives enterprise teams with a simplified user experience allowing everyone to create analytic solutions that improve productivity, efficiency, and the bottom line. Alteryx Designer can be used to automate every analytics step…
$14,850
per year 3 users (minimum), cloud edition
Azure Synapse Analytics
Score 7.7 out of 10
N/A
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
$4,700
per month 5000 Synapse Commit Units (SCUs)
Pricing
Alteryx Platform
Azure Synapse Analytics
Editions & Modules
Designer Desktop
starting at $5,195
per year per user
Designer Cloud Professional Edition
Starting at $4,950
per year per user (minimum of 3 users)
Tier 1
$4,700
per month 5,000 Synapse Commit Units (SCUs)
Tier 2
$9,200
per month 10,000 Synapse Commit Units (SCUs)
Tier 3
$21,360
per month 24,000 Synapse Commit Units (SCUs)
Tier 4
$50,400
per month 60,000 Synapse Commit Units (SCUs)
Tier 5
$117,000
per month 150,000 Synapse Commit Units (SCUs)
Tier 6
$259,200
per month 360,000 Synapse Commit Units (SCUs)
Offerings
Pricing Offerings
Alteryx Platform
Azure Synapse Analytics
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Alteryx Platform
Azure Synapse Analytics
Considered Both Products
Alteryx Platform
Verified User
Executive
Chose Alteryx Platform
Alteryx stacks up against its competitors in the marketplace because from day one its goal was to simplify and democratize data processes. Its visual nature and transparent tool set, combined with its highly addictive joy to use make it stand out from the crowd.
I would 100% recommend Alteryx to a friend, for me its friendly interface is the best, it has all the tools I need without the headache that programming is. It can be used for simple or complex analysis, so honestly, I don’t see a scenario where it wouldn’t suit. I’ve used Alteryx to make simple things I could do in Excel, for example, but it was less complex and faster to do in Alteryx, so why not? Its a very versatile tool.
It's well suited for large, fastly growing, and frequently changing data warehouses (e.g., in startups). It's also suited for companies that want a single, relatively easy-to-use, centralized cloud service for all their data needs. Larger, more structured organizations could still benefit from this service by using Synapse Dedicated SQL Pools, knowing that costs will be much higher than other solutions. I think this product is not suited for smaller, simpler workloads (where an Azure SQL Database and a Data Factory could be enough) or very large scenarios, where it may be better to build custom infrastructure.
Pulling data from multiple disparate data sources.
Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.
Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
Steeper Learning Curve: Alteryx can have a steep learning curve for users who are new to the platform or have limited experience with data analytics. Enhancements to the user interface and user onboarding resources could help make the learning process more intuitive and accessible to a wider range of users.
Enhanced Data Visualization Capabilities: Alteryx offers basic data visualization capabilities, but there is room for improvement in terms of advanced visualizations and interactive dashboarding features. Adding more sophisticated chart types, interactive widgets, and customization options would enhance the data visualization capabilities within the platform.
Improved Error Handling and Debugging: Alteryx provides error handling mechanisms, but enhancing the error reporting and debugging capabilities would be beneficial. Improved error messages, better visibility into data flow, and debugging tools could help users troubleshoot and resolve issues more efficiently.
With Azure, it's always the same issue, too many moving parts doing similar things with no specialisation. ADF, Fabric Data Factory and Synapse pipeline serve the same purpose. Same goes for Fabric Warehouse and Synapse SQL pools.
Could do better with serverless workloads considering the competition from databricks and its own fabric warehouse
Synapse pipelines is a replica of Azure Data Factory with no tight integration with Synapse and to a surprise, with missing features from ADF. Integration of warehouse can be improved with in environment ETl tools
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
I already gave the example of journal entries created in less than a second. What else can I tell you about.... I can tell you those 2 journal entries have historically had to be split into separate accounting systems so the outputs had to be very different (D365 vs Intacct) such that they are exactly ready for uploading. I can tell you I used to have some tire and battery queries hitting a line item detail table and they took hours to run UNTIL I asked IT for a view in SQL and now they're ready in about 5 minutes total. I guess I'd say if anything does take a long time - do some research with others and figure out what would speed them up
Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person
Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.
In comparing Azure Synapse to the Google BigQuery - the biggest highlight that I'd like to bring forward is Azure Synapse SQL leverages a scale-out architecture in order to distribute computational processing of data across multiple nodes whereas Google BigQuery only takes into account computation and storage.
Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.
Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
Product development - allowed my firm to create products that we have been able to market and sell to clients.
Licensing fees is replaced with Azure subscription fee. No big saving there
More visibility into the Azure usage and cost
It can be used a hot storage and old data can be archived to data lake. Real time data integration is possible via external tables and Microsoft Power BI
