Well suited: 1. If data set is not yet well organized. 2. Hypothesis is not yet established. 3. Need to visually explore to find patterns of data (often when analysts have no good understanding of data) 4. When [you need] to analyze events with a timeframe (specifically a sequence of events as a transaction) Less appropriate 1. If a data set is very large, such as Hadoop data, it becomes hard to manage data pipeline and process to feed the data into Ayasdi. To be feed into Ayasdi, data should be aggregated or organized to some level.
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.
Ayasdi Core provides an easy way to get some insight on data. Typically analytics may require having a model or hypothesis before starting to look into the data, but Ayasdi lets you just feed the data first then start seeing what the data looks like.
Ayasdi Core's topological network visualization is quite unique. It allows you to explore patterns and potential relations between multiple data elements. A user can also dynamically navigate data with different aspects on the web.
The Web version of Ayasdi is easy to use, stable, and fast. It hasn't crashed even when we feed it a lot of data sets, although it took time.
Use of Python SDK is required to feed data into Ayasdi, but it lacks training materials or sample codes for a novice to get started.
Although Web UI of Ayasdi is looking good, often it freezes when the user runs an analysis. It doesn't crash but the web page needs to be refreshed to see the progress of analysis.
Algorithms provided by Ayasdi, such as metrics types, lens types need to be explained (what they are and what their strengths and weaknesses are). We had to Google or do research on our own to understand what they are.
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.
We had a working group that has been using R studio for the general purpose of statistical analysis in our organization. Although it is a great tool that provides enriched function sets, it is time-consuming for our clinical analysts to learn the tool to see the first result. R is somewhat of a developer-oriented/friendly tool. Ayasdi is friendly to a domain analyst or end users. Plus, support and consulting from Ayasdi were excellent so that we could get knowledge from them immediately whenever we needed.
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.
