PowerBI for your dashboard and reporting needs.
December 14, 2018
PowerBI for your dashboard and reporting needs.
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Power BI For Office 365
PowerBI is used within our organisation to display various data and metrics in a visual way, but also allows exporting where required to allow users to interact with the data directly in Excel. It is used by all staff at our organisation. For some it is a simple snapshot view of some data to show where we as a company are right now, for others they use it to drill into sales or product data to give them a quick way to see this data without having to use the clunky reports/interface of our ERP system. The product has allowed us to move from just Excel-based reports to dashboards that show visually what is happening. It also provides the option of simple controls to slice and filter the data to requirements. It is simple to use and create visualisations where previously we had to use a separate system for that.
- Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
- Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
- Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
- Ability to show data but also export the data, if permitted.
- Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
- Once a report uses a Pro feature, it needs a Pro license, but a lot of these are just basic features and the users are just viewing and not using any of the advanced features. It would be nice to have a Pro / Viewing license and Pro / Interacting license.
- Limited amount of refreshes per 24 hours period. 5 refreshes as of Dec 2018.
- The emailing of reports is there but kind of basic. It will do a screen grab of a report, which doesn't turn out very well.
Not directly comparable, but we used Telerik previously to create visualisations and our own dashboards, which worked and looked nice but required much more setup to get running as it needed a web server to display the dashboards via HTML. Otherwise, we just used SQL SSIS to create Excel reports with the data required and emailed out, ugly and painful.