11.912

Advanced Project Architecting

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

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 and application functionality

MicroStrategy products covered

  • MicroStrategy Developer
  • MicroStrategy Architect

Topics

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

Self-Paced Training

E-Learning

Course Recordings

English Register

Instructor-Led Training

Online Apr 2 - 4, 2020
9:00 PM - 5:00 AM CST
English Douglas TerBush Douglas TerBush Register
Online Apr 15 - 17, 2020
9:30 PM - 5:30 AM CET
English Chantal Moss Register
Online Jun 8 - 10, 2020
9:30 PM - 5:30 AM CET
English Peter Brown Peter Brown Register
Online Jun 22 - 24, 2020
9:00 PM - 5:00 AM CST
English Douglas TerBush Douglas TerBush Register

No sessions were found matching your criteria.