Duración: 5 días.

Metodología: presencial.

Dirigido a

• Modelador / Administrador COGNOS.
• Data Manager Developers, Data Warehouse Developers, Data Mart Architects.

Pre-requisitos

• Experience using basic Windows functionality.
• Knowledge of database concepts.
• Knowledge of dimensional analysis concepts.
• Working knowledge of SQL.

Objetivo

Cognos 8 Data Manager is a five-day, instructor-led course designed for enterprise data manager developers. Students will learn how to move, merge, consolidate, and transform data from a range of data sources to build and maintain subject-area data marts.

In the process, students will create a catalog and add connections to data sources and targets. They will also deliver fact and dimension data to a data mart through the use of builds and the dimensional framework. In addition, students will learn how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures.

Temario

1. Create a Catalog
2. Create Hierarchies
3. Create Basic Builds
4. Create Derivations and Derived Dimensions
5. Create Conformed Dimensions
6. Customize Reference Structures
7. Preserve and Process Dimensional History
8. Transform Data Using Lookups
9. Customize Data Delivery
10. Process Late Arriving Facts
11. Customize Fact Data Processing
12. Aggregate, Filter, and Partition Fact Data
13. Implement Job Control
14. Automate Data Manager Functionality Using Commands
15. Customize Functionality with User-Defined Functions and Variables
16. Process Unbalanced Hierarchical Data
17. Pivot Fact Data
18. Resolve Data Quality Issues
19. Troubleshoot and Tune the Data Manager Environment
20. Organize and Package Data Manager Components
21. Report on Data with Cognos 8
22. Work in a Multi-Developer Environment (Optional)