Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) - ILO (I5180)

Catégorie: Formation

Cognos

Format: Formation virtuelle avec formateur

Autres formats:

IBM Cognos Education is now pleased to offer you our courses in an exciting new learning format, Instructor-led Online (ILO). Students are offered a similar experience to live classroom training, with the convenience of having it delivered directly to their desktop.

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) Â is a five-day, instructor-led course that teaches participants 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.




	Compétences acquises
	Please refer to course overview for description information.




	Qui peut en profiter
	This advanced course is for developers.




	Préalables
	You should have: Experience using basic Windows functionality Knowledge of database concepts Knowledge of dimensional analysis concepts Working knowledge of SQL




	Abstract
	IBM Education Advantage Program Eligibility: Yes - Education Pack - online account

Ce cours est donnÃ© par des formateurs certifiÃ©s IBM.

Ã€ titre de partenaire en formation agrÃ©Ã©e , ExitCertified peut vous inscrire Ã nâ€™importe quel cours en AmÃ©rique du Nord.

Il y a une diffÃ©rence. DÃ©couvrez-la

Code:	I5180
Format:	Formation virtuelle avec formateur

Durée:	5 days
Certifié par:	IBM

Frais d’inscription (CAD): $contact

TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) - ILO (I5180) Contenu détaillé

Getting Started

Identify the purpose of IBM Cognos Data Manager
Define data warehousing and its key underlying concepts
Identify how Data Manager creates data warehouses
Examine the Data Manager architecture and user interface

Create a Catalog

Examine the purpose and contents of Data Manager catalogs
Create a catalog
Define connections to source and target data
Access data using SQLTerm
Configure flat data source files using SQLTXT

Create Hierarchies

Examine the role of the dimensional framework in Data Manager
Examine hierarchies and their data sources
Identify how to create hierarchies from the columns of one table, the rows of one table, and from multiple tables
Test and view hierarchies
Create a hierarchy of static date values
Handle weeks in a date hierarchy

Create Basic Builds

Examine Data Manager builds and build-related terminology
Create a dimension build using the Dimension Build wizard
Create a fact build using the Fact Build wizard
Test and execute a fact build
Document a catalog
Create catalog schema

Create Derivations

Examine derivations
Apply operators and functions to derivations
Examine the derivation timing model
Add derivations to a fact build

Create Conformed Dimensions

Examine conformed dimensions and their advantages
Design conformed dimensions
Create conformed dimensions
Create data integrity lookups that use conformed dimensions

Customize Reference Structures

Create hierarchies manually using different approaches
Examine the features of a hierarchy
Examine literals
Set data access for hierarchy levels
Examine static and dynamic members
Examine fostering
Use derivations in a hierarchy

Process Dimensional History and Late Arriving Facts

Examine slowly changing dimensions (SCDs)
Use surrogate keys in SCDs
Manage type 1 and type 2 changes to dimensional data
Load historical data for a dimension
Examine late arriving facts
Process late arriving facts in a fact build

Transform Data Using Lookups and Derived Dimensions

Identify when to use lookups
Identify the requirements for a lookup
Create a translation lookup
Create an optional lookup
Add derived dimensions to fact builds

Customize Data Delivery

Configure fact and dimension delivery modules
Create indexes on fact and dimension tables
Update fact data using keys

Customize Fact Data Processing

Filter fact data
Merge duplicate fact data
Examine fact data integrity checking
Reject fact data

Aggregate, Filter, and Partition Fact Data

Aggregate fact data
Examine aggregate rules
Vertically restrict fact data
Horizontally restrict fact data
Partition fact data

Implement Job Control

Examine where job control fits into the data warehouse lifecycle
Create a JobStream
Add, link, and reposition nodes
Execute a JobStream and view the results

Automate Functionality Using Commands

Differentiate between the Command Line Interface (CLI) and Data Manager Designer
Identify common commands
Use commands in a batch file
Examine variables

Customize Functionality with User-Defined Functions and Variables

Examine user defined functions (UDFs)
Create an internal UDF
Create a user-defined variable

Process Unbalanced Hierarchical Data

Examine balanced, unbalanced, and ragged hierarchies
Add a recursive level to a hierarchy
Identify ways to balance a hierarchy and delivered flattened data
Examine circular references

Pivot Fact Data

Examine pivoting
Use the single pivot technique
Use the advanced pivot technique
Examine reverse pivoting

Resolve Data Quality Issues

Identify data quality and cleansing issues
Handle fostered and unmatched members
Perform debugging using SQLTerm and functions
Assess the quality of output data

Troubleshoot and Tune the Data Manager Environment

Use build logging to ensure that data marts are being loaded properly
Perform dimension breaking
Manage memory and resources
Export DDL statements

Organize and Package Data Manager Components

Export and import components using packages
Search for components in a catalog using Navigator

Integrate with IBM Cognos BI

Examine IBM Cognos BI
Identify the role of metadata dimensions, metadata collections, and metadata stars
Export Data Manager metadata to XML
Import Data Manager XML into Framework Manager
Use Data Manager metadata with IBM Cognos BI
Publish a data movement task to IBM Cognos Connection

End-to-End Workshop

Entity-Relationship Model of the GO_Demo Database (Optional)

Work in a Multi-Developer Environment (Optional)

Examine collaborative development support
Examine the source code repository
Examine the component dependency model
Identify planning considerations

Standardizing Dimensions and Facts Exercise (Optional)

Review of Data Manager Essentials (Optional)

Data warehouse design
The purpose of Data Manager components
Development steps in Data Manager to create data marts
Track dimensional changes and late arriving facts

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/ibm-training/I5180.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) - ILO (I5180)

Compétences acquises

Qui peut en profiter

Préalables

Abstract

Formation de IBM (2375 cours)

Formation de Cognos (131 cours)

Formation de BI - Cognos BI (version 10.1) (44 cours)

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) - ILO (I5180) Contenu détaillé