MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Health Center, MicroStrategy Distribution Services
Course Duration:	Three days
Who Should Attend:	MicroStrategy administrators
Prerequisites:	Desktop: Reporting Essentials

Topics:

Introduction to Administration

• Introduction to MicroStrategy Administration
• MicroStrategy Intelligence Server
• Activation
• Course structure

Architecture and query flow

• Metadata repository overview
• Business intelligence architecture
• Three-tier query flow

Connectivity

• Introduction to MicroStrategy connectivity
• ODBC connectivity
• Server definition
• Project source
• Establishing web connectivity
• Database instance

Administration interface

• Starting and stopping Intelligence Server
• Starting and stopping Intelligence Server as a service
• Administration interface
• Administration icon
• Administration menu
• Intelligence Sever configuration editor
• Project configuration editor
• Governing
• Command line (Universal Edition)

Managing MicroStrategy users and groups

• MicroStrategy user groups
• MicroStrategy user accounts
• Importing users and groups
• Linking MicroStrategy users to Windows users
• Find and Replace Privileges tool

Authentication modes

• Authentication modes overview
• Account security policy

MicroStrategy Web administration

• Web administration overview
• Web Administrator page
• MicroStrategy Web preferences
• Web Server tuning

Security

• Security overview
• Controlling the access to database data
• Controlling the access to functionality

History list management

• History list overview
• History list messages monitor
• Reprompting, refreshing and replacement

In-memory caching

• Computational distance
• The importance of 64 bit
• Caching
• Report caches
• Document caching
• Element cache
• Object cache
• Cache sizing recommendations
• Monitoring caches

In-Memory intelligent cubes

• Introduction to intelligent cubes
• The in-memory cube publication process
• Monitoring intelligent cubes
• Managing intelligent cubes
• When to use in-memory cubes
• Cube sizing and memory usage considerations
• Dynamic sourcing
• Cube advisor
• Data import

Internationalization

• Types of internationalization
• Data internationalization
• Metadata internationalization
• Managing languages
• Language preference resolution hierarchy
• Caches and intelligent cubes internationalization

Clustering

• Clustering overview
• Benefits of clustering
• Enabling clustering
• Metadata synchronization in a clustered environment
• Sharing in a clustered environment
• Subscription execution in clustered environments
• Intelligent cubes in a cluster environment

MicroStrategy Health Center

• Introduction to Health Center
• Configuring the Health Center network
• Diagnosing and fixing problems
• Analyzing log files
• Sending information to technical support

Schedules and subscriptions

• Scheduling
• Subscription administration

Distribution Services

• Feature highlights
• Configuration considerations
• Configuring Distribution Services
• Administering subscriptions in MicroStrategy Web
• Managing and monitoring subscriptions

Tuning

• Components of performance
• Server recommendations for tuning
• Migrating from 32 bit to 64 bit platforms
   

MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Object Manager, MicroStrategy Project Merge, MicroStrategy Integrity Manager, MicroStrategy Command Manager, and MicroStrategy Enterprise Manager
Course Duration:	One day
Who Should Attend:	MicroStrategy administrators
Prerequisites:	Desktop: Reporting Essentials

Topics:

Introduction to application management

• Benefits of the administrative tools
• Course structure

Object Manager

• Application lifecycle management overview
• What is Object Manager?
• Duplicating projects and objects
• Managing objects with Object Manager
• Update packages

Project Merge

MicroStrategy Command Manager

• Command Manager overview
• Command Manager interfaces
• Graphical user interface
• Command line interface
• Command line editor interface
• Command Manager procedures
• Connection modes
• Project and configuration locking

MicroStrategy Integrity Manager

• Integrity Manager overview
• Integrity Manager tests
• Integrity Manager test analysis

MicroStrategy Enterprise Manager

• How can I monitor my environment?
• Enterprise Manager architecture
• Enterprise Manager dashboards and reports

Change journaling

• Enable change journaling
• Recording changes
• Managing change journaling

MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy OLAP Services
Course Duration:	Two days
Who Should Attend:	MicroStrategy report developers, along with anyone who has an interest in learning how to use VLDB properties to tune the MicroStrategy Engine for optimal performance
Prerequisites:	Desktop: Advanced Reporting

Topics:

Introduction to the MicroStrategy engine

• The MicroStrategy engine at a glance
• SQL generation process

Basic optimizations

• Multipass SQL
• Composing optimized SQL
• Intermediate tables

