MicroStrategy Analytics

MicroStrategy Analytics

MicroStrategy Analytics



Strong and Easy Reporting

We are using for all data reporting. My some financial data reporting in MicroStrategy Analytics. For department financial budget officer …
Read full review

Popular Features

View all 29 features

Formatting capabilities (25)


Customizable dashboards (24)


Pixel Perfect reports (24)


Report Formatting Templates (25)


Reviewer Pros & Cons

View all pros & cons


View all pricing

What is MicroStrategy Analytics?

MicroStrategy Analytics is an enterprise business analytics and mobility platform. Key features include automatic big data analysis and reporting, data discovery and visualization, digital security credentials, and support for mobile devices.

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.microstrategy.com/en/go/pro…


  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

Alternatives Pricing

What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

What is IBM Cognos Analytics with Watson?

IBM Cognos is a full-featured business intelligence suite by IBM, designed for larger deployments. It comprises Query Studio, Reporting Studio, Analysis Studio and Event Studio, and Cognos Administration along with tools for Microsoft Office integration, full-text search, and dashboards.

Features Scorecard

BI Standard Reporting


Ad-hoc Reporting


Report Output and Scheduling


Data Discovery and Visualization


Access Control and Security


Mobile Capabilities


Application Program Interfaces (APIs) / Embedding


Product Details

What is MicroStrategy Analytics?

The MicroStrategy platform differs somewhat from competing platforms in that it does not include a data warehouse.

The platform integrates with a wide range of third-party data warehouses however. MicroStrategy also built a free discovery/visualization tool called MicroStrategy Analytics Desktop, which is not completely integrated with the rest of the platform. MicroStrategy has strong mobile and cloud capabilities which are differentiators for the platform. MicroStrategy's cloud offerings are unique in that they host the software in their own data centers and allow customers to keep their data on-premise to alleviate security concerns. Analytics is a platform for Business Intelligence (BI) and self-service analytics. It enables organizations worldwide to analyze the vast amounts of data stored across their enterprises to make better business decisions.

MicroStrategy currently has 3 versions:

  • MicroStrategy Analytics Enterprise: Enterprise-grade business intelligence
  • MicroStrategy Analytics Desktop: Free self-service visual analytics
  • MicroStrategy Analytics Express: Free cloud-based self-service visual analytics

MicroStrategy Analytics Competitors

MicroStrategy Analytics Technical Details

Deployment TypesOn-premise, SaaS
Operating SystemsWindows, Mac
Mobile ApplicationNo


View all alternatives

Frequently Asked Questions

What is MicroStrategy Analytics?

MicroStrategy Analytics is an enterprise business analytics and mobility platform. Key features include automatic big data analysis and reporting, data discovery and visualization, digital security credentials, and support for mobile devices.

What is MicroStrategy Analytics's best feature?

Reviewers rate Predictive Analytics highest, with a score of 9.1.

Who uses MicroStrategy Analytics?

The most common users of MicroStrategy Analytics are from Enterprises and the Unknown industry.


(1-25 of 257)
Companies can't remove reviews or game the system. Here's why
November 01, 2021

Strong and Easy Reporting

Score 6 out of 10
Vetted Review
Verified User
Review Source
We are using for all data reporting. My some financial data reporting in MicroStrategy Analytics. For department financial budget officer can see their budget values.
  • Visualization
  • Speed of access to reports
  • Easy report implementation
  • Visual diversity
  • New graphic interfaces
  • Some mathematical functions
Some big data reports, some financial functionality.
Jeff Harris | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
Review Source
We made the decision to centralize all of our reporting from all of our systems into Microstrategy Analytics. Moved off of multiple older systems which included Microsoft BI, Alteryx, and some product specific reporting.
  • They sell the product well, and make promises you will actually believe
  • "checks the box" for most features a company would need. Doesn't actually deliver them though
  • They answer the phone in a timely manner. Can't answer your questions or provide support, but the queue time isn't bad
  • They have online documentation. It's not up to date, and likely doesn't reflect the version of software you are using, but hey... they can point to it.
  • [I feel like] compared to it's peers, this product is not ready for primetime. Has almost no capabilities "out of the box" good luck finding ANY canned reporting capabilities
  • Almost non-existent ecosystem for finding trained help. Relative to the 'big guys" there are not consultants or candidates you can find on the open market to actually help you implement
  • [I feel like they should] stop answering feature limitations by saying "go to the cloud product". If we wanted a SaaS solution, [there] are MUCH better ones than MicroStrategy Analytics. Your primary value proposition is it can be installed locally. I didn't realize that meant we would be limited in functionality to the dark ages.
