IBM Cognos BI Certification Training

Become an expert in using Cognos BI tool by mastering concepts like Metadata Modelling, Report Authoring, Dynamic Cubes and others, while working on industry based use-cases and projects.
Edureka's Cognos Training is in partnership with IBM


Watch the demo class

Why this course ?

  • 628 + satisfied learners. Reviews

Instructor-led live online classes

17

Nov
Fri - Sat ( 5 Weeks )
09:30 PM - 12:30 AM ( EDT )
10% Off
19995
17995

06

Jan
Sat - Sun ( 5 Weeks )
11:00 AM - 02:00 PM ( EDT )
10% Off
19995
17995

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.

Instructor-led Live Sessions

30 Hours of Online Live Instructor-led Classes. Weekend class : 10 sessions of 3 hours each.

Real-life Case Studies

Live project in which there will be creation of data warehousing solutions.

Assignments

Every class will be followed by practical assignments which aggregates to minimum 40 hours.

Lifetime Access

Lifetime access to Learning Management System (LMS) which has class presentations, quizzes, installation guide & class recordings.

24 x 7 Expert Support

Lifetime access to our 24x7 online support team who will resolve all your technical queries, through ticket based tracking system.

Certification

edureka! certifies you as 'IBM Cognos BI Professional' based on your project performance, reviewed by our expert panel.

Forum

Access to global community forum for all our users that further facilitates learning through peer interaction and knowledge sharing.

The IBM Cognos BI training course is designed to provide knowledge and skills to become a successful Business Analyst. The course starts with fundamental concepts like Cognos Architecture, Cognos Services, Troubleshooting the server environment and covers advanced topics like Analysis & Query Studio, Advanced & Interactive Reporting, Cognos Administration and a technical deep dive into the DMR Package in Cognos etc. You will also get an opportunity to explore Dynamic Cubes, how to style OLAP queries, thereby helping you to get an end-to-end experience on how to use the Cognos Tool effectively for business.

After completion of the IBM Cognos course at Edureka, you will be able to:

1. Perform a single server or distributed server installation and configuration of the IBM Cognos BI tool

2. Explore Framework Manager and Cognos Administration

3. Apply dimensional information to relational Metadata to enable OLAP-style queries

4. Learn about the DMR package and how to publish new packages

5. Examine the IBM Cognos BI security environment

6. Identify and implement techniques to optimize and tune your Framework Manager models

7. Achieve minimized SQL

8. Examine Query Studio, Report Studio and its Work Area interface

9. Create various types of Reports using the Cognos tool

10. Understand Multi-fact, Multi-grain and Stitch Queries

11. Get an overview about the Dynamic Query Mode

12. How to work in a Multi-Modeler Environment

13. Edit an SQL statement to author custom queries

14. Manage the caches in the Cognos Administration

15. Understand Determinants

This course is designed for students/professionals who are interested in working in the analytics industry ideally for:

1. Developers who want to gain knowledge of Cognos Development for creating queries and reports

2. Analysts who want to make smarter business decisions

3. Data Engineers and Statisticians

The pre-requisite for this course include basic knowledge of SQL and DBMS.

Cognos is a very powerful tool for statistical and predictive analysis. This training will help you make smarter business decisions by focusing on the actual data and provides a self-service interface to generate reports easily. You will master the various techniques to convert raw data into meaningful information.

Learning Objectives - In this module, you will be introduced to business intelligence, data warehousing concepts like the architecture, its characteristics. Also you will learn in brief about the types of OLAP, perform ETL operations using Informatica. You will learn how to design Framework Manager and DMR.

Topics - Study 3 tier platform architecture, Explore the IBM Cognos Dispatcher, Identify features of the IBM Cognos BI architecture and components, Perform a single server or distributed installation, Data warehousing characteristics: Subject Oriented, Integrated, Time-variant and Non-volatile, Types of OLAP: ROLAP, MOLAP, HOLAP, Dimensions and facts, Introduction to ETL Concepts using Informatica, Design Framework Manager and DMR.

Learning Objectives - In this module, you will be introduced to IBM Cognos Framework Manager and you will understand the workflow process. You will also learn how to write SQL queries and set relationships, perform calculations, apply filters and create star schema among the various query subjects.

