Likelihood to Recommend The product is especially useful when you have real-time and/or time series data to analyze. If you have more mundane, simpler requirements, other products might do the job you need for less money (there are even some decent open source visualization tools you can find.) I know the product is very widely used in capital markets applications to monitor and analyze risk and price and volume changes; if you're working in that area, I don't think there's a better tool to use.
Read full review Paxata can be highly useful to someone who doesn't like/have any experience with writing codes to treat data before using it as input into BI dashboards. Paxata can accelerate data cleaning in environments where a large amount of unclean data is generated and business decisions on the go are required. It performs really well while dealing with natural language.
Read full review Pros Creating a basic model to extract data from a report is very easy. Advanced features like Calculated Fields and External Lookups allow you to augment the raw data. You can create a "project" to automate the data extraction. Combined with Datapump (a separate DW app), you can fully automate the process once the raw report is generated. Read full review Visualize distributions in large data sets effectively which enable the user to quickly spot outliers and treat them appropriately Provides recommendation to merge datasets based on matching column values The cluster and edit feature in my opinion is its most powerful feature and reduces cardinality in column with text Read full review Cons Recently, we had some major sticker-shock when we wanted to upgrade Data Pump. It is an exceptional product, but when the price jumped from $6,000 to over $60,000, it was impossible to get the funds approved internally for the upgrade. We also paid for yearly maintenance contracts which included Professional Services, but rarely found those services beneficial. However, we did receive all software upgrades for Datapump as part of the contract which we found to be very beneficial. However, with the new pricing, that is not longer the case. Read full review Doesn't provide recommendation on how to impute values There is a lag quite often We can say whether a column has errors or quality issues in the first look Read full review Likelihood to Renew Even though we do not utilize it on a daily basis, I do hope my current company renews it's license. If not, I intend to purchase myself.
Read full review Alternatives Considered Datawatch is very good value of money compared to QlikView; QlikView is really more of a BI tool and has a lot of functions that I didn't need. Datawatch is very strong in the real-time area where Tableau, Panorama, and Qlik don't do very well. If you need to set up a visual monitoring dashboard, Datawatch is the best product I've seen for that. if you want to do a lot of in depth statistical analysis of large databases, Tableau is probably a good option.
Read full review Paxata is a much better tool when it comes to handling natural language but
Talend provides recommendations on how to impute missing values and outliers. Paxata provides recommendations on dataset tie-ups and joins but
Talend doesn't provide any such recommendations. In paxata you can visualize distribution of data in a column and filter them by dragging and selecting the section you'd like to retain
Read full review Return on Investment Data Pump reduces complexity of report solutions by offering a standardized approach for organizing and scheduling 97% service level for past 5 years for all of our jobs going through Data Pump Read full review It saves time to clean data It reduces the requirement of too many data engineer/stewards and hence adds positive impact on the return of the business Read full review ScreenShots Altair Monarch Screenshots