it_user807330 - PeerSpot reviewer
Staff Software Engineer at a financial services firm with 10,001+ employees
Real User
Most suited to the enterprise-wide BI platform because of its scalability and stability. They need to improve on distribution services.
Pros and Cons
  • "​Visual Insight gives you the capability of doing self-service analytics. This has been the most powerful and valuable feature.​"
  • "Dependency on development teams, as well as managing the platform, has reduced a lot with Visual Insight.​"
  • "I find MicroStrategy the most suited to the enterprise-wide BI platform, because of its scalability and stability.​"
  • "They need to improve on distribution services. There are lack of features which were there earlier with Narrowcast, but they are not there in the distribution services."
  • "They need to improve on having more professional, well-equipped premium support.​"

What is our primary use case?

We use it primarily for reporting. Most of the reports are grid reports. We do slice and dice, and use pivot tables on the reports. The data goes up to the level of CEO. Basically, we use it for basic grid level reporting.

How has it helped my organization?

It has helped our modern developers. It has helped the business users to design their own reports. They know exactly what the need, so the power is now in their hands. They do self-service and develop their reports. Dependency on development teams, as well as managing the platform, has reduced a lot with Visual Insight.

What is most valuable?

Visual Insight gives you the capability of doing self-service analytics. This has been the most powerful and valuable feature.

We have rolled out Self-Service, and the rollout has been smooth so far. Customers are happy. When I say customers, the consumers of the report. 

Maintenance and manageability becomes easier with a single platform. You do not have a complex environment for four or five different vendors to serve different purposes.

We are developing a mobile platform. Until now, I have not worked on it. There are plans in development of introducing a mobile BI with MicroStrategy.

In 2018, we plan on significantly using the Dossier feature. It comes with MicroStrategy 10.9. We have set up a platform in that version, and we are exploring the Dossier option.

What needs improvement?

I would like to see some enhancements in distribution services and the way reports are delivered currently. It is mostly static reports. We want to be able to do dynamic subscriptions and all that stuff in distribution services.

They need to improve on distribution services. There are lack of features which were there earlier with Narrowcast, but they are not there in the distribution services. Then, they need to improve on having more professional, well-equipped premium support.

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

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

It is stable. I have worked on three different BI tools. I find MicroStrategy the most suited to the enterprise-wide BI platform, because of its scalability and stability.

What do I think about the scalability of the solution?

It is scalable.

How are customer service and support?

I would give them eight, eight out of 10. Sometimes there is a delay, because I am based out of Asia Pacific region. The support is usually done during the US business hours. There is a delay and it is difficult. 

If I am facing an issue today, then I have to wait for the US folks to come on and look at my problem and provide a solution, which I may see tomorrow. There is a one day delay. This goes on for different cases that I open. We are planning to take the Asia Pacific support license as well. We will see how it goes.

How was the initial setup?

No, I recently joined my company.

What other advice do I have?

I would suggest to explore MicroStrategy. It is a good tool. I have been working on it for seven years now. 

I would definitely recommend my friend or a colleague to use it, and implement it in their company.

Most important criteria when selecting a vendor:

  1. Security.
  2. Stability.
  3. Scalability.
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.
PeerSpot user
PeerSpot user
Senior BI Consultant at a tech services company with 501-1,000 employees
Consultant
Even non-IT personnel can create reports. I would like to see web and desktop functionality be reconciled.
Pros and Cons
  • "The drill-down functionality is also very good."
  • "The graphs available for the new dashboard of version 10 are weak."

What is most valuable?

It is very easy for non-IT personnel to create (grid) reports. And once the report is created, the user can switch rows, columns, and add filters. This avoids the creation of a lot of reports that have just a different look.

The drill-down functionality is also very good.

How has it helped my organization?

It did not really change the way the organization works. But it has improved our budgeting process. It also gives us a better overview of our warehouse management.

What needs improvement?

It has two versions: web and desktop. Some changes can be done with the web tools and some can be done with the desktop tool. Reconciling the two tools to make all functionality available in all tools would be a great improvement.

The graphs available for the new dashboard of version 10 are weak. You can include all the 3D graphs that you find, but you have to find them and include them or develop them yourself. By default, you should have at least the same possibilities for the graph so that you can add in a document. For the moment, I still use the document because I did not find a line graph that can use multiple metrics and multiple categories.

For how long have I used the solution?

I have personally used it for three years now. The company I am working for has used it for four years.