If you need an on-premise solution in your own data center, [I feel like] the options are starting to become limited, and MicroStrategy Analytics is one of them. Just don't expect it to be good, or supported.
[I feel as if] they answer the phone quickly, but can't answer any of your questions. Will get lost in a support ticketing system. Better off finding third-party online forums of MicroStrategy Analytics users huddled together trying to help each other do the most basic things.
Mark McCully | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
MicroStrategy Analytics is used by our finance and corporate executives to look at our company's financials from an analytical perspective. All of our sales information is aggregated into data sets that MicroStrategy can drill into for relatively up-to-date financial information. It is used for revenue and purchasing trending and other key business driver analysis.
  • Centralized dashboards.
  • Real-time data analytics.
  • Highly customizable, but easy to use out of the box.
  • Administration of the platform is time consuming.
  • Licensing cost is on the expensive side.
  • Incompatibilities between versions.
MicroStrategy Analytics is a very useful tool for a company of any size to get the most use out of their data that could be anything from financials to supply chain and ERP. It handles very large to smaller data sets with ease and speed.
MicroStrategy's support is very good. We don't have a lot of technical issues in the first place, but when we do have to open a case with them, their front-line engineers seem very capable and resolve most of the issues without escalation. Our sales team is also very good and keeps us in the loop on new features and makes sure we are satisfied customers.
Dharmesh Shah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
MicroStrategy is being implemented for our customers. I'm doing consulting assignment to plan design, architecture, blue prints and best practices to be followed
  • Strong semantic layer to define all the business rules and tightly coupled
  • MicroStrategy Analytics cubes are easy to create and deploy
  • MicroStrategy Analytics cubes performance is best in the industry from performance point of view
  • Slice and dice features are awesome
  • You can define hierarchy, drill up and drill down within data set
  • SDK for Customizing Analytical Applications means you can leverage metadata
  • Embedding Analytics with MicroStrategy REST API
  • Data Mining and Predictive Analytics
  • MicroStrategy Analytics desktop support waterfall model
  • Modern BI tools prefer agile methodologies
  • Correlating unstructured data sets gets challenging
We are delivering MicroStrategy Solutions since 2007. MicroStrategy Analytics is the enterprise reporting tool.
[We are a] MicroStrategy Global Consulting Partner, dedicated CoE for MicroStrategy and project Implementation across multiple domains.
Periscope: Retail Analytics Solution
Geolytik: Our framework for Geo Spatial Analytics
Galileo Machines: A ready to deploy dashboard
Lendics: Security Lending Analytics

Galileo Machines – Advance Analytics Solution for Manufacturing benefits
-Enhanced operational efficiency
-Precise machine failures predictions
-Faster ROI through reduced implementation cycle
-Improved quality of yield and throughput
-Increased profitability of the plan
-Reduced equipment downtime
-Reduced production cost
-Long-term strategic management of production assets

Good user community. Support team is available if you are under AMC. You get decent support after raising the support ticket. If it is product bug they will inform you and let you know which patch will resolve the same.
  • Online training
Yes, upgrade was seamless. You need the right skills for the same.
Rishi Bavishi, CSSGB, CAPM | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microstrategy Analytics is widely used in the company across all departments. Different level of access can be provided to different level of responsible persons. It is a very easy tool to get access of past data with different reports and presenting it with the help of variety of dashboard and VIs. Data collection and analysis is an essential function of it.
  • Data collection/data access- The tool uses different attributes and metrics to generate data for you in a required format with required filters.
  • Data Visualization- The tool has great function of creating Dashboards which are specially useful for higher management to review it.
  • Data Analytics- With great amount of functions, it does most of the excel work within itself. Eliminates excel in most of the fronts.
  • Better user interface- The only thing that comes out is there is a high scope of modifying user interface. Currently it is not as good as Tableau in terms of user interface.
