TrustRadius
Nice dashboards and easy to adapt when you know Excel.
https://www.trustradius.com/business-intelligence-biMicrosoft Power BIUnspecified8.1525101
No photo available
October 03, 2019

Nice dashboards and easy to adapt when you know Excel.

Score 7 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft Power BI

I have used Microsoft Power BI to create automated reports, dashboards for our clients finance department. The reports were consisting of financial targets, actual and forecasts. Along with the reports, we used formula generation functionalities and made auto calculations. It is a good reporting dashboard when it comes to display most current values along with auto calculations. Before Power BI, excel reports or ppt presentations would be distributed within the organization. With Power BI, the dashboards and data visualization became more professional looking.
  • It has a free version offered with Microsoft Office 365. So businesses with this type of license can enjoy it free.
  • Good dashboards, auto calculation and database connection capabilities.
  • Easy to learn and use when you have familiarity with Excel. You can reach free training material on many platforms.
  • Well integrated with other Microsoft programs (Excel, Access)
  • Expensive if you want on premise version. Choose the best fitting license.
  • There are some functionalities that require detailed learning. You need to have good experience with Excel, database connections, DAX.
  • Data quality matters. If you have uncleaned data, then your work on Power BI can be frustrating as it is poor on providing suggestions.
  • You may encounter with performance issues when your data is big.
MS Power BI has that nice feeling as it is a product of Microsoft family, the adaptation period of your organization will be easier. You can use your knowledge on Excel, and enjoy better data visualization, graphs, charts, data calculation capabilities. You can find more free online training material on forums, video sites. It can integrate with other MS products.
Database connections on premise can be different to configure if you are not using a common one. Connection to Azure SQL Database is enough. Data refresh and real time data calculation is good as it is always connected and synchronized. ( as far I know it is for the case when Power BI is on Cloud)
If you want to use the full scale of report sharing then you need Pro license. Once you have the Pro license you have the capability of setting accessibility security or real time sharing or app publishing. Therefore you need to choose the correct license type for your scope data distribution. I gave a middle score as I think they should release a data sharing function free besides Export to PowerPoint or Excel. Eventually BI dashboard reporting tool that you can not use for sharing reports is not good.
It actually depends on the size of the organization and person who will work with Power BI. If you have a big organization, need many reports and need dashboard visualization. Choose it. But be sure the user has good knowledge on Excel, database connections and DAX. If you are a small business you may want to stay on Excel. In any case you can try.

Microsoft Power BI Feature Ratings

Pixel Perfect reports
8
Customizable dashboards
7
Report Formatting Templates
7
Drill-down analysis
8
Formatting capabilities
7
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
7
Publish to Web
7
Publish to PDF
6
Report Versioning
Not Rated
Report Delivery Scheduling
Not Rated
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
7
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
6
Dedicated iOS Application
Not Rated
Dedicated Android Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
6
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