Best of MicroStrategy BI Platform

December 18, 2017 | Data Management

MicroStrategy, a modern leading, BI platform, has been organically developing for more than 20 years. More recent BI products are visually appealing, but they lack architectures suitable for use and integration with other systems. As a result, BI experts and their business users who are searching for solution systematically, consistently decide to choose MicroStrategy.

Based on user requirements, the BI industry is increasingly moving from IT-led BI systems to self-service BI environments. That includes powerful visualization techniques and enables independent data preparation. By embedding these features in the core of the MicroStrategy platform, they still maintain control over the system, architecture, speed, and security.

MicroStrategy is the most comprehensive BI platform in the market, where it has been setting standards since 1994. It’s very different from other major manufacturers that add functionality with purchases and acquisitions and often not able to integrate with their existing BI offer properly. MicroStrategy remained faithful to its mission to create a unified, integrated and consistent analytical environment, developed organically inside the company.

All Users, All Bi Styles, All Data

MicroStrategy supports all ways of BI use: from reports, dashboards, KPIs, ad-hoc reporting, OLAP, forecasting, visual research, and data preparation.
Business users like information consumers, researchers, data analysts or scientists are using Microstrategy. They can have it on any platform: online, cloud, mobile or desktop. It can perform its analysis from data from relational databases, Hadoop, Spark, NoSQL, Hive, JSON environments, Excel or text files. MicroStrategy users can also perform analysis directly on ERP systems, over other BI systems, over data from the cloud, from social networks.

MicroStrategy’s development environment allows developers to create custom reports and documents suitable for printing. Developers can extend MicroStrategy functionality through standard API interfaces with visualizations, additional analytical features, or can be embedded in other applications to create new hybrid custom applications.

MicroStrategy is one of the few BI manufacturers that enables the development of native BI applications for iOS and Android with all natural features specific to mobile devices that are much more useful than typical HTML5 interfaces. Applications greatly increase productivity with built-in workflows that combine analytics, transactions, and multimedia.

Data Access

MicroStrategy is known for its scalability of data access, which includes multi-step SQL queries that are tailored and optimized for each of the most relational databases, and cloud data.

Queries are distributed across different layers from the database, reports, projects, and applications. At each level, the results are stored for re-use, which greatly reduces the response times. MicroStrategy is able to perform queries over several unrelated sources of data and thus creates a virtual, unified data warehouse.

MicroStrategy is among the first to introduce BI in the cloud. Users can use it as PaaS or SaaS and adjust capacity according to needs, such as increasing capacity every first Monday of the month.

Any BI Mode

MicroStrategy supports dimensional, ad hoc analysis (eg OLAP) over relational data warehouses. They can be in any form, but most often in the form of a star or snowflake. Based on the ROLAP principle, all types of analysis originate from operating reports, dashboards, visualizations, alert alarms, all according to business users needs, based on their applications and permissions.

Users communicate with reports and control panels over the Internet, tablets, phones and desktop applications. Users adjust their view on data by drilling, pivoting, slicing and dicing, using different types of graphs, sorting, and tables. Reports can accessed interactively or are sent out periodically or when data values reach the predefined threshold values. Users can also enter data using forms that update back operating databases.

Visual Discovery and Self-Service are an integral part of the MicroStrategy platform. Business users of MicroStrategy Desktop with appropriate permissions can prepare the entire BI environment on their own. They can publish and share their results and findings with others as well as collaborate to discuss findings.

Metadata is the Key to Modern Bi System

MicroStrategy is built over centralized metadata that facilitate management and ensures consistency of data. It also prevents different parts of BI from becoming data silos. An object-oriented metadata repository catalogs all BI data as logical objects that can be re-used in any project, application, document, report, dashboard, or visualization.

The catalog consists of a logical data model and BI schema objects (attributes, facts, hierarchies, …), components (dimensions, filters, sets, groups), documents (reports, control panels, tables, forms, charts, filters) and regulate access to company information. The system automatically populates changes made in the catalog to all related objects throughout the BI environment.

MicroStrategy aggregates all the necessary objects from the catalog and performs a query and delivers results to business users.

The MicroStrategy platform contains a powerful data modelling tool. It allows BI architects to create a single data model with multi-layer hierarchies and relations between objects.

MicroStrategy provides an interface that allows business users to independently prepare and clean up, convert and merge data, thus upgrading pre-prepared logical models stored in the central metadata catalog. Users can easily share their findings with their colleagues, partners or customers and comment on them in real time.

Users can make their work easier and faster by using pre-prepared templates and samples.


Extensibility is part of the MicroStrategy platform. MicroStrategy SDK allows to build new analytical applications or integrates BI components into other applications either on the web or on mobile platforms.

Business users and developers can also extend the functionality of the platform by adding statistical functions built with R, importing analytical models from SAS, SPSS or KXEN using PMML.

Developers can use visualizations from the MicroStrategy Visualization Library and associate them with existing reports without coding. They can use the MicroStrategy SDK to create customized visualizations and import external libraries, such as D3, Highcharts and Google. They can integrate maps and geolocation functions from external GIS providers or include multimedia content (e.g., Video, Audio, Images, Documents).

Centralized Management

MicroStrategy contains a robust, centralized and comprehensive set of BI system monitoring and management tools, which allow logically divide users into groups or regions in large environments.

Administrators have a complete control over the features that users and groups can use. They can restrict users to access  the data on the row and column level. It integrates with third-party authentication systems , such as LDAP and Active Directory. Administrators can also set the interface language so users can analyze data in the language they choose.

Warehouse Manager is MicroStrategy’s tool to monitor the use of BI environment such as use of reports, users, implementation time, bottlenecks.

Object Manager allows managers to move projects from development to test and later to production environment.

Command Manager allows scripting to automate repetitive tasks, such as adding, moving or removing users or groups, granting or revoking privileges, and triggering the execution of scheduled reports.

Integrity Manager compares the results of two versions of the same report. It verifys the impact of updates and other project activities in production reports.

Conclusion on MicroStrategy BI Platform

MicroStrategy is a complete platform for BI and analytics. It meets the dual business needs: it is a robust platform for the development and management of BI systems, on one hand, and it is a visual self-service data discovery environment that responds rapidly developing business users requirements on the other.

MicroStrategy is a golden standard for governed the BI platform.

Ready for the next step?

Our team of experts is here to answer your questions and discuss how we can boost your operational efficiency by merging rich tradition with a progressive mindset.