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 64)
Companies can't remove reviews or game the system. Here's why
Al Mubassir Muin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Better integration with Microsoft products is one of the advantages of using Business Intelligence (BI). It's simple to understand, and plenty of resources are available to outsource it. Many of our existing clients have Microsoft licensing agreements. It's an obvious path when decision-makers want to achieve the outcome with the least amount of additional licensing costs. But first, it's essential to understand the client's goals for the data journey.
Aononna Tazin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Outsourcing work is easy to understand, and there are plenty of resources available in the marketplace. It is expensive, but it is still significantly less costly than the alternatives. Results from Microsoft BI (MSBI) are dependable; therefore, there is no problem with trust. Microsoft BI (MSBI) has a dedicated customer service team that is always ready to assist us.
Nilufa Hossain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
MSBI is great for data collection and reporting, but it lacks the visual appeal and features of Power BI. Even though it's still useful, it falls short of Power BI in terms of features. There's no reason to doubt MSBI's findings. MSBI has a proactive customer service team that promptly responds to inquiries. For any unresolved issues, there are numerous videos available online.
June 03, 2021

Microsoft BI

Score 9 out of 10
Vetted Review
Verified User
Review Source
Easy data load through Excel.
Data load using standard API is possible.
Data synchronized and harmonized.
Improved data quality.
Data Maintenance efforts greatly reduced.
Data comparison between multiple applications within IT landscape is possible because of which data attributes like payment terms, tax codes, General Ledger Accounts etc., can be kept in sync.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Each of the solutions has their pros and cons, but Microsoft's BI offerings provide the best "bang for the buck." Few solutions available offer the breadth of feature functionality in a single package, with BI and database generally being sold as separate offerings. However, even if using only the BI tools (say as an existing Oracle customer), the value proposition still holds up. As subscription licensing has evolved, Microsoft has remained at least competitive, and generally a far better cost option than competitors. Ignoring price, the overall feature set is on par with virtually any other BI suite on the market. Of course, there are some aspects of other tools that I with MS would incorporate (such as a true semantic layer such as Cognos Framework Manager), but when taken as a whole across feature set, price, support, community, etc. it is the best overall value.
Score 8 out of 10
Vetted Review
Verified User
Review Source
A lot of our existing client base has licensing agreements in place with Microsoft, couple that with decision-makers wanting to achieve the outcome with the least amount of additional licensing costs added, and it becomes an obvious path, however, it is very crucial to first truly understand what the client is trying to achieve in the short and long term of their data journey.
Score 9 out of 10
Vetted Review
Verified User
Review Source
The biggest player against Microsoft BI (MSBI) was Tableau, which was acquired by Salesforce. Recently there have been other standalone software/applications that provide similar functionality to Microsoft BI (MSBI). Because my company is a Microsoft shop, we have not explored other options. But I believe you can easily find other solutions. Google also has its own stack of applications that provide similar features to Microsoft BI (MSBI). Although I think Microsoft BI (MSBI) might be more powerful and resourceful than its competitors.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Tableau's feature set is comparable to Microsoft BI at a potentially lower cost, however, Microsoft provides better integration into a Microsoft Environment and more flexible deployment options. Microsoft also provides better enterprise support than Tableau (although this may be subjective). In the end, Microsoft BI was chosen to power our performance management platform thanks to its seamless integration into the backend (SharePoint).
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Tableau is more robust but also more complicated - Microsoft BI provides scaled-down features of Tableau in an easier-to-user format (ie. less training for users to accomplish fairly simple data work).
Score 7 out of 10
Vetted Review
Verified User
Review Source
Unlike Oracle Business Intelligence Cloud Service (OBICS), Microsoft BI offers a good range of visualisation options. However, it falls behind in terms of data management capabilities. If your requirements are more data intensive and less reporting intensive, then Microsoft BI may not be the best tool.

In terms of similarities, Microsoft BI is closest to Tableau - however, I would still recommend Tableau as a better option than Microsoft BI because Tableau allows data integration across multiple sources comfortably.
Thomas Young | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microsoft BI has an advantage over other BI platforms because it integrates nicely with the Microsoft products, such as Excel, Microsoft SQL, Access, and all the other parts of the Microsoft business. A user that has spent time with Microsoft products will find Microsoft BI to be similar in functionality to other Microsoft products. Microsoft puts ease of use as a top priority, and it shows up in Microsoft BI. Microsoft BI is, of course, not the top business intelligence platform. It does not have the nicest graphics, the biggest user base, or the most advanced analytics capabilities. It's sort of a starter BI solution.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We initially considered Google Analytics, but eventually decided against it due to the licensing terms and the associated software that we would need to incorporate. IBM Cognos is great at what it does, as long as you are trying to integrate with software that is on their compatibility list. Thus, in the end, we went with Microsoft BI.
Shelby Bowden | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
Specific data displays are some of the strongest aspects of Microsoft BI when compared to alternate programs. It also does a superior job in compatibility with many programs, especially those from Microsoft. Since my company primarily uses Office 365 and other Microsoft products, Microsoft BI is the natural choice among competitors.
Score 10 out of 10
Vetted Review
Verified User
Review Source
The other programs listed are excellent. I have always been a fan of Google products because they are user-friendly and easily accessible by most. They also produce excellent data outputs. Google is still great for companies of any size but I believe Microsoft BI is an even better alternative for larger companies especially. The cost difference may be something worth taking into account if your company is on a very limited budget, but Microsoft BI is for sure a worthy investment.
Michael Timms | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Whatagraph
To be honest, I have never used anything similar to PowerBI. I have seen reports that come from Whatagraph, but I have never used it myself, so that is the only application that I can sort of compare it too. Just looking at the visuals from both, PowerBI reports are better looking, but that is an unfair comparison because I have not used it and don't know if they have similar options. I have just seen the end result.