What is most valuable?
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.
How has it helped 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...)
What needs improvement?
HTML5 visuals, modern infographics
For how long have I used the solution?
What was my experience with deployment of the 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.
What do I think about the stability of the solution?
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.
What do I think about the scalability of the solution?
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.
How are customer service and technical support?
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. Technical Support
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.
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
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).
What about the implementation team?
We implement everything in house due to the sensitivity of data.
What's my experience with pricing, setup cost, and licensing?
I'd rather not disclose it.
Which other solutions did I evaluate?
We evaluated Oracle, QlickView, Tableau, Microsoft BI
What other advice do I have?
Training training training. Especially in the beginning phase, a wrong choice can be very costly.