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

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
Robert Goodman | TrustRadius Reviewer
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
Boris Skylar | TrustRadius Reviewer
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
Stephanie Grice | TrustRadius Reviewer
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
Shawn Lee | TrustRadius Reviewer
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
Sean Brady | TrustRadius Reviewer
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

Feature Scorecard Summary

Pixel Perfect reports (40)
7.8
Customizable dashboards (47)
8.6
Report Formatting Templates (45)
8.3
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
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
Pre-built visualization formats (heatmaps, scatter plots etc.) (45)
7.4
Location Analytics / Geographic Visualization (42)
7.8
Predictive Analytics (40)
7.8
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
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
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.

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