Microsoft BI (MSBI) Reviews

816 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 69)

Companies can't remove reviews or game the system. Here's why.
Bradley Geppert | TrustRadius Reviewer
April 22, 2020

Microsoft PowerBI unleashes the power of your data

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to access the data and views you have created
  • Simple filtering of data views
  • Ability to view live or near live data
  • It runs in a browser and some browsers work better than others
  • Sometimes you start getting wacky results and you have to refresh the page to reset the views
Read Bradley Geppert's full review
Ashutosh Gaikwad | TrustRadius Reviewer
March 14, 2020

Microsoft BI the killer data analytics and visualization tool

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Creating amazing dashboards
  • You can create a variety of reports and can be scheduled automatically.
  • You can integrate big data in Microsoft BI.
  • It gets hanged while developing complex report which hampers productivity
  • You require pro version to do most of the task
Read Ashutosh Gaikwad's full review
Anonymous | TrustRadius Reviewer
April 25, 2020

Best when used by larger companies in a predominantly Microsoft environment

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Powerful analytical and trending tools.
  • Compatibility with different data sources (including non-Microsoft).
  • Attractive dashboard visuals.
  • Seamless integration into a Microsoft ecosystem.
  • Pricing is not as competitive as alternatives.
  • Online / Cloud versions are lacking in features.
  • Desktop (free) version has limited features.
Read this authenticated review
Anonymous | TrustRadius Reviewer
February 11, 2020

Great, easy to use product - provided you are an Office365 organization.

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The platform is fairly easy to use when compared to other data analytics solutions.
  • Collaborating with other colleagues on data work is extremely simple.
  • If your organization is not an Office365 organization, it becomes challenging to share/collaborate on data projects without creating new accounts and new subscriptions.
  • Limited ability to change the options in your visuals.
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 05, 2019

Excellent BI Stack for an all-in-one solution architecture, however may need specialized platforms for non-traditional datasets

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Great traditional ETL data gathering tools.
  • Large technical user community.
  • Excellent data visualization tools.
  • The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
  • Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
  • Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
Read this authenticated review
Thomas Young | TrustRadius Reviewer
February 17, 2019

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

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Thomas Young's full review
Shelby Bowden | TrustRadius Reviewer
January 23, 2019

Microsoft BI - Putting the power into your reporting

Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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
Read Shelby Bowden's full review
Michael Timms | TrustRadius Reviewer
January 17, 2019

Outstanding Report Creator

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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)
Read Michael Timms's full review
Jason Shaw | TrustRadius Reviewer
December 06, 2018

Power BI just works!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Jason Shaw's full review
Lakhan Suri | TrustRadius Reviewer
January 12, 2019

Multiple tools in single package.

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Create packages to move data and perform different data related tasks using SSIS
  • Create reports to summarize the data in an understandable form using SSRS
  • Analyze the data provided by teams and create data cubes and reports to understand the data properly using SSAS.
  • It should be an open source tool for a vast variety of implementation.
  • You need to buy a licensed server to maintain MSBI
  • Need a proper course or content to learn concepts, which sometimes creates difficulty.
Read Lakhan Suri's full review
Anonymous | TrustRadius Reviewer
March 19, 2019

Good for visualisations and reporting!

Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Good range of visualisation features.
  • Very easy to setup and get onboard.
  • Handles data integration from multiple sources decently well.
  • Not advisable to use Microsoft BI as a standalone primary tool for data management.
  • The process of moulding or repurposing data is not easy.
  • Integrating Microsoft BI with non-Microsoft tools is a huge pain.
Read this authenticated review
Anonymous | TrustRadius Reviewer
February 05, 2019

Great BI tool

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Report generation from our back end data warehouse has become way more streamlined using this tool.
  • By using the Power Pivot and Power View it has enabled us to access and mash up data from a variety of sources. Plus it can easily be shared with other users through simple Office applications.
  • The implementation time for Microsoft BI can be fairly lengthy. It's definitely longer than some of the other products we evaluated.
  • The upfront investment in terms of capital and time is fairly large with this tool. It requires a compliant Microsoft SQL server in the back end to leverage most of its functionality.
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 23, 2019

