Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Solution Architect at a tech services company with 1,001-5,000 employees
Real User
With its single, integrated architecture, we develop once and deploy anywhere

What is most valuable?

The most valuable features are:

  • A single integrated architecture: develop once, deploy anywhere.
  • MicroStrategy Mobile: best in class mobile integration
  • MicroStrategy Office: no need to connect to MicroStrategy web/mobile; open Microsoft Office documents, worksheets and refresh data as and when required
  • MicroStrategy BigData Gateway: seamless connectivity to major Hadoop distributions
  • Pixel perfect dynamic dashboards: high quality dashboards for board-level and management reporting
  • Intelligent Cubes: load data once a day, no need to connect to the database.

How has it helped my organization?

We tried one of the leading reporting/BI tools in the market, but was it was not scaleable for enterprise levels. MicroStrategy does scale for enterprise levels.

What needs improvement?

There are a couple of areas that could be improved. Formatting the dashboard takes lot of time, which increases IT costs.

  1. Dashboard development is time consuming, if you are doing corporate themes with a similar look and feel across all your visualizations. Starting Version 10.2, MicroStrategy provided features to re-use themes and templates across multiple dashboards. This does helps a little when you have grid/graph types of dashboards. However, when every visualization is different, it takes time to achieve pixel perfect visualizations. Having a Visualization Expert in the initial design stage helps with annotations and scales used within different panels, borders, etc., but it does take time to develop.
  2. Tableau visualizations provide targeting from different data points to very different visualizations. There are some visualizations in Tableau which are much better than MicroStrategy.

We would also like to see more visualizations within Visual Insight. The existing visualizations are not at par with Tableau. I believe they were supposed to match Tableau capabilities, but they fall short on that. However, Visual Insight is better for end users who want to develop their own analysis and visualizations.

For how long have I used the solution?

I’ve been using this product for 13 years; from version 7.5.2.

Buyer's Guide
MicroStrategy
February 2025
Learn what your peers think about MicroStrategy. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.

What do I think about the stability of the solution?

We did not encounter any issues with stability.

What do I think about the scalability of the solution?

We did not encounter any issues with scalability.

How are customer service and support?

I would rate technical support a six out of 10 (one-worst 10-best). Based on the level of support (Gold) we had, I have found tech support a bit sluggish. We had already resolved issues with workarounds before technical support came up with solutions.

Which solution did I use previously and why did I switch?

We were using Tableau, but it had scalability issues and per-user licensing costs.

How was the initial setup?

We did have some issues, but good documentation from MicroStrategy and the Technotes helped resolve most of them.

What's my experience with pricing, setup cost, and licensing?

Pricing/licensing is little bit on the high side. Businesses buying this product should plan in advance what licenses to purchase. I would advise you to hire a contractor or free lancer with previous MicroStrategy experience to plan your project correctly.

What other advice do I have?

If you have a user base that is going to increase over time, this product is best suited. Web-user licenses are unlimited for users who do not wish to create their own reports or dashboards and just want to view, download, and use.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user3900 - PeerSpot reviewer
Manager of Development at a tech services company with 1,001-5,000 employees
Consultant
Issues with reports, however can be quickly fixed

A common problem in MicroStrategy that users face is the performance of reports. But with simple tuning techniques that the product provides this can be fixed in no time.
I would like to share with you the techniques that I have played around with.

First I would like to talk about the caching.

Caching allows for improved performance in response to report queries. As the cache gets stored in the memory, when repeated queries are made against the same reports the data is fetched faster.

Caching comes in different forms - Project/Report Level Caching and Template Caching

1. Caching can be enabled/disabled at project or report level. However the report level setting will override the project level setting. Using Project Configuration we can enable the caching else in report – using caching options we can enable or disable the caching. This type of caching is very useful only in cases where the data is preloaded in the database and there is no incremental refreshing of the database at any time of the user report run. For a data warehouse caching would help as against a OLTP ( Online Transaction Processing) system where data is frequently refreshed.

2. Templates can also be used for caching. Using a common template for developing common reports will help to fetch report data faster.

In projects I have worked on, we have implemented template level caching where in one template is built with common set of attributes and metrics and the reports are built by using the templates as shortcuts and in turn we cache the templates. Hence when one of the reports built from the template is run the entire data of template is run and gets cached in the memory and when other subsequent reports are run the report hits the cache and does not hit the database thus increasing the performance.

Next I would like to talk about intelligent cubes. This is a form of In-Memory cache.

