OLAP feature: It uses Intelligent Cube technology which is the most important and game-changing introduction from version 9. Intelligent Cube technology is an in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. MicroStrategy Desktop, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. It’s a huge performance-enhancement technique.
Data discovery: With the introduction on version 10, MicroStrategy enhanced its data discovery feature which helps any user to easily analyze their data by importing Excel spreadsheets, etc. It allows you to connect live with any database, Hadoop, or OLAP. You can import your own query and integrate it with MicroStrategy. These options give you powerful ways to analyze and discover your data, which helps enable important business decisions. See sample below.
It has a robust engine compared to other BI tools available in the market.
Improvements to My Organization
The product has improved our ability to provide self-service visualization/dashboarding capability. These days, business users are more inclined toward self-analytics, rather than coming to a developer with every small request. I think MicroStrategy has done great in this particular field.
Room for Improvement
They need to improve visualization and dashboards, as it is getting tough competition from Tableau in the area. With the release of version 10.4, they did very good.
Use of Solution
I have used it for over six years.
There are absolutely no issues when it comes to stability, and it works best when you have a very good DB schema layer. A perfect schema has always been a strength of MicroStrategy, when compared to other BI tools.
No issues with the scalability; it’s a strength of MicroStrategy, because of the product’s robust SQL engine. It has a great SQL optimization process that pushes requests to the database.
Customer Service and Technical Support
It has a very active user community and they are more than happy to help you with your questions and issues. As far as tech support from MicroStrategy is concerned, I have seen a decline in last year compared to the past. I hope they improve in this area.
I have noticed that good technical guys left the department or no longer work there, which is affecting the quick resolution of any issues, but MicroStrategy is trying to rebuild its tech support department, which they were known for.
When it comes to business intelligence and reporting, I have almost always used MicroStrategy, with a little bit of Tableau.
Initial setup of the tool was very complex and challenging. They made you do lots of steps before you can say it’s done. However, with the release of the latest version, setup has become extremely easy and it’s just a single-step process.
Pricing, Setup Cost and Licensing
It’s an expensive tool and I have seen that only medium- and large-size enterprise can afford its setup and maintenance cost. Licensing is a little bit tricky and it depends on the initial buying agreement.
Other Solutions Considered
We have evaluated other tools such as Microsoft BI, SAP’s BusinessObjects and IBM Cognos, but MicroStrategy came out the winner for the solution to the problem we were looking to solve, and it aligned with our team structure. We looked at Tableau and Spotfire, as well, but they were eliminated in the first round, because of the nature of the problem we were looking to solve.
Before implementing MicroStrategy, you have to get a good resource who knows the product inside out and a data warehousing structure for long-lasting performance.
Disclosure: My company has a business relationship with this vendor other than being a customer: I work as a consultant and the company I used to work for was a MicroStrategy gold partner.