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

Version

11.x

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

  1. 6:00am - 2:00pm PT
  2. 9:00am - 5:00pm ET
$349.50
  1. 9:00am - 5:00pm PT
  2. 12:00pm - 8:00pm ET
$349.50
$99.00
$129.00
$149.00

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

You may also be interested in

Cognos Framework Manager Metadata Modeling Best Practices

Learn more about this course

  • Payments by purchase order or invoice incur a $50 service fee.
  • Paying party will receive a payment confirmation email upon receipt of payment.
  • Each registered student will receive an email with the course details.
  • Students will receive electronic copies of the course materials and may print one hard copy for their personal use. The course materials are copyrighted and any other reproduction or distribution of these materials is strictly prohibited.

Self-paced

This class requires access to a Cognos environment and practice datasets. Read more

Instructor-led online

We recommend using two monitors in order to simultaneously view the training presentation and hands-on class work.

You’ll receive a Zoom link to join the class. We recommend using a headset instead of the computer’s microphone and speakers. You may also listen to the audio by phone.

Instructor-led online

  • 100% refund for cancellations made more than 10 days before the first class
  • 50% refund for cancellations made 5-9 days before the first class
  • No refund for cancellations made less than 5 days before the first class

Self-paced

  • Full refund if cancelling within 24 hours of registration
  • $15 fee for cancellations after 24 hours of registration
  • No refund for cancellations after 15 days of registration
  • Shared subscriptions will be immediately deactivated and no refund issued