TrustRadius
MIcorosft BI - Gather, share and take action on your dataMicrosoft BI is a great tool to allow for the visualization and communication of data to my whole team. Microsoft BI is being used in conjunction with many operational KPI's to better drive action and responses to improve or address issues that arise. The main problem solved by BI is the ability to gather and bring together information from multiple sources and unify this data.,Bringing data together from multiple sources Allows for graphical representation of data to improve communication up and down the management chain. Tracking of data for use in the future,Could be more user friendly Improve the learning curve for new users Allow for better integration with mobile app.,4,SAP Access Control,8,6,Microsoft 365 BusinessPower BI will put an S on your chestIt is currently being used at a program level by project controls to provide project performance data to the project team. Engagement with Power BI allows the different stakeholders for the project to engage with performance data providing them the opportunity to be more responsive to issues and opportunities. It keeps everyone that is a part of the project on course and helps drive collaboration with the team members.,The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI. I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training. I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to. Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so. Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI. Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free. Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.,The desktop version is free, monthly updates, free training resources...what's not to love. I'm sure that someone with a higher degree of technical learning will be able to better articulate some negatives for Power BI, I'm just not that guy. I have nothing but appreciation for Power BI.,10,10,10A Very Powerful and Innovative BI and Virtualization Tool: MS BIPower BI is a dashboard, data query and, data modeling tool. You can report your data as quickly and easily as with other competitors. With machine learning ability you can easily query, model and report your data. With the AI supported insight ability, you can drill down to the problems. If you want more analyzing tools, you can do it with the R scripts in Power BI.,User experience (UX) is the top priority for Microsoft in Power BI. It has incredible abilities to query data from the source, such as machine learning. Query, design, and reporting is in one tool. There is no need for additional tools. It can get data from all resources, even in the reporting frame structure. There is no need for a table structure anymore. If you have unstructured data in any resource, machine learning can recognize/learn how to capture it and get data as you wish. If a data requires editing with some Excel operator (mid, left, find, etc), you no longer need to write any command. Power BI is doing it for you with machine learning technology. You just give some example about what you need in data and it recognizes/ learns how to get it and then populate it. Power BI has a lot of dashboard charts, very different range, very different purpose and you can find what you need. Charts look so pretty and configuration is so easy too. If you want to create a report (using a chart), you can type what you need while you are talking to a friend. Power BI creates it simultaneously as you are writing.,Actually, there is one thing I can say. If you are working with huge data, depending on your computer configuration and only with the desktop (free) version, it is a little bit slow.,10,QlikView, SAP BusinessObjects Business Intelligence (BI) Platform and Tableau Desktop,10,10,Micro Focus PPM (formerly HP PPM), Xmind, SAP Analytics CloudIdeal for Data Analytics and Visualization, but not for noobsWe use Microsoft Power BI for one of our client's project data management. He has a database of mobile app users who sign up for the premium account and Power BI is used to analyze the data and build a graphical representation of the given data, which is very convenient when you need to create a presentation or something (or simply want to see your data presented visually.),Data analytics features - you can filter the data according to a billion (it feels like) ways and make sure your data is just what you need. Graphs, charts, and everything else visual - not only you can analyze your data according to filters and everything, you can also make it look good and understandable without having to look through a ton of numbers. It can handle quite large amounts of data input, so this makes it a good addition for the projects that require big data. Works well with other Microsoft products (including .NET projects).,It's not very user-friendly (at least, not if you use it every single day and can tell where a feature is located when you wake up in the middle of the night). It takes some time to get the hang of it. Sometimes it feels like there is just a bit TOO MANY features. I mean, they are all awesome, but it's easy to get lost.,8,9,7Microsoft BI - Good choice for departmental deployments and limited budgetMicrosoft BI is being used as part of a departmental implementation, especially for self-service capabilities. We build our solutions using different Microsoft BI components or tools such as Reporting Services, Integration Services, and Power BI Report Server.,Self Service Capabilities Easy to use Integration with MS Office,Data Quality Capabilities Performance issues in Power BI with some source systems Data Governance features,8,Microsoft SQL Server,7,7,IBM Cognos, MicroStrategy Analytics
Unspecified
Microsoft BI
594 Ratings
Score 7.8 out of 101
TRScore

