Cognos Self-Service Data Modeling with Data Modules
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.
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
