Frontline Systems Analytic Solver is an Excel add-on for performing data mining, and predictive analytics from within Microsoft Excel.
N/A
H2O.ai
Score 6.5 out of 10
N/A
An open-source end-to-end GenAI platform for air-gapped, on-premises or cloud VPC deployments. Users can Query and summarize documents or just chat with local private GPT LLMs using h2oGPT, an Apache V2 open-source project. And the commercially available Enterprise h2oGPTe provides information retrieval on internal data, privately hosts LLMs, and secures data.
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.
Most suited if in little time you wanted to build and train a model. Then, H2O makes life very simple. It has support with R, Python and Java, so no programming dependency is required to use it. It's very simple to use. If you want to modify or tweak your ML algorithm then H2O is not suitable. You can't develop a model from scratch.
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.
Both are open source (though H2O only up to some level). Both comprise of deep learning, but H2O is not focused directly on deep learning, while Tensor Flow has a "laser" focus on deep learning. H2O is also more focused on scalability. H2O should be looked at not as a competitor but rather a complementary tool. The use case is usually not only about the algorithms, but also about the data model and data logistics and accessibility. H2O is more accessible due to its UI. Also, both can be accessed from Python. The community around TensorFlow seems larger than that of H2O.
- 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.
Positive impact: saving in infrastructure expenses - compared to other bulky tools this costs a fraction
Positive impact: ability to get quick fixes from H2O when problems arise - compared to waiting for several months/years for new releases from other vendors
Positive impact: Access to H2O core team and able to get features that are needed for our business quickly added to the core H2O product
