What users are saying about

Microsoft BI

594 Ratings

OpenText Analytics

18 Ratings
Score 6.6 out of 101

Microsoft BI

594 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

OpenText Analytics

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
Christopher Noyes profile photo

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

Feature Rating Comparison

Ad-hoc Reporting

OpenText Analytics
4.5
Microsoft BI
8.5
Drill-down analysis
OpenText Analytics
6.0
Microsoft BI
8.6
Formatting capabilities
OpenText Analytics
3.0
Microsoft BI
8.3
Integration with R or other statistical packages
OpenText Analytics
Microsoft BI
8.3
Report sharing and collaboration
OpenText Analytics
Microsoft BI
8.8

BI Standard Reporting

OpenText Analytics
Microsoft BI
8.2
Pixel Perfect reports
OpenText Analytics
Microsoft BI
8.1
Customizable dashboards
OpenText Analytics
Microsoft BI
8.1
Report Formatting Templates
OpenText Analytics
Microsoft BI
8.4

Report Output and Scheduling

OpenText Analytics
Microsoft BI
8.7
Publish to Web
OpenText Analytics
Microsoft BI
8.7
Publish to PDF
OpenText Analytics
Microsoft BI
8.5
Report Versioning
OpenText Analytics
Microsoft BI
8.8
Report Delivery Scheduling
OpenText Analytics
Microsoft BI
8.8
Delivery to Remote Servers
OpenText Analytics
Microsoft BI
8.5

Data Discovery and Visualization

OpenText Analytics
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
OpenText Analytics
Microsoft BI
9.0
Location Analytics / Geographic Visualization
OpenText Analytics
Microsoft BI
8.8
Predictive Analytics
OpenText Analytics
Microsoft BI
8.5

Access Control and Security

OpenText Analytics
Microsoft BI
8.7
Multi-User Support (named login)
OpenText Analytics
Microsoft BI
8.8
Role-Based Security Model
OpenText Analytics
Microsoft BI
8.6
Multiple Access Permission Levels (Create, Read, Delete)
OpenText Analytics
Microsoft BI
9.0
Single Sign-On (SSO)
OpenText Analytics
Microsoft BI
8.5

Mobile Capabilities

OpenText Analytics
Microsoft BI
8.5
Responsive Design for Web Access
OpenText Analytics
Microsoft BI
8.4
Dedicated iOS Application
OpenText Analytics
Microsoft BI
8.7
Dedicated Android Application
OpenText Analytics
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
OpenText Analytics
Microsoft BI
8.5

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Microsoft BI
8.4
REST API
OpenText Analytics
Microsoft BI
8.6
Javascript API
OpenText Analytics
Microsoft BI
8.4
iFrames
OpenText Analytics
Microsoft BI
8.4
Java API
OpenText Analytics
Microsoft BI
8.3
Themeable User Interface (UI)
OpenText Analytics
Microsoft BI
8.7
Customizable Platform (Open Source)
OpenText Analytics
Microsoft BI
8.0

Pros

  • In terms of extensibility this is the best reporting platform we have seen. You can build very sophisticated reports with different data sources, and extend the basic functionality with javscript code
  • Securing the BI system is also a strength and the system can be configured relatively easily.
  • Reports can be available on mobile devices
  • Good Javascript embedding framework does not require the site to be built in java
Christopher Noyes profile photo
  • Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
  • Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
  • Collaboration (via SharePoint only, before the release of Power BI Designer)
  • Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
  • Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
Lee Cullom profile photo

Cons

  • We have found a ton of bugs in there, our implementation is very complex and we use a lot of features, but we wish there were less bugs. Particularly with parameter display and validation.
  • Actuate has decided not to continue to support the birtondemand platform and it is running on older versions of their main platform.
  • Building out security extensibility is rather complex.
  • They have not had a rest interface until new versions of iHub.
Christopher Noyes profile photo
  • Power BI maturity: Power BI is a combination of add-ons for Microsoft Excel and a special Office365 hosting site. However, the primary presentation tool, Power View, has a long way to go to catch up with such competitors as Tableau and even Microsoft's current analytics platform, PerformancePoint. To address these concerns, Power BI releases are being scheduled out-of-band from normal version upgrades in order to address requirements of the user community.
  • Office 365: There are currently size limitations, like a 250GB max for PowerPivot worksheets, which might cause issues with organizations who want to utilize very large data sets with Power BI.
  • Messaging: Some of the marketing and best practices around the new cloud-based solutions are unclear, making it difficult for someone who doesn't work in the BI world to understand the benefits and the architecture for such solutions.
  • Multiple data manipulation languages: Currently there are four or five distinct query languages in the Microsoft BI stack: T-SQL for SQL Server, MDX and DAX for Analysis Services, and the Power Query Formula Language for Power Query. In Integration Services, there is yet another language used in some of the tasks. That seems to be a lot to keep abreast of!
Chris Utter profile photo

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
Difficulty with some extensibility that should be fairly easy, lack of shading in the reports (even simple phong shading), lack of out-of-the box capabilities that seem like no brainers and instability with the design tools all drop the product a few marks, but the support community and the overall product experience is well above average. It's at least worth a try and its extensibility makes it a good contender
Bri Gipson profile photo
Microsoft BI8.0
Based on 25 answers
Low Cost and catching up to the market expectations
No photo available

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

OpenText Analytics9.1
Based on 1 answer
Always there on the front and backend for us and the client.
Jeffrey Fischer profile photo
Microsoft BI7.1
Based on 6 answers
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Jacob Saunders profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Breadth of Deployment

Actuate is used in 3-4 product lines. We have about 30 developers company wide that develop reports and perhaps 100 testers and business analysts that use it. Then we resell it with our product which is used by thousands of end users.
Amy Broome profile photo
Everyone uses it around my company. Mostly as BI professionals that use it to create BI solutions.
Michał Becker profile photo

Alternatives Considered

Actuate has a HUGE number of features that can tie nicely into almost any ERP but it takes some time to learn and the development community was relatively small compared to the Crystal Reports alternative. Crystal was far easier to learn and had a massive support base. Probably because it is now owned by SAP.
Todd Bellamy profile photo
Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo

Collaboration and Sharing

OpenText Analytics6.1
Based on 7 answers
Having more that one developer working on Actuate reports became quite a problem because once a report was compiled it was published to the server. The published file then could not be decompiled and the design files had to be stored in a particular shared location on the server. Also, I experienced issues leaving code notes in the SQL statements of the reports when I tried to compile them
Todd Bellamy profile photo
Microsoft BI8.2
Based on 27 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Steve Wake profile photo

Data Integration

OpenText Analytics7.7
Based on 7 answers
This was a feature of Actuate I almost forgot. You could connect to number of different data sources across the organization from Oracle to MySQL and just about everything in between. Also if you have multiple environments of the same system (DEV,QA,PROD) you can change the connection string each time you compile the same report to promote changes. This was easier then changing the connections in alternative software like Crystal Reports
Todd Bellamy profile photo
Microsoft BI8.7
Based on 26 answers
Microsoft BI uses the Machine Learning tool when gathering data from the web. It can detect page elements and learn what you want to get then find itself a way to get this data.
Celil ÇİYNEKLİ profile photo

Return on Investment

  • Actuate can handle 50 to 60 sub reports inside a report very well.
  • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
No photo available
  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo

Pricing Details

OpenText Analytics

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
OpenText Analytics Editions & Modules
OpenText Analytics
Additional Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details