TrustRadius
Microsoft BI - Putting the power into your reportingWe use Microsoft BI primarily just within our lab group and department due to its very specific and powerful data visualization capabilities. While it is applicable to almost any work involving data analytics, it might seem like overkill for some people. We have found that it does an excellent job in preparing and displaying the more complex data that we deal with.,Data display in graphs and tables Compatibility with other Microsoft products User-friendly and informative reporting,Data compatibility with non-Microsoft products Data sourcing functionality is poor Offline server functionality impedes out of country work,7,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, QlikView, Tableau Desktop, SAP BusinessObjects Business Intelligence (BI) Platform and IBM Cognos,5,9,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, IBM Cognos, SAP BusinessObjects Business Intelligence (BI) Platform, Tableau Desktop, QlikViewOutstanding Report CreatorSeveral people that I know use Microsoft PowerBI. It is mainly used for reporting for several teams, then I am able to access those reports for my own use. When I use it I import Excel sheets in, and use PowerBI to make them more visually appealing and easier to filter. It works like a charm. I have not seen any issues other than the occasional drag with data sets.,Makes reports more visually appealing Very good variety of formats for charting information Good cloud connectivity (most of the time),Need to be proficient with Excel before diving into PowerBI Only available with a monthly subscription Steep learning curve for many users (including me),10,Whatagraph,10,10,Microsoft 365 Business, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Cisco Aironet Access Points, Cisco Data Center Network Manager, Oracle VM VirtualBox, Oracle Java SE, DameWare Remote Support, Microsoft System Center Configuration Manager, Citrix NetScalerMicrosoft BI - A diamond in the roughData modeling, visualization, and analytics. Microsoft BI is currently only used for dashboarding (descriptive analytics), where data relationship is simple, while most of the predictive analytics are done in other tools.,Easy integration with other Microsoft products. Great integration with R/Python.,Map visualization limit on data count Inability to model data relationship with multiple non unique keys,7,TIBCO Spotfire,9,9,TIBCO SpotfireBusiness Intelligence like you never seen beforeMicrosoft BI is being used by specific departments, providing analysis of different types of data, how resources are being used and even showing how well Support Departments are doing, responding to tickets that are eventually fed to Microsoft BI. There are many problems being addressed, including allowing several types of connections to our data.,Allow many types of connections to our data Makes impressive graphics from the data collected Provides interactive resources and dashboards,Should have support for other operating systems Prices could be a bit better for organizations with more users,10,Zoho Reports,6,10,Microsoft 365 Business, Windows Server, Microsoft Exchange, SolarWinds Netflow Traffic Analyzer, Google Ads (formerly AdWords)Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you useMicrosoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.,As with most every other Microsoft product, Microsoft BI makes setting up and analyzing data about as easy as it gets. Creating graphics is very easy. Connecting to multiple data sources works just fine. Simple reporting and integration with other Microsoft products is great.,Microsoft BI is not top of the for advanced analysis and modeling. Reshaping and restructuring data is doable, but not super simple. Customizing visualizations is sometimes difficult to impossible.,9,Tableau Online, Tableau Public, Alteryx Analytics, TIBCO Spotfire, MicroStrategy Analytics, Microstrategy Usher, SAS Business Intelligence, SAS Advanced Analytics and SAS Data Integration Studio,9,8,Tableau Online, Tableau Public, SAS Business Intelligence, SAS Advanced Analytics, Alteryx Analytics, Microsoft SQL Server, MySQL
Unspecified
Microsoft BI
617 Ratings
Score 7.9 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Microsoft BI Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Microsoft BI
617 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101
Show Filters 
Hide Filters 
Showing 37 of 618 Microsoft BI ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 37)

  Vendors can't alter or remove reviews. Here's why.
Shelby Bowden profile photo
January 23, 2019

Review: "Microsoft BI - Putting the power into your reporting"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

9
Microsoft BI is pretty excellent for data sharing. This is especially true when sharing data across a network that uses Microsoft products. Security, formatting, ease of sharing, and multi-user editing are all great aspects of the Microsoft BI data sharing process. The only downside is when you are sharing to a group that does not have Microsoft BI, but that is to be expected with any program.
Read Shelby Bowden's full review
Michael Timms profile photo
January 17, 2019

