What users are saying about

Microsoft BI

554 Ratings

Microsoft BI

554 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Microsoft BI

Microsoft has pulled a great trick. The trick is getting you into the pricing for only $20 to $50 dollars a month. They then made it very easy to push to the SharePoint site and keep it updated with free gateway product that will keep your reports live and consistently updated. Now here is a gotcha....IF you use the Data modeling tool (Power Query) for example that is then connected to a large database, you will have no issues. The issues begin at publishing information to SharePoint. There is a size limitation to how large the excel sheet can be. I would point out that we are not making large spread sheets with Pivot tables and millions of rows of data. We are simply connecting through Power Query. The sheet is still very small but the issue is the data model size. This is tapped at a gig on SharePoint. To be considered a true enterprise product, this size limitation will have to be overcome. There is a (not sure if beta or not) version of some of the power views that can be done in Power BI. These views when rendered locally are wonderful. When they are rendered from the web, they can take a little longer. The part that can be agonizing is the showing views through HTML5. This is almost unworkable when using power maps or maps through power view. The response is so jittery that it is almost unusable

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.4
Pixel Perfect reports
Microsoft BI
8.4
Customizable dashboards
Microsoft BI
8.5
Report Formatting Templates
Microsoft BI
8.4

Ad-hoc Reporting

Microsoft BI
8.5
Drill-down analysis
Microsoft BI
8.7
Formatting capabilities
Microsoft BI
8.3
Integration with R or other statistical packages
Microsoft BI
8.2
Report sharing and collaboration
Microsoft BI
8.9

Report Output and Scheduling

Microsoft BI
8.8
Publish to Web
Microsoft BI
9.0
Publish to PDF
Microsoft BI
8.8
Report Versioning
Microsoft BI
8.8
Report Delivery Scheduling
Microsoft BI
9.0
Delivery to Remote Servers
Microsoft BI
8.5

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • The parallel data warehouse is a massive storage appliance with exceptional speed.
  • The platform is all Microsoft and integrates well with all other Microsoft products and infrastructure.
  • Microsoft's support of the product has been outstanding.

Cons

  • The end-user reporting tool, Report Builder, is not that flexible. We feel that the Cognos Report Studio tool is more robust in this area.

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
It is the best fit BI solution for a Microsoft shop - nobody else is even close on integration capabilities, feature set, and price at this point.

Usability

Microsoft BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.

Performance

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.

Support

Microsoft BI7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.

In-Person Training

Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.

Online Training

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.

Implementation

Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.

Breadth of Deployment

Not widely used. It's being deployed across the organization.

Alternatives Considered

Microsoft BI is ideal for proficient Excel users, and it is the best choice in terms of visualizations. We decided to use Microsoft BI for these reasons

Collaboration and Sharing

Microsoft BI8.3
Based on 25 answers
Sharing and accessing files is always easy with Microsoft programs and applications. Very straight forward as one would expect. Never any hassle or problem with regards to sharing files

Data Integration

Microsoft BI8.5
Based on 24 answers
It's weak, and that's it. You need external tools or a lot of knowledge to load data on SQL Server in order to use it in Microsoft stack

Return on Investment

  • The main front end for Microsoft BI is now Excel. The number one spreadsheet tool used in business that everyone already knows how to use. Now it is just a matter of showing a few new features and some best practices. That's a huge ROI gain right there.

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