Coming October 25: PeerSpot Awards will be announced! Learn more
Buyer's Guide
Data Visualization
September 2022
Get our free report covering Tableau, Microsoft, Databricks, and other competitors of SAS Visual Analytics. Updated: September 2022.
632,611 professionals have used our research since 2012.

Read reviews of SAS Visual Analytics alternatives and competitors

IdanEnright - PeerSpot reviewer
Inovation Manager at SoCalGas
Real User
Top 10
Beneficial query editor, scalable, and stable
Pros and Cons
  • "My favorite feature is the power query editor, where it can do the data transformations."
  • "Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop."

What is our primary use case?

We use Microsoft BI all over our enterprise but our main use is for the organizational dashboard. My organization sends all of our systems and ERP data into a Power BI dashboard, which goes to all the managers, the leadership, and then gets reported up to the company executives.

How has it helped my organization?

Microsoft BI has helped out the organization because it has brought visibility of our data across the organization allowing everyone to see the same metrics.

What is most valuable?

My favorite feature is the power query editor, where it can do the data transformations.

What needs improvement?

Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop.

In terms of the performance, it could always improve sometimes. It's only slow to update. The automated data feeds have to be all updated.

For how long have I used the solution?

I have been using Microsoft BI for two years.

What do I think about the stability of the solution?

The stability of Microsoft BI is very good. We have not had an issue.

What do I think about the scalability of the solution?

Microsoft BI has scaled very well for us. We have a very large organization with users all across the company.

We have approximately 100 users using this solution. It's a standard program for analysts and even managers will use it. It is a standard business analyst software. 

The solution is extensively being used in our organization.

How are customer service and support?

I have not contacted Mircosoft for technical support. I only use our internal support.

Which solution did I use previously and why did I switch?

We previously used SAS and it is similar to Microsoft BI. It's a little different in the visualization. It was more on analytics, but it also had the visualization.

We had SAS Enterprise Guide which was on-premise. When they were looking at cloud solutions, they kind of opened it up for more possibilities. The deciding factors of why we switched to Microsoft BI was we already had many Microsoft products and we have a SQL Server Data Warehouse. There's good integration between our existing Microsoft systems with Microsoft BI.

How was the initial setup?

I was part of the initial user testing of Microsoft BI, but it was mostly IT that handled all the initial implementation.

What about the implementation team?

We have a dedicated IT team of two administrators that support Microsoft BI. One of the administrator's full-time job is to manage the Microsoft BI.

What other advice do I have?

My advice to those wanting to implement this solution is to do some training. There is enough training curriculum available to get people going.

I rate Microsoft BI a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DW/BI Architect at a retailer with 10,001+ employees
Real User
User-friendly, flexible, customizable reports, and the support responds well
Pros and Cons
  • "There is a lot of APIs available, which means that Tableau can be customized to a large extent."
  • "When there are millions of records, scaling up is quite difficult."

What is our primary use case?

I primarily use Tableau for fair-market reporting.

I've been using it a lot for our dashboarding needs, circulating data to the business, generating PDFs, and publishing on the portal.

What is most valuable?

Over the time that I have used this solution, I've found the interface to be extremely user-friendly.

I especially like the flexibility that Tableau provides. You can quickly make web edits from version 9.0 onwards. My understanding is that Tableau 2020 has many more features for this, as well.

I customize the reports to my needs and preferences.

There is a lot of APIs available, which means that Tableau can be customized to a large extent.

What needs improvement?

Tableau had some issues with parameters. In particular, prior to version 2020, they did not have dynamic parameters.

Tableau cannot work with cubes or MDX (multidimensional expressions).

For enterprise-level users that are computing millions of records, they need to improve the features.

For how long have I used the solution?

I have been using Tableau for close to five years.

What do I think about the stability of the solution?

In all aspects, Tableau has been very stable.

What do I think about the scalability of the solution?

When there are millions of records, scaling up is quite difficult. There are, however, workarounds.

For example, you have to create summary tables or aggregate tables so that Tableau can be faster. There are third-party solutions like Kyvos available but if Tableau can integrate that and address the scalability, then it'll be an undisputed champion in the space.

How are customer service and support?

Technical support is extremely good. Since we have been a customer of Tableau, they have always responded really well to our queries. This is true regarding price, as well as in the technical aspect.

They have a good knowledge forum.

Which solution did I use previously and why did I switch?

I have worked with SAP BusinessObjects, Domo, SAP, and Birst.

One of the reasons that I prefer Tableau is that it's very user-friendly. Anyone who is familiar with Excel can easily adapt to Tableau.

What was our ROI?

We have been using Tableau for a long time, and we have seen a return on investment. The reason is that we have been able to scale it up to an enterprise level.

In the long run, there is definitely a return on investment.

What's my experience with pricing, setup cost, and licensing?

Licensing is slightly on the higher side compared to other products, such as Birst. There are different licensing options so you really have to be careful when choosing them. I recommend that you discuss your needs with the salesperson and try to negotiate the price.

In general, the price is slightly higher than products such as Power BI and Birst.

What other advice do I have?

Tableau is a solution that is near-perfect.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
CIO at a tech services company with 1,001-5,000 employees
Real User
Top 20
Stable, easy to use, and integrates well with multiple systems
Pros and Cons
  • "Once you have learned Informatica, it is very easy to use."
  • "The documentation could be improved."

