MicroStrategy Tutorial: What is MSTR? Architecture & Reporting
What is MicroStrategy?
Micro Strategy is an enterprise BI application software. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Micro Strategy also supports mobile BI.
You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and so on. It offers an intuitive way to create and modify BI reports and dashboards.
In this MicroStrategy tutorial for beginners, you will learn:
- Why is Microstrategy so widely used?
- History of MicroStrategy
- Features of MicroStrategy
- Important terms using in Microstrategy
- How to Install and Setup MicroStrategy
- MicroStrategy Architecture
- What are Various Objects in Microstrategy?
- Applications of Microstrategy
Here are the major pros/benefits of using MicroStrategy tool.
- It can connect with existing enterprise apps and systems.
- It is deployed in the cloud. Thus, it saves your infrastructure costs.
- It is a useful tool for solving big data related issues.
- It offers features for mobile analytics.
- It allows you to directly access a database with in-memory
- Provide BI ecosystem which helps you to eliminate the requirement for other tools
- It is user-friendly, thus eliminating the need for IT support.
- It offers advanced and predictive analytics features
- In 1989, MicroStrategy was founded on the concept that in future organizations need to utilize the power of their data.
- In 1992, MicroStrategy gets its first big client when it signed a $10 million contract with McDonald's.
- In 1995, the company introduced relational OLAP product suite for decision support applications.
- In 1999, MicroStrategy launched the world's first personal intelligence network. (Strategy.com)
- In, 2004 MicroStrategy delivered Bl technology to users of Microsoft Office applications.
- In 2006, MicroStrategy introduced a Multidimensional Expressions engine for optimizing dynamic MDX syntax.
- In 2012, MicroStrategy delivered enhanced data discovery features in Visual Insight.
- In the year 2014, MicroStrategy made powerful analytics and mobility available on Amazon Web Services.
- In 2016, MicroStrategy made its MicroStrategy Desktop product free for every user.
- In 2018, MicroStrategy transformed visual data discovery by introducing a native MicroStrategy Library App for smartphones.
Here, are essential features of MicroStrategy:
- Ease of use and self-service
- Offers highest user scalability
- Plug and play components
- Highest report scalability
- Automated report maintainability
- Highest data scalability
- Allows you to prompt parameterized reporting
- Helps you to format tabular grid reports using a range of built-in styles
- Conditional formatting of data and visual indicators
- Allows you to convert tabular reports in the form of graphs and charts
- You can drill down granular level data using Microstrategy
- Allows you to export inMS-Excel, HTML or text formats
MicroStrategy offers an excellent feature for data discovery. It is part of the BI process which allows you to connect data from disparate sources in the form of data silos. The tool also helps you to connect data in formats like big data, flat files, etc.
It is a method for cleaning and transforming data in a format which can be adapted easily for extracting business insights. It allows you to structure, cleanse, and enrich data to perform business intelligence reporting.
Data Mining and Predictive Analysis
MicroStrategy offers data mining features like report designers to business users and analysts. It allows you to build predictive analytics reports and distribute them to any device.
Library of Analytic Functions
MicroStrategy offers a comprehensive library that provides data mining, financial and mathematical functionalities. It helps to tie data, performance metrics, and statistical analysis reports.
Extensible Visualization Library
MicroStrategy offers hundreds of open source tools for visualizing the data along with the built-in tools. It allows you to deploy the visualization builder, or you can also even build a new visualization from.
The real-time dashboard allows you to work with real-time data. It also helps to monitor business information in real-time. You can also get a regular update with the latest data.
MicroStrategy offer option of Embedded BI which allows you to connect with SharePoint, WebSphere, NetWeaver, etc. The tool provides a simple integration kit that includes sample coding and documentation.
Now in this MicroStrategy tutorial, we will learn how to install and setup MicroStrategy:
Step 1) Go to the link and click "Continue to Subscribe."
Step 2) Accept the Terms
Step 3) Wait for some time. One the same page you see "Continue to Configuration" button. Click on it
Step 4) Keep the settings default and click "Continue to Launch."
Step 5) Keep the settings default and Click "Launch."
Step 6) You will be shown a confirmation screen. Wait for some time, for instance, to launch.
Step 7) Find the public IP of the instance from your EC2 Console.
Step 8) Use the link
To access MicroStrategy
In our case, the link is
The Architecture of MicroStrategy strategy is constructed with a three-tier structure. Let's learn MicroStrategy architecture with each layer in this Mstr tutorial:
First-tier contains two databases.
- Data warehouse: contains information for a user to analyze.
- Metadata: stores information on data stored in Datawarehouse.
The second tier consists of MicroStrategy Intelligence server. It helps you to execute your reports against the data warehouse.
The third tier is the MicroStrategy Web client or Mobile app, which provides reports to the end users.
In Microstrategy, Object appears in the system layer for use in multiple projects. It includes configuration objects such as Schedules, Data Warehouse, and Login ID.
They are used for the logical representation of structures in Data Warehouse. This type of objects acts as a building block for BI. This helps you to map columns in database, functions, and operations.
This objects layer helps you to assembles the building blocks from the Schema and Analysis. It provides insightful textual and visual analysis.
Helps users to access the project and create objects to store them in personal folders during the project. Non-Administrative users can only view objects on the public folder so you can't delete or create new objects in public folders. For example, Drill Maps, Documents, Templates and searches, Metrics.
- Allows you to garner customer feedback using social media analysis
- It is used for Predictive analytics in the banking and insurance domain.
- Offers omnichannel experience using many different customer touchpoints
- Helps you launch new products with the help of market and customer data
- It helps you to convert big data into reports.
- Micro Strategy is an enterprise BI application software. It supports interactive dashboard, ad-hoc query, Microsoft Office integration, etc.
- MicroStrategy helps you to connect with existing enterprise apps and systems.
- It offers the highest user scalability.
- Data Wrangling is a method for cleaning and transforming data in a format which can be adapted easily for extracting business insights.
- Data discovery allows you to connect data from disparate sources in the form of data silos.
- Data mining features like report designers allows building predictive analytics reports.
- Library to analytical function helps you to tie data, performance metrics, and statistical analysis reports.
- The extensible visualization library allows you to deploy the visualization builder or enable you to build a new visualization form.
- The real-time dashboard allows you to work with real-time data.
- MicroStrategy offer option of Embedded BI which allows you to connect with SharePoint, WebSphere, NetWeaver, etc.
- The Mstr Architecture is constructed with a three-tier structure.
- Configuration, Schema, Report, and Public are important Objects used in MicroStrategy.
- MicroStrategy is used for Predictive analytics in the banking and insurance domain.