Microsoft BI (MSBI)

Microsoft BI (MSBI)

About TrustRadius Scoring
Score 8.2 out of 100
Microsoft BI (MSBI)

Overview

Recent Reviews

Microsoft BI

9 out of 10
June 03, 2021
Microsoft BI being used by Master Data Management team like Vendors data, Customers data, Sites data, Bank, Bank Accounts, Customer …
Continue reading

MSBI - Bang for the Buck

8 out of 10
April 26, 2021
The Microsoft BI stack is being used as the enterprise BI software by our organization. The full stack of BI tools (SSAS, SSRS, and SSIS) …
Continue reading

Popular Features

View all 28 features

Formatting capabilities (52)

8.6
86%

Report sharing and collaboration (52)

8.5
85%

Customizable dashboards (52)

8.5
85%

Report Formatting Templates (50)

8.2
82%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Microsoft BI (MSBI), and make your voice heard!

Pricing

View all pricing

Power BI Pro

$9.99

Cloud
per user/per month

Power BI Premium

4,995

Cloud
per month

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://powerbi.microsoft.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

BI Standard Reporting

8.5
85%

Ad-hoc Reporting

8.6
86%

Report Output and Scheduling

8.6
86%

Data Discovery and Visualization

8.4
84%

Access Control and Security

8.6
86%

Mobile Capabilities

8.7
87%

Application Program Interfaces (APIs) / Embedding

8.4
84%

Product Details

What is 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

Microsoft BI (MSBI) Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is Microsoft BI (MSBI)?

Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.

What is Microsoft BI (MSBI)'s best feature?

Reviewers rate Single Sign-On (SSO) highest, with a score of 9.1.

Who uses Microsoft BI (MSBI)?

The most common users of Microsoft BI (MSBI) are from Enterprises (1,001+ employees) and the Information Technology & Services industry.

Reviews

(1-25 of 76)
Companies can't remove reviews or game the system. Here's why
Swarnabh Sarmah | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI is well suited for
  • Displaying sales analysis dashboard.
  • Displaying dashboard of customer segmentation.
  • Displaying product sales dashboard.
  • Displaying marketing campaign insight dashboard.
  • Displaying dashboard of financial analytics.
Microsoft BI is less appropriate for
  • New users with little to no knowledge of Microsoft Excel.
  • Handling large amounts of Data.
Al Mubassir Muin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI works well with Microsoft's ecosystems, especially SharePoint and SQL Server. Even large, complex datasets can be manipulated and turned into useful information. The platform's lists feature can fill any relevant data gaps when used with SharePoint. Its user-friendly graphical user interface makes it simple to quickly and efficiently display data. Aside from that, the reporting tools are first-rate.
Aononna Tazin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI excels at presenting complex and large data sets in a manageable and informative manner. This program's user-friendly graphical interface makes it simple to view data. Other than that, the reporting features are above average for this type of software. It's widely used with Microsoft products, but it doesn't work well with other programs. With limited physical resources, the free version is recommended for minor data work.
Nilufa Hossain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
The Microsoft BI suite of tools, which comprises tools from the SQL Server suite, provides end-to-end features and functionality for businesses of any size. Users who need dashboards and reports fast will benefit from this tool. It’s simple to connect to databases, cloud storage systems, and CSV files of any type. This makes the dashboards suitable for a more rapid presentation workflow because we can easily incorporate them into PowerPoint presentations. Enterprise and standard editions are both available for some tools.
Score 8 out of 10
Vetted Review
Verified User
Review Source
The Microsoft BI suite of tools, largely composed of tools within the SQL Server suite, provide a full range of end-to-end feature/functionality for businesses of any size. Some flavor of the tool features is available whether using standard or enterprise editions, making the tools accessible for even smaller businesses. Scalability has become excellent over the years, particularly for SSIS and SSRS.
Score 10 out of 10
Vetted Review
Verified User
Review Source
I think Microsoft Business Intelligence tools are really suitable for data analysts and managers who aim to generate dashboards and reports quickly. It easily integrates with data sources of any type such as databases , cloud storage systems , csv files or json file. The dashboards can be easily put into PowerPoint presentations which makes it suitable for faster presentation workflow , especially for managers.
Score 8 out of 10
Vetted Review
Verified User
Review Source
If the client you are dealing with already has existing Microsoft licensing agreements, selecting the Microsoft Stack may be a no-brainer. However, truly understanding the client's needs is the most important place to start versus selecting the technology stack. B2C clients that need a visualization tool may need to look elsewhere if you are looking for a data visualization tool, as costs for licensing are high at the time of writing.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Most suited when you have multiple data sources that need to be collected to build one single landing dashboard and you want insights with graphs and visual representations. It's easy to manage and learn, and the transition from Excel is not too difficult.

Less appropriate when you have data in various different formats and it not 100% clean. The licensing can be a pain if you are thinking of sharing the dashboards with external members.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI will fit seamlessly into Microsoft ecosystems, especially when used with SharePoint and SQL Server. Larger companies with big data sets will be able to justify the high cost of ownership. The platform works well when used to drive strategic decision making and can compensate for gaps in relevant data when used with the lists feature in SharePoint.
Score 9 out of 10
Vetted Review
Verified User
Review Source
It works great for our purposes. I highly recommend hiring a consultant to set it up for you though. I don't think we would have gotten very far had we tried to setup the reports and views ourselves. We're very happy with the results we've seen so far. We've been using it for about 3-4 months.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I would recommend this for smaller data work where users and physical resources are limited as the free version can accomplish a good amount. However, I would only recommend this to organizations which either do not need to share the visualizations/data work or are an Office365 organization as without that it is quite difficult to share/collaborate on projects.
Score 7 out of 10
Vetted Review
Verified User
Review Source
If your primary use case requires the use of several visualisation options and graphical representations, then Microsoft BI might be a good option to use. However, if your data management needs do not revolve around reporting, then it is better to go with other standard business intelligence tools available in the market like Oracle BI or Tableau.
Thomas Young | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
February 05, 2019

Great BI tool

Score 8 out of 10
Vetted Review
Verified User
Review Source
It's a great tool that offers full benefits of self-service BI with very little need for interaction with the IT department. The Power BI Desktop and Mobile application, in particular, has added a lot of value for our business objectives.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI is a terrific tool to use when you need to pull data from various sources, and especially powerful in its ability to display the actionable information on a single dashboard. It is the "go-to" solution for the company that wants to move to the next level of pivot tables, dynamic charting and business intelligence reporting.
Shelby Bowden | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
For large and complex datasets, Microsoft BI excels in presenting the data in a manageable and informative way. Its graphical interface does a great job of quickly and easily displaying data, and the reporting tools are well above average for analytical software. It is also great when used in conjunction with other Microsoft products, but does not do well when paired with alternate programs.
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is extremely well suited for companies (of any size) dealing with large data quantities who have to compile and analyze the data in a short amount of time. I have found it very efficient for my company, as it allows a lot of flexibility for data display and is so user-friendly.
Michael Timms | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.