Cognos BI Developer Corporate Training in Hyderabad

Cognos BI is one of the leading BI tools in the industry. Cognos BI developer training covers the basics of DW&BI, Cognos Connection, different studios like, Query Studio, Report Studio, Advanced Report Studio, Analysis Studio and Event Studio. It also covers Business Insight that includes building and managing dashboards. The modeling tool, Framework Manager is covered extensively to train the participants on how to prepare and build objects and metadata to be used in reports.

Cognos Training Course Content

Datawarehousing Concepts

  • What is DWH?
  • Characteristics of Datawarehouse
  • Difference between OLTP and DWH
  • Architecture of DWH
  • Various BI tools
  • Types of DWH
  • Types of Dimensional Data Modeling
  • Surrogate key
  • Types of Dimension

DW & BI Basic Concepts

  • RDMBS Introduction
  • DW Architecture
  • Star Schema
  • Snowflake Schema
  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Data Mart
  • OLAP, MOLAP, ROLAP
  • Cubes
  • BI Uses
  • Dimensional Model
  • Fact Tables
  • Lookup Tables
  • Hierarchy
  • Cognos Vs Other BI Tools
  • BI Vendor Comparison

Introduction to IBM Cognos

  • Cognos 10.1 Architecture
  • Content store
  • Content Manager
  • Dispatcher
  • Cognos Vs Other OLAP tools
  • Product Overview
  • New Features of Cognos 10.1

IBM Cognos Connection

  • Understanding Packages
  • Components of Cognos Connection
  • Personalizing Cognos Connection
  • Organizing the Reports
  • Activity and Scheduling
  • Properties
  • Create New Page
  • Job
  • Workspace
  • My Inbox
  • My preference

Cognos Query Studio

  • Types of Reports
  • (List, Cross tab (Pivot) & Chart)
  • Filters
  • Prompts
  • Calculations
  • Grouping
  • Sections and Sorting
  • Aggregate Functions & Calculations
  • Page Breaks
  • Conditional Styles & Formatting
  • Apply Template
  • Preference settings

Report Studio

  • Report Templates
  • Formatting Reports
  • Grouping, Sorting
  • Summarizing data
  • Report Sections
  • Working with Variables
  • Parameters
  • Filters
  • Multiple Filter
  • Prompts
  • Cascading Prompt
  • Types of Prompt
  • Conditional Formatting
  • Report Functions & Calculations
  • Repeater Table
  • Using Maps
  • Advanced Chart Options
  • Multiple Page Report
  • Export Into Different
  • Format PDF,XML,XL,CSV
  • Validate Report

Report Studio Advanced

  • Using other toolbox objects
  • Conditional Style
  • Table of contents Reports
  • Using Bookmarks
  • Master Detail Report
  • Conditional Block
  • Unlocking Objects
  • Managing Report queries
  • Drill through reports
  • Report Bursting
  • Using External Data
  • Query Expressions
  • Query Calculations
  • Layout Calculations
  • Generated SQL/MDX Query
  • Active Reports

Analysis Studio

  • Analysis Studio Fundamentals
  • Nest Data in Crosstabs in Analysis Studio
  • Create Analysis with Multiple filter
  • Reusable analysis
  • Build Advanced Crosstabs in Analysis Studio
  • Focus with Filters in Analysis Studio
  • Extend the Analysis

Event Studio

  • Introduction to Event Studio
  • Create an agent
  • Add tasks to an agent
  • Run an agent through its lifecycle
  • Schedule an agent

Business Insight

  • Dashboards – Introduction
  • Create Dashboard
  • Value Filter
  • Slider Filter
  • Using RSS Feed
  • Using web Page
  • Content Pane
  • Widgets
  • Sort, Filter and Calculate data
  • Advanced Filters
  • Lab & Exercise

Business Insight Advanced

  • BI – Advanced : Interface
  • Create Different types of Reports
  • Reporting Styles
  • Create dashboard objects
  • Summarize data and Create Calculations
  • Adding Filters

