1. Home
  2. Business Intelligence (BI) Tools
  3. Microsoft BI (MSBI) Reviews

Microsoft BI (MSBI) Reviews

837 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Learn how we help vendors

Learn More
Show Filters
Learn More

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-6 of 6)

Companies can't remove reviews or game the system. Here's why.
January 15, 2016

Great value for money with Microsoft's BI

Robert Goodman | TrustRadius Reviewer
Robert Goodman
Score 9 out of 10
Vetted Review
Verified User
Review Source

Business Processes Supported

  • We use the database platform to warehouse the data from our disparate admissions, student information, human resources, finance, and advancement systems.
  • SQL Server Integration Services (SSIS) is used to move the data from these ERPs into staging - then onto our dimension model and SSAS cubes.
  • SQL Server Reporting Services (SSRS) is used to report on this dimensional data and provide parameterized, drill-through reporting.
  • SQL Server Analysis Services (SSAS) is used to build cubes for specific functional areas. These cubes can then connect back to the dimensional data as required for drill-through analysis.
Read Robert Goodman's full review
March 10, 2015

Microsoft BI platform review

Boris Skylar | TrustRadius Reviewer
Boris Skylar
Score 9 out of 10
Vetted Review
Verified User
Review Source

Business Processes Supported

  • SQL Server Data Warehouse and Microsoft BI platform allow us to collect data from transactional sources, transform to reportable format, and aggregate to a level that can be used to measure business operational metrics.
Read Boris Skylar's full review
November 13, 2014

Thoughts on MS BI

Stephanie Grice | TrustRadius Reviewer
Stephanie Grice
Score 9 out of 10
Vetted Review
Verified User
Review Source

Business Processes Supported

  • We use Microsoft BI products to publish accounting reports and automatically generate general ledger journal entries to distribute departmental expenses.
Read Stephanie Grice's full review
November 04, 2014

Tools and Integration

Shawn Lee | TrustRadius Reviewer
Shawn Lee
Score 8 out of 10
Vetted Review
Verified User
Review Source

Business Processes Supported

  • Financial month-end reporting.
  • HR Resource and Manager reporting
  • Ticket resolution and project management tracking. Data is pulled from 4 different systems and loaded into SQL Server Analysis Services (SSAS) for reporting.
  • SQL Server Integration Services (SSIS) - Used for data integration across multiple systems.
Read Shawn Lee's full review
September 06, 2013

Build a highly automated and flexible BI solution for your organization!

Sean Brady | TrustRadius Reviewer
Sean Brady
Score 10 out of 10
Vetted Review
Verified User
Review Source

Business Processes Supported

  • Forcasting
  • Asset Management
  • Pricing
  • Sales Reporting
  • Customer Satisfaction Reporting
  • Detailed Account-level Cost and Revenue Reporting
Read Sean Brady's full review

Microsoft BI (MSBI) Scorecard Summary

Likelihood to Recommend (837)
8.2
Likelihood to Renew (25)
8.0
Usability (7)
9.0
Availability (4)
9.5
Performance (4)
7.0
Support Rating (14)
8.5
In-Person Training (3)
6.9
Online Training (2)
8.5
Implementation Rating (14)
9.6
Data Sharing and Collaboration (48)
8.0
Data Sources (47)
8.3

Feature Scorecard Summary

BI Standard Reporting
8.2
Pixel Perfect reports (40)
7.8
Customizable dashboards (47)
8.6
Report Formatting Templates (45)
8.3
Ad-hoc Reporting
7.7
Drill-down analysis (42)
8.1
Formatting capabilities (47)
7.8
Integration with R or other statistical packages (38)
6.8
Report sharing and collaboration (47)
8.0
Report Output and Scheduling
7.4
Publish to Web (42)
6.9
Publish to PDF (42)
7.9
Report Versioning (38)
7.4
Report Delivery Scheduling (42)
7.6
Delivery to Remote Servers (22)
7.0
Data Discovery and Visualization
7.7
Pre-built visualization formats (heatmaps, scatter plots etc.) (45)
7.4
Location Analytics / Geographic Visualization (42)
7.8
Predictive Analytics (40)
7.8
Access Control and Security
8.3
Multi-User Support (named login) (44)
8.4
Role-Based Security Model (41)
7.9
Multiple Access Permission Levels (Create, Read, Delete) (45)
8.6
Single Sign-On (SSO) (26)
8.3
Mobile Capabilities
7.8
Responsive Design for Web Access (33)
7.8
Dedicated iOS Application (26)
7.7
Dedicated Android Application (26)
7.9
Dashboard / Report / Visualization Interactivity on Mobile (35)
7.7
Application Program Interfaces (APIs) / Embedding
7.4
REST API (17)
7.3
Javascript API (18)
7.5
iFrames (17)
7.8
Java API (16)
7.6
Themeable User Interface (UI) (16)
7.1
Customizable Platform (Open Source) (12)
7.1

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.
Categories:  Full-Stack Business Intelligence,  Business Intelligence (BI)

Microsoft BI (MSBI) Competitors

Microsoft BI (MSBI) Pricing

  • Does not have featureFree Trial Available?No
  • Has featureFree or Freemium Version Available?Yes
  • Does not have featurePremium Consulting/Integration Services Available?No
  • Entry-level set up fee?No
EditionPricing DetailsTerms
Power BI Pro9.99per user/per month
Power BI Premium4,995per month

Microsoft BI (MSBI) Technical Details

Deployment Types:SaaS
Operating Systems: Unspecified
Mobile Application:No