Microstrategy is extensively used within my organization and other retail and finance clients I have worked with. MSTR is an efficient tool with numerous analytical, reporting and visualization features all clubbed in one - helps deliver grid reports, dashboards and mobile reports. We have used this for dynamic sourced reports and self analytics as well widely.
Better suited for: For high volume and large number of reporting fields. For requirements where multiple modes of report delivery is required for ex: web, mobile and emails. Dynamic sourcing and self analytics with existing objects avoiding redevelopment efforts. Less appropriate: For small scale analytics considering cheaper options of analytics tools available. Creates complexity for a uncoordinated and distributed development team considering version control and Schema integration issues.