MicroStrategy Tutorial: What is MSTR? Architecture & Reporting

Details

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?

Here are the major pros/benefits of using MicroStrategy tool.

History of MicroStrategy

Features of MicroStrategy

Here, are essential features of MicroStrategy:

Important terms used in MicroStrategy

Data Discovery

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.

Data Wrangling:

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.

Real-time Dashboards

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.

Embedded BI

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.

How to Install and Setup MicroStrategy

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 

http://<ip-address>:8080/MicroStrategy/servlet/mstrWeb

To access MicroStrategy

In our case, the link is 

http://ec2-54-86-245-204.compute-1.amazonaws.com:8080/MicroStrategy/servlet/mstrWeb

MicroStrategy Architecture

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.

  1. Data warehouse: contains information for a user to analyze.
  2. 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.

What are Various Objects in MicroStrategy?

Configuration objects:

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.

Schema Objects:

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.

Report Objects:

This objects layer helps you to assembles the building blocks from the Schema and Analysis. It provides insightful textual and visual analysis.

Public Objects:

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.

Applications of MicroStrategy

Summary:

 

YOU MIGHT LIKE: