TrustRadius
Microsoft BI Review 3 of 48
Microsoft BI Review: "Ideal for Data Analytics and Visualization, but not for noobs"
https://www.trustradius.com/business-intelligenceMicrosoft BIUnspecified7.8583101
July 14, 2018

Microsoft BI Review: "Ideal for Data Analytics and Visualization, but not for noobs"

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft BI

We use Microsoft Power BI for one of our client's project data management. He has a database of mobile app users who sign up for the premium account and Power BI is used to analyze the data and build a graphical representation of the given data, which is very convenient when you need to create a presentation or something (or simply want to see your data presented visually.)
  • Data analytics features - you can filter the data according to a billion (it feels like) ways and make sure your data is just what you need.
  • Graphs, charts, and everything else visual - not only you can analyze your data according to filters and everything, you can also make it look good and understandable without having to look through a ton of numbers.
  • It can handle quite large amounts of data input, so this makes it a good addition for the projects that require big data.
  • Works well with other Microsoft products (including .NET projects).
  • It's not very user-friendly (at least, not if you use it every single day and can tell where a feature is located when you wake up in the middle of the night). It takes some time to get the hang of it.
  • Sometimes it feels like there is just a bit TOO MANY features. I mean, they are all awesome, but it's easy to get lost.
Microsoft Power BI offers a good set of data sources - anywhere from Excel / CSV to JSON to Azure databases. For our client's project, we use the Azure database (the backend of the project is written using .NET) and it's quick and convenient - you simply login and ta-da, you have all your data to manage.
There is a possibility to create any kind of role and access permissions, but it's not the easiest process from what I know (and had experience with). Granted, I am not a developer or system administrator, so I don't usually NEED to create any kind of roles, but yeah. You create a role, then choose the table (database) you need and you can either write a DAX filter expression or choose them from the drop-down menu in your table settings.
If you want Excel on steroids in terms of graphs and data analysis - this is your beast. It has all kinds of visualizations available and you can filter the data to make it as precise as you want. We use it for managing the data from the mobile app and to create visual reports of the users' actions.

Microsoft BI Feature Ratings

Pixel Perfect reports
9
Customizable dashboards
7
Report Formatting Templates
8
Drill-down analysis
9
Formatting capabilities
9
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
10
Publish to Web
9
Publish to PDF
9
Report Versioning
Not Rated
Report Delivery Scheduling
9
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
9
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Single Sign-On (SSO)
9
Responsive Design for Web Access
Not Rated
Dedicated iOS Application
10
Dedicated Android Application
10
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
9
Javascript API
9
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
10