For the IT professional on the go

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Microsoft BI allows us to combine data from multiple sources, build data models, create visualizations, and share the results.
  • Cloud Interactive charts in a cloud that can be easily shared
  • Connectors to popular data sources, allowing us to integrate with almost any system
  • More authentication methods to allow power users to connect directly to Web APIs.
  • It can be quite difficult to setup without guided assistance from experienced users
  • Limits on dataset size.
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 23, 2019

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

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is a very user-friendly interface! Doesn't take long to learn and be able to make some great graphs.
  • The accessibility and sharing capabilities are beyond wonderful-- it has made it easy to share between employees before sending out final reports and it is easy to share with clients who need something to look at before the full report is finished.
  • There are a lot of options for data display and they can be as complex or simple as you want and still look amazing.
  • They have a great online resource for help and tutorials. If you don't catch on quickly on your own, it is quite easy to do some reading online and teach yourself.
  • The Microsoft BI app can be finicky at times and it would be great for that to be more streamlined. We sometimes require data to be shown during fieldwork, and a functional app makes a big difference.
  • The program doesn't always remember my settings. This may just be a glitch with the program on my computer, but it would be a huge timesaver if I didn't have to reset my preferences every week.
Read this authenticated review
Anonymous | TrustRadius Reviewer
December 07, 2018

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

Pros and Cons

  • Easy to learn the software.
  • Allows complex queries to be created ad hoc and ran against databases quickly.
  • Gives the users the ability to empower their departments by setting up easy to implement visualizations.
  • Understanding the full scope of the software takes a lot of time.
  • It doesn't handle very large datasets well, importing can take a while.
  • I have not found a way to build scheduled reports.
Read this authenticated review
Brian Caulfield | TrustRadius Reviewer
October 19, 2018

MIcorosft BI - Gather, share and take action on your data

Score 4 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Brian Caulfield's full review
Jason Leidig | TrustRadius Reviewer
June 19, 2018

Power BI will put an S on your chest

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Jason Leidig's full review
Celil ÇİYNEKLİ | TrustRadius Reviewer
September 07, 2018

A Very Powerful and Innovative BI and Virtualization Tool: MS BI

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Celil ÇİYNEKLİ's full review
Zee Gimon | TrustRadius Reviewer
July 14, 2018

Ideal for Data Analytics and Visualization, but not for noobs

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Zee Gimon's full review

Feature Scorecard Summary

Pixel Perfect reports (38)
7.8
Customizable dashboards (45)
8.3
Report Formatting Templates (43)
8.4
Drill-down analysis (40)
8.0
Formatting capabilities (45)
7.8
Integration with R or other statistical packages (36)
7.5
Report sharing and collaboration (45)
8.1
Publish to Web (40)
7.5
Publish to PDF (40)
7.9
Report Versioning (36)
7.4
Report Delivery Scheduling (40)
7.5
Delivery to Remote Servers (21)
6.9
Pre-built visualization formats (heatmaps, scatter plots etc.) (43)
7.8
Location Analytics / Geographic Visualization (40)
7.9
Predictive Analytics (38)
7.6
Multi-User Support (named login) (42)
8.3
Role-Based Security Model (39)
7.9
Multiple Access Permission Levels (Create, Read, Delete) (43)
8.4
Single Sign-On (SSO) (24)
8.6
Responsive Design for Web Access (32)
7.7
Dedicated iOS Application (25)
7.7
Dedicated Android Application (25)
7.8
Dashboard / Report / Visualization Interactivity on Mobile (33)
7.5
REST API (16)
6.9
Javascript API (17)
7.5
iFrames (16)
7.4
Java API (15)
7.6
Themeable User Interface (UI) (15)
6.9
Customizable Platform (Open Source) (11)
6.8

About Microsoft BI (MSBI)

Microsoft BI (MSBI) 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 (MSBI) Competitors

Oracle Analytics Server (formerly Oracle BI Foundation Suite), Spoom (formerly Analyza)

Microsoft BI (MSBI) 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 (MSBI) Technical Details

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