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
“Trainer was amazing. I was worried about staying engaged for 4 days, but the pace and explanation was exceptional! Would love to know what other training he provides.”
- Natalie Chronister, Project Administrator III, Carnegie Mellon University Software Engineering Institute
“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”
- Grahame Welch, Head of BI, UK Home Office
“The Tableau Visual Analytics session with Michael was awesome, he is a really good instructor”
- Graciela Kahn, Director, Business Intelligence, NeighborWorks America