Well suited for: Creating Dashboards- This can handle high amount of data that too good amount of data manipulation flexibility. Dashboards can be modified pretty quickly and addition of data is also easy. Mirroring same dashboards is also easy where new view can be created and can be saved. There are lot of other benefits as well in terms of accessing data easily.
Gonzalo Segarra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are trying to use it across all the organization as the only tool where you can find all the data of the company, making all kind of dashboards for managers and final users. We've also made "live" dashboard showing the status of the company.
The major problem is to make end users move from Excel to MS. The company leaves all this effort to the IT Team and does not make this a strategic decision.
  • Easy of use
  • Has improved a lot the visualization of data
  • Fast
  • For use it take a lot of time to prepare the correct data. I don't know it there is some MicroSrategy magic solution to make it faster
  • Better comunication with client
  • Improve dashboards, losing with competitors
Very well suited for corporate reports, centralized info.
I don't find it very easy for end users not involved in the transformation of reports.
Brandon Fitzpatrick | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We use MicroStrategy to provide a business intelligence solution for our clients. We use it to create reports and dashboards that our clients can use to analyze their business.
  • Customized dashboards between the desktop and web applications.
  • Shared objects which allows reusability in a number of different reports.
  • Web tool still doesn't have all the customization possible in the developer application.
  • Rigid star scheme requirements creates complications in unstructured data.
  • I would love to see out of the box "what-if" scenario functionality.
Great if you have a data warehouse built as a star schema. Less useful with unstructured data.
Score 8 out of 10
Vetted Review
Verified User
Review Source
MicroStrategy Analytics is used in my organization to analyze the sales performance of products by specific SKUs, categories, or customer segments. It is a business intelligence tool leveraged by merchandising and marketing departments. The business problem addressed by MicroStrategy tool is to understand if a particular product category is growing in revenue after more SKUs were added or after a marketing campaign was run targeting specific groups, sales division or segment of customers. It does an excellent job of creating a custom performance report by dragging and dropping a set of objects which are correlated to each other in a relational database. As well as enables analysts to create quick visualizations.
  • Dragging and dropping report objects to create quick reporting of marketing and merchandising success metrics such as cases sold, revenue, and margin.
  • Segmenting a specific product performance report by filters such as a fiscal period, a list of SKUs, product categories, sub-groups, types, or a segment of customers.
  • Not efficient when the volume of data sets increases to hundreds of thousands of rows, which results in timeout errors when exporting excel reports. So, often the analyst has to break large data sets into smaller subsets, which means more time to analyze.
  • Doesn't do a great job of correlating unstructured data sets such as marketing banner impressions and clicks to structured data sets such as transactions, customer engagement, or cases sold attributed to a specific marketing campaign.
MicroStrategy Analytics tool is well suited when marketing campaign or merchandising category data sets are smaller in volume, are more transactional, and historically collected. So, if the goal of the analyst is to analyze success metrics as cases sold, revenue, and margin by specific product SKUs, category or customer segments of campaigns which were run in the past like a day, week, month, or year ago. This business intelligence tool should not be used to do real-time data analysis or to run reports against thousands of megabytes of data. Because in those complex scenarios, the tool will time out and show reporting errors. Instead, other digital marketing analytics or business intelligence tools such as Google Analytics or Teradata SQL Assistant would be more appropriate to use to meet the advanced analytics needs of an organization.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use it in multiple business units within our organization, from [making] financial decisions to direct people impacting decisions. We are able to pull from multiple data sources and provide dashboards or report analytics from patterned data to make efficient and intelligent decisions to our business model and direction. It helps to provide a pathway to achieve our corporate strategic goals.
  • Dashboards
  • Reporting Analytics.
  • Initial configurations
  • Support costs
The product provides great tools and reports that enable you to look at holistic data to see patterned goals. Gathering multiple data sources from mining, this product achieves just that pretty easily. Its very customizable and enables the executive team to see the weeds in metrics that are understandable.
Vineet Rai | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microstrategy is extensively used within my organization and other retail and finance clients I have worked with. MSTR is an efficient tool with numerous analytical, reporting and visualization features all clubbed in one - helps deliver grid reports, dashboards and mobile reports. We have used this for dynamic sourced reports and self analytics as well widely.
  • Integrated solution for delivering different types of reports through multiple mediums like web, mobile or distribution services.
  • Unique Schema and public objects concept saves development costs by allowing reusable components and maintenance across.
  • Having end to end MSTR implemented eliminates the need to look at different tools for in memory and visualization.
  • Version control and parallel development limitation- I understand it somehow conflicts the architecture specialities but point to be thought over.
  • Visual Insights capabilities to compete with Tableau like reports.
  • MSTR services and technical support teams response time - not always a concern but can definitely be improved.
