In this MicroStrategy tutorial for beginners, you will learn:

History of MicroStrategy MicroStrategy Architecture How to Install and Setup MicroStrategy Features of MicroStrategy Important terms using in Microstrategy Advantages of MicroStrategy Applications of Microstrategy Various Objects in MicroStrategy Top Microstrategy Interview Questions and Answers

History of MicroStrategy

How to Install and Setup MicroStrategy

Here is the step by step process on how to install and setup MicroStrategy:

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.

Step 1) Subsribe to MicroStrategy BI Tool Go to the link and click “Continue to Subscribe.”

Step 2) Accept the Terms Next, accept the terms and conditions of the tool

Step 3) Continue to Configuration Wait for some time. Once the page shows “Continue to Configuration” button. Click on it

Step 4) Keep default settings and Launch the software Keep the settings default and click “Continue to Launch.”

Step 5) Review the settings Keep the settings default and Click “Launch.”

Step 6) Wait for the confirmation You will be shown a confirmation screen. Wait for some time, for instance, to launch.

Step 7) Get the public IP of the instance Find the public IP of the instance from your EC2 Console.

Step 8) Start using MicroStrategy Use the link: To access MicroStrategy In our case, the link is

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.

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

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.

Various Objects in MicroStrategy

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

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.

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.

Summary

MicroStrategy 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.