Cognos Traing Material

COGNOS 10 BI COURSE CONTENT
OVERVIEW OF COGNOS 10 BI
Introduce Cognos 10 BI Examine the different studios in Cognos 10 BI Identify the different data sources within the studios
COGNOS 10 INSTALLATION AND CONFIGURATION

Components used by Cognos 10 Server Components Modeling Components Installing Cognos 10 Uninstalling Cognos 10
COGNOS 10 BI ADMINISTRATION CREATE AND MODIFY A DATA SOURCE

Create Database backups Understand Roles, Users and Groups Specify Permission Settings
COGNOS 10 CONNECTION ADMINISTRATION

What is Cognos Connection? Examine Cognos Connection UI elements , Create a URL, Login, Logoff Personalize Cognos Connection Run and view reports View the run history of a report Organize content with folders and shortcuts Customize report outputs by using report views Schedule single and multiple reports Backups-Export of Cognos, Content. Store or select items for Backups Restore an exported Backup Create and Customize a Page and share a single page with Multiple Users
QUERY STUDIO
INTRODUCTION TO QUERY STUDIO

List the packages available for reporting Understand report types Add and save data to ad hoc reports View data by using charts
CREATE REPORTS IN QUERY STUDIO

Create list, grouped list, and crosstab reports List the charts available and their appropriate use Calculate and sort report data Define a custom group to create your own report Use shared dimensions to create multi-fact queries
ENHANCE REPORTS IN QUERY STUDIO

Highlight report items using conditional styles Focus the scope of a report using filters Format report objects Apply a report template
REPORT STUDIO
INTRODUCTION TO THE REPORTING APPLICATION

discuss different modes of reporting examine Report Studio and its interface explore different report types create a simple, sorted, and formatted report explore how data items are added to queries
CREATE LIST REPORTS

group, format, and sort list reports describe options for aggregating data create a multi-fact query create a report with repeated data
FOCUS REPORTS USING FILTERS

create filters to narrow the focus of reports examine detail and summary filters determine when to apply filters on aggregate data
CREATE CROSSTAB REPORTS

format and sort crosstab reports create complex crosstabs using drag and drop functionality create crosstabs using unrelated data items
PRESENT DATA GRAPHICALLY

create charts containing peer and nested columns present data using new chart type options add context to charts present key data in a single dashboard report
FOCUS REPORTS USING PROMPTS

identify various prompt types use parameters and prompts to focus data search for prompt types navigate between pages
EXTEND REPORTS USING CALCULATIONS

create calculations based on data in the data source add run-time information to the reports create expressions using functions
DESIGN EFFECTIVE REPORTS

enhance report design with report objects reuse objects within the same report share layout components among separate reports
CUSTOMIZE REPORTS WITH CONDITIONAL FORMATTING

create multi-lingual reports highlight exceptional data show and hide data conditionally render objects in reports conditionally format one crosstab measure based on another
DRILL-THROUGH FROM ONE REPORT TO ANOTHER

let users navigate from a specific report to a target report
pass parameter values to filter the data in drill-through targets navigate through multiple reports
DRILL-THROUGH DEFINITIONS

discuss parameter-driven drill through discuss dynamic drill through set up package-based drill-through definitions set scope use the Drill Through Assistant
MANAGE CONTENT IN IBM COGNOS CONNECTION

schedule and manage reports view lineage information organize content examine IBM Cognos Connection personal preferences set alerts and watch rules design a portal page and dashboard set permissions using IBM Cognos 10 BI groups and roles
EXAMINE THE REPORT SPECIFICATION

examine the report specification structure save and edit reports locally discuss considerations for modifying a report specification
CREATE QUERY MODELS

build query models and then connect them to the report layout add filters and prompts to a report using the query model edit an SQL statement to author custom queries
CREATE REPORTS BASED ON QUERY RELATIONSHIPS

create reports by merging query results create reports by joining queries combine data containers based on relationships from different queries
DISTRIBUTE REPORTS THROUGH BURSTING

distribute reports using bursting create burst keys identify report recipients and data items using burst tables distribute reports using email and IBM Cognos Connection
CREATE ADVANCED DYNAMIC REPORTS

filter reports on session parameter values navigate a briefing book using a table of contents create dynamic headers and title that reflect report data let users navigate to specific locations in reports create a customer invoice report
DESIGN EFFECTIVE PROMPTS

control report displays using prompts specify conditional formatting values using prompts create a report that formats based on prompts selection create a sorted and filtered report based on prompt selection
CREATE ADDITIONAL ADVANCED REPORTS

create a report that displays summarized data before detailed data highlight alternate rows in a list report
ANALYSIS STUDIO
ANALYSIS STUDIO FUNDAMENTALS

Define the fundamental terms of Analysis Studio Explain how to insert objects Define and create sets Identify the work area, overview area, and properties pane
TOOLS FOR INVESTIGATION IN ANALYSIS STUDIO

Employ drilling down and up to different levels of detail Apply changes to rows, columns, and measures in the analysis Explain how to change the display of data Use charts to display data graphically
NEST DATA IN CROSSTABS IN ANALYSIS STUDIO

