MICROSTRATEGY

MICROSTRATEGY TRAINING

 MICROSTRATEGY TRAINING COURSE CONTENT


Introduction to Data Warehousing

  • OLAP
  • OLTP
  • Data Warehousing Architecture
  • Star Schema
  • Snowflake Schema
  • Hybrid Schema

Purpose of Data Warehousing

MicroStrategy Architecture
MicroStrategy Products

Micro Strategy Desktop

  • Installing Mstr in to desktop
  • Schema Objects
  • Attributes
  • Creation of Attribute
  • Simple Attribute
  • Compound Attribute
  • Pass-through Functions

Facts

  • Creation of Fact
  • Column Alias
  • Fact entry Level

Hierarchies

  • System Hierarchy
  • User Hierarchy
  • Entry Points

Tables

  • Logical Table
  • Table Alias

Prompts

  • Prompted Filters
  • Object Prompt
  • Level Prompt
  • Value Prompt

Reports and searches

  • Report Manipulations
  • Templates
  • MicroStrategy Web
  • Documents and Static, Dynamic Dashboards

Introduction to Administration

  • Command Manager and Object Manager
  • Logical View

Transformations

  • Expression Based
  • Table Based

Public Objects
Auto styles
Consolidations

  • Creation of Consolidations
  • How to use
  • Virtual Attribute

Custom Groups

  • Creation of Custom Groups
  • Difference with Consolidation and Custom Groups

Drill Maps

  • Creation of Drill Maps
  • Purpose of Drill Maps

Filters

  • Report Filter
  • View Filter
  • Advanced Filter
  • Pass-through Functions

Metrics

  • Simple Metric
  • Compound Metric
  • Nested Metric