We have to calculate most all Lab / Pilot / Proposals sizing and results. The automated calculations in [Excel4apps] is awesome, as once you are familiar with them, it is easy to quickly implement them when needed.
It's a great tool to merge actual data analysis (which Lumira doesn't do that well) with visualization (which Lumira does well) - so it can be seen as Lumira for data analysts. However, a lot of the 'predictive' side is hidden/black box which can be frustrating for those analysts, so you could argue it is too complex for casual users, but too 'black box' for analysts.
It doesn't require you to have a Ph.D. to build models!
You can use it to address a very large and wide dataset without worrying about sampling.
Automation is in the product DNA. You can prepare your data, ingest it into the "Kernel", then get insights about what was found, decide to publish it and schedule scoring tasks or model refresh in the same product.
It is possible but difficult to retrieve data or set criteria from different module into a single report or retrieve. If it is more user friendly instead of having to create a complex formula to retrieve the data, this function will be utilized more often.
It will be nice to have visual (graphs, etc.) report template available
It is helpful if we can retrieve data for a range of date, instead of just YTD, PTD etc. and multi-year data all at once for comparison too.
I am not a power user of Excel. So I find Exel4apps a friendlier version of the things that I could do on Excel and making it easier with a magic wand.
The documentation provides an explanation about what features are available but not necessarily what's happening behind the scenes. On the other side, the "community" has grown since the acquisition and most questions are properly addressed by SAP folks. Since the "product maintenance" mode announcement was made, there wasn't much new content published except on the Smart Predict side (which is built by the SAP Predictive Analytics team)
Excel4apps is more user friendly and can retrieve data much easier and in a nicer format than Jaspersoft. Qlik Sense is useful and have more visual reporting and dashboard. However, it is usually used for higher level of analyses and review. Yardi is used for specific purpose, which is different than Excel4apps. Excel4apps can pull all the financial data from Oracle, including billing and collections.
We have typically used Spotfire for data analysis but decided to move to SAP Business Objects due to its innate connection with SAP. I found Lumira to be good for visualizations but it is not meant for data analysis. Therefore, we have introduced Predictive Analytics to see if it can fill that gap. So far, it's been far less intuitive than Spotfire to get started, and as far as I am aware so far, it does not bring many additional capabilities. I do, however, like that it utilizes the Lumira look/feel and integrates very well.