Apply depth to rows and columns by nesting data Recognize drill behavior in nested rows and columns Demonstrate how to swap nested levels
BUILD ADVANCED CROSSTABS IN ANALYSIS STUDIO

Demonstrate how to view a complete level of data Design a crosstab without retrieving data Compare multiple measures Apply stacked sets to the crosstab Construct an asymmetrical crosstab Compose a custom sort
FOCUS WITH FILTERS IN ANALYSIS STUDIO APPLY FILTERS USING EXPRESSIONS

Apply filters using the Context area Create top and bottom lists Use several techniques to remove rows and columns
FRAMEWORK MANAGE (METADATA MODELING)

Introduction to Framework Manager Framework Manager Basics User Interface, Navigation, Objects Designing Project Create project Importing Metadata Exporting Metadata Create Model Documentation Data Sources Working with Data Source Connections Create and Modify Data Sources Improve Performance by setting Query Processing Type Preparing Relational Metadata for use in Reports Verifying Relationships Working with Dimensions Working with Query Subjects Working with Query Items Supporting Multilingual Metadata Adding Business Rules Organizing the Model
Making Metadata Available to Report Authors Verify Model Set Governors Improving Performance Create or Modify Package Controlling access to Metadata Explore Package Publish Package Guideline for Modeling Metadata Scenarios New Objects - Regular Dimensions, Measure Dimensions, Scope Relationship Dimensional Modeling of Relational Data Sources
WHATS NEW COGNOS 10 BI

BUSINESS INSIGHT

Business Insight Advanced Active Reports Manage External Data List Enhancements Custom Properties for Prompts Enhancements to the User Interface
INFORMATICA 9 COURSE CONTENT

DATA WAREHOUSING CONCEPTS
Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture
E T L INFORMATICA POWER CENTER 9

POWER CENTER COMPONENTS
Designer Repository Manager Workflow Manager Workflow Monitor
INFORMATICA CONCEPTS AND OVERVIEW

Informatica Architecture. Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks
SOURCES
Working with relational Sources Working with Flat Files Working with Relational Targets Working with Flat file Targets
TARGETS
TRANSFORMATIONS
Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation
Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings
POWER CENTER TRANSFORMATION LANGUAGE

Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions
ADVANCED INFORMATICA CONCEPTS

Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations. User Defined Functions. Tasks And Types of Tasks. Worklet and Types of Worklets. Scheduling Work flow Constraint Based Load Ordering. Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading. Push Down Optimization. PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches. o Static LookUp Cache o Dynamic LookUp Cache o Perisistance lookup Cache o Shared LookUp Cache
ETL UNIT TESTING ETL PERFORMANCE TESTING ETL PERFORMANCE OPTIMIZATION TECHNIQUES TASK IMPLEMENTATIONS.
Command EMAIL Timer Event Wait Event Raise Decision Assignment Control Worklet Session

Cognos Traing Material

Uploaded by

Copyright:

Available Formats

Cognos Traing Material

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cognos Traing Material

Uploaded by

Copyright:

Available Formats

COGNOS 10 BI COURSE CONTENT

COGNOS 10 INSTALLATION AND CONFIGURATION

COGNOS 10 BI ADMINISTRATION CREATE AND MODIFY A DATA SOURCE

COGNOS 10 CONNECTION ADMINISTRATION

CREATE REPORTS IN QUERY STUDIO

ENHANCE REPORTS IN QUERY STUDIO

CREATE LIST REPORTS

FOCUS REPORTS USING FILTERS

CREATE CROSSTAB REPORTS

PRESENT DATA GRAPHICALLY

FOCUS REPORTS USING PROMPTS

EXTEND REPORTS USING CALCULATIONS

DESIGN EFFECTIVE REPORTS

CUSTOMIZE REPORTS WITH CONDITIONAL FORMATTING

DRILL-THROUGH FROM ONE REPORT TO ANOTHER

MANAGE CONTENT IN IBM COGNOS CONNECTION

EXAMINE THE REPORT SPECIFICATION

CREATE QUERY MODELS

CREATE REPORTS BASED ON QUERY RELATIONSHIPS

DISTRIBUTE REPORTS THROUGH BURSTING

CREATE ADVANCED DYNAMIC REPORTS

DESIGN EFFECTIVE PROMPTS

CREATE ADDITIONAL ADVANCED REPORTS

TOOLS FOR INVESTIGATION IN ANALYSIS STUDIO

NEST DATA IN CROSSTABS IN ANALYSIS STUDIO

BUILD ADVANCED CROSSTABS IN ANALYSIS STUDIO

FOCUS WITH FILTERS IN ANALYSIS STUDIO APPLY FILTERS USING EXPRESSIONS

FRAMEWORK MANAGE (METADATA MODELING)

WHATS NEW COGNOS 10 BI

INFORMATICA 9 COURSE CONTENT

E T L INFORMATICA POWER CENTER 9

Designer Repository Manager Workflow Manager Workflow Monitor

INFORMATICA CONCEPTS AND OVERVIEW

POWER CENTER TRANSFORMATION LANGUAGE

ADVANCED INFORMATICA CONCEPTS

You might also like