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-08-09-00-00 Aug 09, 2021 9:00 AM CET English
2021-11-22-00-00 Nov 22, 2021 9:00 AM CET English
2021-12-16-00-00 Dec 16, 2021 9:00 AM AEST English
2021-07-01-00-00 Jul 01, 2021 2:00 PM CDT English
2021-07-26-00-00 Jul 26, 2021 1:00 PM EDT English
2021-08-17-00-00 Aug 17, 2021 2:00 PM CDT English
2021-09-02-00-00 Sep 02, 2021 2:00 PM CDT English
2021-10-14-00-00 Oct 14, 2021 2:00 PM CDT English
2021-10-28-00-00 Oct 28, 2021 1:00 PM EDT English
2021-12-13-00-00 Dec 13, 2021 9:00 AM CST English

More course sessions coming soon...