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-7 of 7)
Companies can't remove reviews or game the system. Here's why
Robert Goodman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Jacob Saunders | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
Sean Brady | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
You need to have (1) a very solid SQL Server DBA and (2) a Windows Server administrator with domain administrator rights to get the BI stack set up correctly. As most Windows systems people will tell you, a lot of good comes out of doing some security planning on the domain side (users, groups, roles, etc.) before you start the implementation. This is a big integrated system, and getting it set up right is half the battle.
On the development side, you will want to have a full time data architect making sure that the model you are developing holds together and supports the reporting requirements of the business. You will also want a technical lead who has rich experience with the stack - that person will be able to shepherd the rest of the development team and help them come up to speed with the tools.