Analytic Solver vs. Microsoft R Open / Revolution R Enterprise

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.

Incentivized

If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.

Incentivized

• Easy to use and learn.
• Strong optimization platform for business and supply chain problems which can be modeled in Excel
• It can handle multiple objectives and more than 8000 decision variables in a problem.
• Lots of tutorial and examples are available to solve the problem

Incentivized

• It allows distributed algorithm runs on Hadoop HDFS cluster
• It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
• It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop

• 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.

Incentivized

• Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
• Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.

Incentivized

In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.

It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.

Incentivized

Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.

Incentivized

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.

Incentivized

The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.

Incentivized

• - 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.

Incentivized

• Helped save company money versus buying other stat software

Incentivized