Skip to main content
TrustRadius
Microsoft BI (MSBI)

Microsoft BI (MSBI)

Overview

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.

Read more
Recent Reviews

Casual User’s POC

8 out of 10
February 08, 2020
Incentivized
Microsoft BI is being used for report generation to monitor ongoing technology projects and business initiatives. We have two users who …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 30 features
  • Report sharing and collaboration (49)
    8.9
    89%
  • Report Formatting Templates (47)
    8.9
    89%
  • Formatting capabilities (49)
    8.0
    80%
  • Customizable dashboards (49)
    8.0
    80%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

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
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

8.6
Avg 8.2

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

8.7
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

8.9
Avg 8.4

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

9
Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

9
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.5
Avg 8.0

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

8.8
Avg 7.9
Return to navigation

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 TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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.

Oracle Analytics Server and Spoom are common alternatives for Microsoft BI (MSBI).

Reviewers rate Dashboard / Report / Visualization Interactivity on Mobile highest, with a score of 9.9.

The most common users of Microsoft BI (MSBI) are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(937)

Attribute Ratings

Reviews

(26-50 of 62)
Companies can't remove reviews or game the system. Here's why
Yemsi Pino | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
The software stacks [well] because it has more graphics resolution and the colors are fresh and actualized. On the other hand, there is the Microsoft family software and this is an advantage. Microsoft has a lot of users around the world and it's like everyone knows how to do things intuitively, even if they are wrong, because of previous knowledge with the software vendor.
Gonzalo Angeleri | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is mainly based on Microsoft SQL Server, so it is perfectly integrated. Many of the Microsoft BI components require using SQL Server as the database engine. Generally, the functionalities that are achieved when using SQL Server as a database engine are greater than when using any other engine.
Reinaldo André Muralha | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is an extension of Microsoft SQL Server, it can be used to develop the data warehousing of the information stored in SQL Server and also turn that information in fully customizable reports.
Razvan Bulgariu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
TIBCO Spotfire is better in loading multiple data sources, a bit faster on data mining, but not so nice on the dashboard side if this needs to be accessed by several users. On the other hand, Microsoft BI is perfect for an online dashboard.
Charles Saulnier | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
For analysis and visualization, Power BI is aiming to take a large chunk of Tableau's market share. The rhythm of iterations at this time has in my opinion given the momentum to Power BI. The added functionalities in Excel also make it possible for intermediate users to get familiar with data modeling.
Megan Juell | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI has many more features than MySQL and contains a set of fully-integrated applications to cover all BI needs. It is widely used as an enterprise-level BI system among our clients, allowing us to easily design solutions in-house and implement them in our clients' environments. Additionally, Microsoft provides methods for importing/exporting data that may be sourced from or delivered to outside sources/destinations.
Jasmeet S Babra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is very well suited to implement reporting and visualization within departments. Choosing Microsoft BI over tools like Tableau is the variety of third party apps it extracts data from. This functionality is limited in Tableau as it digests data from large data sources like SQL etc.
Especially for marketing departments where data is coming from social media campaigns, email campaigns, and other campaigns, BI handles it all very well.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
One of the main reasons Microsoft BI was chosen by our company is because it is a reliable program. We tried different programs in the past (and currently also use other ones for certain reporting and analysis needs) but Microsoft BI was the least buggy out of our top choices.
Alexander Lubyansky | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Looking at the visualization portion of BI, there are three types of tools.
  1. Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
  2. Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
  3. More generic software offered by the big IT companies, often part of a BI suite. There's really a lot of variety here. Use this when it fits the workflow and you are already using the relevant software. But, personally, I'd still use the specialist software.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Our company's implementation of Business Warehouse was abhorrent. It was so clunky and unreliable we couldn't get any real reporting information from the warehouse itself. It wasn't sleek at all and everything had to be manually downloaded and plugged into an offline spreadsheet to generate any kind of data. It was not worth the effort.

