IBM Cognos Online Training

 About the Cognos:

The IBM Cognos AnalyticsV11 training course is designed to provide knowledge and skills to become a successful Report Developer and Framework Manager Modeler and Admin.

The course starts with fundamental concepts like Cognos Architecture, Cognos Services and covers advanced topics like Analysis, Report & Query Studio, Advanced & Interactive Reporting, and Cognos Administration. Also you will get an end-to-end experience on how to use the Cognos Tool effectively for business.

Cognos Course Purpose

Who should learn Cognos
Prerequisites to learn Cognos

Objectives Of Cognos Training

IBM Cognos Online Training

                        Cognos 11 Online Training

Data warehousing Basics

Learning Objectives 

In this module, you will be introduced to business intelligence, data warehousing concepts like the architecture, its characteristics.

Topics – 

  • Why should we consider Data Warehousing solutions?
  • Definition of Data Warehouse
  • Characteristics of DWH
  • Difference between DW’s and OLTP
  • DWH Life Cycle
  • DWH Architecture
  • Dimensions & Facts
  • Star Schema & Snowflake Schema Design

WHAT’S NEW IN COGNOS 11.0.6 ANALYTICS?

IBM COGNOS Analytics ADMINISTRATION

  • What is IBM Cognos Analytics?
  • Examine IBM Cognos Analytics UI elements
  • 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
  • Create Data source
  • Deployment
  • Users, Groups and Roles

 Cognos 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 Visualizations available and their appropriate use
  • Calculate and sort report data

ENHANCE REPORTS IN QUERY STUDIO

  • Highlight report items using conditional styles
  • Focus the scope of a report using filters
  • Format report objects

IBM Cognos Frame Work Manager: Relational Metadata Modeling

Learning Objectives – In this module, you will be introduced to IBM Cognos Framework Manager and you will understand the workflow process. You will also learn how to set relationships, perform calculations, apply filters and create star schema among the various query subjects.

Topics – 

  • Introduction to Cognos Framework Manager
  • User Interface, Navigation, Objects
  • Designing Project
  • Create project
  • Importing Metadata
  • Working with Data Source Connections
  • Create and Modify Data Sources
  • 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
  • Verify Model
  • Set Governors
  • Create or Modify Package
  • Publish Package
  • Object ,Data and package security
  • Making Metadata Available to Report Authors
  • Edit Governors
  • Guidelines for Modeling Metadata
  • DMR model – Regular Dimensions, Measure Dimensions, Scope Relationship

 Advanced report authoring

Learning Objectives – This module is a deep-dive into report authoring, linking two reports and displaying one report layer based on others using prompts? You will be given an opportunity to use union, intersection and join operations. You will acquire knowledge on how to distribute one report contents to various recipients.

INTRODUCTION TO THE REPORTING APPLICATION

  • 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

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

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

EXAMINE THE REPORT SPECIFICATION

  • Examine the report specification structure
  • Save and edit reports locally
  • Discuss considerations for modifying a report specification

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

ACTIVE REPORTS

  • Active Reports Introduction
  • Create active report templates
  • Describe active report connections, Apply Filter and Select behavior to active report controls
  • Identify active report controls and variables in a report
  • Use variables to control multiple controls independently
  • Describe characteristics of traditional charts in active reports
  • Control data display using decks and data decks

 

COGNOS 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

 

Handouts:

  • Data warehousing concepts ppt
  • Cognos Connection ppt along with screenshots
  • Query studio ppt along with screenshots
  • Report studio ppt along with screenshots
  • Framework Manager ppt along with screenshots
  • Analysis Studio ppt along with screenshots

Click here to register for the  IBM Cognos 11 Online Training.

IBM Cognos BI 10.2 Online Training Video Tutorials

Click here to enroll for Live IBM Cognos Online Training classes & Cognos self paced Video Tutorials

 

About our IBM Cognos Online Training instructor:

 

  • Trainer is working in the visible MNC.
  • Got 10+ years of experience and industry expert.IBM Cognos Online Training
  • Trained more than 550 students online.
  • Certified and corporate trainer.
  • Expertise in Online Training and Classroom training.
  • Cognos Interview Questions.
  • Hands on Cognos online training.

Click here to enroll for Live IBM Cognos 10.2 Online Training classes