Better suited for: For high volume and large number of reporting fields. For requirements where multiple modes of report delivery is required for ex: web, mobile and emails. Dynamic sourcing and self analytics with existing objects avoiding redevelopment efforts. Less appropriate: For small scale analytics considering cheaper options of analytics tools available. Creates complexity for a uncoordinated and distributed development team considering version control and Schema integration issues.
Abanish Mishra | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microstrategy is used as a reporting solution in my work environment. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel.
  • Visual Insight is a very good tool for data discovery and for create quick dashboard presentation. This is is basically a online web based portal where you have capability to quickly slice & dice the data . Also it provides you options to create derived metrics & derived attribute (MSTR 10) with various mathematical or statistical functions. One of the major mention would be the map based data visualization where you can plot data based on Latitude & Longitude.Also with MSTR 10 following limitations were removed i) using hyperlink ii) HTML 5 is implemented instead of Flash ,so easy to be rendered in mobile too iii) Adding images is possible for hardcoding company logo & symbols
  • Drilling Capabilities. This requires some good backend data modeling. Once you bring in all the facts and dimensions you are supposed to establish relationship between them & create hierarchies. Then it would be easy to drill more & more. For example - Device hierarchy - (Device Used by User--> Browser-->Operating System)
  • Data Source Connectivity.
  • Enterprise Manager is basically BI to BI environment which is used by administrators or executives to track reporting usage, report performance,developer efficiency or frequency of usage & thousands of other statistics which proves to be very helpful in monitoring the efficiency of the whole environment. Once you set up Enterprise miner( which is a bit tricky) you will be able to access all the in built documents or you can custom built dashboard based on your usage
  • Visual Insight have multiple limitations. Few of them are listed here - i)Cannot change default graph colors ii) text/graph formatting are very very limited iii)Add metric to Color by / Thresholds is not possible iv)one of the worst limitation of the VI in older versions is that it is not possible to create filters that apply only to a specific visualization. For example if there are 4 graphs in one dashboard & if you have filters then those filters would be applicable for all of them
  • Some formatting options are not there either on Web or Developer especially while dealing with a document. We have to use both Web & Developer to solve issues.
  • While connecting with MDX cube reporting loses a lot of features.
MicroStrategy Analytics is not only a visualization layer but also data modeling tool itself. So you can bring in all your facts and dimensions and define the relationship in architect mode to build intelligent cubes. It shouldn't be mixed up with a visualization tool like Tableau which doesn't have any other capability (data architect and mining). Companies who need to use it only as a visualization layer tool shouldn't use MicroStrategy.
Mark Szymula | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
MSTR is being used by approximately three departments w/in Casey's. We plan on having MSTR be an enterprise-wide solution
  • MSTR Analytics does visualization very well.
  • Ad-Hoc analysis
  • As w/ any tool - the data underneath MSTR has to governed and structured correctly to use in a self service environment
  • MSTR almost demands that you have an MSTR Administrator on staff to keep the semantic layer fresh
MSTR is suited for a well-governed, solid data environment. While I believe that MSTR, and the rest of BI as a whole, wants to move towards a more self-service business user environment - MSTR still needs a technical staff to support that self service
Score 9 out of 10
Vetted Review
Verified User
Review Source
We went with MS analytics to create internal operational efficiencies and Improve business process outcomes through enhanced decision making using better data points and metrics available at hand. Mainly the team was looking at using the data from the last 12 months or 52 weeks to create dashboards and have a meaningful representation of that huge amount of data. The team liked the options available with filters for using important data. We were able to save the templates with various parameters, filters, and rules which were easy to update with a refresh in a click. The visualizations also looked good as they had different color themes to separate out different parameters. We could also save the widgets and export them as excel sheets, pdf to extract data in shareable files. We intend to use this across a department.
  • Filters and their customization to make meaningful widgets and have multiple widgets in one dashboard view.
  • Ability to save templates that can be later refreshed without having to recreate them from scratch.
  • Takes a little longer to configure initially and is a big load on the data server.
  • Doesn't have a unified interface and has two separate interfaces for lots of features.
  • Support team could be more efficient and have documentation ready to share after helping out with issues.
