Course Outline

Introduction

  • Overview of MicroStrategy Architecture

Working with Schema Objects

  • Creating attributes
  • Understanding and creating facts
  • Using logical tables
  • Understanding mapping and using logical sizes
  • Using transformations

Data Warehousing Concepts and Relationships

  • Understanding star and snowflake schema
  • Understanding data warehousing concepts
  • Understanding one-to-one relationships
  • Understanding one-to-many relationships
  • Understanding many-to-many relationships
  • Understanding joint child relationships
  • User hierarchies
  • Logical models

Advanced Concepts

  • Using compound keys
  • Ragged, split, and recursive hierarchy
  • Slowly changing dimensions
  • Using attribute roles and table aliases
  • Creating connections

Summary and Next Steps

Requirements

  • Basic knowledge of SQL and understanding of business intelligence (BI) concepts

Audience

  • MicroStrategy architects
  • BI developers
  • Analysts
  14 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (3)

Related Courses

Big Data Business Intelligence for Govt. Agencies

  35 Hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 Hours

Related Categories