Alteryx Platform vs. Pentaho

We're trying right now to get more people using it at our company so we can send management documented cases for how we can expand and purchase Alteryx Server which will extend the capabilities even more and across more departments. It's been well suited for pretty much everything we do on a repeating schedule. It's worth the time to set up the workflows. When Treasury sends me the bank download now - I save it to a folder and run our workflows and send back 2 journal entries in .9 seconds. (yes - in less than a second it's finished running)

Incentivized

Pentaho is very well suited to perform data extraction & data mining from various cloud storage & transform that data using various available data models. However, the software struggles when it comes to visualizing the extracted data in an appealing manner & can be difficult for end-users to get an understanding of data tables created using those models.

Incentivized

• 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.

• Integrate and synchronize with big data easily
• Import data from any sources and different databases
• Managing data in on-premise, hybrid and cloud environments.
• Compatibility and flexibility of the platform with any type of scenario and any business or industry
• Various tools in the software suite to transformation of data
• Simple interface appearance and creative UI graphics

• 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.

Incentivized

• I think the relative obscurity of the tool is a downside, not as many developers, consultants or peers you can tap into.
• Lack of a solid user community held us back, looking at Power BI and Qlik, they have huge user communities that help each other out. Would have liked that here.
• Smaller company means smaller sales force, and the lack of a local presence made it hard to only interact online with the account rep. Other companies have someone local who often stops by with pre-sales developers to just pitch in free of charge when they have time.

Incentivized

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 will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration

Incentivized

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.

Incentivized

Even if Pentaho requires less technical skills to develop a pipeline or ETL project, its learning curve can be a bit slow since there are many ways to do the same thing as in any other platform. However, in Pentaho, some things can be confusing some moments for non-technical teams.

Incentivized

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.

Alteryx is an extremely reliable platform. If there is an error in my workflow, I feel pretty strongly it was probably my fault. The platform also handles large amounts of data very quickly and can join/match, sort, filter, calculate on that data quickly as well. One of my favorite things to build into a workflow are the messages based on data/metadata and error messages based on errors I have come across before.

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

Incentivized

We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small. As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract. Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found. They really are TOP-NOTCH.

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

Incentivized

Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...

Incentivized

Course Taken: DI1000 Pentaho Data Integration Fundamentals Setup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The Course The 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000

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.

Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework. Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set. Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.

Incentivized

I used ACL before so all my scripts were written in SQL and it was not low code at all. After me and my team started using Alteryx, we moved all the scripts to workflows in Alteryx, it took some time, but works way better than ACL, it is faster and easier to maintain it any changes have to be done.

Incentivized

Perhaps Snowflake and SalesForce have some components which align with the Pentaho tools. The Pentaho tools have integrations with these technologies to add more value to the final users. Perhaps the only weakness I can honestly find in the Pentaho tools right now is the lack of a powerful web interface for data transformations. There is a web component from which you can access existing data transformations created with the Pentaho Data Integration tool. Still, the web component only allows visualization of the data transformation and remote execution. A complete web interface with remote execution would be excellent, and I'm sure that we might see something like this available at some point in the future.

Incentivized

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.

Incentivized

• Pentaho has improved our overall business process.
• Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
• We have a started a big project using Pentaho that is going to include all the business processes in the organization.

Incentivized