Topics - Define business/reporting requirements, what is Framework Manager, Framework Manager workflow processes. Create a baseline project, Identify facts and dimensions, Identify key differences amongst type data source, model, and stored procedure query subjects, Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships, Examine relationships and cardinality, Use calculations to create calculated query items, Use embedded/Model filters to reduce the data set, Merge query subjects to create as view behavior, Create star schema groupings to provide authors with logical groupings of query subjects, Create a consolidated modeling layer for presentation purposes, Identify the conformed dimensions, Use tools to analyze the model, Create and publish a package, Use macros, parameters map and session parameters, Identify reporting traps, create aliases to avoid ambiguous joins, multiple paths and other traps. Describe multi-fact, multi-grain queries & stitch queries, Use determinants to specify multiple levels of granularity and prevent double-counting.

Learning Objectives - In this module, you will learn the dimensional and rational database features in cognos, the definition of the keywords used along with a related example. You will be introduced to the DMR package in Cognos and learn how it is used for analysis. You will also be given a heads up to execute the SQL queries dynamically in the Dynamic Query Mode.

Topics - Apply dimensional information to relational Metadata to enable OLAP-style queries, Define regular dimension, measure dimension, Define members and member unique names, Identify changes that impact a MUN, create analysis objects such as dimension, level , hierarchies and measures, create multiple hierarchies, learn and apply scope, publishing the DMR package and using it over Analysis, Examine the IBM Cognos BI security environment, Restrict access to packages, Create and apply security filters, Restrict access to objects in the model, Data level security, Identify and implement techniques to optimize and tune your Framework Manager models, Achieve Minimized SQL, Governors Setting in Framework Manager, Overview Dynamic Query Mode in Framework Manager, Work in a Multi-Modeler Environment, Segment and link a project, Branch a project and merge results.

Learning Objectives - In this module, you will learn to create different types of reports using Query and Report Studio and the various activities like applying filters, using parameters and prompts to focus data. You will also learn how to format charts and the various tools available to do this.

Topics - Examine Query Studio and its Work Area interface, create ad hoc reports and charts in Query Studio. Sorting, Grouping and filtering Query Studio Reports. Examine Report Studio and its Work Area interface, Explore different report types, Create simple list report, Explore how data items are added to queries, Create filters to narrow the focus of reports, Examine detail and summary filters, Determine when to apply filters on aggregate data, Create crosstab reports, Convert a list to a crosstab, Create charts, Use parameters and prompts to focus data, Identify various prompt types, Add run-time information to the reports, Create calculated query items and calculations using functions, Apply formatting, Create Sections, Share layout components among separate reports, Discuss report templates, Page breaks in reports, Other objects in Toolbox.

Learning Objectives - This module is a deep-dive into report authoring, linking two reports and displaying one report layer based on others using prompts. You will be given an opportunity to edit an SQL statement and use union, intersection and join operations. You will acquire knowledge on how to distribute one report contents to various recipients.

Topics - Create Drill Through Report, Create Master-Detail Report, Create Boolean, language and String Variables for conditional formatting, Conditional Blocks and Conditional Rendering, Edit an SQL statement to author custom queries, Filter Reports using Query Macros, Use union, intersect and Join Queries, Create Table of contents for a report book and add bookmark for navigation, create a report using an external data file, Enhance User Interaction with HTML items and Java Scripts, distribute reports using bursting, Configure IBM Cognos BI to perform Bursting, burst a report to IBM Cognos Connection Using a Burst Table and Performance Tuning of Reports.

Learning Objectives - Here, you will learn how to combine data and layout in a single file using Active Reports. You will learn the workspace of Analysis Studio and Event Studio using which we will create reports for relational and dimensional data. You will also do administrative activities to manage and schedule events.

Topics - Active Reports Introductions, Create active report templates, Describe active report connections, Apply Filter and Select behavior to active report controls, Modify the interactive behavior of report controls, Identify active report controls and variables in a report, Use variables to control multiple controls independently, Describe characteristics of traditional charts in active reports, Control data display using decks and data decks, Describe characteristics of RAVE Visualizations, Analysis Studio, Define the fundamental terms of Analysis Studio, Identify the work area, overview area, and properties pane, Explain how to insert objects, Define and create sets, Employ drilling down and up to different levels of detail, Use charts to display data graphically, Suppress rows and columns, Workspace & Workspace Advanced: Identify the user interface components of IBM Cognos Workspace Advanced. Create a Report using Relational Data, create a Report using Dimensional Data, understand suppression options, explore filtering data, examine the use of external data in reports, Even Studio, create agents, use parameters and calculations, add tasks, manage task execution rules.

