IBM Cognos Analytics 12: Modeling with Data Modules

Overview

This course provides a high-level overview of the IBM Cognos Analytics v12 Data Module tool and its underlying architecture to provide learners with the skills necessary to master data modeling using the web-based, self-service capabilities of IBM Cognos Analytics v12 Data Modules. Learners will explore the essential steps in building data modules, from understanding the purpose and workflow of data modeling to creating, refining, and optimizing data structures. The course covers various topics, including managing relationships, advanced features and performance optimization, data enrichment with calculations and filters, creating groups and navigation paths, and managing data security. 

Learners will gain hands-on experience through exercises that enhance their ability to create and customize data modules, review and modify column properties, creating calculations, filters and data groups, and adding column dependencies. These hands on activities ensure learners practice consistency and usability for reporting, dashboarding, and exploration purposes.

By the end of this course, learners should be proficient in developing data modules that integrate multiple data sources, support business analysis, and facilitate informed decision-making within the IBM Cognos v12 environment.

Audience

This course is intended for data professionals, business analysts, and technical users who are involved in data preparation, reporting, and business intelligence within their organization.

Prerequisites

• Participants should have the following skills:
  • An understanding of your organization’s business intelligence process and reporting needs
  • Experience using basic Windows functionality
  • An understanding of Cognos reporting

Objective

After completing this course, learners should be able to:

• Describe the data modeling workflow, including identifying sources, enriching the module, and testing it.
• Navigate the Cognos Analytics v12 Data Modules user interface and upload a source file.
• Demonstrate how to create, edit, and optimize relationships in Cognos Analytics v12, including utilizing the Null Safe option and configuring cardinality for accurate data integration.
• Organize data modules by hiding, renaming, or removing fields.
• Use SQL to create a new table by writing and validating a custom query.
• Configure custom sorting for a specified column and validate its application in reports or dashboards.
• Utilize the Enhanced Expression Editor to create a custom calculation combining fields from two tables.
• Design a navigation path and validate functionality in dashboards.
• Configure row-level security filters, assign permissions, and utilize security definitions.
• Configure advanced data module functionalities, including column dependencies, bridge tables, and summary tables.
• And more…

Course Outline

• Course Introduction
• Unit 1: Data Modeling in Cognos Analytics v12
• Unit 2: Creating Data Modules
• Unit 3: Managing Relationships
• Unit 4: Reviewing and Organizing Data Modules
• Unit 5: Advanced Features and Performance Optimization
• Unit 6: Customizing Data Modules with Filters and Calculations
• Unit 7: Grouping Data and Creating Navigation Paths
• Unit 8: Organizing and Sharing Data Modules
• Unit 9: Advanced Functionality in Data Modules