MICROSTRATEGY – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us
rad

MICROSTRATEGY

Microstrategy Training in Bangalore

Microstrategy Training by Industry Experts having 10+ yrs exp.

Microstrategy Training Duration : 6 weekends 

 

Course Content

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

Our Courses