What is our primary use case?
I work with Oracle APEX, Oracle Database, Oracle Data Integrator, Oracle Analytics, which includes Oracle Analytics Server and Oracle Analytics Cloud, and anything related to data and data analysis, including older products that are still in use.
I have been engaged with Analytics Cloud since it came out, as I previously worked with Analytics Cloud, which is the cloud version of Oracle Business Intelligence Enterprise Edition that has been around for many years. Analytics Cloud is the cloud version that was united with another product called DV, which is data visualization. They combined everything together and created Analytics Server and Analytics Cloud, which is the same product but on cloud. I have been working on that product for over fifteen years, with the cloud solution for less time than that since we transitioned to cloud when it became available.
I am currently still using Oracle Analytics Cloud.
What is most valuable?
I have found that the scalability quality of Oracle Analytics Cloud works extremely well. It scales very well with very large projects and works easily with smaller projects, but scales exceptionally well when the size increases. That is the main feature. Other aspects are more complicated compared to other vendors, so I would not say those are the best. In Italy, there is a very large install base of Oracle Analytics solutions that have moved to Oracle Analytics Cloud. Many of our clients already have it, and this is a significant determining factor because I work in consulting and we often implement the solution that the client requires.
We are using the data visualization tool in Oracle Analytics Cloud extensively because it is considerably simpler than using the old OBIEE version. DV is the other side of Oracle Analytics and the visuals are considerably better than the old OBIEE ones. They are not as simple as one might want them to be, but they are very powerful, and we are definitely using those.
I find that it is very simple to do simple tasks in Oracle Analytics Cloud, so it has a very simple and easy learning curve to start with. The problem occurs when you start to do more complicated work. In that case, it does not always behave as you would expect it to. Getting a simple dashboard operational in about an hour is usually quite simple if you are not looking for something extremely complicated. It is a very quick prototyping infrastructure if you need it, and it looks very good.
What needs improvement?
Some things that could be improved in Oracle Analytics Cloud is definitely the way it works. In some cases, for example, if you want to create analytic functions such as the percentage of a measure over another, which is a straightforward question you might ask, it appears simple to do, but the result is not what you expect. I would make it more user-friendly in terms of creating new measures. The measure creation feature could be improved.
In terms of functionality, there are not many functions that are completely missing. There is one aspect that if you compare it with Power BI from Microsoft, which works completely in memory and therefore puts everything in memory to allow many calculations on the fly on what is in memory, that is missing, but it is architecturally different and would not be possible to ask for something like that. Some time features and time series analysis functions could be improved. Calculating a year ago and previous period functions could definitely work with some improvement.
For how long have I used the solution?
I have been engaged with Analytics Cloud since it came out, as I previously worked with Analytics Cloud, which is the cloud version of Oracle Business Intelligence Enterprise Edition that has been around for many years. Analytics Cloud is the cloud version that was united with another product called DV, which is data visualization. They combined everything together and created Analytics Server and Analytics Cloud, which is the same product but on cloud. I have been working on that product for over fifteen years, with the cloud solution for less time than that since we transitioned to cloud when it became available.
What do I think about the stability of the solution?
I would give the stability of the product a rating of nine. It is not perfect, but it is quite stable.
What do I think about the scalability of the solution?
It definitely scales up very well. In some cases, you need to have real-time analytics to get analysis done very quickly. It scales up very well, and that is positive. It definitely compares well to competitors in this regard.
How are customer service and support?
I give the technical support for Oracle Analytics Cloud a rating of eight. It used to be better.
What has changed in the technical support is the time it takes to get an answer from support. We work with both server and cloud, which is the same product. One is installed on-premises, and the other is on cloud. The cloud version gets better support than the installed version. The server version is supported less well, whereas the cloud service version is supported better, in my opinion. We get better help with cloud. Anything that requires installation takes days before they get to your problem because they are checking your setup and verifying whether you have this or that, and it takes quite a while, whereas with the cloud, it seems like there is a fast track option within support.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
Microsoft Power BI is definitely a competitor for Oracle Analytics Cloud.
How was the initial setup?
The initial setup process for Oracle Analytics Cloud is extremely simple. It is just a matter of clicking and requesting one, and that is about it. The creation process is straightforward. However, when you have to give permissions to the users, which means you do not want users who can have full functionality, that is a completely different situation and requires a lot of work. So it is not that simple in that regard. The initial part is simple, and the deployment is really a matter of twenty minutes, during which you click and wait.
What about the implementation team?
The implementation is mainly directly from the vendor for Oracle Analytics Cloud because large clients have to go through the vendor anyway. Oracle account managers take care of big clients. Even medium to small clients have an account. My company, which is a smallish company everything considered, has an Oracle account manager, and I can call him personally if I have a problem. Large clients would go directly through Oracle.
What's my experience with pricing, setup cost, and licensing?
Pricing for Oracle Analytics Cloud works with how much you want it to cost. We have clients who have bought large amounts of Oracle and the price per product has gone down massively because they bought a lot. Microsoft would be cheaper, but not always. We have had situations where Oracle's pricing has been more aggressive than Microsoft's. It is difficult to say because they are definitely competing in the same direction and in some cases the price goes down massively. For the cloud section it does not make as much difference, but for the installed version, it makes a huge difference. We have quite a few clients in Italy who do not want to go on cloud for reasons that are difficult to explain. They prefer to spend more for the installed version rather than cloud. If you want on-premises, the solution definitely goes in favor of Oracle because Microsoft will install something on-premise, but it is definitely not a good choice. It is extremely expensive and does not get the support that you would receive on cloud. Any client who says no to the cloud is basically saying no to Power BI.
Which other solutions did I evaluate?
It depends on the setup of the client regarding Oracle Analytics Cloud and Power BI. We have clients who have one or the other. If the setup is mostly Oracle based, I would suggest Oracle Analytics Cloud. If the setup has various data sources from multiple places, Power BI is possibly better. Anything that has to merge and put many pieces together means the Microsoft solution is better. With a single data source mostly on Oracle, definitely Oracle Analytics Cloud is better.
What other advice do I have?
I looked at the predictive analytics feature in Oracle Analytics Cloud, but I used it very little because, everything considered, it does not add very much. Compared to what is available on the market, it gives a very limited forecasting feature. It is basically a regression tool and not much more than that. I have not used it very much and used it for a few demos, but I did not particularly like it.
I came across the data discovery feature in Oracle Analytics Cloud almost by accident at the beginning because I was not even aware of it. It is actually very useful at the beginning because when you get a dataset and you do not know exactly what is inside or what you are going to find, some information is extracted automatically and it makes it a lot simpler, especially if you expect something to be entirely numeric and then discover it contains a few codes that are not numeric and you can see the distribution. These statistics come out very quickly and easily from the system and that is actually very useful, especially when you are running against time, which happens quite often.
We have clients who require separate setups for different groups doing analytics on the same system. On DV it is quite simple compared to a situation where you are using the old system with metadata that is all integrated in one place. Two groups have to work on the same set of metadata and that makes it horribly complicated to share the same environment. DV makes it a lot simpler.
Oracle Analytics Cloud is fully deployed on Oracle Cloud with no option for any other cloud as far as I know, though I am not totally sure. Oracle does come to various agreements with other vendors and has done so extensively over the last few years. Therefore, I would not be totally sure because it changes very quickly. Some solutions that were only on Oracle about a year ago are now on AWS. So I would need to check that up as I have not needed to check that for a while.
If you want to specify that a certain group can only see a specific set of dashboards and another group can only see a different set of dashboards, that is not as simple as it could be in Oracle Analytics Cloud. It is simpler in other products.
I give this review an overall rating of nine out of ten.