Multiple tools in single package.
Updated November 02, 2021

Multiple tools in single package.

Lakhan Suri | TrustRadius Reviewer
Score 9 out of 10
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.
The interface is good, and even we can use drag and drop functionality to create packages and reports and other tasks.

Microsoft BI (MSBI) 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