IBM Cognos Analytics: Modeling with Data Modules (V11.1.x)

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

Modelers

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

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