MICRO STRATEGY ONLINE TRAINING

                                  MICRO STRATEGY COURSE DETAILS – 9.X

 

1.    Introduction to  Data Warehousing -------------------------1.0 Hrs

 OLAP

      OLTP             

      Data Warehousing Architecture

      Star Schema

      Snowflake Schema

      Hybrid Schema

2. Purpose of Data Warehousing ------------------------------ 0.5Hrs
3. Micro Strategy Architecture ---------------------------------0.5 Hrs
4. Micro Strategy Products ------------------------------------0.5 Hrs
5. Micro Strategy Desktop
   Installing Mstr in to desktop ----------------------------- ---0.5 Hrs

 Schema Objects

    Attributes------------------------------------------------3.0 Hrs

        Creation of Attribute

        Simple Attribute

        Compound Attribute

        Pass-through Functions

   Facts ----------------------------------------------------2 Hrs

        Creation of Fact

        Column Alias

        Fact entry Level

   Hierarchies --------------------------------------------- 0.5 Hrs 

        System Hierarchy

        User Hierarchy

        Entry Points

   Tables ---------------------------------------------------1 Hr 

        Logical Table

        Table Alias

        Logical View

            
    Transformations ----------------------------------------1.0 Hrs

        Expression Based

        Table Based

     

    Public Objects 

       Auto styles -------------------------------------------0.25Hrs

     Consolidations --------------------------------------- 1.0 Hr

         Creation of Consolidations

         How to use

         Virtual Attribute

   Custom Groups ----------------------------------------1.0 Hr

         Creation of Custom Groups

         Difference with Consolidation and Custom Groups

   Drill Maps --------------------------------------------- 1.0 Hr

         Creation of Drill Maps

         Purpose of Drill Maps

          

  Filters ------------------------------------------------- 3.0 Hrs

         Report Filter

         View Filter

         Advanced Filter

         Pass-through Functions

  Metrics ------------------------------------------------ 3.0 Hrs

        Simple Metric

        Compound Metric

        Nested Metric

  Prompts ----------------------------------------------- 4.0 Hrs

        Prompted Filters

        Object Prompt

        Level Prompt

        Value Prompt

  Reports and searches---------------------------------- 1.0 Hr

        Report Manipulations

           
Templates ---------------------------------------------- 1.0 Hr

6. Micro Strategy Web --------------------------------------1.0 Hrs
7. Documents and Static, Dynamic Dashboards ------------ 2.0 Hrs
8. Introduction to Administration

             Command Manager and Object Manager---------------- 1.0 Hr

P S: Each and Very topic in course content will be shown with live examples.