Micro Strategy Course Content

Micro Strategy Course Curriculum
 
  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
  
    Micro Strategy 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