Skip to main content
TrustRadius
MicroStrategy Analytics

MicroStrategy Analytics

Overview

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.

Read more
Recent Reviews

TrustRadius Insights

MicroStrategy Analytics is a versatile tool that is widely used across departments in various industries. Departments such as Accounting, …
Continue reading

MicroStrategy Review

8 out of 10
October 18, 2017
Incentivized
It is being used across our health center in every department, from admin to ops to clinics. We are trying to use it with our scheduling …
Continue reading
Read all reviews

Popular Features

View all 30 features
  • Formatting capabilities (24)
    10.0
    100%
  • Customizable dashboards (23)
    10.0
    100%
  • Report Formatting Templates (24)
    10.0
    100%
  • Pixel Perfect reports (23)
    10.0
    100%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

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…

Offerings

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

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

21 people also 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 Qlik Sense?

Qlik Sense® is a self-service BI platform for data discovery and visualization. It supports a full range of analytics use cases—data governance, pixel-perfect reporting, and collaboration. Its Associative Engine indexes and connects relationships between data points for creating actionable insights.

Return to navigation

Product Demos

MicroStrategy Analytics Product Demo v 10

YouTube

Augmented Reality - MicroStrategy Analytics Demo

YouTube

MicroStrategy Analytics Product Demo v10 (With Voice)

YouTube

MicroStrategy - Analytics Desktop (Basic) - Online Training Video by MicroRooster

YouTube

MicroStrategy - Analytics (Visual Insight) - Online Training Video by MicroRooster

YouTube
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

10
Avg 8.2

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

10
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

10
Avg 8.4

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

10
Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

10
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

9.7
Avg 8.0

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

10
Avg 7.9
Return to navigation

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 Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Mac
Mobile ApplicationNo

Frequently Asked Questions

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.

ibi WebFOCUS, Looker, and QlikView are common alternatives for MicroStrategy Analytics.

Reviewers rate Pixel Perfect reports and Customizable dashboards and Report Formatting Templates highest, with a score of 10.

The most common users of MicroStrategy Analytics are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(265)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

MicroStrategy Analytics is a versatile tool that is widely used across departments in various industries. Departments such as Accounting, Finance, and Audit have found the software to be invaluable in pulling policy level detail reports and generating month-end summary reports for the general ledger. This has greatly streamlined their reporting process and facilitated SOX audit testing. Additionally, multiple business units within organizations rely on MicroStrategy Analytics for financial decision-making and direct people impacting decisions.

Users have also found the software to be useful for prototyping, demoing to customers, analyzing functionality, implementing it, and advising customers on its implementation and usage. Its ability to provide a comprehensive view of company data and create live dashboards has made it an essential tool in achieving corporate strategic goals. It has also empowered department financial budget officers to easily view their budget values.

Furthermore, MicroStrategy Analytics is not limited to specific industries but is used across various sectors like finance, healthcare, and retail. It excels at creating web-based dashboards and mobile reporting, helping solve issues related to turnaround time, staffing, and tracking by utilizing data from scheduling programs and electronic medical record systems.

Overall, MicroStrategy Analytics serves as a full business intelligence enterprise solution by sourcing data from various database technologies, solving the problem of data silos organizations may face. Its versatility makes it a trusted tool for analyzing large datasets and providing valuable insights that drive informed decision-making.

Attribute Ratings

Reviews

(1-25 of 25)
Companies can't remove reviews or game the system. Here's why
Jeff Harris | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
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.
Dharmesh Shah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Innovations:
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

Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
Brandon Fitzpatrick | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Vineet Rai | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MicroStrategy Analytics is currently being used by Accounting, Finance, and Audit. It is being used to pull policy level detail reports, month end summary reporting for making entries to the general ledger, and MTD as well as YTD/ITD reporting with various views to support month end variance analysis. It is also used to perform SOX audit testing on an annual basis.
  • Automated reporting
  • Interactive dashboards
  • Large amounts of data
  • Formatting of reports
  • Moving data around on a report at the user level
  • Creating applications
It supports the web very well. It also supports desktop interfaces as well as mobile interfaces. It is well suited for on site staff as well as remote users. It is well suited for new users and well as experienced users. You can set up reporting to be like canned reporting or with variables that need to be changed from time to time.
Abanish Mishra | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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.
Tapan Jain | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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
  • 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
Randy Kirschner | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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.
Shawn Stephens | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
  • 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.
Mario Ferrer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
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.
Wm. Dexter Jones | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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.
Paul Campbell | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Olivier Sanzot | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
It is currently used by the finance department. It is used for web produced dashboards. We have plans to go mobile soon.
  • Metadata layer
  • Self service BI
  • Easy and fast deployment
  • Users community is missing
  • Possibility to customize (sdk) is hard to learn
