Microsoft BI (MSBI) Professional, Scientific, and Technical Services Reviews & Insights

Score7.3 out of 10

934 Reviews and Ratings

Community insights

TrustRadius Insights for Microsoft BI (MSBI) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Real-time Analytics: Users have appreciated the real-time stream analytics feature for making prompt business decisions. This functionality has been instrumental in enhancing their decision-making processes and improving overall efficiency.

Customizable Workspaces: Customers have highlighted the ease of customization for different project groups through a dashboard and drag-and-drop interface. This flexibility allows teams to tailor their work environments to specific project requirements, promoting collaboration and productivity.

Comprehensive Environment: Reviewers liked that Visual Studio integrated various development aspects, providing a comprehensive environment for different tasks. By combining database, ETL, reporting, and analytics development within one platform, users can streamline their workflows and accomplish diverse tasks efficiently.

Microsoft BI (MSBI) Reviews

25 Reviews

Professional, Scientific, and Technical ServicesArchitecture & Planning1Information Technology & Services20Management Consulting2Marketing & Advertising1Public Relations & Communications1

MSBI : a new boom in the digital world!

Rating: 9 out of 10

Incentivized

January 4, 2024

Use Cases and Deployment Scope

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.

Pros

It managed our projects and maintained reports and dashboards
It provided correct real time stream analytics which helped us to make necessary business decisions
It helped built the most attractive and smooth UI designs for our website

Cons

MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
It would be a lot better if it is a little low on cost.
it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

Likelihood to Recommend

Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones)

Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.

Verified User

Administrator in Sales (Information Technology & Services company, 201-500 employees)

Vetted Review

2 years of experience

"Microsoft BI is a powerful analytic tool for large data sets."

Rating: 9 out of 10

Incentivized

December 6, 2021

Use Cases and Deployment Scope

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.

Pros

Easy customization of workspaces for different project groups via a dashboard and a drag-and-drop interface.
Easy report generation and data attribute comparison across applications. Perfect for data-only devices.
Visual Studio integrates database, ETL, reporting, and analytics development. Large technical user community and rich tool feature set.

Cons

Costs are high compared to the competition, and it could be more user-friendly.
As a browser-based app, it doesn't have as many eye-catching charts and graphs as some others, and some browsers are better than others at running it.
Most of the tasks require a pro version, and proper training is necessary to use it, but you can learn how to use it.

Likelihood to Recommend

Microsoft BI works well with Microsoft's ecosystems, especially SharePoint and SQL Server. Even large, complex datasets can be manipulated and turned into useful information. The platform's lists feature can fill any relevant data gaps when used with SharePoint. Its user-friendly graphical user interface makes it simple to quickly and efficiently display data. Aside from that, the reporting tools are first-rate.

Al Mubassir Muin

Software Engineer in Information Technology at Prime Tech Solutions Ltd. (Information Technology & Services, 51-200 employees)

Vetted Review

2 years of experience

View profile

In the world of data visualization, this is one of the best virtualization tools

Rating: 9 out of 10

Incentivized

November 13, 2021

Use Cases and Deployment Scope

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.

Pros

An end-to-end solution that connects multiple data sources and a single vendor is ideal.
Excellent tools for visualizing data. Using Visual Studio, I could develop database, ETL, reporting, and analytics projects all in one environment.
Easy to use compared to other data analytics solutions, with powerful analytical and trending tools and easy access to our data and views.

Cons

It has limited visual options, and Microsoft BI (MSBI) isn't the best for advanced modeling and analysis.
Excel proficiency is required before diving into PowerBI, and reshaping and reorganizing data is possible but not easy.
Additional training and tutorials for Microsoft BI (MSBI) would be helpful for organizations with a large number of users and better pricing options required.

Likelihood to Recommend

Microsoft BI excels at presenting complex and large data sets in a manageable and informative manner. This program's user-friendly graphical interface makes it simple to view data. Other than that, the reporting features are above average for this type of software. It's widely used with Microsoft products, but it doesn't work well with other programs. With limited physical resources, the free version is recommended for minor data work.

Aononna Tazin

Customer Relationship Management Specialist in Information Technology at Green Light Ltd (Information Technology & Services, 51-200 employees)

Vetted Review

1 year of experience

View profile

"Easy To Use BI Platform With Effective Reporting"

Rating: 9 out of 10

Incentivized

November 1, 2021

Use Cases and Deployment Scope

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.

Pros

Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
Transfer of data from one application to another via Excel and comparison of data attributes between applications
Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Cons

Only the pro version allows me to complete most tasks, and there aren't many options for customizing the interface.
Browser-based, so some browsers won't work, and the price isn't as competitive.
It doesn't have as many visually appealing graphs and charts, and it's not as intuitive to use as some others, but we can get used to it.

Likelihood to Recommend

The Microsoft BI suite of tools, which comprises tools from the SQL Server suite, provides end-to-end features and functionality for businesses of any size. Users who need dashboards and reports fast will benefit from this tool. It’s simple to connect to databases, cloud storage systems, and CSV files of any type. This makes the dashboards suitable for a more rapid presentation workflow because we can easily incorporate them into PowerPoint presentations. Enterprise and standard editions are both available for some tools.

Nilufa Hossain

IT Specialist in Research & Development at Lamda I-TECH (Information Technology & Services, 11-50 employees)

Vetted Review

1 year of experience

View profile

Microsoft BI

Rating: 9 out of 10

Incentivized

June 3, 2021

Use Cases and Deployment Scope

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.

Pros

