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:

  • 21 - 22 May 2024
  • 4 - 5 June 2024
  • 2 - 3 July 2024

US & Canada:

  • 28 - 29 May 2024
  • 11 - 12 June 2024
  • 25 - 26 June 2024

More dates

Prerequisites
  • None
Duration
  • 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:

    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 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