October 18, 2017
Score 8 out of 10
Overall Satisfaction with MicroStrategy Analytics
It is being used across our health center in every department, from admin to ops to clinics. We are trying to use it with our scheduling program's data feed to solve TAT issues, staffing issues, and tracking issues. We've implemented several new policies around appointment cancellations due to findings in Microstrategy data. We also take in a feed from our EMR system for patient data research.
- I think the dashboards are quite helpful to visualize on the spot data.
- Creation of facts and attributes is simple - I have no programming experience and was still able to create and modify these items.
- Scheduling reports to be run on a daily, weekly, or hourly basis is simple. It provides updated data on a timed basis with no need to go back into the program.
- The graph options are not as robust as an Excel user might want.
- The metadata layer can sometimes be slower, and it takes a long time for reports to run.
- Viewing the data feed entered can be cumbersome at times, in terms of validation with reports.
Tableau was more costly and took longer to learn to use. While it does have some perks (such as no metadata layer), I find using the online version of Tableau is not as fast as the online version of Microstrategy, and creating data descriptors is easier in the latter. Tableau does not offer customization of reports as easily, either.
We had several data sources from which to pull feeds, and it might be due to security permissions on another end, but we typically had one error every other week, where we were not able to refresh data. While it was an easy fix, and did not take very long to do, it was a bit of a hassle. Trying to pull in from multiple data sources can cause it to be slow. I also think it had much to do with the person given architect permissions - he made several errors that were not caught early. Long story short, it was more due to user error than Microstrategy error.
Sharing gets a 10, collaboration is a bit less. It was easy to email and share but difficult to work the folder heirarchy for some end users. Additionally, it was hard to collaborate at the same time, and at the beginning, reports were lost and overwritten. However, sharing reports to be pushed out regularly was fantastic, and many people chose to receive their data in this way.
It is appropriate when wishing to show big data to a group that needs to make informed decisions quickly, and that does not have a technical background and cannot get bogged down in percentages and technicalities. For those that want it, however, Microstrategy provides gridded reports that make detailed examination of data easy. Both are simple to create.