In MicroStrategy Project Architecting - Essentials training course, you will learn to create and maintain the foundation of an enterprise analytics application by developing a physical schema and logical model from single, multiple, or heterogeneous data sources. Develop core objects of the reporting infrastructure such as attributes, facts, hierarchies, and mappings to data warehouse tables. Leverage advanced options to build the infrastructure for efficiency and performance.
In MicroStrategy Project Architecting - Advanced training course, you will 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.
By attending MicroStrategy Project Architecting - Essentials workshop, delegates will learn:
- Logical data modeling
- Data warehouse schema development
- Project life cycle management
- Schema management
- Aggregate table development
- Multisource report development
- Partitioning
- Business intelligence project design
By attending MicroStrategy Project Architecting - Advanced workshop, delegates will learn:
- 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
- Attend MicroStrategy - Enterprise Analytics and Data Modeling training or equivalent knowledge
- Project Designers, Administrators, Project Architects, Database Administrators and Advanced Analysts