MS Analytics is really helpful in the visualization of large data, after initial problems in loading, performance and functionalities are really good. MS Analytics is also useful in driving innovation with quick insights from large data sets. The Customer Support team has a scope for improvement—they could have better SDK documentation ready, they could do with shorter turn around time for bug fixes. We should be informed about updates beforehand and there are feature updates that make things a little confusing sometimes like a timeline feature update in the bar diagram was messed up once.
★Alex Khamudis | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microstrategy is currently being used by several different departments within the organization. It makes our reporting easier, where it provides the flexibility to automate much of it, as well as provide an easy to use interface for non sql savvy employees. It solves many of our reporting needs
  • Central location for reporting, makes it easier for several different departments to access different information
  • Automated reporting - allows us to schedule customized reports
  • Well formatted reports that are easy to run
  • My organization is on an older version of the tool with a lot less bells and whistles
  • If an employee is familiar with SQL enough, they can avoid using microstrategy
  • No other major cons
Microstrategy is great for organizations that are looking to empower all types of employees with the ability to retrieve relevant data for their business functions.
From our experience, Microstrategy is very well supported. Whenever we have issues, they are resolved quickly
Tapan Jain | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
MicroStrategy Analytics is used by our organization to create highly interactive dashboards and reports with cutting edge visualizations. Currently, the front end and dashboards are being developed by only a single department but reports and dashboards are consumed across the organization and even clients.
The main advantage of MicroStrategy Analytics is that it can be accessed online through a web browser which eliminates the need to carry heavy Excel files. Also, the reports and dashboards are updated in real time which was not possible with Excel based dashboards.
  • It helps create dashboards that are personalized to a particular type of user. The access to the specific sections of dashboards and reports can be controlled and only the intended audience can access that information. This helps with distributing the same dashboard to different departments and even competitors.
  • The reports are completely responsive to different devices and can be accessed via any device of any resolution. Also, MicroStrategy offers a vast range of power visualizations like heat maps and can also connect with third party applications like Google Maps for additional functionality. Also, this functionality is present even on mobile devices.
  • With its Online Analytical Processing capabilities, users can modify the reports by slicing and manipulating the data as per their needs without executing the SQL query in the backend. This helps in saving a lot of development time as individual users can modify the report online by using filters and slicers without requiring the coding know how.
  • ESRI ArcGIS maps can only be integrated and accessed with internet connectivity which becomes a limitation when using only with LAN connectivity.
  • The community/forum is not very active with a limited number of users and low quality content.
  • Some functionalities are missing from the web version and are only present in the desktop version. Also, dashboards over the web still lack integration with HTML5.
MicroStrategy is well suited when reports have a wider audience but some parts need to be hidden from a specific audience. When there are very stringent deadlines to develop a new report or a dashboard, MicroStrategy should be avoided as it has a longer development time when compared to alternatives like Tableau. Also, when the reports are to be consumed while on the go, MicroStrategy has an edge over other alternatives.
March 04, 2016

From zero to hero.

Davide Moraschi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Build a complete Business Intelligence solution from the ground up. They provide desktop, web and mobile interfaces.
  • Analyze and report on large volumes of data from an extensive number of source databases.
  • Provides a full Software Development Kit (SDK) to personalize, customize and write your own BI applications and web sites.
  • Support for HTML5 is still at the beginning. The latest features were developed with Adobe Flash, which sometimes is not the best and fastest solution. HTML5 with CSS and SVG would probably be more portable and a smoother experience to the user.
  • I personally would like to see native OAuth 1.0 and 2.0 Support. And the ability to directly attach JSON data feeds like Google provided data.
  • Web Services documentation could be improved and expanded with more examples.
Be sure to grasp the basic concepts from the very beginning. A complete and updated ER Diagram of the data warehouse is needed. Read the manuals, as MicroStrategy is a very complex product and cannot be learned by trial and error. There is a book, which was recently published by PACKT, about the whole Business Intelligence development process: http://amzn.to/1by3HAO
Pablo Tempone | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microstrategy is used in one of our banking clients. It's used by different areas, some use it for alerts. Others use it as a dashboard solution or for ad-hoc reporting.
  • The governance and security layer, with the metadata layer.
  • Easy ad-hoc reporting creations.
  • Strong dashboard options.
  • Merging data from different sources has been improved a lot but it's not easy to create a query manually.
  • Training metrics - it's not easy to use for users. But the new method of R integration could change that.
