2021.912 Advanced Project Architecting

  • Duration: 16 hours
  • Education Passes: Architect Pass

Learn about advanced issues in data warehousing design and how to work with these complexities when implementing a MicroStrategy project. Understand how to model complex hierarchies and attribute relationships, implement role attributes and slowly changing dimensions, design the schema for optimal performance, use logical views to solve data modeling and schema design issues, and optimize query performance using both the database and MicroStrategy functionality.

Products Covered

  • MicroStrategy Developer
  • MicroStrategy Architect

Skills Gained

  • Creating data models
  • Modeling complex hierarchies
  • Implementing role attributes and slow-changing dimensions
  • Designing schemas for optimal performance
  • Creating logical views
  • Optimizing query performance using database and application functionality

Topics Covered

  • Introduction to Advanced Data Warehousing
  • Advanced Schema Design
  • Logical views
  • Many-to-Many relationships
  • Attribute roles
  • Hierarchies
  • Slowly Changing Dimensions (SCDs)

Select a Class and Register

Course Type Date/Time Language
0000-00-00-00-01 On-demand Multi-language
2021-03-11-00-00 Mar 11, 2021 8:00 AM AEST English
2021-03-25-00-00 Mar 25, 2021 3:00 PM CDT English
2021-04-29-00-00 Apr 29, 2021 10:00 AM CET English
2021-05-06-00-00 May 06, 2021 3:00 PM CDT English
2021-06-09-00-00 Jun 09, 2021 10:00 AM CET French

More course sessions coming soon...