Course Description

This training teaches data modelers how to model data using data modules in IBM Cognos Analytics. Users will learn how to create data modules from different sources, such as uploaded files. They will also identify how to customize their data modules by adding joins, calculations, and filters. In addition, they will examine how to group their data (for example, by using navigation paths), how to share their data modules with others, and how to make use of some advanced modeling techniques, such as relative date analysis.

Objectives

Data modeling in IBM Cognos Analytics • Create and use data modules • Intent-driven modeling • Use the web modeling user interface: overview  

Create a data module • Sources for data modules • Create a new data module in IBM Cognos Analytics: high level steps • Add and relink sources • Enable data caching  

Modify and refine a data module • What happens when you create a data module? • How can I modify and refine a data module? • Modifying the graphic representation  

Create relationship joins • What are relationships? • Create a relationship: high-level steps • Modify relationships • Create new tables

Customize data modules using filters and calculations • Customizing a data module • Creating filters • Viewing, editing, and removing filters • Creating calculations • Cleaning data • Using custom calculations  

Group data and create navigation paths • Group data • Group on a numeric column • Group on a text column • Create a navigation path  

Share a data module • What happens when you share a data module?  

Advanced data modeling techniques • Perform relative date analysis: overview • Using the sample calendars to enable relative date analysis • Create a data module for relative date analysis • Customizing the reference date for relative date analysis • Deal with multiple grains of data • Set security in data modules  

Assessment

Audience

Modelers

Prerequisites

• Knowledge of your business requirements
• Previous experience building reports with IBM Cognos Analytics V11.1.x

Content

Data modeling in IBM Cognos Analytics
• Create and use data modules
• Intent-driven modeling
• Use the web modeling user interface: overviewCreate a data module
• Sources for data modules
• Create a new data module in IBM Cognos Analytics: high level steps
• Add and relink sources
• Enable data cachingModify and refine a data module
• What happens when you create a data module?
• How can I modify and refine a data module?
• Modifying the graphic representationCreate relationship joins
• What are relationships?
• Create a relationship: high-level steps
• Modify relationships
• Create new tablesCustomize data modules using filters and calculations
• Customizing a data module
• Creating filters
• Viewing, editing, and removing filters
• Creating calculations
• Cleaning data
• Using custom calculationsGroup data and create navigation paths
• Group data
• Group on a numeric column
• Group on a text column
• Create a navigation pathShare a data module
• What happens when you share a data module?Advanced data modeling techniques
• Perform relative date analysis: overview
• Using the sample calendars to enable relative date analysis
• Create a data module for relative date analysis
• Customizing the reference date for relative date analysis
• Deal with multiple grains of data
• Set security in data modulesAssessment