Enquiry Now !      

Microstrategy Course & Training in Pune - Technogeeks - Microstrategy Institutes, Classes, Centers in Pune.

    Duration of Training : 6 Weekends

    Training includes : 20+ Assignments, 3 POCs

    and 1 Real time Project

     

    SYLLABUS

     

    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

    Additional benefits

    • Mock interview sessions
    • Resume building session
microstratigy
microstratigy


Enquiry Now !