Intelligence Everywhere
We’re ready to work with you.
Our team will reach out soon to connect you to what you need.
Explore these resources to get ready:
Change PasswordMicroStrategy Engines & SQL
- Duration: 16 hours
- Education Passes: Architect Pass
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.
Products Covered
- MicroStrategy Developer
Skills Gained
- 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
Topics Covered
- Introduction to MicroStrategy engine
- Basic optimizations
- Templates
- Metrics
- Filters
- Analytical Engine
- Introduction to VLDB properties