Power BI: bringing life to your disparate data
February 15, 2019

Power BI: bringing life to your disparate data

Mathieu Gaouette | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

Power BI is being used to build dashboards and reports. It is used mainly by the marketing department as far as I know but I really wouldn't be surprised that it is being used in other departments. It allows us to have an insight into our business through the visual representation of our data. With this new breed of "reporting tool" (like Tableau software), we are able to simplify the data to allow easy communication to higher management. Power BI helps management make business decisions based on data (ex, whether to close or open branches based on customers in a region, launch refinancing campaign in regions where the mortgage to value rate is low, etc.).
  • Power BI has a step by step approach to integrating data that makes it really easy to get exactly what you want out of your raw data. If you do one manipulation wrong, you can see it right away with the preview.
  • Power BI already contains a wide variety of visual objects you can use but you can also create your own if you have a specific need. Mind you, this will require some node.js knowledge but there are a lot of available tutorials online.
  • The access to the software is extremely easy for people in any organisation as the base software is free (The Author version). It is limited slightly in terms of collaboration and refresh capacity but is perfect for evaluation or one time data analysis.
  • The pricing for pro is a subscription format which I personally dislike. It is also heavily focused on cloud deployment which is probably fine for most of the people but if you need a solution installed on-premise, this solution could be a little more complex (at least it seemed like it to me when we talked about it).
  • I've had a lot of Tableau users telling me that the dashboards created with Power BI weren't as pretty as Tableau. I have to agree that Tableau does have a better look but I never saw Power BI as being a big step down. I just felt I had to have it as more than one person told me the same thing.
Integration of data sources feels more robust and strict. Definitely a more classic or formal approach to data integration. In terms of visuals, Power BI is not completely up to par with Tableau but is nonetheless a great tool especially for a new player in that field of software. Where Power BI really leaves Tableau in the dust is with the cost. For data exploration, users can use the free "Author" version and that usually accounts for more than half of the total users in an org. With Tableau, if someone wants to do some exploration, they need a Tableau Desktop license which is really expensive.
Do:
  • One time data analysis/reporting where you want to have some visual representations to help you understand your data.
  • Create dashboards that can help you take business decisions and just generally help you know if your business is on track.
  • With a pro license: deploy dashboards that can be consumed by other users.
Don't
  • Use a Pro install for regulatory reports (Static reports should be created with a reporting tool if available to avoid duplicating tools and costs).
  • Deploy at large (anyone can have it installed) if data governance is important in your organization. It should really be a tool used by people that really understand the data and how to merge it (integrating different sources).

Microsoft Power BI Feature Ratings

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