Power BI, create for ad hor reporting but not for dashboarding
December 28, 2018

Power BI, create for ad hor reporting but not for dashboarding

Francois Salvert | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

Power BI is mainly used in the Marketing/BI group by analysts. Its main use is to dig into various datasets in order to find answers to various questions directors and VP may ask. Power BI is not really used to produce dashboards but more for reporting (for ad-hoc queries). For example, if there is a specific promo code being used on a given day more than normal, we will use Power BI to investigate patterns from users that have entered this problematic promo code to see if it's legit or not.
  • Easily connect to multiple databases or cloud solutions.
  • Possibility to modify datasets or change formatting in Power BI vs having to modify data at the source.
  • Since Power BI can cache locally some of the data, it's possible to continue working offline on datasets.
  • A bit heavy to run and not that intuitive compared to other tools.
  • Dashboarding is really a pain compared to other tools and the visualization provided with the tool are not what you should expect.
  • Very very frequent updates that require you to reinstall the software almost on a monthly basis. Will need admin rights from your organization.
For dashboarding, Klipfolio is vastly superior. I use Power BI to get quickly to the data I need to display in a dashboard. Once I tested everything in Power BI, I will pull the datasets in Klipfolio to create a dashboard that will refresh automatically every hour, for example.
Perfect for ad-hoc reporting but don't use this software for dashboarding automation. Klipfolio will do a better job for your dashboards.

Microsoft Power BI Feature Ratings

Pixel Perfect reports
2
Customizable dashboards
2
Report Formatting Templates
4
Drill-down analysis
9
Formatting capabilities
8
Report sharing and collaboration
5
Pre-built visualization formats (heatmaps, scatter plots etc.)
3
Location Analytics / Geographic Visualization
3
Multi-User Support (named login)
7
Multiple Access Permission Levels (Create, Read, Delete)
6
Single Sign-On (SSO)
6
Responsive Design for Web Access
3
Mobile Application
3
Dashboard / Report / Visualization Interactivity on Mobile
3
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