TrustRadius
Strengths and Weaknesses of Microsoft Power BI
https://www.trustradius.com/business-intelligence-biMicrosoft Power BIUnspecified8.1528101
No photo available
Updated September 14, 2019

Strengths and Weaknesses of Microsoft Power BI

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft Power BI

1. It is used for Executive reviews for visualization and dashboards to provide insight in the business operations, marketing, finance. My organisation is using this because it comes free with Microsoft Office license. It provides similar services as other tools in the same field.
2. It is being used in my departmen,t but other functions are starting to explore this BI tool.
3. Visualization, dashboards, scorecards, easy to understand huge datasets through graphs and charts, flexible for users to connect withEexcel

  • Free license and tool is available in Microsoft office as an alternative to expensive tools in the same field
  • Flexible to connect with multiple data sources and ERP systems
  • Training modules are available for users with good detailed explanation
  • Can publish review online for yourself and team-members and executives
  • Multiple layout for visualization
  • Editing data is bit difficult -- it requires dataset to be formatted in a particular manner, otherwise it will give errors and the user will end up most of the time in fixing the issue himself.
  • Everytime data is required to be refreshed, which leads to the issue of regenerating the visualization
It is a tool from Microsoft and hence it has good connectivity to link to Excel data sources. But when it comes to merging and cleaning, it gives lot of errors and the user really needs to have understanding of MS-BI
1. Report can be published online for all user access
2. Data sharing is easy because everyone has Microsoft office and hence it is easily available to all users
3. report distribution can be synchronised with Microsoft Outlook application.
Scenarios where it is well suited- User with Excel experience and needs to analyze the data via visualization without spending huge money on license subscription of other software

Scenario where it is less suited - User who does not know how to handle big data and cleaning data requirements of BI.

Microsoft Power BI Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
5
Report Formatting Templates
8
Drill-down analysis
5
Formatting capabilities
7
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
6
Publish to Web
10
Publish to PDF
10
Report Versioning
7
Report Delivery Scheduling
4
Delivery to Remote Servers
5
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
5
Multi-User Support (named login)
10
Role-Based Security Model
Not Rated
Multiple Access Permission Levels (Create, Read, Delete)
Not Rated
Single Sign-On (SSO)
Not Rated
Responsive Design for Web Access
Not Rated
Dedicated iOS Application
Not Rated
Dedicated Android Application
5
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated