MicroStrategy Review

We can create a single report/dashboard from multiple data caches (Cubes)

What is our primary use case?

Predictive analysis with R, reporting and dashbaords.

How has it helped my organization?

With the advent of the partitioning concept in Cube partitioning, predictive analysis with visualizations, our organization is able to win back customers and customer appreciation.

What is most valuable?

  • Its Cube performance
  • Can be easily integrated to D3
  • Can be easily integrated with third-party tools/products

What needs improvement?

Data writeback, and on-the-fly predictive analysis results from R and Python.

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

Cube publish time exponentially increases with MicroStrategy Cube size. Also, it has been observed that the Cube data gets unloaded from MicroStrategy's Cube cache resulting in reports and dashboards being impacted, having no data when executed.

What do I think about the scalability of the solution?

With Cube partition (v10.1 and above) scalability has not been an issue, but the Cube publish time, and temporary space consumption while the Cube is being published, has almost doubled during implementation of Cube partition.

How is customer service and technical support?

I would rate tech support seven out of 10, in terms of response and issue resolution.

Which solutions did we use previously?

We used SSRS reports, but the performance and visualization were always an issue.

How was the initial setup?

Initial setup is bit of complex, this being an enterprise tool. It has three main components: Desktop, Web development, and Intelligence Server, and each has to be installed separately.

Which other solutions did I evaluate?

Before going ahead with MicroStrategy, we evaluated Tableau and QlikView, but in terms performance, data handling, and stability, we found this product scored highest. In fact, Tableau and QlilView are less stable and in no way match the Cube (cached data) functionality offered by MicroStrategy. A single report/dashboard can be created by pulling information from multiple cached data (called Cubes).

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email