Microsoft BI helps you not only streamlines your data but you can create sleek reports from within the system and either do your presentation in real time or download the information to an offline report to help you show how successful your campaigns have run.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Oracle is primarily one amongst the leader in ERP applications and they have quite easily leveraged their BI products to offer pre-built dashboard and operational reporting which is received well by the users. But with Microsoft BI there are host of other features which beats its competitors. Easy of use, navigation, layouts, etc are primarily easy to connect to for the users.
Ved Mishra | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is a great tool when it comes to various integration with line of business applications and its own ecosystem which contains office applications widely used all over the world. Hence, it is well suited for organizations that are complex and have global foot-print. It is also well suited for Power Users who may not have deep technical knowledge but familiarity with day-to-day applications such as word, excel etc...Tableau, Spotfire, Apptio and other tools are much better suited for web-friendly visualizations and for smaller organizations.
Deanne Damato | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
I wasn't part of the decision that selected Microsoft BI but we are heavily invested in AX for our finance and distribution platform and SQL as a database platform.
Chris Utter | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
With over 20 years in IT, I have experienced a full range of relational and non-relational data solutions, from Oracle and Informix to MongoDB and Hadoop. In my opinion, the Microsoft BI stack is the most complete, well-rounded, high performing data management system on the planet right now. More and more, the ability to make data-driven decisions sets organizations apart from their competitors, and no one offers a better solution than Microsoft and its partners. As more and more of what we do in business life moves to the cloud, Microsoft is again leading the way with its Azure platforms.
Steve Wake | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI provides the most flexibility and best integration across of the products in the SQL Server Microsoft BI Suite (and with other Microsoft tools). The tools are flexible enough to work just as well in a small group as they are in a large enterprise and without having to re-learn the products to fit those different scenarios. All of the tools in the SQL Server Microsoft BI stack are provided with one licenses (assuming you install everything on one server) and all of the development tools required are available for free if they they aren't included with the main installer. The Microsoft BI tools will work with most of the major database systems out of the box and if it doesn't, there is a very active 3rd party software environment that develops free or paid add-ons that will cover the options that Microsoft doesn't out of the box. The tools are easy to learn and use and updated on a very regular basis. There is always the flexibility to add or take away from the products installed as part of a Microsoft BI solution, so you never have to be locked into using only the tools provided by Microsoft.
Lee Cullom | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • SAP Business Objects,Tableau Server,MicroStrategy Analytics,Oracle BI Foundation Suite

We chose Microsoft BI due to performance, functionality, TCO and openness (yes, I know, this sounds strange for Microsoft).

  • SAP Business Objects has a less attractive GUI for end users, inferior Excel integration, inferior SharePoint integration, requires more labor to enhance performance and has higher licensing costs than Microsoft BI.
  • Tableau Server has no real ETL capabilities... and thus requires an underlying BI stack. So, while Tableau rules the visualization world with Tableau Desktop, Tableau Server doesn't give us all of the capability we need for a full BI solution for our clients. Tableau Desktop makes an excellent complementary product to Microsoft BI. We typically recommend using both to customers in certain situations.
  • Microstrategy - Comprehensive Multidimensional/HOLAP platform, expensive, visualizations are better than SAP BO, but not as strong as Microsoft, especially Microsoft SSAS + Tableau (which can be acquired at a lower price point). Excel integration isn't as seamless as SSAS to Excel either.
  • Oracle - Expensive, patchwork of acquired BI tools rather than a platform, inferior visualizations. This platform is meant for customers who are already trapped in Oracle licensing.
Jerome Lambert, PhD | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Microsoft BI stacks up against Tableau because Tableau cannot blend various data sources easily. Tableau produces nice reports with a single data source. Today, it's not what we need. We need to easily combine multiple data sources. I would recommend either Microsoft BI or Anametrix with the ODBC connector for Tableau. With the last solution, you combine the power of Tableau (nice reports) and Anametrix (all data sources living under one single roof).
Return to navigation