Is well suited if an organization needs a centralized and strong BI solution for data exploration.
Randy Kirschner | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
MicroStrategy is currently being used throughout the organization to address various ad-hoc requests.
  • Ad-hoc analysis
  • Dashboarding and visualizations
  • There's no clean tree/hierarchical display of attributes that allows me to see the entire tree on one screen. This also translates to a report with one column showing the indentation for nested categories.
  • The interaction and user interface with dealing with a prompted report is less than desirable. Many users hate the interface and find it difficult to use.
  • Not all features are available in web when designing dashboards. You often have to bounce back and forth from Desktop to Web in order to get to the option you're looking for.
MicroStrategy is good for dashboarding and mobile. The software offers a lot of functionality right out of the box and provides the users with many options to easily get at their data.
Frank Bluemke | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • User Friendly
  • Abillity to manage large volumes of data from multiple sources
  • Narrowcast Reporting & Dashboard options
  • Creating documents is very technical and requires training
  • Graphing tools are difficult to use
  • Setting up alerts and email distributions could be easier
I would make sure you understand what information the users will need and what level of detail is needed to ensure that the integration and setup process is configured with the end use in mind. Having examples of reports and information you already produce, where it is coming from and how it is used will help set you up correctly from the beginning avoiding timely changes later on.
Shawn Stephens | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • The Microstrategy web front end is easy to navigate which makes it even easier to train our users on.
  • Microstrategy Visual Insight has added a new dimension to our content which allow for a story to be told about the data.
  • Microstrategy Mobile allows our executive team to analyze key KPI's at the swipe of a finger.
  • I think that although Visual Insight is a new tool that it probably has the most upside to it. Adding features that are available on the Report Services side would be great for VI.
MicroStrategy is well suited for companies that have at least 100+ users with varying skill sets. It is a very versatile tool with many access levels from Pro to Analyst; depending on your experience. Features such as subscriptions, visual insight, and mobile are very well received across departments for reporting. Transactional services is useful for light collaborative needs such as notating certain records. In my opinion MicroStrategy isn't suited for companies looking for heavy financial reporting or collaborative efforts.
Overall I have been using MicroStrategy for a little over 10 years and it has proven to fit most all of my reporting needs.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use MSTR organization wide to track KPIs for our brands. We have several dashboards set up based on brand and channel. MSTR allows for real time monitoring of KPIs and provides views of performance over time. It eliminates the need to constantly run queries to check results, saving countless hours of employee time.
  • Visual representation of data
  • Ease of use for setting up and modifying dashboards
  • Intuitive UX for non-experienced users
  • Sharing custom dashboards
MSTR is great for any organization that is looking for a way to deliver complicated data in an uncomplicated way. From business teams to marketing and finance, several departments benefit from using MSTR to keep track of KPIs enabling teams to make optimizations along the way. MSTR provides great visual representations of data enabling team members to distill thousands of data points into easily digestible charts and graphs.
Mario Ferrer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We're building a new data warehouse and reporting system. MicroStrategy will be at the forefront of our strategy, providing a robust, multi-language, multi-tenant architecture for our customers and internally. It replaces our Excel, CSV based reporting company-wide.
  • Without a doubt, it scales, it is robust and the performance is great.
  • The latest enhancements for version 10 (like replacing Flash with HTML 5) address some previous issues and concerns.
  • They've closed the gap they had with Tableau and similar products with the introduction of Desktop, while still providing governed, data discovery. Something Tableau lacks.
  • It is hard for me to point out room for improvement. Version 10 just came out and I haven't had the chance to fully experiment with it, but it looks very good so far.