It is not appropriate for small departments.
Score 7 out of 10
Vetted Review
Verified User
  • Designing of the Architecture
  • Ability to create highly interactive dashboards
  • Handle large amounts of data
  • Compatible with most of the data sources
  • The development environment (Desktop) can be a little bit more intuitive. The UI is still more like 90s
  • Ease of use for the end user to analyze data (ability to add comments/annotate) and share
  • Include more informative and visually appealing visuals as well as widgets.
MSTR may not for any business types or it may not be a one size fits all kind of solution. There are other BI tools out in the market that are available for relatively less or even free to meet your needs. So an extensive vendor analysis to meet your specific needs is essential.
Justin Sharifipour | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
  • Fantastic features for mobile applications. Out of all of the BI tools out there, it is by far the best on an iPad
  • Lots of features for the end-user to custom the output of reports
  • In-memory processing allows for very quick responses
  • It has a very steep learning curve for report developers. I found it the most difficult to learn from a developer perspective
  • A lot of system administration overhead is required. Probably not suitable for a small organization. The cloud version would probably be better.
  • The remote training that they offer (such as through the PEP program) is terrible. I had training classes online that would've been better served getting a root canal. Training is one of their most deficient areas in my opinion.
Be very careful before buying the full on-site version of the product. If the sales rep says that it has minimal IT involvement, don't believe it. Ask about cloud options, the different modules that you are buying as part of their proposal, and what kind of training they are offering as part of their bid. If it's online training and not on-site, be very skeptical.
Score 10 out of 10
Vetted Review
Verified User
  • Ease of creating Advertiser Based Playbooks that empowered sellers during their sales call.
  • Flexible to update, modify, and uniformly deploy.
  • At times more set templates were restrictive and not adjusting to accommodate more data points.
  • Refreshes of certain data points prevented daily frequency.
  • Formatting at times would reset to defaults.
I would recommend understanding the needs of the end user and having the full scope available so that the proper project can be scaled in the timeline defined. Phasing may need to happen as you problem solve for elements that require modification in order to fit into the analytics tool/cube.

Update Dec-14, this continues to be a game changer for our decision making and ability to flex with the changing media landscape.
Lara Rasner | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
  • MicroStrategy is a very powerful BI tool that, with the right training, can open the world of analysis to consumers, allowing your data to assist the masses with important business decisions, by offering a layer of abstraction between your data and users.
  • MicroStrategy does a good job with any type of security model you need to implement. Security can be regulated on a large scale down to the object level. Sending reports to multiple people and being able to limit the data to each of those people based on group security is a phenomenal aspect.
  • The flexibility of dashboards, reports and grids within MicroStrategy desktop was remarkable and allowed for a highly customized BI interface.
  • Administration and implementation of MicroStrategy exposed fatal flaws in their software as a whole. I expected much, much higher quality software for the licensing/pricing demanded from MicroStrategy.
  • Although their tech support staff were always friendly, it took multiple (and I mean multiple) attempts to solve issues, some of which were never resolved. Many of which were drawn out for weeks with support staff asking me to perform troubleshooting steps that I'd outlined I'd already performed in the ticket comments when posted. Just very ineffective support as a whole.
  • Their error code base is not well documented. I can't count how many times I found an error being thrown and could not find reference of what that error meant, or was caused by. I found many people complaining about the same error in their community discussion boards, with no responses from anyone at MicroStrategy offering assistance.
It would really depend on the size, scale and needs of your data warehouse BI tool. I would say a good rule of thumb if you have a minimum of 50 users that are going to be constantly creating/slicing/dicing your data, this may be the tool for you. If fewer, then I would suggest investing in a great data warehouse developer and Excel classes for your consumers. Also know that, even though it touts itself as a fast, self-service BI system, unless you have a skilled SQL Developer or DBA, it will be slow as molasses as it creates the tSQL for the queries itself, in a very poorly designed manner.
Salim G. Ansari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I am setting up an account management team for the organization. Microstrategy is at the heart of the system and has produced some great results so far.
  • CAMERA is our major dashboard: Corporate Account Management Electronic Reporting Application
  • It pulls data from multiple sources in the organization and helps monitor our SLA management.
  • Reporting for masses the without going through a dedicated account!!
  • Web reporting needs to be aligned with mobile reporting. One stop shop.