Templates

• Attributes
• Hierarchies
• Consolidations
• Custom groups
• Custom group banding

Metrics

• Level metrics
• Order of resolution: hierarchies in metrics
• Nonaggregatable metrics
• Conditional metrics
• Transformation metrics
• Nested metrics
• Metric join types

Filters

• Attribute qualification
• Set qualification

The analytical engine

• Report limits
• Subtotals
• Compound metrics
• Evaluation order
• Analytical functions

Introduction to VLDB properties

• VLDB properties defined
• The VLDB properties editor

VLDB Properties

• Governing VLDB properties
• Indexing VLDB properties
• Joins VLDB properties
• Pre/Post statements VLDB properties
• Query optimizations VLDB properties
• Select/insert VLDB properties
• Tables VLDB properties
• Dynamic sourcing VLDB properties
   

MicroStrategy Products Covered:	MicroStrategy Desktop and MicroStrategy Architect
Course Duration:	One Day
Who Should Attend:	MicroStrategy project architects, along with anyone who has an interest in designing and creating projects with MicroStrategy Architect
Prerequisites:	Basic SQL knowledge Desktop: Reporting Essentials Architect: Project Design Essentials

Topics:

Introduction to advanced project design

• Review of the project design process
• Review of schema objects
• Using the Fact Editor

Maintaining project schema

• Review of database instances
• Maintaining your warehouse
• Aggregation awareness
• Data marts

Using MultiSource Option

• Introduction to MultiSource Option
• Associating tables to database instances
• Creating objects for multisource reports
• Creating a multisource report

Fact level extensions

• Overview of fact level extensions
• Degrading fact levels
• Extending fact levels
• Disallowing fact levels

Transformations

• What is a transformation?
• Creating and using transformations
• Transformation examples

Partitioning

• Introduction to partitioning concepts
• Warehouse partition mapping
• Metadata partition mapping

MicroStrategy Products Covered:	MicroStrategy Architect
Course Duration:	Two Days
Who Should Attend:	Project designers, database administrators, and anyone else with an interest in learning ways to resolve complex data warehouse modeling and design issues in support of a MicroStrategy reporting environment
Prerequisites:	Basic SQL knowledge Desktop: Reporting Essentials Architect: Project Design Essentials Architect: Advanced Project Design

Topics:

Introduction to advanced data warehousing

• Data warehouse design and reporting
• Overview of advanced data warehousing

Advanced schema design

• Snowflake and star schemas
• Recommended schema design

Logical views

• Logical views in MicroStrategy Architect
• Creating logical views
• Using logical views to resolve data warehousing issues

Many-to-many relationships
Attribute roles
Hierarchies

• Ragged hierarchies
• Split hierarchies
• Recursive hierarchies
• Slowly changing dimensions

MicroStrategy Products Covered:	MicroStrategy data mining functionality in MicroStrategy Desktop
Course Duration:	Two Days
Who Should Attend:	Report designers, advanced business analysts, and anyone else who wants to use MicroStrategy data mining services for predictive and classification analysis
Prerequisites:	Desktop: Reporting Essentials

Topics:

Introduction to data mining

• Data mining and advanced analytics overview
• Advantages of data mining
• What can you do with data mining?
• Limitations of data mining
• Data mining and business intelligence
• Data mining models, terminology, and techniques
• Basic data mining model
• Data mining terminology
• Data mining types and algorithms
• Data mining with MicroStrategy
• Data mining process
• Scoring approaches

Introduction to Data Mining Services

• Data Mining Services overview
• Data mining workflow
• Creating datasets and selecting variables
• Developing predictive models
• PMML and R overview
• Creating and using predictive metrics
• MicroStrategy predictive model viewer

Forecasting with MicroStrategy

• Overview
• Linear and exponential regression
• Tree regression
• Time series analysis

Classification with MicroStrategy

• Overview
• Decision trees
• Logistic regression

Association rules

• Overview
• Association rules

Cluster analysis

• Overview
• Cluster analysis models

Data mining best practices
 

MicroStrategy Products Covered:	MicroStrategy Desktop
Course Duration:	One Day
Who Should Attend:	MicroStrategy report developers, MicroStrategy advanced business analysts, and anyone who has an interest in learning how to create reports with user-defined SQL queries
Prerequisites:	Basic SQL knowledge Desktop: Reporting Essentials Architect: Project Design Essentials

Topics:

