Ideal for Data Analytics and Visualization, but not for noobs
July 14, 2018

Ideal for Data Analytics and Visualization, but not for noobs

Zee Gimon | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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.
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 (MSBI) 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
Mobile 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