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