MicroStrategy BI

Module 1: MicroStrategy Platform Overview

• MicroStrategy architecture: Intelligence Server, metadata, clients
• MicroStrategy products: Web, Developer, Workstation, Cloud
• Object hierarchy: schema, public, and configuration objects
• MicroStrategy Web interface: Library and dossier navigation
• MicroStrategy Workstation: modern client overview
• MicroStrategy certification pathway

Module 2: Metadata & Schema Objects

• Project creation: database connection and warehouse mapping
• Tables: logical and physical table definition
• Attributes: business entities with ID and description forms
• Facts: numeric measures in the warehouse
• Attribute relationships: parent-child hierarchy definition
• System hierarchy: attribute drill paths

Module 3: Metrics & Calculations

• Simple metrics: Sum, Count, Average, Min, Max
• Compound metrics: arithmetic combinations
• Metric expressions: function library in MicroStrategy
• Conditional metrics: IF logic in metric expressions
• Transformation metrics: year-ago, period-over-period
• Smart metrics: automatic level detection

Module 4: Reports

• Grid report: tabular analytical output
• Report objects: metrics, attributes, and prompts
• Report filters: limiting data scope
• Prompts: parameterised, user-input report filters
• Sorting and subtotals in grid reports
• Report services documents: pixel-perfect layouts

Module 5: Dossiers & Visual Analytics

• Dossier: MicroStrategy's interactive dashboard
• Chapter and page organisation
• Visualisation types: bar, line, heat map, bubble, network
• Panel stack: tabbed visualisation within a dossier
• Selectors: filtering interactions in dossiers
• Dossier linking: navigation between dossier chapters

Module 6: Prompts & Advanced Filtering

• Prompt types: attribute element, value, object, level
• Cascading prompts: dependent filter selections
• Prompted filters: reusable prompt-driven conditions
• View filters: slice without rerunning query
• Custom groups: user-defined attribute groupings
• Consolidations: cross-attribute grouping

Module 7: Security & Administration

• MicroStrategy Security roles: view, modify, full control
• Data level security: security filters for row access
• User groups and ACLs for object security
• MicroStrategy Command Manager: scripted administration
• Statistics and performance monitoring
• MicroStrategy Intelligence Server clustering for HA

Module 8: MicroStrategy Cloud & Embedding

• MicroStrategy Cloud: SaaS deployment overview
• MicroStrategy on AWS, Azure, and Google Cloud
• Embedded analytics: MicroStrategy Library API
• REST API: programmatic access to MicroStrategy objects
• MicroStrategy AI: NLP-powered analytics with Auto
• Migration from on-premise to MicroStrategy Cloud

Our MicroStrategy instructors are MicroStrategy-certified BI architects with deep enterprise analytics experience at financial institutions, government agencies, and Fortune 500 companies. They have designed MicroStrategy environments serving thousands of business users with complex governed metrics, high-performance report execution, and enterprise security configurations.