Great value for money with Microsoft's BISQL Server Management Studio provides a nice interface to view, query, and modify the database tables. The interface is user friendly and logical. Microsoft, in general, has fantastic educational pricing. This allowed the TCO to be much lower for our university. Microsoft tools integrate nicely with one another. We are also in the process of implementing SharePoint. We plan to use SSRS (.rdl) reports which will integrate with SharePoint - and also will have the ability to experiment with PowerView (.rdlx) dashboards and PowerPivot (Microsoft's in-memory BI tool).,The end-user reporting tool, Report Builder, is not that flexible. We feel that the Cognos Report Studio tool is more robust in this area.,9,,10,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.,3000,8,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.,Using the enterprise version, we leveraged data-driven subscriptions. This feature allows you to publish reports to specific individuals or groups based upon data events. This has become useful for a wide variety of things. In a previous company, I used this feature to drive process improvements by notifying teams of early task completion. In some cases, we were able to drive a process that typically took 4 weeks down to a process that only took 2.5 weeks. That led to revenue gains. Since Microsoft BI contains an out-of-the-box ETL tool (SSIS), we've been able to leverage this functionality to help support other projects. Recently, we created a SalesForce integration to Workday. We have been able to setup nightly data feeds using SSIS which extract known sets of data for our statisticians. While the data isn't formatted in SAS dataset, it outputs the data in a common format that is easy for the statisticians to consume and transform into a useful SAS dataset.,,Implemented in-house Professional services company,8,Self-taught,We had Microsoft SQL BI specialists on staff. We would advise to have training on the platform otherwise.,10,No,8,10,7,Ellucian Banner. Workday HCM. Workday Financials. PeopleSoft Admissions. Apply Yourself. Sage Millennium.,We will continue to support systems that are key pillars to our business units.,Utilize Microsoft's Higher Education EES (Enrollment for Education Soulutions) licensing. This is a great value.Microsoft BI platform reviewEasy development tools with ability to support large data.,Features of the predictive analytics are not the best in the industry yet.,9,,10,Rapid report development, simple web-based reporting tools, easy support, common development techniques.,60,5,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.,,Implemented in-house,9,Self-taught,Yes, it was a simple deployment due to ease of the SQL Server Reporting Services (SSRS) UI.,9,No,8,9,9,7,Microsoft SharePoint,Defined price versus value, and finalized support terms.
Microsoft BI
677 Ratings
Score 8.0 out of 101
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Microsoft BI Reviews

<a href='' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Microsoft BI
677 Ratings
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.0 out of 101
Show Filters 
Hide Filters 
Showing 2 of 677 Microsoft BI ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-2 of 2)

  Vendors can't alter or remove reviews. Here's why.
Robert Goodman profile photo
January 15, 2016

Microsoft BI Review: "Great value for money with Microsoft's BI"

Score 9 out of 10
Vetted Review
Verified User
Review Source


SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Read Robert Goodman's full review

Feature Scorecard Summary

Pixel Perfect reports (30)
Customizable dashboards (36)
Report Formatting Templates (34)
Drill-down analysis (32)
Formatting capabilities (36)
Integration with R or other statistical packages (29)
Report sharing and collaboration (36)
Publish to Web (33)
Publish to PDF (32)
Report Versioning (29)
Report Delivery Scheduling (33)
Delivery to Remote Servers (14)
Pre-built visualization formats (heatmaps, scatter plots etc.) (35)
Location Analytics / Geographic Visualization (32)
Predictive Analytics (31)
Multi-User Support (named login) (34)
Role-Based Security Model (31)
Multiple Access Permission Levels (Create, Read, Delete) (34)
Single Sign-On (SSO) (15)
Responsive Design for Web Access (25)
Dedicated iOS Application (20)
Dedicated Android Application (20)
Dashboard / Report / Visualization Interactivity on Mobile (26)
Javascript API (13)
iFrames (12)
Java API (11)
Themeable User Interface (UI) (11)
Customizable Platform (Open Source) (9)

About Microsoft BI

Microsoft BI 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 Competitors


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$0
Power BI Pro$10per user per month

Microsoft BI Technical Details

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