|
Cognos 8 BI Metadata Modeling I
Los
instructores de Profesionales en Inteligencia de Negocios (PROFIN) cuentan con la
certificación directa de Cognos.
Duración:
21 horas
Descripción:
En este curso se revisan las estructuras
genéricas de modelado. Se introduce a los conceptos básicos de modelado en
el ambiente de Framework Manager, seguido de conceptos y técnicas mas
complejas para resolver problemas de reporteo. Se analizan los esquemas
operacional y de estrella para resultados predecibles así como la creación
de modelos dimensionales para su uso en consultas tipo OLAP.
Contenido del programa:
- Identificar estructuras comunes de
datos
- Introduccion a Framework Manager
- Preparar metadatos en Framework Manager
- Modelado para resultados predecibles en Framework Manager
- Crear vistas de negocio
- Configurar la seguridad
- Modelado de una fuente de datos en un esquema tipo estrella
- Administrar fuentes de datos OLAP
Detalle de temas:
Identify Common Data Structures
Examine the characteristics of operational databases and databases designed
for reporting
Examine relationships and cardinality
Identify different data traps
Examine OLAP data sources
Introduction to Framework Manager
Define Framework Manager and its purpose
Describe the Framework Manager enviroment
Examine the Cognos 8 and Framework Manager Workflow processes
Examine the Framework Manager user interface
Prepare Metadata in Framework Manager
Verify and modify query item properties and relationships to control the
presentation of data and ensure expected results
Customize metadata for a multilingual audience
Customize metadata for runtime to dinamically control the data returned
Model for Predictable Results in Framework Manager
Identify reporting traps
Identify the advantages of modeling as a star schema
Define how Cognos 8 treats cardinality
Use the metadata modeling recommendations to model an operational data
source
Implement a time dimension
Specify determinants
Create Business Views in Framework Manager
Add a relational business view to the model using star schema groupings
Create a call center application using a stored procedure query subject
Create an organizational reporting business view by resolving a recursive
relationship
Add a dimensionally modeled relational business view to the model to enable
OLAP style queries
Set Security in Framework Manager
Examine the Cognos 8 security enviroment
Restrict access to packages
Create and apply security filters
Restrict access to objects in the model
Model a Star Schema Data Source
Use the metadata modeling recommendations and other techniques to model a
dimensional data source (star schema)
Manage OLAP Data Sources
Connect to an OLAP source in a Framework Manager project
Publish an OLAP model
Publish a model with multiple OLAP sources
Publish a model with an OLAP source and a relational source
|
