What users are saying about

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
352 Ratings
18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 6.5 out of 101

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
352 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 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 Power BI

Perfect for ad-hoc reporting but don't use this software for dashboarding automation. Klipfolio will do a better job for your dashboards.
Francois Salvert profile photo

Feature Rating Comparison

Ad-hoc Reporting

OpenText Analytics
4.5
Microsoft Power BI
8.2
Drill-down analysis
OpenText Analytics
6.0
Microsoft Power BI
8.5
Formatting capabilities
OpenText Analytics
3.0
Microsoft Power BI
8.1
Integration with R or other statistical packages
OpenText Analytics
Microsoft Power BI
8.0
Report sharing and collaboration
OpenText Analytics
Microsoft Power BI
8.1

BI Standard Reporting

OpenText Analytics
Microsoft Power BI
8.0
Pixel Perfect reports
OpenText Analytics
Microsoft Power BI
7.7
Customizable dashboards
OpenText Analytics
Microsoft Power BI
8.4
Report Formatting Templates
OpenText Analytics
Microsoft Power BI
7.9

Report Output and Scheduling

OpenText Analytics
Microsoft Power BI
7.9
Publish to Web
OpenText Analytics
Microsoft Power BI
8.8
Publish to PDF
OpenText Analytics
Microsoft Power BI
7.9
Report Versioning
OpenText Analytics
Microsoft Power BI
7.7
Report Delivery Scheduling
OpenText Analytics
Microsoft Power BI
7.7
Delivery to Remote Servers
OpenText Analytics
Microsoft Power BI
7.3

Data Discovery and Visualization

OpenText Analytics
Microsoft Power BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
OpenText Analytics
Microsoft Power BI
8.4
Location Analytics / Geographic Visualization
OpenText Analytics
Microsoft Power BI
8.5
Predictive Analytics
OpenText Analytics
Microsoft Power BI
7.5

Access Control and Security

OpenText Analytics
Microsoft Power BI
7.9
Multi-User Support (named login)
OpenText Analytics
Microsoft Power BI
8.2
Role-Based Security Model
OpenText Analytics
Microsoft Power BI
7.3
Multiple Access Permission Levels (Create, Read, Delete)
OpenText Analytics
Microsoft Power BI
7.8
Single Sign-On (SSO)
OpenText Analytics
Microsoft Power BI
8.3

Mobile Capabilities

OpenText Analytics
Microsoft Power BI
7.8
Responsive Design for Web Access
OpenText Analytics
Microsoft Power BI
7.9
Dedicated iOS Application
OpenText Analytics
Microsoft Power BI
7.8
Dedicated Android Application
OpenText Analytics
Microsoft Power BI
7.8
Dashboard / Report / Visualization Interactivity on Mobile
OpenText Analytics
Microsoft Power BI
7.8

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Microsoft Power BI
7.1
REST API
OpenText Analytics
Microsoft Power BI
7.6
Javascript API
OpenText Analytics
Microsoft Power BI
7.4
iFrames
OpenText Analytics
Microsoft Power BI
7.0
Java API
OpenText Analytics
Microsoft Power BI
6.4
Themeable User Interface (UI)
OpenText Analytics
Microsoft Power BI
7.4
Customizable Platform (Open Source)
OpenText Analytics
Microsoft Power BI
6.9

Pros

  • The report outputs can vary across different types such as HTML, PDF, and Excel
  • Their open source offering is very sufficient
  • There are great boards and blogs for developers and engineers to expand and use their features.
  • The people from the company that I've worked with are professional and courteous.
Bri Gipson profile photo
  • Data blending from several different files is a big hit with our Power BI users. We have so many excel and CSV files and many of them are not clean, so making use of the data cleaning and blending saves us from countless pivots and lookups to just get data worthy of analyzing.
  • The visualizations are top notch, and available without additional cost. Everything is in vibrant colors and crisp, clear lines that whatever your produce is clearly pleasing to the eye. From mapping down to pie charts, the visuals are well done.
  • The Beta preview is very helpful, not all software allows you to preview or use things in beta, but Power BI has a wonderful set of tools and visualizations you can add into your work with very little effort or complexity.
