What is most valuable?
Scalability and the ability to process large amount of data are the product’s most valuable features. The ability for a user to create a report without knowing anything about joins, SQLs, tables, etc. is to me the best feature of MicroStrategy.
How has it helped my organization?
The product enables our business to create thousands of reports without knowing anything about the backend. MicroStrategy has been an enterprise reporting tool at our organization for a very long time. From the very beginning, the ability of the tool to provide a drag and drop interface to end users to create reports using the enterprise data warehouse effortlessly helps them in taking strategic decisions in their day-to-day operation.
What needs improvement?
The initial schema development takes some time. Without a robust schema, the tool will not function properly. The schema is the main engine which creates SQL effortlessly, but designing and maintaining the schema will take some time. The relationship between different attributes has to be maintained properly, as one incorrect relationship has the potential of affecting 100s of reports using that attribute. The schema can’t be maintained by end users and IT intervention is required.
There are two main development tools – Developer and Web. The two platforms are not in sync. Some options are not present in developer and some are present in web. The ones that are present in both are not located under same menus.
Dashboard development takes a long time.
The self-service BI part of the tool, Visual Insights, which is designed to provide the business the ability to create interactive dashboard using visualization, is not very great. Though Visual Insights has improved a lot in version 10.x, it still has a long way to go and is no way near competitors such as Tableau.
For how long have I used the solution?
I have used it for eight years.
What do I think about the stability of the solution?
With every version, they will introduce some new tools/feature and it’ll take them a few versions or hotfixes to stabilize that new feature. There are different modes of running dashboards – presentation, Flash, interactive – and not all features work in all of the different modes.
What do I think about the scalability of the solution?
The tool is scalable. Adding users or reports doesn’t have to be a headache, as long the hardware is robust enough to handle the additional reporting load.
How are customer service and technical support?
There is a community site where developers can ask questions and get answers from other developers and experts, as well as MicroStrategy tech support. The community also has a pretty decent knowledge base in the form of tech notes, which provide information about known defects, issues and workarounds.
We have a support contract and regularly work with tech support on issue resolution, etc. I would give them 5/10, simply because, at times, the reps aren’t experienced enough and need a little hand-holding, which you wouldn’t expect considering they are the vendor and should know more or should be on par with the person asking the questions. Issue resolution also take a lot of time.
Which solution did I use previously and why did I switch?
We’ve always worked with MicroStrategy.
How was the initial setup?
Initial set up is a bit complex, as I’ve mentioned. Everything is based on the relationship defined in the schema. If someone messes that up, the reports will start giving incorrect output.
Also, to ensure scalability, the hardware needs to be robust, but I guess that is true for any tool.
What's my experience with pricing, setup cost, and licensing?
It is an expensive tool. Licenses are user based or CPU based. Depending on the size of the organization, you might want to go with CPU based rather than user based, as that might be cheaper.
Which other solutions did I evaluate?
Before choosing this product, I did not evaluate other options.
What other advice do I have?
It’s a good product for organizations planning to deploy an enterprise-wide reporting solution that will be built on top of a RDBMS. It is very robust and can handle large amounts of data fairly well. If the goal is to have a tool that can provide self-service BI and let end users create attractive dashboards without having to worry about object sharing, reusability, schema design, and IT involvement, then there are better & cheaper tools in the market.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
I agree with the Dimensional Modeling capabilities within the tool. Parent-Child relationships are easily defined (including M-M & Joint Child relationships). The ability to create table alias with one click is a handy feature, too. Hierarchies and Drill Paths provide ease of navigation within the attributes and data.
The MicroStrategy Project Design Guide (any version will do) provides one of the best, most easily understandable explanation of dimensional modeling I've ever come across. In fact, I've kept my original hardcover version from their v5 edition as a resource I lend to anyone I'm teaching modeling to.