What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
555 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
472 Ratings

Microsoft Power BI

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

SAP Crystal

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

Likelihood to Recommend

Microsoft Power BI

Power BI is great for reporting of any type. The dashboards I create for my executive team are crisp and easy to understand. I often get complements on it, and suggestions on what other reports or data could benefit from Power BI. Power BI is still dependent on data sources, so if my data source connections break, then the report is no good. This isn't something that you can create and forget. It needs eyes on it to ensure the data is correct
Richard Crane profile photo

SAP Crystal

Crystal reports is a great Business Intelligence tool for any midsize business that prefers to keep its data in-house instead of in the cloud. The learning curve for parsing data source and creating first reports could be a bit steep at the beginning, but then the cost savings are invaluable. The reports generated by Crystal are easily manipulated according to different requirements and further analyzed by the recipients.
Frank Hunt profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft Power BI
8.2
SAP Crystal
8.1
Pixel Perfect reports
Microsoft Power BI
8.0
SAP Crystal
8.5
Customizable dashboards
Microsoft Power BI
8.5
SAP Crystal
7.8
Report Formatting Templates
Microsoft Power BI
8.3
SAP Crystal
8.0

Ad-hoc Reporting

Microsoft Power BI
8.4
SAP Crystal
7.8
Drill-down analysis
Microsoft Power BI
8.5
SAP Crystal
7.4
Formatting capabilities
Microsoft Power BI
8.3
SAP Crystal
8.4
Integration with R or other statistical packages
Microsoft Power BI
8.3
SAP Crystal
7.5
Report sharing and collaboration
Microsoft Power BI
8.6
SAP Crystal
7.8

Report Output and Scheduling

Microsoft Power BI
8.4
SAP Crystal
8.1
Publish to Web
Microsoft Power BI
8.8
SAP Crystal
7.8
Publish to PDF
Microsoft Power BI
8.3
SAP Crystal
8.9
Report Versioning
Microsoft Power BI
8.3
SAP Crystal
7.6
Report Delivery Scheduling
Microsoft Power BI
8.4
SAP Crystal
8.1
Delivery to Remote Servers
Microsoft Power BI
8.0
SAP Crystal
7.9

Data Discovery and Visualization

Microsoft Power BI
8.2
SAP Crystal
7.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft Power BI
8.5
SAP Crystal
7.6
Location Analytics / Geographic Visualization
Microsoft Power BI
8.3
SAP Crystal
7.1
Predictive Analytics
Microsoft Power BI
7.8
SAP Crystal
7.7

Access Control and Security

Microsoft Power BI
8.4
SAP Crystal
7.7
Multi-User Support (named login)
Microsoft Power BI
8.4
SAP Crystal
7.8
Role-Based Security Model
Microsoft Power BI
8.0
SAP Crystal
7.7
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft Power BI
8.3
SAP Crystal
7.5
Single Sign-On (SSO)
Microsoft Power BI
8.8
SAP Crystal
7.8

Mobile Capabilities

Microsoft Power BI
8.1
SAP Crystal
7.1
Responsive Design for Web Access
Microsoft Power BI
8.2
SAP Crystal
7.5
Dedicated iOS Application
Microsoft Power BI
8.0
SAP Crystal
6.7
Dedicated Android Application
Microsoft Power BI
8.1
SAP Crystal
6.9
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft Power BI
8.1
SAP Crystal
7.4

Application Program Interfaces (APIs) / Embedding

Microsoft Power BI
8.0
SAP Crystal
7.0
REST API
Microsoft Power BI
8.1
SAP Crystal
7.4
Javascript API
Microsoft Power BI
8.2
SAP Crystal
7.0
iFrames
Microsoft Power BI
7.9
SAP Crystal
7.1
Java API
Microsoft Power BI
7.6
SAP Crystal
7.0
Themeable User Interface (UI)
Microsoft Power BI
8.1
SAP Crystal
6.9
Customizable Platform (Open Source)
Microsoft Power BI
8.0
SAP Crystal
6.6

Pros

Microsoft Power BI

  • Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways.
  • Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products.
  • Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.
Rick Botha profile photo

SAP Crystal

  • Great visualization for static format & precise tasks: For presentation to senior management /ex-co/vendors where concise decisions need to be made, Crystal is a nice choice to slide data into presentable views.
  • Diverse data source connect: We have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. It can also be used to join different database types together in one report.
  • It uses the "recurring bands" structure for page layout which is efficient and fungible for generating different types of reports. Crystal doesn't require that we set up a metadata layer before creating reports and provides direct access to tables and dimensions.
Rohit Narang profile photo

Cons

