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-15 of 15)
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 one of the best data visualization tools available in the market. It also has various interesting features. Unlike other BI tools, Microsoft BI has more than 200 visuals available. One can find almost all kinds of data source accessibility in Microsoft BI. It also helps in presenting the current status of ongoing work.
Al Mubassir Muin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It's simple to use, but novices may find it a little challenging. MSBI on-premises should be looking forward to tackling "modern" ETL capabilities, such as data extraction from the cloud, API calls, etc. A sizeable MSBI community can answer inquiries about technical resources. BI implementations are generally well supported in most organizations' ecosystems.
Aononna Tazin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It's easy to learn and deploy, and it works for us. We have a very responsive customer service team, and all issues are resolved promptly. The tool requires initial training, but it's just a few clicks to generate a good report after that. Microsoft BI (MSBI) ensures that the applications are always in sync with the most accurate data.
Nilufa Hossain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It's easy to use, but not the most user-friendly for new users. MSBI should consider how to deal with modern ETL capabilities now available. Getting data using APIs and cloud services, and so on. Customer service is prompt in responding to issues and resolving them. BI implementation is most successful in organizations with a supportive ecosystem.
Score 8 out of 10
Vetted Review
Verified User
Review Source
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users.
For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Again , I used it on a personal level for generating quick visualizations for geographical data. I think for me as a programmer I found it easy to use , the whole workflow of connecting data to Microsoft BI to generating dashboard of visualizations was smooth and easy to learn. So usability wise I rate it highly. There are a whole lot of nifty features such as predictive analysis which I didn't use but I am sure will be useful for other audience.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Overall simple to use from a development standpoint. The Large MSBI community base helps with technical resource queries. MSBI on-prem stack should look forward on how to tackle "modern" ETL capabilities, i.e. pulling data from the cloud, API calls, etc. Overall the ecosystem is pretty good for BI implementations at most organizations.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Love it! Microsoft BI (MSBI) is a great tool and Microsoft is constantly making updates to make it better every day. It's an easy tool to learn and there are tons of resources available on the web to help with any questions you may have. The training is helpful, detailed, and updated on a regular basis. If you think that there are some features or capabilities missing, you can reach out to the Microsoft BI (MSBI) team and they will definitely help you out.
Sean Warren | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:

1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries.

2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI.

It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend.