Create query models 
   • Build a query and connect it to a report 
   • Answer a business question by referencing data in a separate query 
 

Create reports based on query relationships 
   • Create join relationships between queries 
   • Combine data containers based on relationships from different queries 
 

   • Create a report comparing the percentage of change 
Introduction to dimensional reporting concepts 
   • Examine data sources and model types 
   • Describe the dimensional approach to queries 
   • Apply report authoring styles 
 

Introduction to dimensional data in reports 
   • Use members to create reports 
   • Identify sets and tuples in reports 
   • Use query calculations and set definitions 
 

Dimensional report context 
   • Examine dimensional report members 
   • Examine dimensional report measures 
   • Use the default measure to create a summarized column in a report 
 

Focus your dimensional data 
   • Focus your report by excluding members of a defined set 
   • Compare the use of the filter() function to a detail filter 
   • Filter dimensional data using slicers

Enhance user interaction with HTML 
   • Create interactive reports using HTML 
   • Include additional information with tooltips 
   • Send emails using links in a report

Calculations and dimensional functions 
   • Examine dimensional functions 
   • Show totals and exclude members 
   • Create a percent of base calculation 
 

Create advanced dynamic reports 
   • Use query macros 
   • Control report output using a query macro 
   • Create a dynamic growth report 
   • Create a report that displays summary data before detailed data and uses singletons to summarize information 
 

Design effective prompts 
   • Create a prompt that allows users to select conditional formatting values 
   • Create a prompt that provides users a choice between different filters 
   • Create a prompt to let users choose a column sort order 
   • Create a prompt to let users select a display type 
 

Examine the report specification 
   • Examine report specification flow 
   • Identify considerations when modifying report specifications 
   • Customize reporting objects 
 

Distribute reports 
   • Burst a report to email recipients by using a data item 
   • Burst a list report to the IBM Cognos Analytics portal by using a burst table 
   • Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship

Introduction to IBM Cognos Active Reports 
   • Examine Active Report controls and variables 
   • Create a simple Active Report using Static and Data-driven controls 
   • Change filtering and selection behavior in a report 
   • Create interaction between multiple controls and variables 
 

Active Report charts and decks 
   • Create an Active Report with a Deck 
   • Create an Active Report with 11.0 visualizations

Create query models
   • Build a query and connect it to a report
   • Answer a business question by referencing data in a separate query

Create reports based on query relationships
   • Create join relationships between queries
   • Combine data containers based on relationships from different queries
   • Create a report comparing the percentage of change

Introduction to dimensional reporting concepts
   • Examine data sources and model types
   • Describe the dimensional approach to queries
   • Apply report authoring styles

Introduction to dimensional data in reports
   • Use members to create reports
   • Identify sets and tuples in reports
   • Use query calculations and set definitions

Dimensional report context
   • Examine dimensional report members
   • Examine dimensional report measures
   • Use the default measure to create a summarized column in a report

Focus your dimensional data
   • Focus your report by excluding members of a defined set
   • Compare the use of the filter() function to a detail filter
   • Filter dimensional data using slicers

Calculations and dimensional functions
   • Examine dimensional functions
   • Show totals and exclude members
   • Create a percent of base calculation

Create advanced dynamic reports
   • Use query macros
   • Control report output using a query macro
   • Create a dynamic growth report
   • Create a report that displays summary data before detailed data and uses singletons to summarize information

Design effective prompts
   • Create a prompt that allows users to select conditional formatting values
   • Create a prompt that provides users a choice between different filters
   • Create a prompt to let users choose a column sort order
   • Create a prompt to let users select a display type

Examine the report specification
   • Examine report specification flow
   • Identify considerations when modifying report specifications
   • Customize reporting objects

Distribute reports
   • Burst a report to email recipients by using a data item
   • Burst a list report to the IBM Cognos Analytics portal by using a burst table
   • Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship

Enhance user interaction with HTML
   • Create interactive reports using HTML
   • Include additional information with tooltips
   • Send emails using links in a report

Introduction to IBM Cognos Active Reports
   • Examine Active Report controls and variables
   • Create a simple Active Report using Static and Data-driven controls
   • Change filtering and selection behavior in a report
   • Create interaction between multiple controls and variables

Active Report charts and decks
   • Create an Active Report with a Deck
   • Create an Active Report with 11.0 visualizations