Microsoft BI Reviews

Microsoft BI
594 Ratings
Score 7.8 out of 101
Show Filters 
Hide Filters 
Showing 26 of 594 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 26)
  Vendors can't alter or remove reviews. Here's why.
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

Data Integration

8
I really like how Microsoft brings data from multiple sources together. I think this is one of the strengths of the software allowing for a more complex accumulation of data and information. This results on more complex analysis but again Microsoft BI does a superb job at making this complex data easy to interpret and take action on.
Read Brian Caulfield's full 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

Data Integration

10
Power BI allows you to connect to a wide range of data sources from Excel workbooks, to enterprise solutions such as SAP, Azure, IBM systems and a myriad of online solutions like Facebook and GitHub and the list of connections is growing rapidly.
Read Jason Leidig'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

Data Integration

10
Microsoft BI uses the Machine Learning tool when gathering data from the web. It can detect page elements and learn what you want to get then find itself a way to get this data.
Read Celil ÇİYNEKLİ'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

Data Integration

9
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.
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

Data Integration

7
Microsoft BI supports a variety of different data sources such as SQL Server, Oracle DB, DB2, Sybase, Excel, Access, Text files, MySQL, Teradata, Amazon Redshift, Azure SQL Database, Azure SQL Data Warehouse, Impala, SAP Business Warehouse, SAP Hana.
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

Data Integration

8
The data is what really matters on a graphic presentation, and if I'm not allowed to edit or to update this data somehow it's like I'm cutting the progress I've been making and have to it do all over again. This is not a solution. On the other hand, the color and options to present graphics solutions are really nice but could be better. That's my goal.
Read Yemsi Pino's full review
Reinaldo André Muralha profile photo
October 16, 2017

User Review: "Microsoft BI - Advanced Surveys"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Microsoft BI allows for integration and merging data from disparate sources, allowing the interconnection of several systems without much effort and at a low cost.
Read Reinaldo André Muralha's full review
Razvan Bulgariu profile photo
February 03, 2017

Review: "Microsoft BI is the perfect Dash-boarding product"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Data Integration

6
You need to have good IT skills to connect different data sources.
Read Razvan Bulgariu'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

Data Integration

8
It's pretty good in terms of range of data sources, the ability to pull from both databases and the hard drive, and the way it compacts/autoformats data. There is still room for improvement in terms of access speed and smarter data formatting.
Read Alexander Lubyansky's full review
Micah Jones profile photo
July 12, 2016

Review: "Microsoft BI is Worth a Look for Business Intelligence"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
It has been really simple to connect data sources, both offline and online.
Read Micah Jones'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

Data Integration

8
Microsoft BI tools can connect to various data sources using ODBC, OData protocols. There are options to connect a range of data sources like Oracle, SQL, IBM DB2, Teradata, Sybase, Informix, Text file and data various other feeds. BI reports can bring data from various data sources and separate data connection. All data is alike once it is imported/connected and available in data-model.
Also, tools and solutions can be modified to fetch data real-time. Minimum download strategy ensures and tool is responsive to latest data changes in the back-end.
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

Data Integration

10
We are standardized on SQL as a platform so connecting databases and data warehouse cubes is extremely easy. The only other data we strive to connect to is data is SharePoint lists and that is easy as well.
Read Deanne Damato's full review
Alain Quesnel profile photo
February 10, 2016

"Microsoft BI Review"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Microsoft BI has a full range of available data sources, from the usual suspects for RDBMSes, to the most common flat file sources
Read Alain Quesnel'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

Data Integration

