MicroStrategy can read data from a wide variety of different DBMS and web services, producing optimized SQL code for each of them. It's a one stop solution for BI: after 10 years using it I still haven't found a report or graph that can't be done with the suite.
Senior business Intelligence consultant at Asociación SevillaUP
Feature rich, complete, one-stop solution for BI. Needs training and coffee.
What is most valuable?
HTML content in dashboards
How has it helped my organization?
streamlining processes, cleansing data
We use it for any kind of reporting and analysis. It helped manage the institution, reduce costs and provide better service to the patients (which are our customers...)
What needs improvement?
HTML5 visuals, modern infographics
The web is full of very interesting data, and the number of web services providing datasets is increasing. I would like to see Support for OAuth 1.0 and 2.0 to be able to attach external data sources. I'd like to have Support for JSON data. I hope HTML5 and JavaScript will be used extensively in next versions, to substitute the Flash based components.
For how long have I used the solution?
Since 2003
Buyer's Guide
MicroStrategy
December 2024
Learn what your peers think about MicroStrategy. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,053 professionals have used our research since 2012.
What was my experience with deployment of the solution?
The software is feature rich and clearly not easy to start with. I believe the installation and the setup of the data model is the most difficult part; once this is done, the rest of the deployment is very easy. Clients run on Windows, on Android and on iOS seamlessly, there is a web based interface that can be used from most browsers.
What do I think about the stability of the solution?
No. I have been using the software both on Windows and on headless Linux, and had no stability issues fo far. Memory availability is very important, as in any other data intensive software.
What do I think about the scalability of the solution?
We don't have Petabytes scale databases. Our information systems are in the Gigabytes order of magnitude. We were able to handle our data volume with ease. Number of concurrent users is in the hundreds, no problems so far.
How are customer service and support?
Customer Service:
We solve most of the issues with the knowledge base or the discussion forums. To date we had no interaction with the customer service apart from some help we needed for upgrading from version 7 to version 9.
Technical Support:The knowledge base is extensive and covers 90% of the problems we may face. For the rest, we manage to find alternatives thanks to networking, blogs, forums, etc.
Which solution did I use previously and why did I switch?
We are still using multi vendors solutions. There are historical datawarehouses that need to be maintained (Oracle BI, Actuate, Microsoft BI), but all new development is done with MicroStrategy. Reason for that is mainly practical and economical. We prefer paying licenses to one signle vendor whenever posible. We are also testing the new free Desktop version for a reduced number of users.
How was the initial setup?
The setup is complex. After the installation you need to configure several aspect of the suite: metadata, connections, Project settings and start developing objects. I suggest buying a book or reading the manual thoroughly. There is a very good book on Amazon "Business Intelligence with MicroStrategy" that covers every aspect of the setup and initial phases of the Project (http://amzn.to/1by3HAO).
What about the implementation team?
We implement everything in house due to the sensitivity of data.
What's my experience with pricing, setup cost, and licensing?
I'd rather not disclose it.
Which other solutions did I evaluate?
We evaluated Oracle, QlickView, Tableau, Microsoft BI
What other advice do I have?
Training training training. Especially in the beginning phase, a wrong choice can be very costly.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Operational Risk Manager
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.
Buyer's Guide
MicroStrategy
December 2024
Learn what your peers think about MicroStrategy. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,053 professionals have used our research since 2012.
BI Analyst at a healthcare company with 1,001-5,000 employees
We are using Dossiers to enable our executive committee to tell the stories behind the data
Pros and Cons
- "We have ramped up user adoption."
- "Technical support has sent us to rapid response before, when we really needed them."
- "Dossiers are going to change the name of the game for us. We want to be able to have the executive committee go into a meeting and tell a story. We want them to tell us a story, not us."
- "Enterprise Manager should be a little bit less quirky when you build out-of-the-box customization reports for it."
What is our primary use case?
We actually have two industries we service. We service the transportation industry, as well as the healthcare industry. We typically do patient transports for emergency and non-emergencies. We do them by helicopter, that is our airmen division. We have a number of other businesses that we serve, like alarm system companies and the like, but primarily we use our analytics to look at patient transport counts and volumes, by the day, by the week, and by the month.
We also look at specific parishes (we call them battalions) to see how we can expand businesses out in Texas and Louisiana. We have a large market in Louisiana, Mississippi, and the surrounding areas. Therefore, we do a lot of proof of concept reporting as well, and we use the Enterprise Manager for other things as well.
How has it helped my organization?
We literally have some issues with the high-end users using the data and trusting the data. A lot of it gets dumped into certain areas, therefore we made a central repository for it. Then MicroStrategy reports off of that central repository, so we can validate the data relatively easily. Thus we can say, "Look, this is what we are seeing for Louisiana. This is what you guys have from the communication center. It matches one for one."
It builds a lot of rapport between the top end users and us. When I say that, I am referring to the "C" levels, the executive committee people, and other high end users.
MicroStrategy self-service is on the horizon. We have a couple of groups of people that we are trying to test out self-service with right now, specifically, our quality improvement group and our business development group. The problem for us is we do not want self-service to become this thing where there are reports everywhere and we can't manage it, so we are trying to develop some auditing processes to make sure that we are not throwing ourselves to the wolves. However, the plan is definitely to move towards self-service. We want the users to be able to be intelligent enough to make what they need and see what they want.
Dossiers are going to change the name of the game for us. We want to be able to have the executive committee go into a meeting and tell a story. We want them to tell us a story, not us. I do not want to go in as an IT guy and say, "Hey, this is the story." We really want the executive committee to be able to understand that this is a way of telling a story with data, because data without information is useless. If we can get them to that point, which I am confident that we can, then MicroStrategy will have done a great service to us, and rendered time back to us to go spend on other places.
That is really what we are shooting for. Dossier is a big thing for us. Geospatial analytics is huge for us. Anything that we can do with self-service is big for us. Those are the top three goals for 2018, in general.
What is most valuable?
The one thing that we have wanted to get more into, and we have touched a little bit of, is the Esri out-of-the-box: Esri mapping geospatial analytics. In fact, our presentation includes a piece of how we were able to leverage placing that airmen station in Texas for the first time, based upon transports from a geospatial map.
There also are a few others that we have taken advantage of recently. I think the chat feature inside of 10.10 is huge, especially if you are doing collaborative dashboarding.
We mostly do MicroStrategy, so we prefer the single platform for analytics capabilities. There are some use cases to do multi-platform. We just have not been at a point where we can overutilize it yet, or even utilize it at all. The cases for us that come up, they are so far and few between that we really have to take advantage of it and spend a lot of time on it, so that we can sell it. I imagine in the future that we probably will have multi-platform stuff.
We have some mobilize licenses right now. We have a small amount: 25. We built a couple of mobile apps. We have not jumped on the mobile bandwagon just yet. We have some use cases for it. We have not really identified where we can get the most bang for our buck. I imagine 2018 might have some of that as well, as a minor goal, possibly 2019. This being a huge issue for us, our getting into it, because a lot of our trucks, our medics, our people who drive on our trucks, and do the transfers, they all have iPads. If there is something that we can give them which says, "Hey, avoid traffic here," or do something to make a decision, that could be huge. Use cases are always a challenge.
What needs improvement?
If I had no issues with the tool ever or if I did not have any problems when I upgraded, then I would probably give it a higher rating (a perfect 10). If the Enterprise Manager was a little bit less quirky when you build out-of-the-box customization reports for it, I probably would give it a 10, but just those small things bring it down a little bit for me. However, it is a good tool.
Let us say that you have someone who comes in who does not have a strong programming background and they want to use Enterprise Manager to do some things. It is sort of the way the warehouse is set up, they might need the statistics warehouse when they first get in and they could be very turned off by the UI. Just the way some of the reports tailor themselves out-of-the-box, it does not really lend itself to be helpful.
Then you have to customize, and when you start customizing, you bring in these attributes that sometimes do not even fit together. You may want to see something and how it gets done, then you are kind of stuck. That can make you leave the tool alone completely. Luckily for us, we have found ways to work with our consultant, and just really try to tackle it as much as possible. We have found ways to get around it.
What do I think about the stability of the solution?
I actually enjoy MicroStrategy a lot. When it came to Arcadia Data, it was sort of dead in the water, a Lazarus project. It kind of came up from the dead. Mostly because people did not understand the tool. My grandfather always had a saying that you got to know the tool before you can use the tool. That is what we did. My colleague and I took MicroStrategy, and said, "What does it do, what is it?"
We just started building simple reports from scratch and went from there. Now, that we understand it, people are like, "Oh, okay. I get it. It's not that bad, it's actually great."
I am a fan of MicroStrategy and other tools, but I think MicroStrategy is a great tool. It does really well for what it serves.
How is customer service and technical support?
We like the tech support. They have done a number of things to help us out. They have sent us to rapid response before, when we really needed them. They have gotten back to us as early as a day, maybe half day, and even within an hour.
We have had positive experiences with them. There are areas that I can specify that they can improve in, but I think that is with any help desk or technical support.
How was the initial setup?
I was not involved in the initial setup.
I came in three years after its inception, and it was in the Lazarus stage. They were not going to spend any more money, get rid of the tool, phase out of it, and since then we have brought the tool back:
- We have bought 100 new licenses.
- We have ramped up user adoption.
- We have run on trips to do symposiums.
- We have found that it is starting to fit together.
What other advice do I have?
Do not walk away without taking the time to get to know the product or the people intimately. If you are trying to do analytics, it is a fantastic product, a top-tier product. We have dealt with a number of other products. I worked with folks who have dealt with Tableau and others. Especially with what they are doing with Dossier and all the things that are coming out, MicroStrategy has really started to lead the way with analytics in the future. I would court MicroStrategy and spend some time with them. Get to see what the tool does and what can it do for you. Do some proofs of concept.
Most important criteria when selecting a vendor: We try to court them as much as possible. We want them to come and see how we do things in Louisiana. We are very much a down to earth folk. I will say that. People mention the Cajuns. We are kind of rambunctious, too. We got to get to know the person that is selling the product before we even get to know the product, then we look at the product, and say, "What does it do? What can it do for us?"
We do a lot of proofs of concept. We are doing telemetry in our trucks, ambulances, and vans, possibly. What we found is the MicroStrategy reps travel a great distance to see us, and we appreciate that. We need to see them face-to-face. If there is a quote, it is amazing what you find face-to-face. That is huge for us. We have to have that.
MicroStrategy is just readily available for us.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
IT Consultant at a healthcare company with 1,001-5,000 employees
We prefer having analytic capabilities in a single platform, because it is easier
Pros and Cons
- "We prefer having the analytic capabilities in a single platform, like MicroStrategy provides, because it is easier. The customer gets used to one type of tool, then sticks with it."
- "We have been using it mostly for grid reports and its exporting features."
- "We have not invested nor are we planning to invest in MicroStrategy's mobile platform."
What is our primary use case?
We use it mostly for the operational reporting. We also use it for the insurance claims and how to track them.
The product is working fine. We feel they understand the healthcare system.
How has it helped my organization?
The features of the product have definitely been beneficial. We do plan to roll out MicroStrategy Self-Service to our business teams.
We prefer having the analytic capabilities in a single platform, like MicroStrategy provides, because it is easier. The customer gets to use one type of tool, then sticks with it. The customers are looking for Geospatial in 2018, so that is where we will be using it.
What is most valuable?
We have been using it mostly for grid reports and its exporting features. We are going to start using the Geospatial, which is a new feature. We are also looking forward to the 10.9 and 10.10 features coming out.
What needs improvement?
We have not invested nor are we planning to invest in MicroStrategy's mobile platform.
What do I think about the stability of the solution?
It is a very stable solution, meaning the application is very good. MicroStrategy works very well.
What do I think about the scalability of the solution?
It is highly scalable. We have quite a few customers who are the users themselves. They use it and have not had any issues yet.
How is customer service and technical support?
I sometimes use technical support. When I do, I have found them to be helpful. The right person answers me when I contact them.
How was the initial setup?
I was not involved in the initial setup.
However, I have been involved in upgrades of the solution, which were mostly straightforward.
What about the implementation team?
The vendor technical support assisted in the upgrades.
What other advice do I have?
This is definitely a solution worth investing in. It will be useful for the long term. Anyone who is researching similar solutions should look for the longer term.
Most important criteria when selecting a vendor:
- The technical capability.
- They are able to deliver it.
- They understand the product.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Microstrategy Project Manager & Microstrategy Lead Architect at a healthcare company with 1,001-5,000 employees
It has server distribution to publish the dashboards and reports in different formats.
What is most valuable?
It is one of the best BI reporting tools as per Gartner. It is a complete reporting bundle, which includes reports/dashboards/document creation along with Cube.
It also comes with self-service analysis that helps the user carry out short analysis within the corporate level. It has a good administrator tool to handle the administrative part. It has server distribution to publish the dashboards and reports from the end user in different formats as well.
It includes lots of other features that help to take the reporting to the next level; for example, R Integration that supports more than 70 databases.
It has strong metadata in the architecture, which makes a huge difference with the other tools in the market.
How has it helped my organization?
It's a DSS tool. Thus, for analysis in an analytics-oriented company, it has made a huge difference in their decisions.
What needs improvement?
This product needs to be ready to use at the enterprise level . As the market is growing and changing very fast, sometimes the development team does not have sufficient time to incorporate requirements within the given time frame. Thus, some solutions should be ready to use, i.e., the plug and play functionality for solutions at the enterprise level.
For how long have I used the solution?
I have used this solution for more than 10 years.
What do I think about the stability of the solution?
Not many issues were encountered in terms of stability; there were only a few defects which were resolved in later releases.
What do I think about the scalability of the solution?
There were no scalability issues.
How are customer service and technical support?
I would give the technical support a 8 out of 10 rating.
Which solution did I use previously and why did I switch?
Previously, I have used different solutions. However, I have found MicroStrategy better than any other tool.
How was the initial setup?
A few configurations are needed as per requirement.
What's my experience with pricing, setup cost, and licensing?
The pricing policy is good compared to other products in the market. It's a license-based software.
Which other solutions did I evaluate?
We did not evaluate other options. As we know, it's the best solution.
Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
BI Manager at a government with 1,001-5,000 employees
Dashboards can be built in a relatively simple manner.
What is most valuable?
We value the ability to build dashboards and reports in a relatively simple way. We can teach end users how to do their own reports and dashboards making the process cheaper and faster.
Also, the ability to import data from a grand variety of sources and combine them into a single report/dashboard, skipping the expensive ETL process or validating it before a robust construction.
How has it helped my organization?
MicroStrategy makes it easier to control internal and external demands and also to monitor public programs financed by the institution.
What needs improvement?
Data discovery and self-service BI still needs to be simpler to end-users.
For how long have I used the solution?
I have used MicroStrategy since 2012; four years.
What do I think about the stability of the solution?
We have not had stability issues.
What do I think about the scalability of the solution?
We have not yet had scalability issues.
How are customer service and technical support?
I rate technical support a 4.5/5.
Which solution did I use previously and why did I switch?
We did not have a previous solution.
How was the initial setup?
Initial setup was complex. MicroStrategy is a hard tool to configure in many ways, starting from its licensing schema.
What's my experience with pricing, setup cost, and licensing?
Make a good study of your needs because its very expensive to change from nominal licensing to a server core licensing.
Which other solutions did I evaluate?
The buying decision was made by a previous team. But other solutions are always evaluated, like Tableau and ClickView.
What other advice do I have?
Make sure there isn’t a cheaper solution that satisfies your demands. Prepare a good team to develop and use it or you’ll have a big mess and difficulties making data discovery and self-service BI.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Application Developer at a healthcare company with 1,001-5,000 employees
It has provided the ability for end users to self-service on ad-hoc reports.
What is most valuable?
The ability to create VI’s which are easy for front end users to manipulate in order to see the data they wish to see.
Visual Insight allows the developer to create reports and/or cubes as the foundation and the end user can easily pull any of the metrics and attributes into the report, graph or other visualization without requiring technical reporting knowledge. This really gives the end user the ability to manipulate the data as they see fit. They can see as little or as much detail as the report/cube allows.
How has it helped my organization?
The ability for end users to self-service on ad-hoc reports.
What needs improvement?
Instead of using a lot of table joins within MSTR, we have had to rely on ETL for those same reports and then expose that view/report in MSTR. A couple of reasons for this are slowness when running the report inside MSTR and difficulty in setting up left joins when using multiple tables.
For how long have I used the solution?
We have been using the solution for about three years.
What do I think about the stability of the solution?
We have not encountered any stability issues. Only a few outages that have always been resolved quickly.
What do I think about the scalability of the solution?
Scalability issues have been the most significant which we have faced.
How are customer service and technical support?
This is not an area I have to deal with much but from what I have heard it seems to be good.
Which solution did I use previously and why did I switch?
We previously used SSRS. We still use this sometimes but have been working to transition to MSTR. MSTR gives the end users more flexibility when looking at reports.
How was the initial setup?
The setup was complex. Our warehouse was completely rewritten in order to fit the MSTR model.
What's my experience with pricing, setup cost, and licensing?
We have no specific comments regarding this issue.
Which other solutions did I evaluate?
We evaluated others but I was not part of that decision making so am unaware of other options being looked at.
What other advice do I have?
Find other companies who are willing to share their experience and the lessons learned when setting up their environments.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Principal Architect at a tech consulting company with 501-1,000 employees
Provides enterprise reporting, mobile access, and customizable dashboards. The development environment could be simplified.
What is most valuable?
- Enterprise reporting
- Mobile
- Distribution
- Dashboards
Most of our customers for whom I implemented the solutions were interested to see the level of detail. However, due to a couple of weaknesses we get from this tool, this was a bit painful.
How has it helped my organization?
We do consulting and Implementation of solutions to many industries like retail, distribution, manufacturing, oil & gas, wholesale, etc. Most of the solutions require the end reporting to be apt and simplified in nature. MicroStrategy’s built-in solutions help a very reasonable amount of customers. As they require customization, developers are required to use the desktop client. That is not simple.
What needs improvement?
Simplify the development environment and improve the visualizations.
For how long have I used the solution?
I have been using MicroStrategy for one year and three months.
What do I think about the stability of the solution?
We have not had stability problems.
What do I think about the scalability of the solution?
We have not had scalability problems.
How are customer service and technical support?
I rate technical support 2.5/5.
Which solution did I use previously and why did I switch?
We did not have any previous solution.
How was the initial setup?
Setup was pretty much straightforward.
What's my experience with pricing, setup cost, and licensing?
Licensing is completely dependent on the number of architects and developers the organization requires. The pricing is reasonable when compared with other industry leading tools.
Which other solutions did I evaluate?
We evaluated Oracle BI, Microsoft BI, Tableau and Cognos.
What other advice do I have?
I recommend that they evaluate the in-built dashboards, test them with sample data and see how dashboards best fit your needs. As the development or customization of this tool is a crutch, people do not prefer to get into this technology.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free MicroStrategy Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Popular Comparisons
Microsoft Power BI
Tableau
Amazon QuickSight
Teradata
IBM Cognos
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Oracle Analytics Cloud
TIBCO Spotfire
ThoughtSpot
Sisense
Workday Prism Analytics
Pentaho Business Analytics
AtScale Adaptive Analytics (A3)
Buyer's Guide
Download our free MicroStrategy Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- How much does Microstrategy cost per CPU core?
- When evaluating Business Intelligence Tools, what aspect do you think is the most important to look for?
- BI Tool Replacements, What Do You Recommend?
- Which one is best for ETL - Pentaho or Jaspersoft?
- Seeking advise on going with Birst, BOARD or Pentaho as an OEM platform solution where we could end up with 1,000's of users over time.
- BI Tool Evaluation Criteria Rating Matrix -- anyone have one they've used in making a tool selection?
- QlikView or Tableau - Which is better?
- BI tools for tactical decision-making?
- What is a good BI tool in the Oracle world?
- I currently use Panorama Necto as a viewer on SQL Analysis services cube--what other solutions are out there?
Ramon, which features in MTSR's BI apps have you find most valuable/useful?