11.911

MicroStrategy Engines and SQL

Understand how the 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. Skills you gainSQL 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 MicroStrategy products coveredMicroStrategy Developer TopicsIntroduction to MicroStrategy engine Basic optimizations Templates Metrics Filters Analytical Engine Introduction to VLDB properties

Pricing

  • Free with PEP
  • 14 Training Units
  • $1400

Duration

  • 16 hours

Version

  • MicroStrategy 2019

Platform

  • Analytics

Role

  • Administrators

Level

  • Expert

Recommended Prerequisites

Self-Paced Training

E-Learning

Course Recordings

English Register
Portuguese Register
Portuguese Register

Instructor-Led Training

Online May 25 - 26, 2020
9:30 AM - 5:30 PM CET
English Hans-Joachim Diedrich Register
Online May 28 - 29, 2020
9:00 AM - 5:00 PM CST
English Douglas TerBush Register

No sessions were found matching your criteria.