For us, multi-language, multi-tenant were some key features, but obviously many questions come to mind, depending on the needs, such as platform, big data support, data-blending, data-mashups, language, customizations, etc.
Paul Campbell | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use MicroStrategy Analytics in many departments, the span of support goes from Business users to IT support. This tool is intended to be the "one stop shop" for all reporting needs. We are able to connect many different data sources which tend to be common in large companies. The current implementation met our needs in the past and we are adapting to use it better and more efficiently for future needs. I believe when configured correctly, this product can meet all requirements for our department and all other departments.
  • Extremely fast and reliable sql generation, report and document development.
  • Flexibility and integration with nearly all data sources.
  • Self reliant product, many out of the box products that allow easy maintenance, development, and monitoring.
  • Cost of product is more reasonable than many other in its class.
  • Reports and documents produced can be pixel perfect and allow for extremely custom dashboards and scorecards.
  • There are many tools and products in the whole Analytics suite, I find this cumbersome and would like to see all these tools brought together
  • There is no version control built into the product. Versioning seems outdated and the principle way of handling versions is outdated and I think should be remodeled.
  • To a new user, learning the entirety of all MicroStrategy products is difficult and can take a long time to adapt to.
MicroStrategy Analytics is very well suited for small and large companies and for varying degrees of budgets. The price model is fair for the type of features and functionality out of the box. There will have to be someone dedicated to MicroStrategy and the lifecycle of the business data model. It is not a light weight product on the back end, but can be very lightweight to the end users. No-SQL allows the domain experts, people who understand the business and not technology, to analyze and dig at questions without being burdened by asking database experts for advanced SQL generation. I give this product a 9 out of 10 because it is not fully HIPAA compliant and the means to make it HIPAA compliant means we must cripple some basic functionality.
  • Online training
  • Self-taught
If the staff does not know they answer they either find it out at some point, or put in a feature request. I have never been left hanging or been given an answer that is unsatisfactory to the solution. Even if there was no current solution, I was still told the logical reason and why.
Jonathon Frampton | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Standard KPI reporting.
  • Scheduled reporting.
  • Simple dashboards.
  • Easy report design and creation.
  • Discovery - visually dig through the raw data.
  • Real-time updates.
  • Connections to alternate data sources (APIs, local files).
  • Limited visualizations.
  • Built-in statistics and forecasting (lack of).
BI is not cheap, sometimes... In many cases the "Enterprise-ness" of MS is not necessary as many smaller competitors are gaining ground quickly (QlikView, Tableau, Birst, etc...) and would make great solutions for companies that do not require the strict rules associated with a larger organization. I would just make sure that as anyone is considering either a new BI install or change that they make sure to look at some of the "new" Big Data toting companies that can add value quickly.
Wm. Dexter Jones | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microstrategy is our primary BI delivery environment and is being used for the entire organization. We have a unique business case in that our organization is the BI department for hundreds of other organizations; however, attributes, metrics, and nomenclature are different although using the same data set. In addition, our data sets are 10s to 100s of millions of rows of data. Microstrategy scales for large datasets and has just enough flexibility to address these problems.
  • Aggregate awareness.
  • The ability for the SQL generator to select the correct aggregate table, whether a hierarchy or dates, is invaluable to organizations with less mature database developer resources.
  • Delivery of reports, particularly web-based delivery.
  • Microstrategy provides the most options for report delivery, scheduling, and formats; a requirement of self-service BI.
  • Managing metadata
  • Microstrategy's architecture prefers a star schema; this can serve as a virtual ER builder and help locate possible bottlenecks in the database design.
  • Scheduling delivery; the use of schedules is very inflexible.
  • Instead of building specific delivery objects, a schedule builder (similar to MS Outlook) will push Microstrategy ahead of the competition. The schedule objects add to the maintenance.
  • FTP/sFTP delivery options.
  • Internal delivery to file systems and availing the file location to FTP is good, but often times external FTP/sFTP is required. Currently, BI engineers have to build external processes to deliver to external FTP.
  • Desktop dashboard development; it is a bit disjointed.
  • Dashboard development options are different between desktop (now called developer) and web are different. We often have developer and web open at the same time to build dashboards.
  • Architect product; still hasn't gained global acceptance for schema management.
  • More flexible cross-tab development.
  • There's an idea I have about joining data sets where there's aggregate data combined with crosstab data. The example i use is a annual budget (metric) along side monthly spend (metric). Today, the annual budget must be an attribute which means it cannot be used in calculations.
You have to ask if the product you're using can handle large datasets and whether there is flexibility in the delivery of analytics? In addition, how many DBMS's does the product natively support? What is the TCO? MicroStrategy is in the upper tier for each of these questions.
They address ALL issues/enhancements and often times, are resolved in the next version or patch of the product.