BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

IBM COGNOS Training


IBM Cognos BI Course Content

  

Day 1

Data Warehouse Basics 1

  • Introduction to DWH
  • Characteristics of DWH
  • Data Warehouse Concepts
  • Data mart Vs Data Warehouse
  • Data warehousing architecture
  • OLAP vs OLTP
  • ODS
  • OLAP tools
  • Tactical info Vs Strategic info
  • Analytical Systems Vs Operational Systems

Day 2

Data Warehouse Basics 2

  • 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

 Day3

Introduction to Cognos

  • About Cognos 10.1
  • Cognos Connection
  • Query Studio
  • Event Studio
  • Report Studio
  • Analysis Studio
  • Framework Manager

Day4

Cognos Architecture

3 – Tier Cognos 10.1 Architecture

Day 5

Framework Manager – I

  • Introduction to Framework Manager
  • Objects to work with – Projects, Models, Query subjects, etc
  • Create a project
  • Import Metadata
  • Work with Metadata

Day 6

Framework Manager – 2

  • Manage Projects
  • Work with dimensions
  • Modify properties of Query Items
  • Create a filter
  • Organize the model

Day 7

Framework Manager -3

  • Creating Layers
  • Cardinality
  • Joining Query Subjects

Day 8

Framework Manager -4

  • Different Types of Query Subjects
  • Differences between Model and Data source Query Subjects

Day 9

Framework Manager -5

  • Users, Groups & Roles
  • Access Permissions
  • Different types of Framework Manager Securities 

Day 10

Framework Manager -6

  • Verify models
  • Create & modify packages
  • Access to metadata
  • Publish a package
  • Authorization
  • Cognos Namespaces
  • Deployment Specs & Planning
  • Deploy Cognos Entries

Day 11

Framework Manager -7

  • Different Types of Options to discuss
  • Interview Questions

 Day 12

Cognos Connection

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

 Day 13

Query Studio-1

  • 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

 Day 14

Query Studio-2

  • Apply page break on Reports
  • Run and Manage reports
  • Define custom group
  • Conditional formatting
  • Expand and Collapse groups
  • Apply Swap and Rows on Reports

 Day 15

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

Day 16

Data Containers 

  • List Properties
  • Crosstab Properties
  • Chart Properties

Day 17

Work with Data

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

Day 18

Report Studio Prompts

  • Include Prompts
  • Prompts & Prompt Page
  • Insert prompts into the report
  • Different Types of Prompts
  • Prompt Properties

Day 19

Report Studio Tool Box items-1

  • Repeater Table
  • Block
  • Table
  • Repeater
  • Field Set
  • Singleton
  • Map

 Day 20

Report Studio Tool Box items-2

  • Layout Calculation
  • Query Calc
  • Image
  • HTML item
  • Hyper Link
  • Page Number
  • Row Number

 Day 21

Advanced Reports:

  • Render Variable
  • Style Variable
  • Conditional blocks
  • Conditional Formats
  • Drill-through reports
  • Master-detail reports

Day 22

Cognos 10.1 Active Reports-1

  • Introduction to Active reports
  • Key Features
  • Purpose
  • Active Report structure
  • Row Number
  • Variable Text item
  • Deck & Data Deck objects

Day 23

Cognos 10.1 Active Reports-2

  • 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

Day 24

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

 Day 25

Introduction to Analysis Studio/Cubes

  • Introduction of analysis Studio
  • Dimensional Package
  • Insert Data
  • Context Filter

 Day 26

Analysis Studio concepts

  • Insert Data
  • Analyze data using Analysis Studio
  • Replace Data
  • Sort Data
  • Explore Data

Day 27

IBM Cognos Administration

  • Brief about Cognos Installation and Configuration
  • Securities

Day 28

IBM Cognos Administration

  • Migration or Deployment
  • Server maintenance

Day 29

IBM Cognos Interview Questions

 

  • Request Demo