Microsoft BI Review: "Outstanding Report Creator"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

10
Microsoft PowerBI is part of the Office 365 suite, so it is remarkably simple to edit your report on the fly and share it out to your team via Sharepoint or Microsoft Teams. The only issue that I have seen is that sometimes with links to older reports it seems like it takes forever for the report to load.
Read Michael Timms's full review
Thomas Young profile photo
January 09, 2019

Review: "Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you use"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
Microsoft BI makes sharing data across the department and organization relatively straight-forward. As long as each user has some understanding of Microsoft BI, sharing data and visualizations couldn't be easier. I'm not really a security guy, but from what I can tell, controlling access works just fine and controlling versioning is also straight-forward. Formatting visualizations is clunky.
Read Thomas Young's full review
Celil ÇİYNEKLİ profile photo
September 07, 2018

Microsoft BI Review: "A Very Powerful and Innovative BI and Virtualization Tool: MS BI"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

10
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).
Read Celil ÇİYNEKLİ's full review
No photo available
January 23, 2019

Microsoft BI Review: "For the IT professional on the go"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
The sharing and collaboration abilities inherent within Microsoft BI are astounding. The ease at which reports can be created and shared across the enterprise make it a time-saving tool. Security features are woven into the design and should be more than sufficient for any size company. Predictive capabilities are also a plus.
Read this authenticated review
No photo available
January 23, 2019

Review: "Microsoft BI is the program you've been waiting for!"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

10
Microsoft is a big company and they have mastered data sharing. Microsoft BI makes it so easy to share with other employees and clients both through an online dashboard and as exported files. The real-time editing makes business much faster and avoids confusion that comes with independent editing. The adjustable permissions make sharing with various people (from employees to clients) a breeze.
Read this authenticated review
No photo available
December 07, 2018

Microsoft BI Review: "Microsoft Business Intelligence is a quick and cheap way to start practicing with data visualization."

Score 9 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
Microsoft BI has built in security that allows for role based access depending on the needs of the end user. Report distribution works well and the ability to share a link to a visualization report is very handy to quickly disperse information quickly pulled out of a product and displayed through BI.
Read this authenticated review
Jason Leidig profile photo
June 19, 2018

Microsoft BI Review: "Power BI will put an S on your chest"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

10
In culmination with SharePoint, the sharing of data using Power BI becomes incredibly flexible. Engagement with data derived from Power BI is really diverse, there is a multitude of ways to communicate the information created in Power BI to all manner of audiences.
Read Jason Leidig's full review
Zee Gimon profile photo
July 14, 2018

Microsoft BI Review: "Ideal for Data Analytics and Visualization, but not for noobs"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
There is a possibility to create any kind of role and access permissions, but it's not the easiest process from what I know (and had experience with). Granted, I am not a developer or system administrator, so I don't usually NEED to create any kind of roles, but yeah. You create a role, then choose the table (database) you need and you can either write a DAX filter expression or choose them from the drop-down menu in your table settings.
Read Zee Gimon's full review
Gonzalo Angeleri profile photo
April 09, 2018

Review: "Microsoft BI - Good choice for departmental deployments and limited budget"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Microsoft BI allows users to access a portal where reports and indicators are published. Sharepoint also integrates very well with Microsoft BI, which greatly improves collaboration capabilities. The access through mobile devices improved a lot in the last versions and it is possible to access the reports, indicators, and dashboards natively from iOS.

Read Gonzalo Angeleri's full review
Yemsi Pino profile photo
May 03, 2018

Microsoft BI Review: "Great Graphics presentations"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
Having control over capabilities and sharing data across teams, is difficult when you have an expensive license and you need it for all of your company. In other words, your collaborations are reduced to the team that has a license. And for a small company, there is only one collaborator. Even for big companies, if the expenses are not inside the limits, they are going to reduce the licenses and the team are going to be 3 mostly. For these reasons, report distributions are not an issue because the company will use other media, i.e. email.
Read Yemsi Pino's full review
Alexander Lubyansky profile photo
August 07, 2016