No photo available

Cons

  • Report rendering can take a long time for large reports (250,000+ pages) - we run these in batch over night
  • The deployment of production code from development to test to production enviroments can be complex due to the number of components that must compile
No photo available
  • Power BI lacks in horsepower compared to other tools with more robust ETL components built in. Particularly if you connect to any type of source system database like SQL, you have to either have a SQL View built for you that limits the volume of data your bring in, or have solid knowledge of the SQL table structures to build yourself custom (and correct!) connections to the tables.
  • Security is not as robust as other BI tools, like Qlik Sense. We often need to restrict subsets of data by customer and even functional position of an individual within a customer. Power BI’s security seems to be built for using just within a company, so if you leverage your work outside the firewall there can be issues when figuring out security streams.
  • I do not like the pricing. It’s really a dirty trick, Microsoft goes around and says the product is free. Well, the stand-alone is free, yes, but you have to pay for the “enterprise” version so you can share files. They say it only costs $10 a month/user, which again is a white lie. You need much more IT infrastructure and people to build SQL views and Tabular Models so you can use the tool, and Microsoft does not tell you that. So we find it is a good stand-alone tool to analytics, but a fairly heavy cost structure if you roll it out enterprise-wide as compared to Qlik or Tableau (which are more expensive per license, but require less back-office support).
No photo available

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
We have invested much into the software and hardware that supports our reporting platform - Actuate is a staple in our environment.
No photo available
Microsoft Power BI10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft Power BI8.8
Based on 3 answers
PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts
Rohit Acharya 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
No score
No answers yet
No answers on this topic

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
No answers on this topic

Alternatives Considered

I've used JReports and Actuate is very similar but seems to have a lot more customization features for the end user of BIRT reports.
Amy Broome profile photo
Power BI does not have the feel of a fully independent and robust BI Solution. It tackles smaller functional or department-level analytic needs and can operate in a small or solo roll-out environment. But scaling up to enterprise would be better suited for Qlik or Tableau. Same thing with any imbedding into Salesforce, if you’re rolling this out from a NOT IT-driven perspective you should go with Power BI for the cheap licensing and let IT absorb the costs for additional staff to support it on the back end. If you are IT-driven in the roll out, use Qlik so the business units pay the higher license costs but you need less staff to support them.
No photo available

Collaboration and Sharing

OpenText Analytics6.1
Based on 7 answers
As a developer, the report code itself cannot be diffed and the merged from one version of a report to another. If you have 2 developers working on the same report, the last developer's changes have to be manually implemented into the first developer's version of the report. You cannot use a tool such as WinMerge to merge differences from one report design into another. Or rather, you could but there's no guaruntee that it would work. This is a real bottleneck. You have to implement changes in the design tool
Amy Broome profile photo
Microsoft Power BI8.0
Based on 53 answers
The paid version is required to share and collaborate, and it does so well if you don’t need many security layers involved. I don’t feel it plays well with even its own family of tools like Word or PowerPoint. We’ve always had trouble imbedding visualizations into any other presentation tool and end up using the Snip tool to just get a static image to use. It also has limited report bursting, when most other tools can automate and schedule excel reports or pixel perfect reports in a wide variety of ways. Good for sharing amongst a team but there are better options for broader enterprise or global sharing.
No photo available

Data Integration

OpenText Analytics7.7
Based on 7 answers
They support plenty of major databases and we can connect to several different data sources.
Amy Broome profile photo
Microsoft Power BI8.3
Based on 52 answers
It works great with many different files at a time spread all over the place (within your firewall). Connects to most things, but not a lot of speed when leaving your home internal network. I would not consider it to have its own built in ETL tool like Qlik does. I think it’s great on number crunching and dashboard building, but super slow on managing the data or getting the data into the tool. Power BI is like Excel on steroids, where other tools are more robust and environmentally inclusive of the data like SQL.
No photo available

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
  • It's a good start for setting up customized dashboards.
  • Available for all users based on Office 365 platform we have in place.
  • Doesn't really allow depth of report - specifically customization of visual displays.
Mark Metz profile photo

Pricing Details

OpenText Analytics

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

Microsoft Power BI

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