HTML content in dashboards
MicroStrategy can read data from a wide variety of different DBMS and web services, producing optimized SQL code for each of them. It's a one stop solution for BI: after 10 years using it I still haven't found a report or graph that can't be done with the suite.
Improvements to My Organization:
streamlining processes, cleansing data
We use it for any kind of reporting and analysis. It helped manage the institution, reduce costs and provide better service to the patients (which are our customers...)
Room for Improvement:
HTML5 visuals, modern infographics
The web is full of very interesting data, and the number of web services providing datasets is increasing. I would like to see Support for OAuth 1.0 and 2.0 to be able to attach external data sources. I'd like to have Support for JSON data.
Use of Solution:
The software is feature rich and clearly not easy to start with. I believe the installation and the setup of the data model is the most difficult part; once this is done, the rest of the deployment is very easy. Clients run on Windows, on Android and on iOS seamlessly, there is a web based interface that can be used from most browsers.
No. I have been using the software both on Windows and on headless Linux, and had no stability issues fo far. Memory availability is very important, as in any other data intensive software.
We don't have Petabytes scale databases. Our information systems are in the Gigabytes order of magnitude. We were able to handle our data volume with ease. Number of concurrent users is in the hundreds, no problems so far.
We solve most of the issues with the knowledge base or the discussion forums. To date we had no interaction with the customer service apart from some help we needed for upgrading from version 7 to version 9.
The knowledge base is extensive and covers 90% of the problems we may face. For the rest, we manage to find alternatives thanks to networking, blogs, forums, etc.
We are still using multi vendors solutions. There are historical datawarehouses that need to be maintained (Oracle BI, Actuate, Microsoft BI), but all new development is done with MicroStrategy.
Reason for that is mainly practical and economical. We prefer paying licenses to one signle vendor whenever posible.
We are also testing the new free Desktop version for a reduced number of users.
The setup is complex. After the installation you need to configure several aspect of the suite: metadata, connections, Project settings and start developing objects.
I suggest buying a book or reading the manual thoroughly.
There is a very good book on Amazon "Business Intelligence with MicroStrategy" that covers every aspect of the setup and initial phases of the Project (http://amzn.to/1by3HAO).
We implement everything in house due to the sensitivity of data.
Cost and Licensing Advice:
I'd rather not disclose it.
Other Solutions Considered:
We evaluated Oracle, QlickView, Tableau, Microsoft BI
Training training training. Especially in the beginning phase, a wrong choice can be very costly.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Aug 10 2015