Cognos Framework Manager

  • Objects Introduction
  • Metadata Modelling
  • Design & Create a Project
  • Data source connection
  • Namespaces
  • Database view
  • Business view
  • Presentation view
  • Cardinality Relationships
  • Model Query Subjects
  • Data source Query subjects
  • Query items
  • Determinants
  • Regular Dimension
  • Measure Dimension
  • Model Filters, Prompts & Calculations
  • Business Logic
  • Preparing the Metadata
  • Creating Star Schema
  • Data level Security
  • Object Level Security
  • Package Level Security
  • Verify Objects
  • Performance Tuning
  • Create & publish Packages

Cognos Training Course Highlights

  • Trainers with 6 – 12 years experience in the industry
  • Extensive coverage of all types of reports and all studios
  • Demo will be performed for all types of reports, dashboards and scorecards
  • Most suitable for BI developers with/without prior BI knowledge

Advanced Cognos BI Developer Training in Hyderabad

Cognos BI is one of the leading BI tools in the industry. Cognos BI developer advanced training covers Metric Studio, Metric Designer and Transformer. Basic knowledge of BI reporting and multi dimensional cubes is a pre requisite for this training.

Metric Studio

  • Identify scorecards, metrics, and metric types
  • Organize metrics with strategies
  • Track initiatives with projects
  • View metric history
  • Address problems with actions
  • Monitor status visually with diagrams
  • Verify metric details
  • Quickly access important metrics
  • Create a scorecard
  • Create metrics
  • Enter metric values
  • Customize Metric Studio
  • Report on Metric Studio data

Metric Designer

  • Import data into scorecards using Text files Export Data
  • Metric designer introduction
  • Create Metric Extracs
  • Cube based Metrics extract
  • Relational framework manager based extract
  • Execution
  • Schedule and publish extracts
  • Create a complete extract, publish and execute.

Transformer

  • Transformer Overview
  • Data Sources in Transformer
  • Dimensions
  • Define Measures
  • Measures Allocation
  • Build cubes
  • Drill through in Cognos

Cognos BI Administrator Training in Hyderabad

Cognos BI is one of the leading BI tools in the industry. Our Administrator course is having an extensive coverage of topics needed for the Administrators to perform better in a corporate environment. The training starts with an introduction to Cognos BI, Architecture, Installation, Security Configuration, Explains Security Model, User Management, Cognos Connection Administration, Data Source connection management, Job scheduling, Dispatcher, Services, and Performance Tuning.

IBM Cognos Administration Introduction

  • BI Environment
  • Role of the Administrator
  • IBM Cognos workflow process.
  • Configuration user interface

IBM Cognos Architecture

  • BI Environment
  • Cognos Workflow
  • Content Manager
  • Content Store

Cognos Installation and Configuration

  • Pre Requisites
  • New Cognos Installation
  • Configure with web server
  • Configure without we server
  • Cognos Configuration Settings
  • Mail server settings
  • Content store connection

Security Configuration

  • NTLM Security
  • Virtual Directory
  • Windows NT setup
  • LDAP
  • Security setup in Cognos Configuration
  • Security connection information

IBM Cognos Security Model

  • User
  • Groups
  • Default authorization
  • Authentication and authorization
  • Security policies
  • Secure administrative capabilities
  • Security settings after installation.
  • Security in Cognos Framework Manager

Create User, Group in Cognos

  • Create new user, Group in
  • Cognos directory
  • Administrative capabilities

Admin IBM Cognos Connection

  • Understanding Packages
  • Components of Cognos Connection
  • Personalizing Cognos Connection
  • Organizing the Reports
  • Properties
  • Create New Page
  • Job
  • Workspace
  • My Inbox
  • My preference

New Data source Connection

  • Single source Database connection
  • Dynamic Query Mode
  • Cube Connection

Administer the IBM Cognos BI

  • Server Environment
  • Dispatcher
  • Services
  • Monitor all bi services
  • Set preference

Manage Content in IBM Cognos Administration

  • Import Cognos Content
  • Export reports, Folders, Packages Into deployment.
  • Content Maintenance

Manage Run Activities

  • Current Activities
  • Past Activities
  • Upcoming Activities
  • Manage Schedules

Manage Run Activities

  • Present Report to Consumer
  • Consumer capabilities
  • Self Querying

Jobs Scheduling

  • Create Schedule
  • Create Jobs
  • Scheduling Options
  • Delivery Type

Dispatcher and Services

  • Dispatcher in detail
  • All Services
  • Properties of Services

Performance Tuning

  • Over View of Performance Tuning
  • Performance tuning settings
  • Services