TrustRadius
Outstanding 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, MySQLPower BI just works!We currently have limited use of Power BI within our IT and accounting departments for relaying reporting information. We use Power BI to create an efficient interface for our executive team to gain access to vital sales information from our restaurants in a concise, detailed manner as opposed to our traditional Excel spreadsheets. IT uses Power BI to track purchasing as well as within our help desk department.,Great for translating numbers in graphics that are easy to understand and manipulate for anyone with no technical expertise,Additional training and tutorials that exist with Power BI as users are working with it would be beneficial.,9,9,8,Microsoft Office 365, Microsoft Dynamics GP, Windows Server
Unspecified
Microsoft BI
615 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
615 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 55 of 615 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 55)

  Vendors can't alter or remove reviews. Here's why.
Michael Timms profile photo
January 17, 2019

Microsoft BI Review: "Outstanding Report Creator"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

If you are part of an enterprise that is running daily reports to many users, and you want to up your game by making visually stunning, easy to follow reports, PowerBI is the tool for you and well worth the cost. If you are in an environment that runs one report a month, the cost might not be worth it just for some bells and whistles.
Read Michael Timms's full review
Ivan Leung profile photo
January 16, 2019

User Review: "Microsoft BI - A diamond in the rough"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Dashboarding with simple data relationship.

In the oil and gas industry, it's common to be analyzing geospatial items along with cross-sectional data, and this can easily go over the row limit that Microsoft BI has for its map visualization; this is a shortfall.

For high-level dashboarding, say, aggregated data for management reporting, Microsoft BI is perfectly suited due to its professional layout and ease of deployment. The data modeling aspect in Microsoft BI leaves much to be desired as it doesn't allow for many relationships which are rather common in the data used in our industry; this forces users to create a unique key by having to concatenate columns of interest, which tend to result in untidy data and make maintenance difficult.
Read Ivan Leung's full review
Jean Franco profile photo
January 09, 2019

Microsoft BI Review: "Business Intelligence like you never seen before"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

You can have Microsoft BI in any scenario since it can gather information from many different sources. You also need to take into consideration that Microsoft BI provides a lot of resources to developers allowing you to customize and do much more with this tool. In some circumstances where you need to build graphics in real time from sources where you need a task to import the data, it can be cumbersome.
Read Jean Franco'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

Likelihood to Recommend

Microsoft BI is great if you and your team have used Microsoft products for a long time. Connecting Microsoft BI to your current processes will be a breeze. The software also makes it easy to create executive dashboards and automated data reporting. For simple financial reporting, Microsoft BI is as easy as they come.
Read Thomas Young's full review
Brian Caulfield profile photo
October 19, 2018

Microsoft BI Review: "MIcorosft BI - Gather, share and take action on your data"

Score 4 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Microsoft BI is well suited for a data landscape that traverses multiple business units. its ability to bring different type of information together and communicate it in a more concise manner is great. Scenarios that required continuous monitoring and team communication, Microsoft BI is perfect. The ability to access the information on the fly through the mobile app is outstanding.
Read Brian Caulfield'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

Likelihood to Recommend

Microsoft BI is well suitable for Data Mining, Data Analyzing, Reporting, Data Visualizing, Prediction, Data Insight, Distributed Dashboards, Private Dashboards, Complex Data Analysis and Data gathering from any resource (Web, Excel, SQL, Access, Oracle, Text, Google Analytics, MailChimp, many more) projects.
Microsoft BI is less suitable for Big Data, especially if data is larger than a TB.
Read Celil ÇİYNEKLİ's full 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

Likelihood to Recommend

Very affordable, well suited for anyone who wants to try out business intelligence and data visualization without a large time investment up front to get it going.

Not appropriate for very large databases, it can take large datasets a while to load into BI. Not a lot of granularity provided out of the box, though there are many add ons to provide further functionality available.
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

Likelihood to Recommend

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
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

Likelihood to Recommend

If you want Excel on steroids in terms of graphs and data analysis - this is your beast. It has all kinds of visualizations available and you can filter the data to make it as precise as you want. We use it for managing the data from the mobile app and to create visual reports of the users' actions.
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

Likelihood to Recommend

Well suited for:
- Customers with a Microsoft landscape who use MS Office or Office 365, SQL Server and Active Directory a lot.
- Departmental deployments.
- Self-Service Capabilities
- Small Budgets
- Mobile Capabilities

Some issues with:
- non-Microsoft environments
- Complex data sources like SAP.
- Complex calculations in Power BI

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

Likelihood to Recommend

The software is really well designed to make presentations and graphics once the data in the sheets are complete and there are no more corrections. Instead, if you feel that you need corrections you will have to start the process over again. It's frustrating. I think this software requires more capabilities than others, network knowledge and how the Microsoft software is connected.
Read Yemsi Pino's full review
Haibo Yang profile photo
September 26, 2016

Microsoft BI Review: "Think hard on your BI goals"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Read Haibo Yang's full review
Charles Saulnier profile photo
December 15, 2016

Review: "Microsoft BI - a complete BI offer at last!"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Microsoft BI is a no-brainer for departments or enterprises who already work with MS Office or in a Windows environment, since users can easily make connections with actions they already know.

The added functionalities in Excel to connect to data sources, build tables and relationships through PowerPivot makes it a powerful tool that 99% of people already have access to. When linked with SQL Server and Power BI, you have a complete solution for analysing and visualizing data that is easy to use, but at the same time scalable to work with complex DBs and datasets.
Read Charles Saulnier'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

Likelihood to Recommend

Visualization of business data: it's good, fast, and cheap. What more can you ask? With more specialized visualization needs, use Tableau or write code. For complex scientific visualizations, write code.

It's also so much easier communicating about the tool and its visuals to other people who don't spend their lives analyzing complex data. "It's Excel for Big Data!" is really quite simple.

Read Alexander Lubyansky's full review
Megan Juell profile photo
November 15, 2016

Review: "Microsoft BI from a Consultant's Perspective"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It is well suited for organizations that require a scalable environment, rich with features. Windows integrated security and role configurations also make it especially easy to configure advanced security for a large number of users. It may be less necessary/appropriate for projects with simpler needs or organizations running on operating systems other than Windows.
Read Megan Juell's full review
Jasmeet S Babra profile photo
October 24, 2016

Review: "Microsoft BI- Multiple sources, One solution"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Microsoft BI can digest data from a variety of sources like Google Analytics, mailchimp, Facebook, salesforce etc., which is great from a marketing point of view. Data is changing every minute and for a big organization, getting these updates live is a great feature.
Read Jasmeet S Babra's full review
Alina Hera profile photo
October 17, 2016

Microsoft BI Review: "Clean and Clear Data Analytics"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Microsoft BI is best after a bit of training on how to use the program. It is straight forward to use after that and easy to integrate with all your Microsoft programs, and I would recommend it as the next step after Excel because Microsoft BI's capabilities can be very similar to that of Excel.
Read Alina Hera'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

Likelihood to Recommend

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.
Read Ved Mishra's full review

Feature Scorecard Summary

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

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