What do I think about the stability of the solution?

We have not had stability issues, but we are a small group and we do not use the mobile functionalities.

What do I think about the scalability of the solution?

We have not had scalability issues, but we are a small group.

How are customer service and technical support?

I find technical support very responsive. If they do not know the answer, they search for it until they find a solution that solves your problem. The community site has also a lot of information.

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

I am an external consultant and I know the Microsoft BI suite. I also worked a bit with QlikView. The company that uses MicroStrategy had no other tools before it.

How was the initial setup?

I was not there at the initial setup. I found it easy to add some new attributes, facts, and metrics.

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

I am not in charge of licensing. They made a change in the licensing module some time ago and we can now use all the enterprise tools for free. This was a big improvement. We are using a name license. The advantage is that these licenses can be used on all environments.

Which other solutions did I evaluate?

I was not there for the initial choice. But I know they had a PoC on SAP BusinessObjects and Microsoft BI.

What other advice do I have?

If you use MicroStrategy on top of a data warehouse, put all the code translation in a snowflake schema. The reason is that often the last pass of the process translates the code into labels and it is easier if these labels are in separate tables.

Install the enterprise manager tools and projects at the beginning. You can create a lot of objects and you need to know which one is used. This tool is not perfect, but it will give you an overview of the utilization of MicroStrategy.

As an IT person, you have to create the model: define the attributes and the metrics. Once you have done that, if a user wants to create a grid report he must drag attributes and metrics and drop them in the grid area.

This user has to know the business a bit because he must combine attributes and metrics that make sense.

Another way of working is to create a big grid report with multiple attributes and metrics. A user can easily remove the attributes and metrics that he does not need and remove them from the grid. He then can save the report is his "my report" folder if he use it often.

For example, as retail company, we created a "big" grid report with sales and stock by articles, shop, sales persons, year and month. The sales period is part of the filter. If a user want the sales per shop and years, he just has to remove from the grid the attributes and metrics that he does not need. Same thing if he wants sales per users. For us, it simplifies our life because one report replaced eight existing reports in our system.

Now, the the reports are made by someone from the business that asks sometimes (but not often) for IT support.

If you only want simple grid reports, almost anyone can make them. If you want advanced reports (dashboard, pixel perfect documents) the user must follow a training.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MicroStrategy
May 2024
Learn what your peers think about MicroStrategy. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
772,649 professionals have used our research since 2012.
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
it_user516102 - PeerSpot reviewer
Manager - BI and Analytics with 501-1,000 employees
Vendor
It is easy to develop dashboards for both web and mobile. They are not improving the prompt interface.

Valuable Features:

  • Rapid development: Once you have data, it is pretty fast to develop dashboards that are available in both web and mobile environments. It is quite easy to develop in days.
  • Enterprise readiness

Improvements to My Organization:

  • Management's ability to slice and dice data quickly with ease

Room for Improvement:

Any product/feature request takes years to get, if at all. This really pulls the rating down overall.

For example, the MSTR prompt interface sucks, where users can enter details to get data. However, they do not seem to be too worried about modifying it. Selector preferences cannot be stored per user. Prompts can be saved per user but that interface sucks.

Also, multiple currencies are handled poorly even after introducing two or more datasets in a document.

Use of Solution:

I have used it for more than two years.

Stability Issues:

I have not encountered any stability issues. We have four servers with DR capability.

Scalability Issues:

I have not encountered any scalability issues.

Implementation Team:

We got MSTR Services to set it up.

Cost and Licensing Advice:

With V10, they made life easier for licensing; bargain and do not take the quote as serious.

Other Solutions Considered:

Before choosing this product, I evaluated MicroStrategy, Cognos 8/9, Tableau’s very early versions and QlikView.

Other Advice:

It is good enterprise-level software. Consider Tableau and Qlik before making your decision. Evaluate your user readiness. For example, to use Tableau, the users should be more on the power users side. MicroStrategy is better if management is not tech savvy.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user512919 - PeerSpot reviewer
Microstrategy Developer at a financial services firm with 1,001-5,000 employees
Real User
Customization options are available at the coding and visual levels.

What is most valuable?

  • Business users can create their reports once architected
  • Available on all devices
  • Customization options available at coding and visual levels

How has it helped my organization?

Enterprise-wise solutioning helps us to troubleshoot more effectively.

What needs improvement?

Creating a dashboard is a very tedious and manual process.

For how long have I used the solution?

I have used it for six years.