Microsoft BI Review: "It's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything."

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Honestly, software-based sharing and collaboration are not that important to me or to the work I do. There's this thing called the print screen button. There's also this thing called sending someone a file. It's easy enough to use the tool itself. If you are incapable of using Microsoft BI, you should not be entrusted with "write" permissions on anything made with it.
Read Alexander Lubyansky's full review
Ved Mishra profile photo
February 19, 2016

User Review: "Intelligent big boy Microsoft BI"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Role based and item-level securities can be configured to ensure proper control of report and data. Various collaboration tools like Office 365, SharePoint and other office applications provide platform to share and collaborate. Although, formatting can be sometimes challenging; MS BI reports can be embedded in web-pages to provide user-friendly dashboards.
Read Ved Mishra's full review
Deanne Damato profile photo
February 12, 2016

Review: "Microsoft BI platform good for Reporting but always changing for the rest of the toolset so use caution for your needs."

Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

9
I rated this high because it's a combination of SQL security, AD security and SharePoint security that makes sharing reports easy to do while giving the comfort that it is getting in the right hands.
Read Deanne Damato's full review
Steve Wake profile photo
February 04, 2015

User Review: "Why is Microsoft BI Right for Me?"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Read Steve Wake's full review

Feature Scorecard Summary

Pixel Perfect reports (28)
7.9
Customizable dashboards (34)
7.9
Report Formatting Templates (32)
8.2
Drill-down analysis (30)
8.2
Formatting capabilities (34)
8.4
Integration with R or other statistical packages (27)
8.1
Report sharing and collaboration (34)
8.9
Publish to Web (31)
8.3
Publish to PDF (30)
8.8
Report Versioning (27)
8.1
Report Delivery Scheduling (31)
7.6
Delivery to Remote Servers (12)
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.) (33)
8.4
Location Analytics / Geographic Visualization (30)
7.9
Predictive Analytics (30)
8.0
Multi-User Support (named login) (32)
8.4
Role-Based Security Model (29)
8.1
Multiple Access Permission Levels (Create, Read, Delete) (32)
8.6
Single Sign-On (SSO) (14)
8.5
Responsive Design for Web Access (24)
8.2
Dedicated iOS Application (19)
8.4
Dedicated Android Application (19)
8.1
Dashboard / Report / Visualization Interactivity on Mobile (25)
8.3
REST API (11)
7.9
Javascript API (12)
8.3
iFrames (11)
7.7
Java API (10)
7.5
Themeable User Interface (UI) (10)
7.8
Customizable Platform (Open Source) (8)
7.4

About Microsoft BI

Microsoft BI benefits from the ubiquity of SQL server and the set of tools built around the database, including an ETL layer, master data management, data cleansing, report and reporting.

The reporting engine is SQL Server Reporting Services which does not have the visualization capabilities of  visualization tools like 
Tableau or Qlik. Excel has historically been the platform visualization tool. Power BI for Office 365 has done much to improve the discovery and visualization capabilities of Excel.

Microsoft  now offers Power BI cloud as the visualization platform with geospatial 3D, natural-language query generation, and self-service ETL along with charting and other data visualizations that can be uploaded and shared through the Power BI service. 

The Power BI platform also provides  live access to on-premises Microsoft SQL Server instances, and self-service access to third-party cloud sources including Salesforce, Marketo, Zendesk, and GitHub. Mobility is supported through a native iPad app, an iPhone app.

This new platform is viewed by Microsoft as a visualization layer sitting on top of their earlier generation of installed SQL-based technology.

Microsoft BI Competitors

Pricing

Does not have featureFree Trial Available?No
Has featureFree or Freemium Version Available?Yes
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?No
EditionPricing DetailsTerms
Power BI$0
Power BI Pro$10per user per month

Microsoft BI Technical Details

Deployment Types:SaaS
Operating Systems: Unspecified
Mobile Application:No