EncartaLabs

MicroStrategy Project Architecting

In MicroStrategy Project Architecting - Essentials training course, attendees 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, attendees 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, attendees 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, attendees 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 Designer, Administrator, Project Architect, Database Administrator and Advanced Analyst

COURSE AGENDA

MicroStrategy Project Architecting - Essentials
(Duration : 3 Days)

1

Architecting the MicroStrategy schema

  • MicroStrategy project life cycle
  • Gathering business requirements
  • Creating a logical data model
  • Data warehouse physical schema design
  • Creating a MicroStrategy schema
  • Working with tables
  • Working with facts
  • Working with attributes and relationships
  • Working with hierarchies
2

Managing the MicroStrategy schema

  • Modifying facts
  • Working with transformations
  • Aggregate tables
3

MicroStrategy Multisource Option

  • Primary and secondary database instances
  • Support for duplicate tables
  • SQL generation for multisource reports
  • Supported use cases
4

Advanced design features

  • Fact level extension
  • Partitioning
  • Data importing
  • Logical view creation
  • Attribute role configuration
MicroStrategy Project Architecting - Advanced
(Duration : 2 Days)

1

Introduction to Advanced Data Warehousing

  • Data Warehouse design and reporting
  • Overview of Advanced Data Warehousing
2

Advanced Schema Design

  • Snowflake and star schemas
  • Recommended schema design
3

Logical views

  • Logical views in MicroStrategy Architect
  • Creating logical views
  • Using logical views to resolve data warehousing issues
4

Many-to-Many relationships

5

Attribute roles

6

Hierarchies

  • Ragged hierarchies
  • Split hierarchies
  • Recursive hierarchies
7

Slowly Changing Dimensions (SCDs)

  • Creating a life stamp
  • Using a hidden attribute

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top