It is well suited for business analytics and SLA management but needs improvement in providing support to the scientific research community.
Laura Lewis | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Analytics is used throughout the business, from report and dashboard consumers to analysts using advanced data mining functionality. It allows us to produce consistent reporting, in a timely fashion and automate the distribution to a large customer base.
  • Scalability- build once and apply security features to allow the report to be used by multiple roles and levels
  • Mobile functionality
  • More visualizations- when your user base is comfortable with the charts in Excel not being able to replicate them causes reduced user adoption
It is well suited for an environment where interactivity and scalability are important or where there is a need for mobile reporting.
Toreyan Clarke | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
  • MicroStrategy was a helpful tool for providing daily, monthly, and quarterly reporting due to the ability to build automated reports that can be sent to large groups of people using distribution lists.
  • I found MicroStrategy very helpful when putting together monthly performance reviews using the visual reporting tools. The ease with which I was able to switch from data tables to charts as a better way to tell stories about complicated data sets was particularly useful.
  • When we needed to pull user information for targeted marketing campaigns, MicroStrategy dramatically reduced the amount of time we spent tying User IDs to user activity within our DMP. In turn, we were able to leverage the data to create user segments which helped us focus our marketing spend more effectively for marketing campaigns.
  • Perhaps it was the nature of the size of the company I previously worked for, but the amount of time it took for changes and upgrades to be implemented was a bit frustrating at times.
  • It would be incredibly helpful if users had the ability to make changes to metrics and attributes without having to rely to heavily on MicroStrategy developers, it would make the product a great deal more useful.
  • Being able to distribute rich MicroStrategy reports without sending enormous emails was problematic at times. If there was a way to let data rich reports being distributed via email live in a web environment would be a big plus for the platform.
  • Being unable to view reports on smartphones was a bit of a pain at times as well, particularly when you need to send reports to colleagues working off-site without a laptop or desktop computer available.
I would say MicroStrategy is useful for someone who is 100% dedicated to manipulating data as their day-to-day responsibility. It is also important to set expectations with individuals who will be using your work in MicroStrategy to be aware of the fact that it takes time for the main users to become familiar with the platform. Additionally, you must be willing to constantly inform your team of any issues arising with reporting for the platform.
Score 9 out of 10
Vetted Review
Verified User
  • Proficient data management for a multitude of attributes- this allows for a bank of knowledge for report building and analysis.
  • User friendly making it a relevant partner in my day to day job.
  • Web based function allowing for flexibility and ease of access from varying locations.
  • Restraints on data exports by column and row can be constraining.
  • Some user frustration due to time constraints at different levels of data.
  • At beginning, hard to determine difference in metrics and attributes to aid in report creation.
Be patient when first learning the system as it can be frustrating to pick up and understand the lingo for execution. Give examples of how you would utilize the data warehouse and ask for examples of building reports as well as output. Be sure to ask what technical support would be offered in the honeymoon period while you are getting acclimated to the product.
November 09, 2013

Srini's MSTR review

Srini Veerapaneni | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
  • Data segmentation is a real strength. I used it extensively to pull data based on geographic and customer demographic lenses
  • Speed. Especially with the basic builders which housed most of the reports I needed, the performance was outstanding. The datamart is huge.
  • Visualization is a strength as well. I felt this was an underrated feature but MSTR produced great graphs.
  • While performance was a strength of basic builders, advanced buiders were lacking in performance.
  • Same with visualization. Graphs weren't easy for everyone and you needed bit more technical expertise. Tableau is a great example of how easy it should be for everyone to visualize graphs.
Ask yourself what's most important for you needs? Speed, accuracy, pretty reports. Then compare the leading players out there and weigh each of them along those three dimensions. While all the leading vendors do a good job of BI, they each excel in a different area and it will be obvious to you once you do the analysis as to which one firts best for your needs.
Sid Haas | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
  • Drag and drop analysis for users that don't need any database knowledge or programming experience.
  • Beautiful dashboards that load quickly and provide instant snapshots and/or trends over time.
  • Ability to extend from desktop to mobile with relative ease.
  • Microstrategy Web and Microstrategy Desktop work slightly differently. There are still some functions that need to be completed in the Desktop software that are not available through a browser.
  • Web-based dashboards still utilize Flash. I expect to hear about a transition to HTML5 or something similar, but have not yet heard about this. Microstrategy Mobile solutions do not require Flash.
  • Product licensing is difficult to understand.
Success with Microstrategy (or any BI tool) begins with your data. Spend the time and effort it takes to clean up your data and develop bullet-proof ETL (Extract - Transform - Load) procedures and scripts to keep that data clean at all times. Ensure that you have excellent performance from your database server(s) and plenty of memory available for Microstrategy's tremendous caching engines.
Return to navigation