Cognos Online Training

IBM Cognos  Online Training By IT Experts :

Online Training USA Solutions training is the leading IBM Cognos Business Intelligence Training Provider in all over the world. IQ training has a vast experience of over 10 years in the field of IT Training and its geographic reach has been growing very quickly. We have been continually offering highly impressive IBM Cognos BI Training through innovative technology. IQ has continue to be a reliable Global leader in IBM Cognos Business Intelligence Training by delivering utmost quality training services.

What Is IBM Cognos BI?

Cognos is IBM’sBI- business intelligence and performance managing software platform. The software is made to aidenterprise users without technical information to extract business data, review it and build reports. IBM Cognos Business Intelligence (BI) provides reports, research to assist support just how people consider and perform if they are trying to understandperformance of business. You may easilysearchfor data, evaluate key points and easily collaborate to align decisions with key shareholders.

Course Objectives:

• Build and maintain reports using Query and Report Studio.
• How to analyze your data in Analysis Studio.
• Understanding modelling metadata and creating packages for report building.
• Install, configure and manage security and content in the IBM Cognos Environment.
• Build and maintain reports using Impromptu.
• Exploration for analysis and reporting on data in a multidimensional cubes

Cognos 10.1/10.2 Training Course Contents

Module 1: Introduction to Data Warehouse

• Introduction to DWH
• Characteristics of DWH
• Data Warehouse Concepts
• Data mart Vs. Data Warehouse
• Data warehousing architecture
• OLAP vs. OLTP
• Business Intelligence Concepts
• ETL Concepts
• Reporting Concepts
• Industry leading ETL and Reporting tools
• Define Fact, dimension and identifier
• Star schema and Snowflake schema
• Slowly changing dimension

Module 2: Introduction to Cognos

• About Cognos 10.1
• 3 – Tier Cognos 10.1 Architecture
• Cognos Connection
• Query Studio
• Event Studio
• Report Studio
• Analysis Studio
• Framework Manager

Module 3: Cognos Connection

• Log on to Cognos Connection
• Models and Packages
• Create a URL Create a shortcut
• Properties of an Entry
• Search for an Entry
• Bookmark an Entry
• Personalize the portal
• Scheduling and manage reports
• Create Jobs

Module 4: Introduction to Query Studio

• Introduction
• Features in Query Studio
• About Ad-hoc Reports
• Types of Report (List, Cross Tab, Chart Reports & Others)
• Applying Filters, Prompts & Calculations
• Sorting, Grouping, Sections & Aggregate Functions
• Apply page break on Reports
• Run and Manage reports
• Define custom group
• Conditional formatting
• Expand and Collapse groups
• Apply Swap and Rows on Reports

Module 5: Introduction to Report Studio

• Basic Report Structure
• User Interface
• Work with Objects Set options
• Create a Report
• Page Structure View
• Reports Layout
• Reuse objects
• Set object properties

Module 6: Work with Data

• Filter Data
• Sort Data
• Create Sections
• Format Data
• Header & Footer
• Add a Summary
• Create Calculations

Module 7: Prompts & Advanced Reports

• Include Prompts
• Build Prompt Page Tool
• Prompts & Prompt Page
• Insert prompts into the report
• Manage changes in the model
• Conditional Formats
• Drill-through reports
• Master-detail reports

Module 8: Cognos 10.1 Active Reports

• Introduction to Active reports
• Key Features
• Purpose
• Active Report structure
• Row Number
• Variable Text item
• Deck & Data Deck objects
• Tab Control& Data Tab Control
• Button Bar & Data Button Bar
• Toggle Button Bar & Data Toggle Button Bar
• Radio Button Group & Data Radio Button Group
• Check Box Group & Data Check Box Group

Module 9: Framework Manager – I

• Introduction to Framework Manager
• Objects to work with – Projects, Models, Query subjects, etc.
• Create a project
• Work with Metadata
• Multilingual Reports
• Manage Projects
• Work with dimensions
• Modify properties of Query Items
• Create a filter
• Organize the model

Module 10:Framework Manager -II

• Verify models
• Create & modify packages
• Access to metadata
• Publish a package
• Authorization
• Cognos Namespaces
• Application security
• Users, Groups & Roles
• Access Permissions
• Initial Security setup
• Content Store security
• Deployment Specs & Planning
• Deploy Cognos Entries

Module 11: Introduction to event Studio

• Basic event Studio structure
• Working with different Tasks
• Managing the Task execution rules
• Reordering the tasks
• Work with New calculation item
• Running the event report

Module 12: Introduction to Analysis Studio/Cubes:

• Insert Data
• Change the number of Visible Items
• Analyze data using Analysis Studio
• Nest Data
• Replace Data
• Sort Data
• Explore Data
• Define a filter