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 gain

  • 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

MicroStrategy products covered

  • MicroStrategy Developer

Topics

  • Introduction to MicroStrategy engine
  • Basic optimizations
  • Templates
  • Metrics
  • Filters
  • Analytical Engine
  • Introduction to VLDB properties

Self-Paced Training

E-Learning

Course Recordings

English Register
Portuguese Register

Instructor-Led Training

Online Apr 6 - 8, 2020
9:30 PM - 5:30 AM CET
English Igor Freitas Igor Freitas Register
Online Apr 9 - 11, 2020
8:00 PM - 4:00 AM PST
English Anahi Serrano Anahi Serrano Register
Online Apr 20 - 22, 2020
9:30 PM - 5:30 AM EET
English Chantal Moss Register
Online May 25 - 27, 2020
9:30 PM - 5:30 AM CET
English Hans-Joachim Diedrich Hans-Joachim Diedrich Register
Online May 28 - 30, 2020
9:00 PM - 5:00 AM CST
English Douglas TerBush Douglas TerBush Register

No sessions were found matching your criteria.