EncartaLabs

MicroStrategy Engines and SQL

( Duration: 2 Days )

In MicroStrategy Engines and SQL training course, attendees will learn to understand how MicroStrategy Engine develops Structured Query Language (SQL) to gather data in a variety of reporting scenarios. Learn methods for tuning and optimizing report performance using Very Large Database (VLDB) properties.

By attending MicroStrategy Engines and SQL workshop, attendees will learn:

  • SQL analysis
  • SQL optimization techniques
  • Creating complex queries with SQL, using subqueries and intermediate tables
  • Understanding SQL behavior based on different objects on a report
  • Managing the report execution process in a BI environment

  • Attend MicroStrategy - Analytics Reporting training or equivalent knowledge
  • Attend MicroStrategy Project Architecting training or equivalent knowledge

MicroStrategy Project Designer or Administrator

COURSE AGENDA

1

Introduction to the MicroStrategy engine

  • SQL generation process
2

Basic optimizations

  • Multi-SELECT statements
  • Multipass SQL
  • Attribute definitions and their impact on joins
  • Intermediate tables
3

Templates

  • Attributes
  • Hierarchies
  • Consolidations
  • Custom groups
4

Metrics

  • Non-aggregatable metrics
  • Conditional metrics
  • Transformation metrics
5

Filters

  • Attribute qualifications
  • Set qualifications
  • Metric qualifications
6

Analytical Engine

  • Role of the Analytical Engine
  • Processing a report limit
  • Subtotals
  • Compound metrics
  • Analytical functions
7

Introduction to VLDB properties

  • VLDB properties defined
  • The VLDB properties Editor
8

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top