Learning Objectives - In this module you will learn the various dimensional concepts and compare it with the relational concepts. You will perform various actions on the dimensional data and create reports and dashboards based on the result generated. You will also learn how to create hyperlinks in the report.

Topics - Introduction to Dimensional Concepts, compare dimensional and relational model types, examine dimensional data structure, Examine dimensional functions for members, sets, and tuples. Compare relational and dimensional queries, Identify dimensional style filtering techniques, Filter non-null data, Calculations and few important Dimensional Functions, Functions for Navigating Dimensional Hierarchies, Use functions to traverse the dimensional hierarchies, Create reports with children(), ancestor(), and descendants() functions, Relative Functions, Review basic drilling up and drilling down, Set Up Drill-Through Reports, Drill through from one report to another, Drill through from dimensional data to relational data, Create a single report with data from multiple sources.

Learning Objectives - In this module you will learn what are Dynamic Cubes, how to create and deploy them and measure its performance with aggregates. You will also learn the various methods to provide security and the benefits of creating a Dynamic Cube. You will also learn to model a Virtual Cube and publish it.

Topics - Overview of Dynamic Cubes, Identify the challenges of large data volumes that are resolved by dynamic cubes, Explore the IBM Cognos Cube Designer interface, Explore the IBM Cognos Cube Designer interface, Review the automatic and manual processes to create a cube, Examine query service administrative tasks, Optimize Performance with Aggregates, Examine aggregation in dynamic cubes, Define Security, Overview of dynamic cube security, Assign users and groups to security views, Model a Virtual Cube and Examine the benefits, requirements, and build process of virtual cubes.

Learning Objectives - In this module, you will learn how to perform Cognos Analysis in Excel, the various query settings to be done to tune and enhance the performance and how to work with Dynamic Query Analyzer. You will also be exposed to the Business Driven Workflow of Cognos.

Topics - Features of IBM Cognos Analysis for Microsoft Excel, IBM Cognos Analysis for Microsoft Excel use case, enhanced event management, human task service use case, query Service metrics, manage the cache in IBM Cognos Administration, query Service settings, disabling the Query Service. What is Dynamic Query Analyzer? Working with Dynamic Query Analyzer.

Learning Objectives - In this module, you will be given an overview of all the administration tasks that revolve around the Cognos Tool. It gives you an insight of how to move the data from the previous version to Cognos 10.1. You will learn how to audit and manage the Cognos Environment.

Topics - IBM Cognos Administration Overview, using the various administrative features: Enhanced search, restricting the scheduling options, managing the Cognos environment, Auditing.

Project #1: Creation of Financial Data Warehousing Solution

Industry: Finance

Data set: Adventure-works dataset

Problem Statement: Creation of Reports and Dashboards using Financial Datawarehouse

Project #2: Creation of Sales Data Warehousing Solution

Industry: Sales

Data set: Sales Data

Problem Statement: Creation of Reports and Dashboards using Sales Package

IBM's Cognos BI is supported only in Windows OS. Typical hardware requirements are: RAM 4 GB and Disk Space 10GB with dual core CPU. Please note that Cognos does not work on Mac OS
We will help you set up the software on your computer.  The software can be downloaded and installed for free from the link that will be provided in the LMS. The detailed installation guides are also provided in the LMS for setting up the environment. In case you come across any doubt, the 24*7 support team will promptly assist you.
You will never miss a lecture at edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session in any other live batch.
edureka is committed to provide you an awesome learning experience through world-class content and best-in-class instructors. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
All instructors at edureka are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by edureka to provide impeccable learning experience to all our global users.
You can Call us at +91 90660 20867 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you.

  • Once you are successfully through the project (Reviewed by a edureka expert), you will be awarded with edureka’s IBM Cognos BI Professional certificate.
  • edureka certification has industry recognition and we are the preferred training partner for many MNCs including e.g. Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc

IBM Cognos BI Certification Training