Rather than returning data from the data warehouse for a single report, you can return sets of data from your data warehouse and save them directly to Intelligence Server memory. These sets of data can be shared as a single in-memory copy, to be used by many different reports created by multiple users.

These are gaining huge importance as they have several advantage over report cache as report caches expire or become invalid in certain circumstances.
A few instances are:

1. When there are changes made to the objects in the data warehouse, the existing caches may be configured so that they are no longer valid when hitting certain warehouse tables. Any further report execution will not hit the cache.

2. When the definition of an application object changes (such as report definition, report, report template, metric definition) the related report cache is marked invalid.

3. When there is need to control the growth of caches in the intelligence server memory, old caches need to be expired automatically.

Intelligent cubes can be refreshed on daily, weekly, quarterly monthly or yearly. In my past experience where I was working with a financial firm, we maintained cubes for different regions - Asia, EMEA and Tokyo. Also we developed cubes for daily and monthly data. Hitting against the database caused performance issues and having a single cube to store all data had its problems.
Also with recent versions of the tool, a new concept called incremental refreshing was introduced where in a cube loaded with 1 lakh records need not be refreshed just to insert or update a few row of records. With this new concept it was just sufficient to build a incremental refresh report with the required criteria to refresh the cube. For eg: If data was loaded for Region A at 9:00 AM from the database into the cube and data for Region B was available only at 12:00 PM then a incremental refresh report can be created on top of the cube with only one filter condition like Region = B and with the insert records option so that it does not override the existing data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user8547 - PeerSpot reviewer
it_user8547Consultant at a financial services firm with 501-1,000 employees
Consultant

Cubing and caching works for OLAP database generally when the frequency of data update is less. For systems like OLTP these tuning won’t work. I agree when you use cubing and caching the reports fly in seconds but there are various performance tuning techniques that can be used in Microstrategy.

General tuning includes tuning your DB driver which is provided by data direct for MSTR which is very useful if you want to increase network through put and use clustered DB. There are lot of quick tunings which is possible using microstrategy and I believe a separate post on it.

In case you want to explore some tuning options I would be happy to assist.
Feel free to reach out to me at arpitagrawal9@yahoo.co.in for any queries.

See all 5 comments
Buyer's Guide
MicroStrategy
February 2025
Learn what your peers think about MicroStrategy. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
Sales Director at Expeditus (Pty) Ltd
Real User
Better graph technology than most competing tools on the market
Pros and Cons
  • "MicroStrategy has what they call the Semantic Graph — an enterprise-grade semantic graph — and I think the technology is fantastic."
  • "MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people."

What is most valuable?

MicroStrategy has what they call the Semantic Graph — an enterprise-grade semantic graph — and I think the technology is fantastic. 

What needs improvement?

MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people.

What do I think about the stability of the solution?

If you have a skilled individual to make sure all the settings are correct, it is stable. Once the setup is configured correctly, it's a very stable system.

What do I think about the scalability of the solution?

MicroStrategy is scalable. It's built for enterprises.

How are customer service and support?

MicroStrategy support could be more responsive. About 10 or 15 years ago, they were winning technical support awards, but I've not seen anything like that in the last few years. So I think there's a lot of room for improvement in their technical support.

How was the initial setup?

If you have the right skills, it's not a difficult process. However, as environments change and become increasingly complex, it's harder to keep everything aligned on the administrative side, especially in large institutional settings. It's challenging to keep the backend administration of the system in line with those changes. Larger organizations have complex environments that the technology needs to interface with. So that's where it gets complicated. 

What's my experience with pricing, setup cost, and licensing?

All BI software vendors' list prices are high. It's about a price that fits the customer's needs. And I think MicroStrategy has some flexibility in its pricing model where we can easily demonstrate a total cost of ownership comparison against any of the other players. But you could do that from any BI vendor's perspective.

What other advice do I have?

I rate MicroStrategy nine out of 10. Doing business with MicroStrategy is relatively challenging because of the processes that are involved. But the technology is probably the best in the market overall. I think they could add a lot more graphs and charts into their standard product. At the moment, you have to go to third parties to get some of the latest charts and graphs. 

