MicroStrategy backend is a warhorse.
The SQL engine (the component that generates the SQL code for reports) is very smart and has a lot of setting to adapt to your database to improve performances.
Security is strong and flexible, user can have access to different reports/dashboards or to the same object but allowed to see only part of the data.
The plugin architecture allows to add new functionality or to integrate MicroStrategy with your environment.
In the last version they improved the front-end for data exploration, but they are still behind Tableau. Much nicer than other tools.
Sometimes you can find annoying bugs that you wonder how they didn't catch before (the new quarterly release programs should help here).
The tool added a lot of functionality in the last few years, but how to use/implement them it's a bit complicated, the added new functionality but the had to build them on top of the old interface.
Get someone with experience to help you.
Use the MicroStrategy community to have help to solve your problems.
Building dashboards and reports for users from C levels to the new accountant. The new Dashboard capability is much more customizable and it looks awesome.
Prototyping from a simple db query is very quick and it helps a lot.
The MicroStrategy capability to be db agnostic allows us to use different databases, we are now exploring the hadoop space with MicroStrategy.