Cognos Self-Service Data Modeling with Data Modules

Beginning 1 day

In this course you will learn to

  • Get started with data modules
  • Upload local files
  • Create custom tables
  • Organize data module objects
  • Get started with the fundamentals of data modeling
  • Create data module unions and joins
  • Create a data server to access additional sources
  • Link local files and database tables with data modules
  • Create calculations and table views
  • Create data sets
  • Create custom data groups and navigation paths



Included in this course

  • Hands-on exercises
  • Course manual

Suggested attendees

Business analysts or report authors. No previous experience required, but it is helpful to have used Cognos.

This class is also offered in a ½ day format for those with a solid understanding of databases, database nomenclature (joins, cardinality) and experience as Cognos report authors or dashboard developers.

Choose Format


Course Outline

  • Upload local files for analysis
    • Understand data modules in Cognos
    • Upload Microsoft Excel worksheets
  • Combine local files for analysis
    • Examine custom tables
    • Create a data module
    • Combine local files for analysis
  • Organize data module objects
    • Test a data module
  • Fundamentals of data modeling
    • Review fundamental data modeling concepts
    • Describe the different options for cardinality
    • Understand the benefit of a join filter
    • Create a data module join
  • Data server to access additional sources
    • Define data servers
    • Connect to a SQL Server database
    • Use the database connection to define a data server connection
    • Create a data module combining database tables
  • Calculations, views and joins
    • Review join relationships and insure proper aggregation
    • Create custom calculations
    • Create a table view
    • Create joins
    • Manage aggregation
  • Add row-level security to a data module
  • Data sets
    • Create data sets from existing packages
    • Link data sets in a data module
  • Data groups and navigation paths
    • Create custom data groups
    • Create navigation paths