Course Description

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.

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

• Developers who want to gain knowledge of Cognos Development for creating queries and reports
• Analysts who want to make smarter business decisions
• Data Engineers and Statisticians

Hachion's Cognos online training program covers from basic to advanced concepts in IBM Cognos. Our course curriculum is designed by industry experts in the IT industry. We provide 100% job assistance with certification guidance.

We provide 100% job assistance to the Hachion students, once they complete the course. We also provide resume writing, mock interviews, and resume marketing services as part of our job assistance program. 

We offer three modes of training in the Cognos online training program.

• Self Placed
• Mentorship
• Instructor-Led