MicroStrategy is a comprehensive enterprise analytics platform that transforms raw data into actionable intelligence through a unified metadata architecture. Founded in 1989, it provides end-to-end BI capabilities from data modeling and report authoring to mobile delivery and embedded analytics. Unlike many cloud-first competitors, MicroStrategy's ROLAP architecture with Intelligent Cube in-memory acceleration offers both flexibility and performance at scale. A key mental model: MicroStrategy treats everything as metadata objects — reports, metrics, attributes, even security filters — stored in a central repository that drives consistency across the entire platform, making large-scale BI governance practical where ad-hoc tools fail.
What This Cheat Sheet Covers
This topic spans 20 focused tables and 129 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
Table 1: Core Platform Architecture
MicroStrategy runs as a classic three-tier stack, and these are the pieces you actually install and operate. The Intelligence Server is the engine room — everything else either feeds it definitions, queries it, or renders what it returns — so seeing how the metadata repository, web tier, and authoring tools orbit that server is the first step to reasoning about any deployment.
| Component | Example | Description |
|---|---|---|
mstrsvr.exe process managing 100+ concurrent users | • Central application server that orchestrates query execution, caching, scheduling, and security • the heart of MicroStrategy's 3-tier architecture | |
SQL Server database storing all object definitions | • Centralized relational database that stores definitions of all reports, dashboards, metrics, security settings, and schema mappings • enables single-source-of-truth governance | |
Importing 200 tables from Oracle data warehouse | • Schema discovery tool that reads physical database structures and maps them to MicroStrategy logical objects • maintains synchronization between warehouse and metadata |