Menu
or
All Courses
INR USD

Cognos BI

Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports.

Why this course ?

From Business Intelligence to financial performance; from strategy management to analytics applications, Cognos software provides what your organization needs to become an analytics-driven top performer.

Course Features

  • Instructor Live Sessions

    30hrs of Online Live Instructor-led Classes. Weekend class:10 sessions of 3 hours each and Weekday class:15 sessions of 2 hours each.
  • Real-life Case Studies

    Live project based on any of the selected use cases on the above selected Domain.
  • Assignments

    Each class will be followed by practical assignments which can be completed before the next class.
  • Lifetime Access

    You get lifetime access to the Learning Management System (LMS). Class recordings and presentations can be viewed online from the LMS.
  • 24 x 7 Expert Support

    We have 24x7 online support team available to help you with any technical queries you may have during the course.
  • Certification

    Towards the end of the course, you will be working on a project. Covalent certifies you as an course Expert based on the project.

Course Curriculum

Download
  • Cognos BI course content

    Overview of Cognos 8 BI

    • Introduce Cognos 8 BI
    • Describe IBM Cognos 8 BI components
    • Describe IBM Cognos 8 architecture at a high level
    • Define IBM Cognos 8 groups and roles
    • Explain how to extend IBM Cognos8

     

    Cognos 8 Installation and Configuration

    • Components used by Cognos 8
      • Server Components
      • Modeling Components
    • Installing Cognos 8
    • Setting up the Environment
    • Configuring Cognos 8
    • Setting up Samples
    • Uninstalling Cognos 8

     

    Cognos 8 Framework Manager

    • Introduction to Framework Manager
      • Framework Manager Basics
      • User Interface, Navigation, Objects
      • Planning the project and data model
      • Naming Conventions for objects in a project
    • Designing Project
      • Create project
      • Importing Metadata
      • Exporting Metadata
      • Multi-user Modeling
      • Segmenting and Linking
      • 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 - Determinants, Regular Dimensions, Measure Dimensions, Scope Relationship
      • Dimensional Modeling of Relational Data Sources
    • Types of Security
      • Data Level
      • Objective Level
      •  Package level                        

       

    • SQL Generated by Cognos 8
      • Understanding Dimensional Queries
      • Resolving Ambiguously Identified Dimensions and Facts
      • Resolving Queries that should not have been split
      • Resolving Queries that are split in the wrong place
    • Optimizing PowerCubes
    • Deployment of PowerCubes to the Cognos Connection

     

    Cognos 8 Connection

    • Examine 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
    • Personalize Cognos Connection
    • Creation of Portal pages

     

    Cognos 8 Query Studio

    • Introduction to Query Studio
    • Create Reports (List, Grouped List, Crosstab, Charts)
    • Changing the Appearance of Reports (Format)
    • Sorting and Grouping
    • Filters and Prompts
    • Subtotals and Calculations
    • Run and Manage Reports
    • Drill Through reports

     

    Cognos 8 Report Studio

    • Introduction to Report Studio
      • Report Studio User Interface
      • Creating, Save and Run Reports
      • Report Templates
      • Managing Reports
    • Formatting a Report
      • Report Layout Guidelines
      • Fonts, Styles, Header, Footer and Borders
      • Insert objects
      • Apply Table Styles
      • Swap Columns and Rows
    • Create Additional Advanced Reports
      • create a report that displays summarized data before detailed data
      • highlight alternate rows in a list report
      • use single data items to summarize report information
      • save reports to server file system
      • Drill-through Reports
      • Drill-up/Drill-down Reports
      • Master-Detail Reports
      • Scheduling Reports
    • Working with Data
      • Filters, Parameters and Prompts
      • Sorting and Grouping
      • Subtotals and Calculations
      • Working with Queries
    • 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 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                                 

Projects

  • Cognos BI project

    Real time case studies.

    1. Creation of Financial data warehousing solution

    2. Creation of sales data warehousing solution

     

FAQ's

  • Can I attend a demo session before enrolment?

    Yes

  • What if I miss a class ?

    If you miss a class we can provide recording video for particular session and same session you have to attend another batch also

  • Will I get placement Assistance ?

    Yes

  • Do I receive a certificate for training ?

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.
  • what support is available after the training?

    Doubts clarification up to getting a job

    Resume preparation

    Mock interviews

    Placement Assistance

  • What Features do you provide?

    • Led sessions with corporate trainers
    • Course Material
    • Real time projects with industry experts
    • Day wise Assignments (Tasks)
    • Lab facilities
    • Placement assistance
    • Resume preparation
    • Software installation
    • Doubts  clarifications

Certifications

  • Course Completion Certificate

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.

Videos

Cognos BI Videos are Under construction

Reviews

Pochi Reddy

IT analyst

Definitely there is no doubt in saying that all the instructors at covalent are industry experienced and the support staff provides a quick response to the tickets you log whether it be Day or Night. I like the way the sessions have been organized, with the Pre-requisites required for the next session and the assignments. You can find enough of required information in the forums. Finally with their help understanding complete concepts in a correct way.

readmore...

Linga Reddy

Financial analyst

It is my great thank to team at Covalent for the valuable learning experience within a period of time with well-structured and planned course design.

readmore...

Enroll Now

© 2018 Covalent Technologies All rights reserved

Drop us a Query

Drop us a Query

Call us on

IN: 91-9848733309
IN: +91-9676828080