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 64)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
I use MSBI specifically for data generation and data analytics. It has helped me to create a data way more simpler and easy to understand. It improved the frequent usage of dataflow by more than one user and it has helped me to use and distribute each leads or data to other employees. It helped me build impactful connections through social media and other digital platforms.
Lakhan Suri | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
In my organization, we are using MSBI to create, maintain and deploy reposts. We use all three component of MSBI like SSIS, SSRS, SSAS. We use ETL packages to maintain Dataware hosts using SSIS. We create reports using SSRS and analyze the data using the SSAS tool
Al Mubassir Muin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Microsoft Power BI is a beautiful and powerful data visualization tool that we use. It is a robust business analytics tool with excellent visualizations. Excel files, OneDrive, and third-party tools like SQL databases are all supported. We can use the Query revised feature to edit and transform our data, accessible anywhere. It makes it simple to import data from Excel or other sources. Many options are available for visuals, including custom visuals added to any report. With these data visualization charts, real-time automation is possible. For non-technical users, the Power BI desktop has the best part: it is simple to use. Basic visualizations can be created using a variety of drag-and-drop options. Microsoft Power BI has been fascinating to observe how visuals interact between pages.
Aononna Tazin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
With Microsoft BI (MSBI), we can create our own data sets, goals, and records with no difficulty. We have a wide range of options and features to choose from when it comes to sifting through vast amounts of data. Our organization uses its interactive and engaging layouts are the most impressive feature. This tool makes it simple to view and determine data. This site’s design is excellent, allowing us to see what would have been hundreds of lines of text in graphs and tables. To generate comprehensive documents, we adopt it to figure out large measures of SQL, Excel, and other application-related data. We use it to help our clients make more informed business decisions that lead to increased revenue.
Nilufa Hossain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I can connect to Oracle, Snowflake, SQL Server, Excel, CSV, text files, and create custom visualizations with Microsoft Power BI Desktop. Our team can generate reports and analyze data with all of their BI tools at their disposal (SSAS SSRS and SSIS). The best feature of Power BI is its appealing and interactive layouts. Power BI simplifies visualizing and interpreting data. It is possible to use drag-and-drop relationships and data visualization with the Microsoft BI stack to solve many client data problems. Anyone, regardless of skill level, can get up and run with their first project, even with no prior knowledge of SQL. We’ll assess various options based on the client’s licensing agreements. The Microsoft BI stacks are the best choice.
June 03, 2021

Microsoft BI

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI being used by Master Data Management team like Vendors data, Customers data, Sites data, Bank, Bank Accounts, Customer Mandates, Employees, and Products data within our organization. It solves the problem of master data attributes like payment terms, tax codes etc., discrepancies within the applications of our IT landscape.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft Power BI for the data management of our projects. Some of our projects include collecting data of users who signup for webinars and Power BI is then used to analyze that data and provide us with a graphical representation of it. This is very convenient to embed in presentations, etc.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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) are being leveraged to provide reporting and analytics to the business. It allows us to provide standard reporting, delivered ad-hoc or via e-mail, exception based notifications, and analytics. Additionally we leverage SSIS for data warehouse ETL as well as EDI.
Score 10 out of 10
Vetted Review
Verified User
I dont use it right now but , I used it during my research assistantship to generate beautiful visualizations for big data. At the time I was researching about covid has impacted people using twitter data and BI tools really shined in [how] easily they could connect with various platdata platforms easily.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We implement Microsoft BI solutions to clients across North America. Clients are constantly coming to us having issues gathering their data from disparate sources in order to make meaningful decisions with their information. Depending on the client and their licensing agreements, we will then evaluate options, and the Microsoft BI stack tends to be a leader of the pack to solve many client data issues.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using Microsoft BI (MSBI) to visualize our data better and provide detailed insights on KPI. It also helps in building dashboards, which help key stakeholders analyze and make decisions on a regular basis. We have been able to use the tool as a starting step for our customers to provide them with useful insights and data. Data is the key thing that everyone wants. Some of our customers are even ready to pay more if we are able to provide them with detailed information.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We currently use Microsoft BI to power the dashboard and analytics behind our performance management platform. Previously, this was done manually by each division in their own silo, making it difficult for upper management to translate disparate information from different sources into useful business decisions. With the help of Microsoft BI, we were able to warehouse data from a variety of sources across different business units into a centralized location and extract powerful reports and dashboards to assist with strategic decision making.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft PowerBI to analyze data from our CRM and invoicing system (Connectwise with a SQL backend). Connectwise has a large number of built-in reports and a custom report writer but it was falling short of our needs. We engaged an outside consultant to create a large set of reports and views using PowerBI. Our managment teams uses it weekly. The ability to view them online without any special software of "running" of reports make it so much easier to use than other platforms we've used.
Score 8 out of 10
Vetted Review
Verified User
We have deployed the Microsoft BI tool company-wide now. It is very simple to use and better than other tools available. You can easily create and share dashboards. It helps an organization in multiple ways by creating very interactive dashboards, and its possible to present complex data in a more presentable way.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have a BI team that manages the applications and the resources and connects the multitude of data sources into its data warehouse for analytics and reporting. We create multiple dashboards for different departments as they need. One business need we use it for is wait times in clinics. We can determine what days of the year are the busiest to ensure we don't incur any staffing issues and then use the data to promote wait times on market billboards externally for potential patients.
November 20, 2019

Microsoft BI review

Hrishikesh Kardile | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI has transformed the reporting process at JCT. It is being used across the whole organization due to ease of access to data and drilldowns. The company has created tools to give visibility of detailed level data to folks working at corporate as well as in the field.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is used by a few data teams in my organisation in conjunction with other business intelligence tools. One of the primary reasons for using Microsoft BI is its simplicity, user friendliness, and good palate of visualisation options. Unlike most other standard BI tools in the market, Microsoft BI does provide a good array of graphical representations - thereby making it a good choice for reporting purposes.
Thomas Young | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Microsoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.
February 05, 2019

Great BI tool

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have been using a number of Microsoft products in our company and decided to go with the Microsoft BI platform due to its easy integration with Microsoft Office suite. We wanted to incorporate a business intelligence tool into our enterprise to get a full 360 view of our mission-critical data. Microsoft BI helped fill that role.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it in various pockets across our organization. We use trend analytics, reports, and interactive dashboards all the time, but the real workhorse is the Marketing cost data aggregation toolkit. We also connect PowerBI with SQL integrated OLAP databases, enabling us to leverage data housed within SAP with extracted data to create visual dashboards to track various KPI metrics on a daily basis.
Shelby Bowden | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft BI primarily just within our lab group and department due to its very specific and powerful data visualization capabilities. While it is applicable to almost any work involving data analytics, it might seem like overkill for some people. We have found that it does an excellent job in preparing and displaying the more complex data that we deal with.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
My company deals with a lot of data, and it is extremely important that we have an efficient, easy to use program with visually appealing outputs. Microsoft BI can do it all. We collect a lot of data in the field and have to look at trends in that data through time. After our own analysis, that all has to be presented to our clients who generally need self-explanatory figures. Microsoft BI has been a great program for us.
Michael Timms | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Several people that I know use Microsoft PowerBI. It is mainly used for reporting for several teams, then I am able to access those reports for my own use. When I use it I import Excel sheets in, and use PowerBI to make them more visually appealing and easier to filter. It works like a charm. I have not seen any issues other than the occasional drag with data sets.
Return to navigation