Course: Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) B5180CN
Durations:4
Fees:10000RMB

Outline
1、Getting Started
 Identify the purpose of 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

2、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

3、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

4、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

5、Create Derivations
 Examine derivations
 Apply operators and functions to derivations
 Examine the derivation timing model
 Add derivations to a fact build

6、Create Conformed Dimensions
 Examine conformed dimensions and their advantages
 Design conformed dimensions
 Create conformed dimensions
 Create data integrity lookups that use conformed dimensions

7、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

8、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

9、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

10、Customize Data Delivery
 Configure fact and dimension delivery modules
 Create indexes on fact and dimension tables
 Update fact data using keys

11、Customize Fact Data Processing
 Filter fact data
 Merge duplicate fact data
 Examine fact data integrity checking
 Reject fact data

12、Aggregate, Filter, and Partition Fact Data
 Aggregate fact data
 Examine aggregate rules
 Vertically restrict fact data
 Horizontally restrict fact data
 Partition fact data

13、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

14、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

15、Customize Functionality with User-Defined Functions and Variables
 Examine user defined functions (UDFs)
 Create an internal UDF
 Create a user-defined variable

16、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

17、Pivot Fact Data
 Examine pivoting
 Use the single pivot technique
 Use the advanced pivot technique
 Examine reverse pivoting

18、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

19、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

20、Organize and Package Data Manager Components
 Export and import components using packages
 Search for components in a catalog using Navigator

21、Integrate with Cognos BI
 Examine 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 Cognos BI
 Publish a data movement task to Cognos Connection

22、End-to-End Workshop

23、Entity-Relationship Model of the GO_Demo Database (Optional)

24、Work in a Multi-Developer Environment (Optional)
 Examine collaborative development support
 Examine the source code repository
 Examine the component dependency model
 Identify planning considerations

25、Standardizing Dimensions and Facts Exercise (Optional)

26、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
