Power BI - The go to software for small businesses
April 10, 2017

Power BI - The go to software for small businesses

Kunal Sonalkar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

Microsoft Power BI is used to analyze data, create dashboards, data visualizations and interactive reports for the management team to take key data driven decisions. It is used particularly by our Business Analytics dept. The main problem which it addresses is to help the decision team take informed decisions with the help of reports and data analysis performed by Power BI. It also helps in delivering reports to the people who request data of a certain domain for the informative purposes.
  • It can help you in putting your business/product/service on one dashboard. It can give you detailed data analysis reports, extremely interactive dashboards, and can perform automated report delivery as well.
  • It also has SQL server analysis and you can reuse robust data models. It has Azure analytics services in the cloud which makes it very robust product and the friendly reports and dashboards make it great product among the end users as well.
  • It also has the functionality of stunning mobile apps which update immediately if there are any changes to the data. This gives the user a strong capability to monitor the data.
  • You can publish the reports in no time and they are distributed among the organisation people immediately. So it's fast, quick and secure. You can manage the permissions as to who can view or who can edit the reports.
  • Sometimes it is not able to handle the massive and huge data tables. It can create a time lag in cases of heavy data sets and in many instances users might have to reboot the software and start from scratch.
  • It requires a lot of hands on training for a new beginner to get accustomed to Power BI. It's complexity sometimes can create a negative impact as a lot of time is needed in training and deployment.
  • In the earlier version, it doesn't allow the functionalities like high granularity and scheduling reports. The users need to constantly update on the features which might be sometime time taking to reinstall.
Power BI performs quite well in comparison to it's competitor's products. We compared it mainly to GoodData and Tableau. Power BI has a great pricing. It's affordable and efficient with mid-sized datasets. Hence many companies go for it. Competitive products like Tableau are well-suited to handling huge datasets, and also create better dashboards in some instances, but the pricing is not suitable for small scale industry or business.

GoodData, on the other hand, is relatively new in the market. It has attractive pricing but will take time to develop the sophisticated functionality provided by Power BI.
The scenarios where it's a small to mid sized business, Power BI will work well as it can handle mid-sized datasets in a very efficient way. Data analysis by creating interactive dashboards and reports is very user friendly.

The situations it might not work are when you have huge datasets to analyze. Power BI might end up in the time lag to import huge amounts of data. You might have to restart the software all together in some instances. Having said that, it's affordability and great pricing make it a success.

Microsoft Power BI Feature Ratings

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