Crear un modelo multidimensional.
Conceptos esenciales únicos para el procesamiento analítico en línea y cómo administrar el almacenamiento de datos y las actualizaciones del modelo de manera continua.
3.52
Horas
Horas dedicadas al curso.
25
Clases
Clases totales
10
Estudio
Horas dedicadas de estudio
5
Nivel
Inicial
Creating Tables for a Multidimensional Model
- Dimensional Modeling Fundamentals.
- Dimensions.
- Measures.
- Star Schema.
- Dimension Table Design.
- Fact Table Design.
Building a Basic Multidimensional Model
- Building a Basic Multidimensional Model.
- SQL Server Data Tools.
- Data Source.
- Data Source View.
- Cube Development.
- Deployment and Processing.
Solving Common Problems in Dimension Design
- Solving Common Problems in Dimension Design.
- Date Dimension.
- Hierarchy Types.
- Slowly Changing Dimensions.
- Translations for Dimensions.
Solving Common Problems in Measure Group Design
- Solving Common Problems in Measure Group Design.
- Aggregate Functions.
- Dimension Usage: Regular.
- Dimension Usage: Referenced.
- Dimension Usage: Fact.
- Dimension Usage: Many-to-many.
- Perspectives.
- Cube Translations.
Optimizing the Multidimensional Model
- Optimizing the Multidimensional Model.
- Aggregations in the Query Architecture.
- Usage-based Optimization.
- Storage Modes.
- Partitions.
Keeping the Multidimensional Model Up-to-date
- Keeping a Multidimensional Model Up-to-date.
- Deployment in SSDT.
- Deployment Wizard.
- Process Command.
- Processing Options.
Satisfacción
¿Qué aprendí?
- Crear modelo de datos multidimensional .
- Modelar Dimensiones.
- Modelo de Estrella.
- Tabla de Hechos.
- Resolver probelmas comunes en los cubos.
