JMP away from cumbersome Excel workbooks
February 12, 2018

JMP away from cumbersome Excel workbooks

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Software Version

Other

Overall Satisfaction with JMP Statistical Discovery Software from SAS

JMP is being used to track a wide array of real-time production data at our biotech company. It is currently used by one department (technical operations) in order to quantify failures and track efficiencies with regard to our production processes. These include sales rates/times, creating survival curves, organizing multivariable processes, addressing multicollinearity, technician efficiencies and other aspects of our production. It mainly serves as a conduit to create quick snapshots of overall production efficiency that have replaced cumbersome Excel spreadsheets, as JMP can process basic graphs easier and faster than Excel.
  • JMP has "drag and drop" graph building functions that can filter variables and make adjustments instantaneously.
  • JMP has its own scripting language that can link to an Excel spreadsheet and instantaneously create report-outs
  • There is a low overall learning curve, especially if you are familiar with other statistical programs or more advanced Excel functions
  • Huge support network and prompt response time from SAS. Also, many third party JMP experts that can help you create report outs or write more complicated scripts.
  • It would be nice if JMP had multiple sheets in order to create graphs from pivot tables.
  • The overall aesthetic is pretty weak, compared to Excel, especially if you are trying to make a more polished presentation
  • Changing variables in the graph builder can cause you to lose your formatting, which can be annoying and time-consuming if you make a mistake
  • JMP has sped up almost all of the report-outs we were creating from Excel. Once the script is written, you won't have to do anything besides update your database(s).
  • JMP really makes you concatenate column information. It definitely makes everything faster as soon as you understand how to organize your initial data table.
  • Some graphs from Excel (especially time to survival) are quite difficult to censor and separate multivariate data, so you probably won't be able to get rid of Excel completely.
I have only used STATA as a statistical package, and they are completely different tools. JMP has a much better layout and ease of use, but may not be as powerful as STATA for advanced processes. Overall speed and ease of use makes it like a combination of ms excel and stata together.
JMP is great for crunching huge datasets, especially if you are overloading your Excel workbook. You can have JMP communicate directly with Excel or FileMaker because it has its own scripting language, so you can basically have report at the click of a button. If you are into formatting and pretty graphs, JMP does not include a ton of aesthetic functionality. The drag and drop graph building function allows you to filter out variables easily and change the look of your graph, but can be confusing at times even when you are trying to create simple graphs. Overall it is a great tool to crunch a lot of data without lag.

JMP Statistical Discovery Software from SAS Feature Ratings

Pre-built visualization formats (heatmaps, scatter plots etc.)
8
Location Analytics / Geographic Visualization
10
Predictive Analytics
9
Customizable dashboards
6
Drill-down analysis
9
Formatting capabilities
6
Integration with R or other statistical packages
9
Report sharing and collaboration
7
Publish to Web
10
Publish to PDF
10

JMP Statistical Discovery Software from SAS Support

The SAS support team came on site to give a presentation to our entire team. They answer questions immediately and provide insight specific to your needs. They also provided a video conference to get me started with the software, which was really useful. There are textbooks written on scripting and JMP usage, which were provided to me as well.
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
No escalation required
Immediate help available
Support cares about my success
Quick Initial Response
Not kept informed
Every aspect of my communication with SAS has been outstanding. They really want you to succeed and prove it by providing the user with multiple opportunities to meet one on one with their staff.