Cognos BI

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.
• 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

• 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.