JMP away from cumbersome Excel workbooks
February 12, 2018
JMP away from cumbersome Excel workbooks
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 Statistical Discovery Software from SAS Feature Ratings
JMP Statistical Discovery Software from SAS Support
Pros | Cons |
---|---|
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.