Introduction to Freeform SQL reporting

• What is Freeform SQL?
• What are the benefits of using Freeform SQL?
• Comparison of Freeform SQL and standard reports

Creating Freeform SQL reports

• Overview of Freeform SQL report creation
• Configuring a Freeform SQL database instance
• The Freeform SQL editor
• Creating a Freeform SQL report
• Managed objects
• Filters and Freeform SQL reports
• Drilling on Freeform SQL reports
• Using Freeform SQL reports in documents

Prompts in Freeform SQL reports

• Using prompts in Freeform SQL reports
• Creating a Freeform SQL report with prompts

Advanced topics for Freeform SQL reports

• Using derived and common table expressions
• Using stored procedures
• Accessing non-relational data sources

Security for Freeform SQL Reports

• Configuring access to Freeform SQL objects
• Using security filters in Freeform SQL reports
   

MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Health Center
Course Duration:	Two Days
Who Should Attend:	MicroStrategy administrators, project managers, developers, and architects
Prerequisites:	Report Services: Dynamic Dashboards Administration: Configuration and Security Administration: Application Management and Tuning

Topics:

Introduction to High Performance

• The High Performance initiative
• High Performance highlights
• Components of performance

In-memory caching and cubes

• Computational distance
• The importance of 64-bit
• Report, document, element, and object caching
• Cache sizing recommendations
• Intelligent Cubes (publication process, sizing recommendations, incremental refresh, report execution against cubes)

Data transfer

• Network performance
• Distribution Services performance

System architecture and configuration

• Performance measurement primer
• Server specifications
• Intelligence Server configuration
• Web Server configuration

Data presentation: reports, dashboards, and mobile

• High Performance reports
• High Performance dashboards (dataset and design techniques to optimize performance)
• Optimizing performance for mobile

Data source access

• Schema design optimizations
• SQL generalization optimizations
• Data architecture optimizations
• Other query performance optimizations (multisource, ODBC)

Performance testing methodology

• Introduction to performance testing
• Performance testing methodology

Workshop: designing a high performance dashboard
 

MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy OLAP Services
Course Duration:	One Day
Who Should Attend:	Report designers and developers, business analysts, and anyone else with an interest in learning ways to combine Microstrategy's advanced features to solve challenging report scenarios
Prerequisites:	Desktop: Reporting Essentials, Desktop: Advanced Reporting, practical experience working with MicroStrategy

Topics:

Introduction

• Course structure
• Review of advanced reporting concepts

                 - Level metrics
                 - Count metrics
                 - Conditional metrics
                 - and more

Reporting scenarios

• Scenario 1:

                 - Intelligent Cubes and reports
                 - View reports
                 - Drilling

• Scenario 2:

                 - Intelligent Cubes
                 - View reports
                 - Derived elements

• Scenario 3:

                 - Prompted filters
                 - Rank metrics
                 - Level metrics
                 - Advanced function metrics

• Scenario 4:

                 - Prompted filter
                 - Embedded filters
                 - Conditional metrics

• Scenario 5:

                 - Prompted filter
                 - Transformation metrics
                 - Consolidations

• Scenario 6:

                 - Prompted custom group and filter
                 - Count, level and conditional metrics
                 - Relationship filter

MicroStrategy Products Covered:	MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Mobile
Course Duration:	Two days
Who Should Attend:	MicroStrategy Mobile app developers, along with anyone interested in building dashboards and apps that use MicroStrategy Transaction Services
Prerequisites:	Report Services: Dynamic Dashboards, Mobile for App Developers As an option, students may bring an iPad or Android tablet to class to view their exercise on a mobile device. An iPhone or Android phone can be used for some exercises. The device should meet these specifications: iPhone iOS 6.x, Android OS 2.2x or higher MicroStrategy Mobile apps installed Personal iTunes account installed (for downloading the MicroStrategy apps from Apple's App Store)

Topics:

Using Transaction Services in MicroStrategy Mobile apps and in MicroStrategy Web

Architecture overview

• Transaction Services and the MicroStrategy product suite
• Common and advanced workflows

Creating freeform SQL reports

Creating Transaction Services reports and documents

• Creating Transaction Services reports
• Designing transactional dashboards

MicroStrategy Mobile-specific features

• Widgets
• Offline mode

Advanced topics

• Tracing transactional SQL
• Using stored procedures
• Using input-dependent text
• Creating what-if analyses

Creating freeform XQuery reports

Workshop