JMP® is statistical analysis software with capabilities that span from data access to advanced statistical techniques, with click of a button sharing. The software is interactive and visual, and statistically deep enough to allow users to see and explore data.
$1,320
per year per user
Toad Data Point
Score 7.9 out of 10
N/A
Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and workflow automation.
Many organizations have seen their analytical capabilities, and the results from them, plateau. Of these, we've observed, that most of them didn't appreciate that they could do (even) better. These companies should definitely consider JMP. Any company that is research-based can benefit from accelerating their research, learning more in less time, effort and cost, with JMP's tools. Basically, any organization that is hungry enough for improvement to seek out better ways is suitable for JMP. Those who are happy with their current performance are not likely to consider the changes, though they were not major impediments by our clients, required.
Toad Data Point is the clear tool of choice if the end-user is interested in reports that are relatively simple to build using SQL code and export to Excel. It is less useful if the analyst also needs to run statistical models on the data and visualize the data for those functions I usually use RStudio or Jupyter Notebook which incorporates those features much more seamlessly.
I've mentioned this earlier, but the licensing agreements are very prohibitive. I work with a company where my role has become less and less doing my own analytics and more and more trying to help other people in that role. As we are bringing more people "up to speed" it's hard to justify licenses for 2-3 people when they aren't full time, Six Sigma black belts just looking at stats all day. A floating license option would make this a no-brainer, since these people could continue their other work and add JMP usage as they grow their skills, but this is not something JMP/SAS has offered.
The GUI interface makes it easier to generate plots and find statistics without having to write code. The JSL scripting is a bit of a steep learning curve but does give you more ability to customize your analysis. Overall, I would recommend JMP as a good product for overall usability.
I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
The helpful tips are great for new users. I am always able to find solutions to a tool I am working with through the hep section. And my area has a users group that meets each quarter to share ideas and view upcoming JMP revisions.
We actually use both JMP and IBM SPSS, but I think JMP's complexity lends itself to more in-depth statistical analyses. SPSS is designed for that as well, but we tend to use it more for quicker analyses, and we have found that JMP is far more powerful.
TOAD excels at connecting to divergent data sources, but appears geared more to DBAs than to regular query users. Microsoft's offerings excel against Microsoft SQL Server, but sometimes struggle with other data sources. However, SSMS and vs code excel at many developer productivity/workflow enhancements. vs code, in particular, has a lively extension system that allows it to be tailored for development/querying/model building/etc. That flexibility comes at a cost - the learning curve is steep for new users. The tradeoff between complexity and power may not be good for some environments/users/situations.
JMP has resulted in literally millions of dollars in ROI due to identification of correctable errors.
Use of JMP control charts JMP has greatly simplified and improved interpretation of Lean, FMEA, and PDSA type analyses.
Use of JMP has enable the testing and subsequent selection of 'best practices' saving uncounted hours in false starts based on 'collective experience'.
The down side is that JMP is not a 'magic box', one still has to take care in applying the tools properly. Moreover, time-consuming approaches using JMP may still be the 'order of the day', because the service (even power user) is unaware of significant shortcuts available for free on the JMP community website.
It is the least common denominator - not particularly optimized for our environment or workflows.
Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.
