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 7.0 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.
The use of this software does not necessarily follow that it is "globally better" than others. In the department we have used this and others with similar characteristics, given that, as previously indicated, all the software has advantages and weaknesses with respect to other …
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 …
1. It is good tool for a mathematical model which is a single period and deterministic model 2. It is good for the users who are comfortable in handling the Excel Solver and needs to upgrade the Excel Solver for more than 200 variables 3. It works well for the multiple objective problems. 4. Difficult to manage the big model as 100 constraints and 2000 variables can limit the use of the tool's efficiency. 5. Its limitation is that a model designer can not make a big and complex model.
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.
JMP Pro is a really powerful tool for doing statistical analysis. Although the click environment does not require coding experience, new learners will still need to take a long time to know the parameters in the function before performing any analysis.
The output from JMP Pro analysis (regression analysis) is not always easy to understand, especially when the parameters are programmed differently with the other similar software.
The use of this software does not necessarily follow that it is "globally better" than others. In the department we have used this and others with similar characteristics, given that, as previously indicated, all the software has advantages and weaknesses with respect to other software with similar characteristics. Obtaining better results lies in the user's ability to detect those "benefits and weaknesses" and maximize their usefulness within the specific field of work in which they operate. In our case, one of the reasons that led us to try and use it, was related to trying to "tie" more processes to the same environment, which in this case is the one associated with the Excel database, in such a way as to reduce the initial manipulation and accommodation that should be made to the data if they come from different sources such as MATLAB, or WinQsb. This facilitates the use of software for the type of user who does not necessarily have deep knowledge of linear algebra or operations research, for example.
On the contrary, the most analytical and knowledgeable user manifested in a high percentage, preferring to use MATLAB as a tool, claiming that they have a greater and easier access to the calculation functions, which even in specific cases, could be modified.
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.
