MICROSTRATEGY ONLINE TRAINING

                                  MICROSTRATEGY COURSE DETAILS – 9.X

1.    Introduction to  Data Warehousing

• OLAP 

• OLTP

• Data Warehousing Architecture

• Star Schema

• Snowflake Schema

• Hybrid Schema

2.    Purpose of Data Warehousing
3.    MicroStrategy Architecture 
4.    MicroStrategy Products 
5.    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

• 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

Prompts 

• Prompted Filters

• Object Prompt

• Level Prompt

• Value Prompt

Reports and searches

• Report Manipulations

Templates

6.    MicroStrategy Web
7.    Documents and Static, Dynamic Dashboards
8.    Introduction to Administration

• Command Manager and Object Manager

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

MICRO STRATEGY INTERVIEW QUESTIONS

1. What are Logical Views used for?
   Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Once these Logical views are created, they are available to the report designer in a way similar to any other table. This allows developers to model attributes and facts whose expressions span multiple tables.
2. How will Project Sources be configured in MSTR Office?
   By editing the projectsources.xml, new project sources can be added.
3. Difference between standard, absolute and ignore condition in metrics?
   Standard filtering allows the report filter to affect the metric.
   Absolute filtering raises the report filter to the level of the target, so all subcategories in the categories included on the report are added together.
   Ignore filtering disregards filtering criteria based on the attribute in the target and its related attributes (both parents and children).
4. Comparison between Consolidations and Custom Groups?
   A custom group is a set of special filters that can be placed on a template. It is made up of an ordered collection of elements called custom group elements. Consolidations are used to specify the data you want to view in your report. They allow you to group attribute elements in new ways without changing the metadata and warehouse definitions.
5. What is an object prompt?
   An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups and so on. Object prompts can either determine the definition of the report template or the report filter.
6. How the reports are optimized?
   VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine.
7. What is the order of precedence of VLDB properties?
   Reports>Project>Database Instance>DBMS
8. Difference between Report Limit and Report filter?
   A report limit specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated.
   Report Filter applies the where condition to the query sent to warehouse to extract the results.
9. What is Metric Formula Join Type? How it is different with Metric Join Type?
   This is basically used for Compound Metrics and determines how the different tables used in metric formula are joined.
   Whereas the Metric Join Type determines how the metrics are joined to other metrics.
10. What are attribute roles?
    A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).

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.

           

MICRO STRATEGY ONLINE TRAINING

AcuteSoft is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies.
ACUTE SOFT has a pool of Expert Trainers worldwide on all the technologies to train the students.
ACUTE SOFT is offering Training services to Major IT giants and to individual students worldwide.
About Our faculty: we have excellent SAP MICRO STRATEGY instructor who have real time experience plus expert orientation in Online Training.
SAP All Modules online Training
We offer you:
1.   Interactive Learning at Learners convenience
2.   Industry Savvy Trainers
3.   Learn Right from Your Place
4.   Customized Curriculum
5.   24/7 system access
6.   Highly Affordable Courses
7.   Support after Training
a.   Resume Preparation
b.   Certification Guidance
c.   Interview assistance
Guaranteed Placement Assistance
We have a ninth coming online batch on SAP MICRO STRATEGY .
We also provide online training on SAP (All Modules), DATA WAREHOUSING (All Modules), SAS, SAS BI, Share point, oracle (All Modules), TIBCO, Testing tools, Java, Dot Net and MS BI.
Contact   :  Santhosh / Lakshmi:
     INDIA: + 91-7702226149
     US   : +1 973-619-0109    
     Land line:   040 - 42627705
     http://www.acutesoft.com/