コース概要

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

要求

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

Audience

  • MicroStrategy architects
  • BI developers
  • Analysts
 14 時間

参加者の人数



Price per participant

お客様の声 (4)

関連コース

MicroStrategy Business Intelligence (BI)

14 時間

MicroStrategy for Developers

14 時間

Business Intelligence in MS SQL Server 2008

14 時間

AWS QuickSight

14 時間

Big Data Business Intelligence for Govt. Agencies

35 時間

Big Data Business Intelligence for Telecom and Communication Service Providers

35 時間

Big Data Business Intelligence for Criminal Intelligence Analysis

35 時間

Business Intelligence Reporting Tool (BIRT)

14 時間

SAP BusinessObjects Business Intelligence (BI)

28 時間

Datameer for Data Analysts

14 時間

Oracle Business Intelligence (OBI)

28 時間

Power BI Dashboards

14 時間

Pentaho Open Source BI Suite Community Edition (CE)

28 時間

Qlik Sense for Data Science

14 時間

Qlik: Advanced Topics in Design and Development

14 時間

関連カテゴリー