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.
[Visual KPI is well suited for:] 1. Maintenance or field worker in oil & gas/chemical/ process industry mostly; machines status on the map & functionality for tracing exact location of the machines. 2. Key personnel of the site is always in move within the site/plant; useful for monitoring key performance indicators of the plant 3. KPIs to be built based on multiple data sources as well as integration with ERP tool
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.
1. At large it was successful implementation. - [Users] are empowered to find out performance measures easily - issues like machine downtime, trend analysis, location specific downtime information, roll out functionalities, up time of the machines or area, alert based on run hour of the machines/ pumps, manual data entry to capture reason code for any downtime
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.
Most of these products serve as the master source for managing data, but they all seem to have their own focus for what kind of data and metrics they monitor, visualize and analyze. I think Visual KPI holds its own against the competition because it serves so many purposes for so many departments at your organization.
