What users are saying about

Microsoft Power BI

Top Rated
319 Ratings

OpenText Analytics

18 Ratings
Score 6.7 out of 101

Microsoft Power BI

Top Rated
319 Ratings
Score 8.1 out of 101

Add comparison

Likelihood to Recommend

OpenText Analytics

What is the licensing structure? How long does it take to get licenses? Can an OEM reseller of Actuate get one license for the entire development organization?
Amy Broome profile photo

Microsoft Power BI

Power BI is great at dynamically reflecting real time data. It has wonderful views of data and can narrate a story that is powerful and impressive. Decisions can be made on the overall visuals shown. BI can show you where your sales are picking up while showing you areas to focus on. The quality of your BI dashboard tremendously improves with the overall quality of your incoming data. BI has great capability to share results across the organization in a secure and safe way in almost any computer platform. Mobile phones welcome too!
No photo available

Feature Rating Comparison

Ad-hoc Reporting

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

BI Standard Reporting

OpenText Analytics
Microsoft Power BI
8.2
Pixel Perfect reports
OpenText Analytics
Microsoft Power BI
7.9
Customizable dashboards
OpenText Analytics
Microsoft Power BI
8.6
Report Formatting Templates
OpenText Analytics
Microsoft Power BI
8.0

Report Output and Scheduling

OpenText Analytics
Microsoft Power BI
7.9
Publish to Web
OpenText Analytics
Microsoft Power BI
8.9
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.6
Delivery to Remote Servers
OpenText Analytics
Microsoft Power BI
7.4

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Microsoft Power BI
7.2
REST API
OpenText Analytics
Microsoft Power BI
7.7
Javascript API
OpenText Analytics
Microsoft Power BI
7.5
iFrames
OpenText Analytics
Microsoft Power BI
7.1
Java API
OpenText Analytics
Microsoft Power BI
6.5
Themeable User Interface (UI)
OpenText Analytics
Microsoft Power BI
7.6
Customizable Platform (Open Source)
OpenText Analytics
Microsoft Power BI
6.9

Pros

  • End user ability to customize Business Intelligence Reporting Tools (BIRT)
  • Actuate Support is usually prompt and helpful.
  • Ability to embed in other applications, has extendable code for authenticating/authorizing users.
Amy Broome 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

  • Licensing is a bear.
Amy Broome profile photo
  • UX sometimes can be overwhelming, can be more intuitive
  • Free features always can receive more attention to gain client fidelity
  • Solutions like Power BI can always do better with their Mobile version
Litzi Saraí Gordils Ortuño profile photo

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite
Todd Bellamy profile photo
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 was used by the indirect procurement team and the maintenance departments company wide across many facilities. Well over 100 concurrent users at anytime. Actuate was used across vast majority of locations with the ERP solution we had at the time.
Todd Bellamy profile photo
No answers on this topic

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
Power BI is usually the cheapest solution and most user-friendly for most people (since we are all used to the Microsoft Suite). However the connectivity to non-Microsoft soft tools (databases and data analysis tools) are somewhat limited, especially when compared to its biggest competitor: Tableau.
Gabriel Chiararia 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 Power BI8.3
Based on 46 answers
I really like the data sharing features of Power BI. You can save it in different formats, share reports as a webpage, and the best part is that if you update your dataset, the report will automate automatically! In terms of security, well, I trust Microsoft.
Gabriel Chiararia profile photo

Data Integration

OpenText Analytics7.7
Based on 7 answers
We connect to various data sources and enjoy quick connectivity
No photo available
Microsoft Power BI8.4
Based on 45 answers
Microsoft Power BI can connect to most prominent databases such as Amazon Redshift, MySQL, Oracle, Teradata etc. The live data streams are still not robust and face lags and breakdowns frequently especially with redshift. Power BI and excel go hand in hand and offer interoperability. Flat files and other text file sources can easily be connected. PBI distinguishes itself from other tools by connecting to online service apps like Salesforce, SharePoint, QuickBooks and other services.
Rohit Acharya 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
  • 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