What do I think about the stability of the solution?

I have not encountered any stability issues; it is very stable.

What do I think about the scalability of the solution?

I have not encountered any scalability issues.

How are customer service and technical support?

Technical support is 6/10.

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

I did not previously use a different solution.

How was the initial setup?

Initial setup was straightforward.

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

It is somewhat expensive.

Which other solutions did I evaluate?

Before choosing this product, we evaluated SAP BusinessObjects and IBM Cognos.

What other advice do I have?

Depending on the data volume, choosing the most suitable database will be key. Setting up the MicroStrategysystem for optimum performance will drive how helpful the output will be.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user125418 - PeerSpot reviewer
Owner/Principal at a tech services company with 51-200 employees
Consultant
Data access could be improved but I find the totality of the product to be the best in the business

What is most valuable?

The ability of the end user to be able to design and modify their own solutions, as well as the ROLAP architecture that provides almost unlimited scalability.

How has it helped my organization?

With MicroStrategy's focus on end user empowerment, a business analyst can make any modifications needed to follow wherever their analytical thought process leads them. With a multi-dimensional cube solution (Cognos, for example), if the analyst falls into the "white space" between cubes he/she needs to stop and request a new cube from the IT shop, interrupting the analytical thought process, possibly for a significant amount of time.

What needs improvement?

Data access could be improved. MicroStrategy has a data import capability but it only works for data in a Excel spreadsheet or a CSV file. It would be helpful if one could point the data importer at a web site, or provide it a URL of a data source and have it import the data.

For how long have I used the solution?

I have followed MSTR's development for nearly 20 years and find the totality of the product to be the best in the business because of scalability, single metadata, SQL generator, and end user usability. I organized a review of 6 then-current BI applications in 1996, including MicroStrategy, Holos, Information Advantage, Essbase, Oracle Express, and Cognos. Only MicroStrategy, OBII (formerly Oracle Express) and Cognos are still standing.

What was my experience with deployment of the solution?

Not on my personal WIndows 7 Pro 64-bit machine. I've never deployed the Server product.

What do I think about the stability of the solution?

Not on my personal WIndows 7 Pro 64-bit machine.

What do I think about the scalability of the solution?

Not on my personal WIndows 7 Pro 64-bit machine.

How are customer service and technical support?

Customer Service: Unknown.Technical Support: Unknown.

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

One customer was using Cognos and I advised them that they may want to consider switching to MicroStrategy for the reasons I stated above.

How was the initial setup?

On my personal Windows 7 Pro 64-bit machine. I don't know how different it might be on an enterprise server, although an acquaintance who has deployed it says that there are no issues.

Which other solutions did I evaluate?

I've also looked at Tibco Spotfire and Pentaho, and read reviews and evaluations of Tableau. All of these are seductive, but their solutions ignore the challenges of dealing with masses of data. MicroStrategy's single metadata also makes it possible to track every object and action in the system, and to autogenerate documentation.

What other advice do I have?

Look at the complete package, considering TCO, administrative ease and end user usability/empowerment.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user114918 - PeerSpot reviewer
it_user114918Professional Services Manager at a tech consulting company with 501-1,000 employees
Consultant

Hi Keith,
I am not sure what version you are working with, but MSTR 9.4.1 can import data from files (CSV, Excel and Text) located on your computer or anywhere (using URL). It can import data from databases, Salesforce, and Freeform (scrits made by DB professionals) too.
Cheers.

it_user3900 - PeerSpot reviewer
Manager of Development at a tech services company with 1,001-5,000 employees
Consultant
Even if the costs are high, the benefits are huge.

I would agree with the fact that MicroStrategy brings along with it increased costs but would clearly like to quote that it brings along it with it huge benefits that probably other reporting tools dont offer. The tools architecture has been framed in such a way that the design and development are easy thus reducing the maintenance efforts.

Companies do think twice before implementing MicroStrategy because of the costs involved. Not only its about the implementation but also technical support which is around $10,000 per year. Also when there is a project coming in any company analyses if its possible to achieve it with other reporting tools with lesser implementation, administration, support and maintenance costs but they do not analyse if in the long run any other additional features would be required which would be beneficial for the users. After a year of implementation when the users come in with new requests then they start to understand that their current tool does not offer the required and start to evaluate other tools and plan to migrate it. I think this might not be the case if their COE team had done an extensive analysis initially on the capabilities of the tool. This tool bring along with it some special capabilities like mobile, social and cloud.

