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 | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
Course Modules
Introduction to the MicroStrategy engine
- The MicroStrategy engine at a glance
- SQL generation process
Testimonials
“Instructor was very passionate about Databricks and helped me to stay engaged. Great pace, great knowledge, and the trainer was fantastic overall :) ”
- Emma Darling, Platform Engineer, Barclays Bank
“The PowerCenter training last week went very well. There were many practical exercises included which I really appreciated because they helped me understand the topics much better, I learned a lot and found the sessions very useful. I’m continuing to review and practice the content this week to consolidate what I’ve learned.
.”
- Taha Elmaadani, Data Integration Consultant, PTA IT Consulting
“Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.”
- Chris, Cirrus Aircraft