What is our primary use case?

One of my use cases is integrating personnel data from multiple systems.

What is most valuable?

Once you have learned Informatica, it is very easy to use.

The feedback that I have received from team members is that they found it easy to work with.

What needs improvement?

It is very difficult to learn.

The documentation could be improved. For example, if they were to create a system like SAS Books or IBM Redbooks that includes books on how to install, and how to troubleshoot problems, then it would be great.

I would like to see a centralized dashboard that can be used to access all of the Informatica products, rather than having a set of fragmented applications. A consolidated system with everything in a single platform would make it easier for technicians, as well as when it comes to purchasing it. That would be amazing.

For how long have I used the solution?

I have been using Informatica PowerCenter for two years.

What do I think about the stability of the solution?

This is a stable product that has been around for a long time.

What do I think about the scalability of the solution?

We have approximately eight people who use Informatica in the organization.

How are customer service and technical support?

The customer service is good but they can't move you through the entire installation and troubleshooting process.

Which solution did I use previously and why did I switch?

I also have experience with solutions from IBM, SAS, and other vendors.

What about the implementation team?

My IT team was responsible for the deployment. Our team has approximately 12 people and they are responsible for installation and maintenance, including upgrades.

What's my experience with pricing, setup cost, and licensing?

I consider this to be an expensive product.

What other advice do I have?

In summary, Informatica is a good product that is very difficult to learn but once you learn it, it's very easy to use. It is a product that I can recommend using.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
GauravSingh1 - PeerSpot reviewer
Vice President Credit Risk Management at a financial services firm with 10,001+ employees
Real User
Top 5
Good dashboards and reporting, secure, and the machine learning enablement is helpful
Pros and Cons
  • "The AI/ML enablement is useful, as many reporting tools do not offer machine learning models as of now, without writing customized code."
  • "At this time, dataflows cannot be shared, but I think that this should be enhanced."

What is our primary use case?

This product is used for reporting and visualization.

We are not using the latest version but rather, one version back.

What is most valuable?

From a financial or bank perspective, this product is secure enough.

The dashboards, analytics, visualizations, and different reports are valuable for business analytics.

The AI/ML enablement is useful, as many reporting tools do not offer machine learning models as of now, without writing customized code.

What needs improvement?

This product does not support custom charts in the visualization.

At this time, dataflows cannot be shared, but I think that this should be enhanced.

There are a couple of other limitations. For example, many reporting tools offer good features and oracle should learn from that.

There should be tool tech enhancements.

For how long have I used the solution?

We have been using Oracle Analytics Cloud for approximately three years.

What do I think about the stability of the solution?

This is a stable solution and we plan to continue using it for at least another year.

What do I think about the scalability of the solution?

I believe that this is a scalable product.

How are customer service and technical support?

We have been in contact with Oracle technical support and we are satisfied with it.

Which solution did I use previously and why did I switch?

I have worked with many reporting tools including SAS Visual AnalyticsSpotfire, and Activu.

There was no specific reason for switching to Oracle Analytics Cloud. This was a decision driven by the priorities of the moment.

How was the initial setup?

The time required for deployment is almost an hour.

What about the implementation team?

Deployment requires a small team of people. One from admin, another from the development team, and one more.

What other advice do I have?

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
System Engineer at Roads & Transport Authority
Real User
The hyperintelligence is the most valuable feature, however data loading and data management are challenging
Pros and Cons
  • "The hyperintelligence is the most valuable feature."
  • "Preparation, data loading and data management application is challenging with MicroStrategy. It lacks cube-based analytics as it is outdated, meaning there is no memory or fast processing analytics or MMA deployment."

What is our primary use case?

Our company does business intelligence recording.

What is most valuable?

The hyperintelligence is the most valuable feature.

What needs improvement?

Preparation, data loading, and data management application are challenging with MicroStrategy. It lacks cube-based analytics as it is outdated, meaning there is no memory or fast processing analytics, or MMA deployment.

For how long have I used the solution?

We have been using MicroStrategy for three years.

What do I think about the stability of the solution?

MicroStrategy is very stable.

What do I think about the scalability of the solution?

This is a scalable solution. We have 55 business users.

How are customer service and support?

MicroStrategy's technical support is fair.

Which solution did I use previously and why did I switch?

We used SAS prior to MicroStrategy and I preferred SAS.

How was the initial setup?

The initial setup of MicroStrategy is complex. Our organization's structure requires the handling of three environments of the platform, development and production with the corporate technology, production support and the other IT support making it very complicated to get the developed final product live. Deployment took two weeks. 

What was our ROI?

There is a ROI from MicroStrategy. The data management and visualization to start the business strategies creates new services. However, you do require an adjustment to policies in order to make a profit.

What's my experience with pricing, setup cost, and licensing?

I am unsure what the licensing costs are for this solution however, development costs are around $100,000 per year.

What other advice do I have?

I recommend other organizations focus on the data processing and data preparation for the platform because it is very challenging. 

I would rate MicroStrategy a 7 out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Buyer's Guide
Data Visualization
September 2022
Get our free report covering Tableau, Microsoft, Databricks, and other competitors of SAS Visual Analytics. Updated: September 2022.
632,611 professionals have used our research since 2012.