Frontline Systems Analytic Solver is an Excel add-on for performing data mining, and predictive analytics from within Microsoft Excel.
N/A
JMP Pro
Score 8.3 out of 10
N/A
JMP Pro offers all the capabilities of JMP, plus advanced features for more sophisticated analysis including predictive modeling and cross-validation techniques.
Based on my limited experience and use, and therefore limited global knowledge of the software, I would recommend it especially if the data that will be used as inputs to the model has previously worked on a spreadsheet such as Excel. I would also recommend it to analyze problems of medium and small size. Given the experience I have had when I have used it with large problems, there have been noticeable decreases in the speed of response (which are not associated with the size of the system of equations involved in the calculation). Excellent for processing linear programming models.
JMP Pro is perfectly suited for statistical analysis but users should have some statistical knowledge before using it since there may be some terms/functions in the software that are not widely used in other fields. No prior coding experience is needed to use JMP Pro. However, most people doing data processing would prefer to code their analysis.
I think the most awesome thing about JMP Pro is the Profiler component. The Profiler component makes sharing analyses interactive on the web using interactive HTML5. The Profiler makes showing the impact of interaction effects so easy. It's the best statistical software feature I think I've ever come across.
JMP Pro does dashboards well. It is relatively straight-forward to create four pane dashboards that automatically update. I think it's nice.
I think JMP Pro graphics are a massive improvement when compared to the graphics produced by its parent company - SAS. JMP Pro's features are vast, and easy to use and understand.
On the few occasions when I have used it to deal with problems of optimization of relatively large parameters (with a large number of restrictions and decision variables), the program has been slower, not substantially but slower, than programs such as the WinQsb, even when the latter runs on 32-bit machines and not 64. That has caught my attention, even though it is not a real problem for the uses I give to the program.
Given my partial function as a university professor, it has been much more effective and practical to use other software, due to the limited options that the educational license associated with the software has.
We believe in building the models in Excel. A limitation with Excel is that Excel Solver can not take more than 200 decision variables with multiple constraints. It is cheap in terms of license and maintenance fees against other softwares which are available in the market.
The intuitive interface JMP Pro offers is more interactive than R studio, but since coding is not required in JMP Pro, programming analysis in R studio is more convenient in some aspects. JMP Pro is able to quickly analyze multiple variables and produce reasonable outputs and models, which is valuable for users doing data analysis.
- It has allowed finding ways to optimize (minimizing costs or times) the field processes involved in various projects.
It has even allowed, in specific cases where it was used for that purpose, to optimize the allocation of resources (people) to work in different jobs that present weekly variations of the activity that these people must perform.
It has allowed the sensitivity analysis of projects to changes in the decision variables related to them, which, and in very dynamic and changing environments, resulted in substantial decreases in money losses.
The overall ROI for JMP Pro was positive because of the Profiler option. This makes communicating the results of regressions as easy and complex as needed. It's such an awesome feature, I wonder why it wasn't offered before.
If JMP Pro didn't have the Profiler feature, I think I would still recommend using JMP Pro, but the recommendation is not a slam dunk. The software has its own programming language, which is not well-known and requires effort to debug.
JMP Pro's dashboards are well-built, and provide a positive ROI from the perspective of creating real-time, interactive reporting. It's very nice for this feature.
