Course 11.912

Advanced Project Architecting

Learn about advanced issues in data warehousing design and how towork with these complexities when implementing a MicroStrategyproject. Understand how to model complex hierarchies and attributerelationships, implement role attributes and slowly changingdimensions, design the schema for optimal performance, uselogical views to solve data modeling and schema design issues,and optimize query performance using both the database andMicroStrategy functionality

About this course

  • 플랫폼: Administrative
  • 기간: 2 Days
  • Price: $1400
  • Certification Path:

Products Covered:

  • MicroStrategy Developer
  • MicroStrategy Architect

Topics Covered:

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

Skills You Gain:

Skills you gain
  • 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 andapplication functionality