Power to the top with Power BI
December 11, 2017

Power to the top with Power BI

Abhinav Rai | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

Power BI is our primary visualization tool for dashboards, scorecards, ad-hoc reports, and self-service. The power of Power BI stems from the implementation of a strong foundation in the form of an enterprise data warehouse. While we introduced Power BI, the data warehouse has been implemented in small chunks, therefore, while the goal is for Power BI to be used across the organization, currently, it is used by a subset of staff. The primary purpose of having Power BI is to allow staff to self-serve and get information at a glance without needing to use a complicated tool or relying on IT /technical resources to generate extracts.
  • Easy to use, intuitive
  • Inexpensive licencing
  • Option to deploy to cloud or on-premise
  • Variety of visualizations
  • Ability to deploy on top of any data source
  • Heavy use of DAX as a programming language for measures/KPIs
  • Confusion around the variety of products that serve same/similar purpose from Microsoft
  • No ability to create a portal with Power BI
The primary reason why we selected Power BI is cost. Most enterprises have some sort of Microsoft or SQL Server licensing in place. Adding Power BI and the Microsoft infrastructure is a low-cost barrier to an existing license. Most other products came at a much higher price point. However, when looked at the feature sets, each technology has its pros and cons. We decided to pit the cost vs feature sets and found Power BI to be most favorable for us.
Power BI is a market leader in visualization and analytics toolsets. The backing of Microsoft is critical because the tool is familiar to users who use Microsoft products. Integrates well with any data source - whether it is a CSV, an Oracle database, SQL database, or any data warehouse. The visualization options are great and provides flexibility and variety. The natural language search and visualization is a great feature. Mobile apps are great for executives to get information at a glance.

Microsoft Power BI Feature Ratings

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