Dashboard capability.
Comparison between data attributes of various applications.
Data load through Excel.

Cons

Integration between different data sources and MSBI.
Dashboard features.
Performance.

Likelihood to Recommend

Shyam Agrawal

Business Systems Analyst in Information Technology at NetApp (Information Technology & Services, 10,001+ employees)

Vetted Review

3 years of experience

MSBI - Bang for the Buck

Rating: 8 out of 10

Incentivized

April 26, 2021

Use Cases and Deployment Scope

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.

Pros

Single vendor provides a true end-to-end solution from data storage to end-user consumables.
Visual Studio provides a single IDE for database, ETL, reporting, and analytics development.
Rich feature set across the tools with 15-20 years of maturity.

Cons

Reunification of installers to simplify the process for both server installs and developer (SSRS now split out, BI tools not all within one package).
Ongoing Visual Studio instability.
Better server to server deployment options for SSRS.

Likelihood to Recommend

The Microsoft BI suite of tools, largely composed of tools within the SQL Server suite, provide a full range of end-to-end feature/functionality for businesses of any size. Some flavor of the tool features is available whether using standard or enterprise editions, making the tools accessible for even smaller businesses. Scalability has become excellent over the years, particularly for SSIS and SSRS.

Verified User

Employee in Information Technology (Architecture & Planning company, 1001-5000 employees)

Vetted Review

15 years of experience

A smart tool for data analysts to generate awesome reports

Rating: 10 out of 10

Incentivized

April 18, 2021

Use Cases and Deployment Scope

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.

Pros

Powerful analytics tools
Great visualization features. I really liked visualizations based on map
Ability to connect with multiple data sources
Tight integration with Microsoft services
Awesome user interface

Cons

Steep learning curve depending on your background. For me it was easy but I saw some people struggling with it

Likelihood to Recommend

I think Microsoft Business Intelligence tools are really suitable for data analysts and managers who aim to generate dashboards and reports quickly. It easily integrates with data sources of any type such as databases , cloud storage systems , csv files or json file. The dashboards can be easily put into PowerPoint presentations which makes it suitable for faster presentation workflow , especially for managers.

Verified User

Engineer in Information Technology (Information Technology & Services company, 1001-5000 employees)

Vetted Review

1 year of experience

Microsoft PowerBI unleashes the power of your data

Rating: 9 out of 10

Incentivized

April 22, 2020

Use Cases and Deployment Scope

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.

Pros

Easy to access the data and views you have created
Simple filtering of data views
Ability to view live or near live data

Cons

It runs in a browser and some browsers work better than others
Sometimes you start getting wacky results and you have to refresh the page to reset the views

Likelihood to Recommend

It works great for our purposes. I highly recommend hiring a consultant to set it up for you though. I don't think we would have gotten very far had we tried to setup the reports and views ourselves. We're very happy with the results we've seen so far. We've been using it for about 3-4 months.

Bradley Geppert

Director of IT Services in Information Technology at CompuType IT Solutions (Information Technology & Services, 11-50 employees)

Vetted Review

1 year of experience

Good for visualisations and reporting!

Rating: 7 out of 10

Incentivized

March 19, 2019

Use Cases and Deployment Scope

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.

Pros

Good range of visualisation features.
Very easy to setup and get onboard.
Handles data integration from multiple sources decently well.

Cons

Not advisable to use Microsoft BI as a standalone primary tool for data management.
The process of moulding or repurposing data is not easy.
Integrating Microsoft BI with non-Microsoft tools is a huge pain.

Likelihood to Recommend

If your primary use case requires the use of several visualisation options and graphical representations, then Microsoft BI might be a good option to use. However, if your data management needs do not revolve around reporting, then it is better to go with other standard business intelligence tools available in the market like Oracle BI or Tableau.

Verified User

Engineer in Information Technology (Information Technology and Services company, 10,001+ employees)

Vetted Review

2 years of experience

For the IT professional on the go

Rating: 8 out of 10

Incentivized

January 24, 2019

Use Cases and Deployment Scope

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.

Pros

Microsoft BI allows us to combine data from multiple sources, build data models, create visualizations, and share the results.
Cloud Interactive charts in a cloud that can be easily shared
Connectors to popular data sources, allowing us to integrate with almost any system

Cons

More authentication methods to allow power users to connect directly to Web APIs.
It can be quite difficult to setup without guided assistance from experienced users
Limits on dataset size.

Likelihood to Recommend

Microsoft BI is a terrific tool to use when you need to pull data from various sources, and especially powerful in its ability to display the actionable information on a single dashboard. It is the "go-to" solution for the company that wants to move to the next level of pivot tables, dynamic charting and business intelligence reporting.

Verified User

Consultant in Information Technology (Information Technology and Services company, 51-200 employees)

Vetted Review

2 years of experience

Loading Reviews List....

"Easy To Use BI Platform With Effective Reporting"

Rating: 9 out of 10

Incentivized

November 1, 2021

Use Cases and Deployment Scope

Pros

Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
Transfer of data from one application to another via Excel and comparison of data attributes between applications
Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Cons

Only the pro version allows me to complete most tasks, and there aren't many options for customizing the interface.
Browser-based, so some browsers won't work, and the price isn't as competitive.
It doesn't have as many visually appealing graphs and charts, and it's not as intuitive to use as some others, but we can get used to it.

Likelihood to Recommend

Nilufa Hossain

IT Specialist in Research & Development at Lamda I-TECH (Information Technology & Services, 11-50 employees)

Vetted Review

1 year of experience

View profile