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.

8.9
Avg 8.1

Access Control and Security

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

8.9
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.5
Avg 7.9

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

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
We are using Power BI in our organization for dashboards, for exposing flaws in our data, and for telling presentation ready stories about our firm's sales and profitability.
  • Microsoft's BI stack is a set of widely implemented products used in various capacities including operational reporting, ETL, and self service BI. This product stack has been successfully implemented in a wide range of verticals including health care, insurance, and banking.
  • Power BI is an agile and low cost solution to an organization's analytics needs. Power BI is tightly coupled with other Microsoft products, enabling companies to have a single firm wide solution with a single vendor.
  • If you want a straight forward and simple BI solution, there are better products for this. To take full advantage of Microsoft BI, you also need SharePoint, SQL Server, and Microsoft Excel/Office. Other software vendors offer BI solutions that consist of only a single software product, but if you are looking only to create fancy dashboards, this is not for you. This is a longer term strategic solution. Features are a bit slim now in Power BI, but expect that to change in future releases.
Microsoft BI is an excellent fit for companies that are already using SQL Server and/or SharePoint. PowerBI is an excellent fit for companies that are already using Microsoft Office and/or Office 365. If you're looking for an agile tool with the option for publishing dashboards and reports to the cloud, then Power BI is an appropriate choice. While considering other products, be sure to ask if they have a data integration layer. Microsoft BI includes Integration Services and Data Quality Services, other vendors might not have that same offering.
Tableau is a very feature rich tool, but it is also a pricey tool relative to Microsoft BI. Tableau's visualizations are very nice, but those features don't necessarily give us a strategic advantage or allow us get our work done any quicker. The monthly fee that you pay for PowerBI and Office 365 is a tiny fraction of the Tableau solution.

These are low risk and very proven traditional BI tools. However, while they are a very good fit for a wide variety of scenarios, other vendors are now offering features and approaches that are worth considering. If an organization does not already use some other Microsoft products like SQL Server, Office, and SharePoint then they might want to consider some of the other competing products. Simply put, if you are already using SQL Server and/or Microsoft Office and/or SharePoint then Microsoft BI makes a lot of sense

.

No
  • Price
  • Vendor Reputation
  • Existing Relationship with the Vendor
Total cost of ownership is a relevant consideration. We didn't have to take on much additional cost to use Microsoft BI and Power BI. We didn't have to go to another vendor and we didn't have to re-train our staff.
Involving your CIO in the selection process is important.
Return to navigation