MicroStrategy has established itself in all industries like communication and media, education, energy and utilities, financial services, food and beverage, health care and life sciences, manufacturing, retail and travel. Today, 14 of the top 20 global financial institutions rely on solutions powered by MicroStrategy. It has also showcased a number of successful Mobile BI Implementations. One is Whole Foods Market. This purveyor of natural and organic foods has over 300 stores and annual revenues of over $10 billion. The grocer is part way through a project to put mobile analytics into the hands of every store team leader using smartphones. Store team leaders have access to dozens of key performance indicators about their store. Given the limited screen size of a phone, whole foods decided not to implement charts. Instead, tabular data is shown, with a simple traffic light system used to highlight good, mediocre, and poor performance. Each store team leader can configure their own version of the app to show the performance of a few other stores alongside their own. So store managers often pick the closest store to them geographically, or a store of similar size, or leading stores in other regions.

With Cloud Personal, any analytics can be shared with other people through mail. MicroStrategy has recently unveiled an interesting demonstrator of the power that can be gained from harvesting social data.With Wisdom, users can understand the demographic profile of people who like specific entities – be they people, places or products. For example, it’s easy to discern the demographic profile of people who like a certain politician, a particular brand of beer, or a TV show.

Users can experience and enjoy MicroStrategy products – primarily Visual Insight – in minutes with no risk or investment. The visualizations and dashboards created can also be viewed using MicroStrategy’s native mobile BI applications for iOS devices.

Thus even if the costs are high the benefits are huge.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1068 - PeerSpot reviewer
it_user1068Tech Support Staff at a tech company with 51-200 employees
Vendor

When benefits are great, costs barely count.

See all 2 comments
it_user6330 - PeerSpot reviewer
Product Manager at a retailer with 10,001+ employees
Vendor
MicroStrategy vs. Tableau

After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications.

Tableau has found its sweet-spot as an agile discovery tool that analysts use to create and share insights. It is also the tool of choice for rapid prototyping of dashboards.

  • Tableau is very flexible with its data import. Tableau's data blending capability is very intuitive. This capability is useful when you have data spread across several different sources that has not gone through ETL processes. This is a problem analysts deal with routinely. They are unable to wait for the data warehouse team to develop ETL processes to provide the physical models they need to build an analysis.
  • The Tableau interface is Excel-like and has a low barrier to entry for analysts that are used to working in Excel.
  • Building a dashboard by mashing up visualizations in a Tableau worksheet is extremely simple. Users are able to build good presentation-quality dashboards in a very short amount time.
  • Tableau's annotations capabilities and its time and geographical intelligence are key differentiators.
  • Tableau has overcome limitations in data sharing with the introduction of a Data Server in Tableau 7.0. The Data server allows Data sources and extracts to be shared securely and opens up interesting new possibilities.

If your application can take advantage of the above characteristics, consider Tableau.

Visual insights (VI) is MicroStrategy's data discovery tool. VI has many differentiating features which make it attractive:

  • VI is free if you already license Report Services.
  • VI supports visualization and dashboard creation over the Web.
  • Your existing MicroStrategy reports may have content that can be used as datasets for visual exploration. Converting a report to an analysis is a one click action.
  • Within a MicroStrategy project, applications can be built relating multiple visual insights analyses. A visual insights analysis may also support ad-hoc drilling workflows that access the data warehouse.
  • VI is Flash based and it is possible to export analyses and view them offline.
  • VI is built on top of a shared infrastructure and is fully integrated with distribution services, olap services, report services and other key features of the MicroStrategy platform such as its security and administration features.

Consider VI for the following applications:

  • As an exploration interface for existing MicroStrategy reports.
  • As a Web-based tool for providing self-service visualization creation capabilities to business users. Provide a layer of certified OLAP services cubes and report builders that are created by a developer community as a backbone for building these visualizations.
  • For applications that need scheduled delivery to email/file/print.
  • For applications that have complex security requirements.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user5331 - PeerSpot reviewer
it_user5331Business Intelligence Engineer at a leisure / travel company with 10,001+ employees
Real User

Hi Parag, "good" and "minimal cost" only means excel unfortunately.
Tools like Tableau may seem just $1000 away but cost escalate when rolled out to all employee in company with proper support.

See all 13 comments
Buyer's Guide
Download our free MicroStrategy Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2024
Buyer's Guide
Download our free MicroStrategy Report and get advice and tips from experienced pros sharing their opinions.