Nice dashboards and easy to adapt when you know Excel.https://www.trustradius.com/business-intelligence-biMicrosoft Power BIUnspecified8.15251012019-10-03T17:01:46.286Z
October 03, 2019
Nice dashboards and easy to adapt when you know Excel.
Score 7 out of 101
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.