TrustRadius
Microsoft BI Review 3 of 55
Microsoft BI Review: "Multiple tools in single package."
https://www.trustradius.com/business-intelligence-biMicrosoft BIUnspecified7.9615101
Lakhan Suri profile photo
January 12, 2019

Microsoft BI Review: "Multiple tools in single package."

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft BI

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
  • Create packages to move data and perform different data related tasks using SSIS
  • Create reports to summarize the data in an understandable form using SSRS
  • Analyze the data provided by teams and create data cubes and reports to understand the data properly using SSAS.
  • It should be an open source tool for a vast variety of implementation.
  • You need to buy a licensed server to maintain MSBI
  • Need a proper course or content to learn concepts, which sometimes creates difficulty.
Easy to understand, resources easily available in market to outsource the work.
We can connect a vast range of data sources to merge and get data. We can get data from multiple data sources and consolidate that into a single report.
We can access and manage reports on the bases of security roles. Data security can be managed by several ways according to the permission granted.
The interface is good, and even we can use drag and drop functionality to create packages and reports and other tasks.

Microsoft BI Feature Ratings

Pixel Perfect reports
8
Customizable dashboards
6
Report Formatting Templates
8
Drill-down analysis
8
Formatting capabilities
7
Integration with R or other statistical packages
7
Report sharing and collaboration
8
Publish to Web
7
Publish to PDF
7
Report Versioning
7
Report Delivery Scheduling
7
Delivery to Remote Servers
8
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
7
Predictive Analytics
9
Multi-User Support (named login)
7
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Dashboard / Report / Visualization Interactivity on Mobile
6