I would recommend it. But if you're going to implement it, you need to invest in educating and training your employees on the product because it is complex. Data literacy today is a big topic, so companies investing in BI technologies should also invest in promoting data literacy among the staff who will be accessing and consuming that information. Right now, most of the training goes to BI professionals. However, companies should also train people who need to consume the data coming out of those departments.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Operational Risk Manager
Real User
Its flexibility and performance help make our organization more efficient, less expensive
Pros and Cons
    • "I would try to make it a little more basic, user-friendly. In terms of the UX, it's a bit sluggish there."

    What is our primary use case?

    Our primary use case is to use the business intelligence tool for court data, to make the court and judges work more efficiently, faster, and less expensive.

    It's performing well, we are expecting a major breakthrough this year regarding the analytics bot.

    What is most valuable?

    The flexibility.

    And looking ahead in 2018, we expect to be using dashboards and, hopefully, Dossier.

    What needs improvement?

    I would try to make it a little more basic, user-friendly. In terms of the UX, it's a bit sluggish there.

    What do I think about the stability of the solution?

    You should ask me this question when we get to version 10.10.

    We have had downtime with the current version but I wouldn't put that on MicroStrategy. Maybe it's MicroStrategy's fault, but I wouldn't it put it that way.

    What do I think about the scalability of the solution?

    I think the scalability is excellent.

    How is customer service and technical support?

    We haven't used tech support directlly, we have our partners to help us.

    What other advice do I have?

    Regarding rolling out self-service to business teams with MicroStrategy, we have been thinking about it, but I doubt that we will.

    As for having the analytic capability in a single platform like MicroStrategy, versus many-point solutions, we naturally prefer one platform. This is because of a single, standard mode. We don't have to scatter and search through eleven different platforms when there's only one there.

    We are thinking about investing in the mobile platform of MicroStrategy but I can't say positive, we will, or negative, we won't. I don't know at this point.

    For me, the most important criteria when selecting vendor, in general, are 

    • flexibility
    • and their Interest in work with us - I like devotion to our interests.

    You should have a clear goal, and focus on a single thing for the tool, to yield the best results as fast as possible.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user538236 - PeerSpot reviewer
    Sr Staff BI Engineer at a financial services firm with 1,001-5,000 employees
    Vendor
    Object sharing helps the end user with self-service reporting.

    What is most valuable?

    • Sharing objects, which helps the end user with self-service reporting.
    • Security filter controls the data-level security in the report for sharing with more than one partner.
    • Access Control List controls the object-level security for accessing by user.
    • OLAP functionality:
      • Multidimensional analysis: OLAP helps the user gain an insight on the data coming from different sources.
      • OLAP helps faster execution of complex analytical and ad-hoc queries.
      • Allows trend analysis periodically.
      • Drill down abilities.
    • MicroStrategy Desktop is one of the popular analytic tools that can be migrated to a server for publishing for other users.

    How has it helped my organization?

    • * Reduced IT dependency. *
    • Using template
    • Users (Business Analyst) are using this canned report template for their reporting based on their info and save that report in their own folder. And they are using subscription to deliver that report to their stakeholder.
    • Allowing user to create report from scratch. Train them what to use and what to not use. Once they familiar these then they don’t dependent on IT.
    • Introducing the Dashboard; provide enough information in the dashboard. Once user started using those dashboard then they don’t dependent on IT.
    • Now most of the request from users like below;
    • - New metric (custom metric)
    • - New filters (custom filter)
    • - Complex reports where they can’t create by themselves.

    What needs improvement?

    • MicroStrategy Desktop: Personal analytical tool that helps users to do their analytical work using multiple sources of data. However, this tool needs to improve to add more analytical functions, and an easy solution to use third-party graphs and maps.
    • Multi-level security: Currently, MicroStrategy provides multiple ways of access (Standard, Windows, Database, LDAP, etc.) the MicroStrategy tool (use either one of them), but not combined solutions.
    • Big data solution: Currently, MicroStrategy is providing a very good big data solution for MicroStrategy Desktop but not an easy server-level solution.

    * Reduced IT dependency. *

    n Using template

    o Users (Business Analyst) are using this canned report template for their reporting based on their info and save that report in their own folder. And they are using subscription to deliver that report to their stakeholder.

    n Allowing user to create report from scratch. Train them what to use and what to not use. Once they familiar these then they don’t dependent on IT.

    n Introducing the Dashboard; provide enough information in the dashboard. Once user started using those dashboard then they don’t dependent on IT.

    Now most of the request from users like below;

    - New metric (custom metric)

    - New filters (custom filter)

    - Complex reports where they can’t create by themselves.z

    For how long have I used the solution?

    We have been using the solution for about eight years.

    What do I think about the stability of the solution?

    We have not encountered any stability issues.

    What do I think about the scalability of the solution?

    We have not encountered any scalability issues.

    How are customer service and technical support?

    I would rate the technical support as about 7/10.

    Which solution did I use previously and why did I switch?

    We were previously using Crystal Reports. We switched because of the analytical solution offered with this product.

    How was the initial setup?

    Initial setup is straightforward. Step-by-step configuration information has been provided by the vendor.

    What's my experience with pricing, setup cost, and licensing?

    I would advise others to go for the Named User license instead of the Server Level license initially. License pricing is moderate.

    Which other solutions did I evaluate?

    I am not aware of any other evaluated solutions.

    What other advice do I have?

    Go for it.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user162021 - PeerSpot reviewer
    Business Development Manager at a tech company with 51-200 employees
    Vendor
    Blending and mashing enables business users to access different data sources, and combine them to create reports and visualizations.

    What is most valuable?

    • Visual insights:
      • For ad-hoc and self-service visualization
      • Faster user adoption
      • Connection to different sources
      • Data blending / mashing: Blending and mashing is valuable since users right now are currently tied up with the traditional way of getting data from databases prepared by IT. This feature will enable business users to immediately have access to different data sources, whether from IT or from their personal files, and allows them to combine these sources, and create reports and/or visualizations quickly and easily.
        Saves time and empowers business users.
      • Visual data discovery / data visualization
    • Developer: object-oriented BI modelling
    • Web services: building highly customized BI applications
    • Mobile: pixel-perfect mobile dashboards, building mobile apps
    • Object manager: migrations
    • Security: complete and secure for enterprise scale

    How has it helped my organization?

    • As a consulting firm: delivering BI solutions to customers effectively and efficiently at an enterprise level

    What needs improvement?

    • Developer: Simplify BI modelling features to increase learning curve and user adoption.
    • Data visualization: Improve and add visualizations and features to prepare BI apps. Reduce clicks and steps.

    For how long have I used the solution?

    I have been using it for 3-4 years, including earlier versions (9.2).

    What do I think about the stability of the solution?

    We have encountered minimal stability issues.

    What do I think about the scalability of the solution?

    We have not encountered any scalability issues.

    How are customer service and technical support?

    Customer support is great but can still improve TAT.

    Which solution did I use previously and why did I switch?

    We did not switch from a previous solution. We use Tableau, Microsoft and MicroStrategy depending on the needs or requirements of the customer.

    How was the initial setup?

    The setups I have done are all single-server deployments, both in Linux and Windows:

    • I-Server
    • Mobile server
    • Web server

    What's my experience with pricing, setup cost, and licensing?

    Further simplify the licensing scheme:

    • Architect is expensive
    • Match or beat the pricing of Tableau
    • Tableau is still cheaper

    Which other solutions did I evaluate?

    All products have been used depending on the customer.

    What other advice do I have?

    At the enterprise level, MicroStrategy is good but requires a longer learning curve to fully maximize the platform as compared to other traditional BI tools and niche products such as Tableau.

    Disclosure: My company has a business relationship with this vendor other than being a customer: We are a business partner of MicroStrategy in the Philippines. Re-seller, SI and SP.
    PeerSpot user
    PeerSpot user
    System Architect at a tech services company with 5,001-10,000 employees
    Consultant
    It offers reports, dashboards and widgets for end users, along with mobile and web access

    Valuable Features

    • Perfect reports, dashboards and widgets for end users
    • Mobile and web access

    Improvements to My Organization

    Management can see how the business is going, financial stuff and analyze all sales processes. It is possible to build advanced beautiful reports, decorated with different graphs, charts, which is so liked by management, though this beauty can be infinitely improved, especially in mobile apps. Also, we can present analytics in dashboards, combine elements in a document, animate them, visualize them and more.

    Room for Improvement

    As an architect and implementation specialist, I think it must improve component integration, troubleshooting and diagnostics.

    The evaluation possibilities for developers are very bad. Obtaining the installation key and activation code is a complicated procedure; there are problems with the extension of the evaluation period. Unfortunately, it sometimes takes a long time for customers to understand the benefits of the product and in this way, MSTR is less convenient for developers.

    We had some problems with EM statistics ETL, Architect, and Operations Manager.

    Use of Solution

    I have used it for two years.

    Stability Issues

    I have encountered stability issues: unstable Architect mappings, IS crashes without diagnostics, and so on.

    Scalability Issues

    I have not encountered any scalability issues, because we did not risk using it for large projects. We use Oracle BI instead.

    Customer Service and Technical Support

    Technical support is a six out of 10. For example, MicroStrategy closed their office in Russia. Before that, customers could solve problems with the product through us, due to the lack of a Russian-speaking support line. After the office closure, they simply did not renew support.

    Initial Setup

    Initial setup was relatively straightforward. However, beginner users can suffer from a lack of information and help from the community after using Oracle products.

    Pricing, Setup Cost and Licensing

    The product has a nice price.

    Other Solutions Considered

    Usually, we use Oracle BI, MSAS or Pentaho. For only two projects, MSTR was the best choice for our customers. We also can use SAP BO.

    Other Advice

    Read the documentation, have patience and good luck in looking in the knowledge base.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user326337 - PeerSpot reviewer
    it_user326337Customer Success Manager at PeerSpot
    Real User

    Did you find everything you need(ed) in the documentation/knowledge base?

    See all 4 comments
    it_user511212 - PeerSpot reviewer
    Senior BI Developer at a tech services company with 1,001-5,000 employees
    Consultant
    I like MSTR architect resembles data modelling for attribute relations/hierarchies; MSTR web has numerous options for end users.

    What is most valuable?

    MicroStrategy has a lot of features. If the developers and end-users know how to use it in depth, it is one awesome BI tool.

    MicroStrategy Architect is kind of a data modelling tool available in the MicroStrategy Desktop. It is used to maintain the relationships among the attributes. It is a really useful tool, especially when you have to modify the relationships/hierarchies; you do not need to go to the database to do the changes. Instead, you can use this architect to define them.

    MSTR generates SQL automatically for every object you pull on to the report. It has many options available in the VLDB properties where you can optimize the SQL.

    Web is an amazing tool for end users. You can customize the reports, create new ad-hoc reports, modify the existing static reports and apply sorting, filtering, pivoting, etc. Admins can define the access levels to the users based on their right to view/modify the sensitive data. Access levels can be defined at many levels; at project level, folder level, report level to the developers, standard users, project owners/directors.

    How has it helped my organization?

    The security filters concept was very useful for our requirements. It was like we had to use same database tables (backend) and report structure (frontend) for different countries but each country should not see the others’ data. In this case, we can apply security filters in the web environment to the user groups specific to the country.

    Data blending is also a good feature. With this, you can insert objects from more than one dataset in a single grid or graph in the dashboard. This allows users to create their own custom dashboards from multiple datasets.

    What needs improvement?

    The visual insight tool can be improved further. When I tried with Tableau, it has a wide variety of graphs to generate quick and easy.

    The graphical interpretations developed from the reports are not directly usable for dynamic analysis and formatting takes longer. the graphs do not indicate trends on their own. Whereas in Tableau, developing dashboards from the scratch is easy and super fast and dashboards look great without formatting.

    But I heard MSTR version 10 has come up with many features; yet to try.

    For how long have I used the solution?

    I have used it for five years.

    What do I think about the stability of the solution?

    I have not encountered any stability issues so far.

    What do I think about the scalability of the solution?

    I have not encountered any scalability issues so far.

    How are customer service and technical support?

    I am not really a great fan of tech support, because my project’s issues didn't get solved or the response was not quick.

    However, there is a discussion forum on the MicroStrategy Community site. You can post any technical/tool-based questions and you will get a fast response. It also has a knowledge base, which has many posts/tech notes written to provide solutions to the different kinds of problems. This community is really awesome, with many blogs/articles on MSTR.

    Which solution did I use previously and why did I switch?

    MicroStrategy was the first tool I worked on in five years. But I would probably switch to Tableau if I needed to work on visual insights and utilize a variety of graphs.

    How was the initial setup?

    Initial setup was quite straightforward and easier to me.

    What's my experience with pricing, setup cost, and licensing?

    The price is too high. They could at least increase the software evaluation period.

    Which other solutions did I evaluate?

    We didn't evaluate any other tools; the requirements we received from customers instructed us to work with MSTR.

    What other advice do I have?

    MSTR is a great tool for reporting. Especially for big organisations, it is very stable. Training is a must for the developers who want to play with the options available in and out of the tool.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user326337 - PeerSpot reviewer
    it_user326337Customer Success Manager at PeerSpot
    Real User

    Anusha, until these features are (hopefully) updated, what is preventing your reports from being directly usable? Are these findings that you were able to derive easily when using Tableau? I'd love to hear your feedback.

    Buyer's Guide
    Download our free MicroStrategy Report and get advice and tips from experienced pros sharing their opinions.
    Updated: February 2025
    Buyer's Guide
    Download our free MicroStrategy Report and get advice and tips from experienced pros sharing their opinions.