Microsoft Power BI

  • It is such a powerful system that it can come across as intimidating for some without some Excel knowledge
  • I'm not a database analyst or administrator, so calling the data in can be difficult (not necessary the fault of the software, but something that could be difficult for teams without someone with database knowledge)
  • It can come across as confusing, when there is both a local Power BI and online Power BI components. They don't necessarily do the same functions. You'll definitely want to know how to use the online version as this is how you'll publish and share the results of your findings, but the local one has a lot of capabilities that don't appear to be directly available in the online version (and if so, it's not immediately apparent).
Steffany Winkelmann profile photo

SAP Crystal

  • The option to export to Excel is very picky about report format to get a clean export. Once you know the tricks for setting up a report for this export, it's not hard to do, but it can be very tedious if the report has a lot of elements. This is the way it's been for years and SAP has indicated that it's not something that's going to be changed.
  • Crystal requires that a user knows how the data they're reporting on is configured in the database - it's not really suited for a "casual" user, but for someone with at least some technical skills in relation to databases. This is not something that can or should necessarily be changed, but it is something that potential users need to be aware of.
  • Other than new types of database connections, SAP has indicated that they will not be upgrading any functionality in "classic" Crystal. They instead have chosen to focus on upgrades to Crystal for Enterprise. The problem with that is that it requires the SAP BI Platform - either SAP BusinessObjects or SAP Crystal Reports Server.
  • One of the major things that's not being upgraded is the Charting libraries, which were last updated in the early 2000's, before SAP purchased Crystal. So, Crystal doesn't have newer chart types available.
Dell Stinnett-Christy profile photo

Likelihood to Renew

Microsoft Power BI

Microsoft Power BI 10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly profile photo

SAP Crystal

SAP Crystal 10.0
Based on 19 answers
I have made my career off Crystal Reports. Business Intelligence is a niche area of Information Technology that combines technical knowledge and an understanding of how a company uses information. Crystal Reports is the most solid, flexible and reliable business intelligence tool I have worked with, allowing me to work on projects in a variety of markets and industries, from the financial to educational, to telecommunications to governmental. Understanding how to use Crystal Reports as part of a Business Intelligence career gives you the tools you need to better connect businesses to their data, deliver quality and productive solutions, and allow you the report developer to build the experience and skills to build a reputable career in the high demand world of Business Intelligence Reporting.
David Deitch profile photo

Usability

Microsoft Power BI

Microsoft Power BI 9.0
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

SAP Crystal

SAP Crystal 8.1
Based on 22 answers
Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Greg Goss profile photo

Support

Microsoft Power BI

No score
No answers yet
No answers on this topic

SAP Crystal

SAP Crystal 4.7
Based on 15 answers
The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Nathan Patrick Taylor profile photo

Implementation

Microsoft Power BI

No score
No answers yet
No answers on this topic

SAP Crystal

SAP Crystal 8.8
Based on 14 answers
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
John Suit profile photo

Alternatives Considered

Microsoft Power BI

Microsoft Power BI as I said earlier is unfortunate in relation to the panels but compared to Tableau.Although Microsoft Power BI has a general interface easier to understand in my company because we already have a signature with the package Office 365 that the integration of the same is excellent.
Gabriel Oliveira profile photo

SAP Crystal

As I said before I never used a reporting tool before Crystal Reports but I have since used SSRS. Crystal Reports blows SSRS out of the water. The reports look nicer and it was easier, faster, and better to create a report in Crystal Reports. Prior to using Crystal Reports I wrote reports by coding them using RPG on the iSeries. I could never go back to doing that.
Janet Fawcett profile photo

Return on Investment

Microsoft Power BI

  • I'm using the free version, so the only investment was the time spent to learn how to use the product (which as an Excel user, was very short).
  • I use Excel to store every single bit of information about all the projects I do, and being able to see them visualized helped me see some redundant steps I was taking.
  • No negative impact at all for me.
jim paroly profile photo

SAP Crystal

  • Employee Empowerment - Now that our Crystal Reports are written and published, all of our team members have access to run the same reports across the company. Previously, there was only 1 point person in charge of running reports, which took a lot of time away from other job duties.
  • Increased Employee Efficiency - One of the Crystal Reports my company uses has allowed me to take a task that took 3 days to complete and cut the time down to 4 hours. There was a lot of manual data collection and calculations that were done, which has also led to less errors.
  • Accurate real-time data - Since Crystal Reports are very quick to run, we are able to give real time data to our customers rather than maintaining oudated databases in other systems such as Excel.
Shannon Odland profile photo

Pricing Details

Microsoft Power BI

General

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

Microsoft Power BI Editions & Modules

Additional Pricing Details

SAP Crystal

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

SAP Crystal Editions & Modules

Edition
SAP Crystal Reports 2016 - Full version$4951
SAP Crystal Server 2016 1 NUL$8692
SAP Crystal Server 2016 5 CAL$8,7443
SAP Crystal Reports Viewer 2016$04
SAP Crystal Reports 2016 - Upgrade$2954
  1. per user
  2. per named user
  3. per 5 concurrent users
  4. per user
Additional Pricing Details
* SAP Crystal Reports 2016 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2016 - Full version allows you to create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. If you already have an older version of Crystal Reports, buy a license for SAP Crystal Reports 2016 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2016, 1 NUL includes 1 license of: SAP Crystal Reports 2016 - SAP Crystal Server 2016 - SAP Crystal Dashboard Design 2016. * As an add-on to SAP Crystal Server 2016 1 NUL, SAP Crystal Server 2016 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.

Rating Summary

Likelihood to Recommend

Microsoft Power BI
8.5
SAP Crystal
8.1

Likelihood to Renew

Microsoft Power BI
10.0
SAP Crystal
10.0

Usability

Microsoft Power BI
9.0
SAP Crystal
8.1

Reliability and Availability

Microsoft Power BI
SAP Crystal
8.0

Performance

Microsoft Power BI
SAP Crystal
8.0

Support

Microsoft Power BI
SAP Crystal
4.7

In-Person Training

Microsoft Power BI
SAP Crystal
10.0

Implementation

Microsoft Power BI
SAP Crystal
8.8

Scalability

Microsoft Power BI
SAP Crystal
7.0

Add comparison