MicroStrategy Engine Essentials Training

Course Description

This two-day course explores the logic and behavior of the MicroStrategy engine. Students learn how the engine generates Structured Query Language (SQL) for a variety of reporting scenarios. After an overview of the MicroStrategy engine architecture, students focus on the SQL generated by the MicroStrategy engine for common reporting requirements such as advanced metrics, set qualification filters, and analytical engine features.

Students also explore ways to tune and optimize the MicroStrategy engine through the use of VLDB (Very Large Database) properties. Students learn what VLDB properties are and how they can be defined at different levels of a MicroStrategy project. Students review the most commonly used VLDB properties in certain categories, such as indexing, joins, pre/post statements, query optimizations, and tables.

Throughout the course, students gain hands-on practice via a series of exercises.

Course Summary

Next Public Course Dates

UK & Europe:

  • 3 - 4 October 2023
  • 17 - 18 October 2023
  • 7 - 8 November 2023

US & Canada:

  • 26 - 27 September 2023
  • 10 - 11 October 2023
  • 24 - 25 October 2023
  • None
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite

Course Modules

Introduction to the MicroStrategy engine

  • The MicroStrategy engine at a glance
  • SQL generation process

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

    To discuss your project requirements, send us a message

    For a free assessment, quick quote or training information, send us a message

    To book this course, please fill in your details and submit the form.

    To discuss your training requirements or book a class, drop us a line