The BI tool for the masses
May 16, 2018

The BI tool for the masses

Adam Bruckman, MPH, CPC | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

Power BI is being used in our department to create internal reports within our group. The main sanctioned BI tool for our organization is Tableau, but we have to rely on a central IT group to produce dashboards. With Power BI, we can create and customize our own reports, but cannot widely distribute them.
  • Power BI integrates seamlessly with PowerQuery which allows you to easily manipulate source data and add calculated columns for your data model.
  • Producing a data model is very easy as Power BI makes visualizing the model schema and joins simple.
  • Producing data visuals is so much more user-friendly than in Tableau. Customizing and producing visuals is very intuitive and there are tons of built-in visualizations to choose from ( however some are not explicitly Power BI approved and may not work properly).
  • Sharing the dashboards is very easy and end-users can interact with the visualizations.
  • Data and visualizations smoothly integrate with other Microsoft products such as PowerPoint and Access.
  • Although BI is making great updates on a daily basis, there are still some limitations involved with the data modeling and certain visualizations.
First of all, Power BI is a fraction of the price of Tableau. Secondly, I found Tableau to be much less user-friendly than Power BI. Tableau is great if your organization wants to completely control BI and centralize it in the hands of highly skilled data analysts and IT teams. Power BI, on the other hand, is more egalitarian in that just about anyone can quickly understand how to use Power BI to create customized data models that are meaningful to them and churn out impressive looking interactive visuals. I highly prefer Power BI over Tableau.
Power BI is excellent for decentralizing an organization's BI capabilities. It's great both for creating dashboards widely disseminated throughout your organization as well as allowing users to create their own dashboards for use on a smaller scale. Since it's so approachable and intuitive, you don't need to be an IT expert or data analyst to get up and running with it.

Microsoft Power BI Feature Ratings

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