What users are saying about

Microsoft BI

593 Ratings

Microsoft BI

593 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Microsoft BI

I found that Tableau is more efficient in providing options to calculate measures, percentages as compared to MS BI Power Pivot. Also, Tableau is more web-friendly. However, analytic capability is well suited in Microsoft BI. Microsoft BI is well suited in larger organization setup which requires various integration with external line of business applications. Sometimes, the cost impact can be bigger for smaller organizations as they look for savings while shopping for minimum viable product.
Ved Mishra profile photo

Feature Rating Comparison

BI Standard Reporting

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

Ad-hoc Reporting

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

Report Output and Scheduling

Microsoft BI
8.7
Publish to Web
Microsoft BI
8.7
Publish to PDF
Microsoft BI
8.5
Report Versioning
Microsoft BI
8.8
Report Delivery Scheduling
Microsoft BI
8.8
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.0
Location Analytics / Geographic Visualization
Microsoft BI
8.8
Predictive Analytics
Microsoft BI
8.5

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • The interfaces of the products are familiar to most people that currently use Microsoft products so its comfortable in that respect
  • Creating a report is easy to do with drag/drop functionality. You also have alot of dropdowns. You can use formulas the same way you do in Excel. They have "expressions" which are like formulas with a mix of SQL.
  • Publishing a report to the server is simple as well. You go to the server and upload the file from your file directory.
  • Setting up subscriptions is simple as well. Anyone can do it with minimal knowledge. Its sort of like creating a recurring calendar event.
  • The hierarchy within SSRS is intuitive. A Project is the top level item. You can add as many reports as you want to a project. Similar to any other IDE where you keep all your files in one project (HTML, CSS, JavaScript, JSP, Servlet) except in the case of SSRS its all reports.
  • Whether you choose to use 2008 or 2012 the interface is layed pretty much the same. So if you start of in 2008 and then upgrade, you dont have to re-learn anything. Their are slight differences in the two versions but it wont hinder your ability to build a report.
Mashhood Syed profile photo

Cons

  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.
Steve Wake profile photo

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.
Robert Goodman profile photo

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

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.
Robert Goodman profile photo

Support

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

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

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

Microsoft BI9.6
Based on 7 answers
You need to have (1) a very solid SQL Server DBA and (2) a Windows Server administrator with domain administrator rights to get the BI stack set up correctly. As most Windows systems people will tell you, a lot of good comes out of doing some security planning on the domain side (users, groups, roles, etc.) before you start the implementation. This is a big integrated system, and getting it set up right is half the battle.On the development side, you will want to have a full time data architect making sure that the model you are developing holds together and supports the reporting requirements of the business. You will also want a technical lead who has rich experience with the stack - that person will be able to shepherd the rest of the development team and help them come up to speed with the tools.
Sean Brady profile photo

Breadth of Deployment

Not widely used. It's being deployed across the organization.
Jerome Lambert, PhD profile photo

Alternatives Considered

Microsoft is a distant me too in a world that is crowded and drowning in BI Me too products. Visualizations 5/10. Micro Strategy, ClickView, Domo, BOBJ etc will kill this product. The issue is cost and speed to implementation. The cost is far less than any of the previously mentioned items. The implementation time could be a fraction of those products. The implementation of this product can be as simple as connecting Excel to the database (Create the relationships that you can do in the dbase or the query in Excel) and pushing to the Cloud. From the cloud based app you simply launch the gateway. The gateway is a breeze for anyone to connect with. The gateway only needs path back and its a breeze. No IT guys needed, no professional services, no firewalls or routing tables to configure. Just plug and play. This feature alone is the key product differentiation in my review. We already had the tables developed and ETL be damned, they all push from the MS-SQL dbase directly to cloud. Is this going to be big and fast in an environment with Data Universe's, API's to other products, and true Enterprise class features. I dont think so. Is it good enough for most small to medium companies or departments? Yes
Sean Warren profile photo

Collaboration and Sharing

Microsoft BI8.2
Based on 27 answers
You can publish dashboards or reports from the web or desktop versions in many ways. From the web side, you can distribute dashboards or reports over roll based, user based or user group. From the desktop side, you can distribute dashboards or reports by file (MS BI report file, MS Excel, MS Access, and other formats).
Celil ÇİYNEKLİ profile photo

Data Integration

Microsoft BI8.7
Based on 26 answers
Microsoft Power BI offers a good set of data sources - anywhere from Excel / CSV to JSON to Azure databases. For our client's project, we use the Azure database (the backend of the project is written using .NET) and it's quick and convenient - you simply login and ta-da, you have all your data to manage
Zee Gimon profile photo

Return on Investment

  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
No photo available

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