10
There is no data that I have not been able to get with the Microsoft BI tools. The tools will accept flat files and access any database that has a way to query it, even if that is through a web API. If you need to get some data into a Microsoft BI solution, there is a way to do it. You can go down the custom development route if you have to, but in most cases there is someone else that has tried to do the same thing and shared their solution online for you to use. The Microsoft BI tools are used in so many different companies and scenarios that it is very rare these days that you are first one doing something. There is also the speed factor, depending on the source of the data I have run into more issues with the source systems not being able to keep up with the processing on the Microsoft BI side.
Read Steve Wake's full review
Lee Cullom profile photo
February 03, 2015

Review: "Microsoft BI -- Say GoodBI to the Competition for the Moment."

Score 9 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
If you combine Microsoft SQL enterprise licensing with Azure & Power BI, it's actually difficult to find a data source that can't be leveraged. This has never been a negative in our customer implementations.
Read Lee Cullom's full review
Julia Gusman profile photo
September 25, 2014

Microsoft BI Review: "Microsoft - Your Old Trusted Friend?"

Score 1 out of 10
Vetted Review
Verified User
Review Source

Data Integration

3
It connects nicely to the SQL Server and flat files but once you are trying to go beyond the obvious and say connect to other data bases, you are often left to figure out how to download, install and use some third party plugins.
Read Julia Gusman's full review
Mashhood Syed profile photo
September 14, 2014

Review: "Microsoft BI - A good all around suite of products for the traditional data environment"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

5
I can only speak about the data source we used which was SQL Server. That worked flawlessly. I really am not sure how the application works when you connect it to any other data source or when you merge data (or if thats even possible).
Read Mashhood Syed's full review
Asif Paracha profile photo
March 30, 2015

User Review: "Why I Love Microsoft BI."

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
I never feel issue.
Read Asif Paracha's full review
Jerome Lambert, PhD profile photo
November 06, 2014

Review: "Microsoft BI entering 21st century for its analytical capabilities"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
Microsoft BI is good if you have another tool in which you have all your data sources under a single roof. The Excel add-in from Anametrix, an Ensighten Company, allows you this.
Read Jerome Lambert, PhD's full review
Michał Becker profile photo
September 19, 2014

User Review: "Microsoft BI"

Score 4 out of 10
Vetted Review
Verified User
Review Source

Data Integration

2
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.
Read Michał Becker's full review
Frederic Freyermuth ☁ profile photo
September 12, 2014

Microsoft BI Review: "Useful but reporting could be more sexy..."

Score 6 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Very good connection with data sources inside local architecture. Lack of external connector for cloud based applications like Salesforce.com.
Read Frederic Freyermuth ☁'s full review
No photo available
June 13, 2016

Review: "When you do your homework, Microsoft BI can be a real reporting asset."

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
Again do your homework spend a good 6-10 months (as appropriate for your size of company and data you will be importing) to really understand all of the connections your data has if you spend the time in the pre-planning phase doing and identifying it you will relieve so many headaches down the road when you think everything is connected properly but you missed something and have to go back. Not only will that set your project back but it will also most likely cost you more money in the long run to fix something.
Read this authenticated review
No photo available
March 10, 2016

User Review: "Microsoft BI - A Brand Trust worthy"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
Data source integration is one of a key for any software. Microsoft BI works well integrating with microsoft related products. For other data source integration, the integration is not straight forward.
Read this authenticated review
No photo available
March 07, 2016

User Review: "A personal exprience with Microsoft BI"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Data Integration

9
I think in general MicroSoft BI connectivity is excellent, we would have liked SSRS to be able read from Cognos cubes and it was not possible.
Read this authenticated review
No photo available
February 15, 2016

Microsoft BI Review: "Simple, snappy, flashy"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

6
The software was nice, the problem was price per seat and the slight learning curve. In the end we deemed it best to stick with the more boring simple simple operating look and appeal of Excel and similar more basic Microsoft Applications and Programs, rather than venture into the Microsoft BI system. That is to say it was nice, and very aesthetically pleasing, but ultimately it wasn't for us.
Read this authenticated review

Feature Scorecard Summary

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

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