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 is well suited for projects that are more discovery related. If this is a one-time project that we create a visual for, this would definitely make sense to use. If this is an ongoing analysis (monthly for example), we might look to another software that we would be able to automate a little further in how the visualization comes together
In comparison to other tools such as GraphWiz or Circos, Gephi comes with an intuitive, easy-to-use interface that makes it easy to load your data, and quickly start building all sorts of different graphs. There's absolutely no code that needs to be written for either loading or modeling. And without downloading additional plug-ins, Gephi ships with quite a few standard graph models, as well as some "fun" extras such as the Sierpinski triangle, and a variety of force atlas types.
Most of the layout types (maybe all) are highly configurable, which can make for extremely customized and unique displays of your data. Again, none of this requires the user to write any code. That said, it is possible to script custom functionality for your models, or even update the Java source code yourself, if you feel like getting technical. Gephi builds are available on GitHub, and the developers encourage people to contribute ideas, improvements, and plug-ins.
There's a plug-in for Gephi that allows for streaming data to update your model. This essentially allows you to create near realtime graphs of your data in motion. This plug-in was by far the biggest reaston we invested time in the product; to create animated data visualizations without exhaustive hours in development.
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 (and many others) have had to expand Gephi's memory manually by experimenting with the configuration file. I'm glad it's possible, but it should be easier.
Gephi sometimes crashes inexplicably and loses your work, so I have developed a habit of explicitly exporting versions of my graphs as csv's, but I think this should be handled automatically in Gephi.
Because it is prone to crash, ideally, Gephi would help the user manage his/her use, by estimating processing and memory for very large tasks and prompting the user to confirm their requests before executing. Instead, I just tend to avoid certain functions.
While Gephi isn't perfect, it's a powerful tool for mathematical graph modelling that's hard to find in other products, particularly by way of its interface. It grants non-software developers access to a point-and-click way of creating accurate, beautiful visualizations that would normally take hours in other applications. The fact that it allows for live streaming data is also something that's hard to come by, at least for visualization software
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.
Gephi is very intuitive and the fact that it shows its process helps the user understand what's going on. However, the animation features can really slow it down and there isn't a way to shut them off. Furthermore, the failures on saving mean you frequently have to start over. These problems disrupt the workflow and can be frustrating.
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.
The interactivity in Gephi and the quality of the output figures are impressive. However, the selling point was the fact that we were able to link Gephi into our pipeline using Java's interface. Other products were less customizable and lacking of the sophistication Gephi provided without too much pain during the liking process.
I have only used the product for education purposes. I will not be the best person to provide details about ROI and business efficiency and customer service. I was personally very excited about the tool and am continuing my work on the tool.
