microstrategy architect project design - advanced

For MicroStrategy Architect Project Design - Advanced

  • Basic SQL knowledge
  • Attending a training on MicroStrategy Desktop: Reporting Essentials or equivalent knowledge
  • Attending a training on MicroStrategy Architect: Project Design Essentials or equivalent knowledge

MicroStrategy Architect Project Design - Advanced Training course covers advanced features available to project designers. Delegates learn to manage project data sources using primary and secondary database instances as well as to maintain project schema with the Architect graphical interface. They will also learn to create aggregate tables using data marts, as well as how to use MicroStrategy MultiSource Option to configure projects to access heterogeneous data sources.

For MicroStrategy Architect Project Design - Advanced MicroStrategy project architects and anyone who has an interest in designing and creating projects with MicroStrategy Architect.

COURSE AGENDA

  • Review of database instances
  • Maintaining your warehouse
  • Aggregation awareness
  • Data marts
  • Review of the project design process
  • Review of schema objects
  • Using the Fact Editor
  • Introduction to MultiSource Option
  • Associating tables to database instances
  • Creating objects for multisource reports
  • Creating a multisource report
  • Overview of fact level extensions
  • Degrading fact levels
  • Extending fact levels
  • Disallowing fact levels
  • What is a transformation?
  • Creating and using transformations
  • Transformation examples
  • Introduction to partitioning concepts
  • Warehouse partition mapping
  • Metadata partition mapping