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 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-25 of 27)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
  • It has increased the operational efficiency approximately by 25% which is a huge positive and impact on our company
  • It improved the decision making capabilities by providing the on -point analytics and features like report creation. The company is able to take great decisions for itself.
  • The cost of MSBI is a bit of a extra burden for my company as we need some additional features which are highly charged, also for some extra storage space.
Al Mubassir Muin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Increased data compatibility and presenting data to clients is much easier, which has helped with our reportings to the clients.
  • A better understanding of multiple functions aside from cost has significantly impacted quickly generating visualizations for our data.
  • The financial impact has been pleasantly surprising from using it, and Quicker report generation and data management tools are better in the long run than saving data on raw CSV.
Aononna Tazin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Profits increase due to a strategic change suggested by Microsoft BI (MSBI) output. Additionally, maintenance is straightforward.
  • Data harmonization and synchronization are two essential aspects of information technology. Save time interpreting data and easily integrate with Azure apps already in place.
  • Using our analytics capabilities, we have assisted our clients in better understanding complex data by providing them with simplified reports. So it streamlined decision-making.
Nilufa Hossain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Profit increase due to MSBI output and a better understanding of multiple functions other than cost.
  • Data compatibility will be improved, and MSBI will have the opportunity to handle the API more effectively. The MSBI ETL stack works well with relational databases, but with cloud-based data sources emerging, non-relational data sources should be supported.
  • Save time interpreting data. Our analytics capabilities have helped our clients understand complex data with simple reports. Thus, it facilitated decision-making.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • As it came "in the box" with necessary SQL Server RDBMS purchases, the ROI for the BI components are high as there was no incremental cost.
  • Has provided standard reporting for most of the organization available via highly formatted PDF or Excel versions.
  • Has provided ad-hoc analytics using SSAS in conjunction with Excel.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • We have been able to quickly build data models using the MSBI stack to deliver value to our clients.
  • One opportunity for MSBI is to handle API's better. The MSBI ETL stack works well with relational databases, but with the emergence of data source offerings in the cloud, the capability of non-relational db data sources should be expanded.
Charles Saulnier | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • At the moment, the lack of use of Power BI has indered our market progression IMO
  • A large majority of customers keeps the solution once implemented, very few have switched platform
  • Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
Jasmeet S Babra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • I would say making work easier for internal marketing reports is a great time saving activity in which Microsoft BI excels. Instead of downloading data manually from various sources, it integrates live data from applications.
September 26, 2016

Think hard on your BI goals

Haibo Yang | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
  • However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
Robert Goodman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Firstly, reduction in cost from the three previous vendors which we were supporting. Just by replacing these legacy pieces of software, we have saved money.
  • We are working to quantify the cost savings achieved in business improvement from the reporting that we have provided. We don't have a specific figure as of yet, but the reports that are now available 'on-the-fly' have saved many man hours. Previously, data needed to be consolidated across multiple systems which could have taken weeks of manual manipulation. Now, this data is available in one platform and we have cross-functional reporting capability.
Scott Lerner | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
  • Provided visibility at the Transactions level from a profitability standpoint
  • Sales reps are now using BI Dashboards to measure their success not just net sales
  • Company now measures customers from as well at a profitability standpoint
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
Christopher Wagner | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
  • The main front end for Microsoft BI is now Excel. The number one spreadsheet tool used in business that everyone already knows how to use. Now it is just a matter of showing a few new features and some best practices. That's a huge ROI gain right there.
October 24, 2013

MS BI Suite Review

Score 9 out of 10
Vetted Review
Verified User
  • Microsoft BI tools come free with SQL Server license. If you have SQL Server license you get the SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) tools for free.
October 20, 2013

Microsoft BI

Bryan Simmons | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
  • Ability to maintain and develop dashboards with KPI's for fast delivery to decision makers across the organization.
  • Insight into overall departmental performance. Allowance for departments to set their own metrics for success.
  • Data insights for marketing and sales campaigns allow decision makers to fine tune future campaigns.
Return to navigation