Microstrategy

OVERVIEW

Building Strategic Influence in Matrix Organizations

Microstrategy gives organizations the complete set of capabilities required to transform into an Intelligent Enterprise, from enterprise reporting and data discovery, to mobile productivity and real time telemetry. Microstrategy enables organizations to work on challenging data sets and to share accesses to data with various business groups, ensuring the decision makers have access to data whenever and wherever they need it.

WHAT YOU'LL LEARN

Why you shouldn't miss this course

By the end of this course, participants will have the leadership toolkit to shape and steer GenAI portfolios across their organization.

01Microstrategy Installation and MSTR configuration

02Data warehousing and Microstrategy architecture

03Microstrategy analytics desktop objects and schemas

04Analytics and Reporting on Microstrategy

05Hierarchy and Grouping in Microstrategy

06Creating facts, attributes and schema objects

07Integrating social media and analytics data through “data wrangling”

08MicroStrategy security filter and performance tuning

PREREQUISITES

Recommended experience

CURRICULUM

Structured for
Strategic Application

Database Concepts
Definition of Data Warehousing
Types of tables
Star Schema
Snow Flake Schema

Developer
Architect
Report services
Intelligence server
Distribution Services
Administration
Object Manager
Integrity Manager
Command Manager
Web
Data Blending
Visual Insights

Microstrategy Developer

A brief into Business Intelligence
A brief into Developer & Architecture in Microstrategy
Types of Objects in Microstrategy
A brief into Public Objects
A brief into Schema Objects
A brief into Configuration Objects

A brief into Attributes and Metrics.
A brief into Report Creation
Different types of Report Modes
Pivoting
Templates
Sorting
Auto Styles
Outline Mode
Formatting Changes
Conditional Formatting (Templates)

Creating & saving Advanced report filters
Creation & saving Advanced report Prompts
Creating, formatting and saving metrics
OLAP services in Microstrategy desktop
Report Objects
View filters
Derived Metrics
Smart Metrics
Level Metric
Transformation Metrics
Conditional metrics
Creating and saving prompts & searches
Consolidations and Custom Group
Exporting Report in Microstrategy

Creating an Intelligent Cube
Publishing an Intelligent Cube
Creating Intelligent Cube Reports
Derived Elements(Lists, Calculations, Filters)
Dynamic Aggregation
Dynamic Sourcing

Report Data Options
Aliasing
Report Limits
Attribute Join Types
Metric Join Types
VLDB Properties

A brief into Microstrategy Architect
Logical data model
Physical warehouse schema
Advanced Data modeling & schema design
Many-to-many relationship
A brief into project creation in Microstrategy architect
Creating Microstrategy facts
Creating Microstrategy attributes
Role attributes
Automatic and Manual Mapping
Creating Microstrategy hierarchies
Project configuration workshop

A brief into enterprise reporting
Document basics
Document design concepts
Useful design techniques

Introduction to Microstrategy administration
Administration and query flow
Connectivity
Startup and administration interface
Security
Microstrategy intelligence server administration
Caching and scheduling
Datamarts
Clustering

Creating Subscriptions
Scheduling Subscriptions
Subscribing to User and User Groups

MSTR Installation
Object manager
Project duplication
Groups and user creation
Command manager

Exposure to mstr10
mstr10 – new concepts
Document Creation
Dashboard Creation
Custom Groups
Metric Creation
Prompt Creation

Creating Documents and Dashboard
Different View and Execution Modes
Creation of Documents and dashboards with slice n Dice Concepts
Inserting Panel Stacks, Layouts, Selectors and widgets in Documents and Dashboard

Adding External data to create dashboards
Importing Dashboards
Exporting Dashboards
Data blending
Linking attributes

RECOMMENDED PARTICIPANT SETUP

This course follows Cognixia's AI-first,
hands-on learning model

Access to sanitized process maps, KPI definitions, candidate initiative lists, and basic cost baselines (time, cycle time, error or rework rates)

INTERESTED IN THIS COURSE?

Let's Connect

Speak with a Cognixia specialist about enrollment options, custom cohorts for your leadership team, or tailored delivery formats for your organization.

✓

Response within 1 business day

✓

Available in 5 delivery formats globally

✓

Volume pricing for teams of 10+

Get in touch

One of our specialists will contact you within one business day.

WHY COGNIXIA

Why Cognixia for This Course

KEEP EXPLORING

Mapped Official Learning

Leadership

Change Management for AI-Augmented Organizations

Equip enterprise leaders to drive culture, skills, policy, and operating-model change required for sustainable Generative AI adoption at scale.