Course Length: 2 day(s)
Course Price: $1400 CAD
Available Course Formats:
- In-class
- Instructor Led Online
Scheduled Dates:
Sep 4, 2019 - Sep 5, 2019 (2 day(s))
Location:
Canada, ON - Markham
Time:
09.00 EST - 17.00 EST
Sep 4, 2019 - Sep 5, 2019 (2 day(s))
Location:
Instructor-Led-Online
Time:
09.00 EST - 17.00 EST
GTR
Sep 4, 2019 - Sep 5, 2019 (2 day(s))
Location:
Canada, ON - Ottawa
Time:
09.00 EST - 17.00 EST
Sep 4, 2019 - Sep 5, 2019 (2 day(s))
Location:
Canada, NS - Halifax
Time:
09.00 AST - 17.00 AST
Sep 4, 2019 - Sep 5, 2019 (2 day(s))
Location:
Canada, BC - Vancouver
Time:
09.00 PST - 17.00 PST
Oct 2, 2019 - Oct 3, 2019 (2 day(s))
Location:
Canada, ON - Markham
Time:
09.00 EST - 17.00 EST
Oct 2, 2019 - Oct 3, 2019 (2 day(s))
Location:
Instructor-Led-Online
Time:
09.00 EST - 17.00 EST
Oct 2, 2019 - Oct 3, 2019 (2 day(s))
Location:
Canada, ON - Ottawa
Time:
09.00 EST - 17.00 EST
Oct 2, 2019 - Oct 3, 2019 (2 day(s))
Location:
Canada, AB - Calgary
Time:
09.00 MST - 17.00 MST
Oct 2, 2019 - Oct 3, 2019 (2 day(s))
Location:
Canada, NS - Halifax
Time:
09.00 PST - 17.00 PST
Nov 5, 2019 - Nov 6, 2019 (2 day(s))
Location:
Canada, ON - Markham
Time:
09.00 EST - 17.00 EST
Nov 5, 2019 - Nov 6, 2019 (2 day(s))
Location:
Instructor-Led-Online
Time:
09.00 EST - 17.00 EST
Nov 5, 2019 - Nov 6, 2019 (2 day(s))
Location:
Canada, ON - Ottawa
Time:
09.00 EST - 17.00 EST
Nov 5, 2019 - Nov 6, 2019 (2 day(s))
Location:
Canada, AB - Calgary
Time:
09.00 MST - 17.00 MST
Nov 5, 2019 - Nov 6, 2019 (2 day(s))
Location:
Canada, NS - Halifax
Time:
09.00 AST - 17.00 AST
Dec 10, 2019 - Dec 11, 2019 (2 day(s))
Location:
Canada, ON - Markham
Time:
09.00 EST - 17.00 EST
Dec 10, 2019 - Dec 11, 2019 (2 day(s))
Location:
Instructor-Led-Online
Time:
09.00 EST - 17.00 EST
Dec 10, 2019 - Dec 11, 2019 (2 day(s))
Location:
Canada, ON - Ottawa
Time:
09.00 EST - 17.00 EST
Dec 10, 2019 - Dec 11, 2019 (2 day(s))
Location:
Canada, AB - Calgary
Time:
09.00 MST - 17.00 MST
Dec 10, 2019 - Dec 11, 2019 (2 day(s))
Location:
Canada, NS - Halifax
Time:
09.00 AST - 17.00 AST
This course introduces students to the fundamentals of reporting in IBM Cognos Analytics v11. Students will be introduced to Lists, Crosstabs and Charts as well as interactive features like prompts and report drill-through. During the course students will also learn how to add advanced formatting to the objects in their reports, apply conditional styles, and integrate external data.
Course Outline:
Overview of Cognos Analytics
- What is Cognos Analytics?
- Launching Cognos Analytics
- Cognos Analytics Layout & Panes
- Existing Reports
- Cognos Analytics Report Types
Building List Reports
- Report Templates
- Data Panel Source, Data Items, and Toolbox
- Relational Package Objects
- Adding Data Items to a Report
- Reorganizing Report Data Items
- Remove, Re-Order, Add columns
- Navigate Query Explorer
- Grouping and Group Spans
- Formatting Report Objects
- Adding a Title to a Report
- Naming Report Objects
- Saving and Running Reports
Filtering and Sorting Reports
- Sorting a Report
- Layout Sorting
- List Headers and Footers
- Filtering Data
- Advanced Filters
Using Prompts in Reports
- What are Prompts?
- Creating prompts
- Build a Prompt Page Tool
- Create a Parameter in a Filter
- Prompts directly in a Report Page
- Cascading Prompts
Creating Crosstab Reports
- Crosstab Reports
- Swap Rows and Columns
- Format Measures in Crosstab
- Pivot a List to a Crosstab
Creating Advanced Crosstabs
- Nesting and Stacking Crosstabs
- Creating an Asymmetric Crosstab
- Crosstab Spaces
- Crosstab Default Measure
Adding Calculations to your Report
- Adding Calculated Data Items
- Query Calculations
- Layout Calculations
- Functions
Reporting with Charts
- Adding Charts
- Chart Formatting
- Visualizations
Enhancing your Report
- Enhancing Reports
- Text Objects and Images
- Table Styles
- Report Style References
- Formatting Objects
- Custom Grouping
- No Data Property
- Visual Aids
- Layout Component Reference
- Templates
Applying Conditional Formatting
- Apply Conditional Formatting
- Conditional Formatting Steps
- Variable Types
- Conditional Rendering
- Unlocking Report Objects
Drill Through Reports
- Drill Through
- Benefits of Drill-Through
- Drill-Through Process
Integrating External Data
- Working with External Data
- Upload Data File Wizard
- Data Modules
Workshops
Course Audience & Prerequisites:
Audience
- Professional Report Authors
Prerequisites
- There are no prerequisites for this course
Course Offerings:
Instructor Led In Classroom
Newcomp can directly deliver IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.
Currently, in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.
Instructor Led Online
Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples
ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.
- Course Outline
- Course Audience & Prerequisites
- Course Offerings
- Related Courses
Overview of Cognos Analytics
- What is Cognos Analytics?
- Launching Cognos Analytics
- Cognos Analytics Layout & Panes
- Existing Reports
- Cognos Analytics Report Types
Building List Reports
- Report Templates
- Data Panel Source, Data Items, and Toolbox
- Relational Package Objects
- Adding Data Items to a Report
- Reorganizing Report Data Items
- Remove, Re-Order, Add columns
- Navigate Query Explorer
- Grouping and Group Spans
- Formatting Report Objects
- Adding a Title to a Report
- Naming Report Objects
- Saving and Running Reports
Filtering and Sorting Reports
- Sorting a Report
- Layout Sorting
- List Headers and Footers
- Filtering Data
- Advanced Filters
Using Prompts in Reports
- What are Prompts?
- Creating prompts
- Build a Prompt Page Tool
- Create a Parameter in a Filter
- Prompts directly in a Report Page
- Cascading Prompts
Creating Crosstab Reports
- Crosstab Reports
- Swap Rows and Columns
- Format Measures in Crosstab
- Pivot a List to a Crosstab
Creating Advanced Crosstabs
- Nesting and Stacking Crosstabs
- Creating an Asymmetric Crosstab
- Crosstab Spaces
- Crosstab Default Measure
Adding Calculations to your Report
- Adding Calculated Data Items
- Query Calculations
- Layout Calculations
- Functions
Reporting with Charts
- Adding Charts
- Chart Formatting
- Visualizations
Enhancing your Report
- Enhancing Reports
- Text Objects and Images
- Table Styles
- Report Style References
- Formatting Objects
- Custom Grouping
- No Data Property
- Visual Aids
- Layout Component Reference
- Templates
Applying Conditional Formatting
- Apply Conditional Formatting
- Conditional Formatting Steps
- Variable Types
- Conditional Rendering
- Unlocking Report Objects
Drill Through Reports
- Drill Through
- Benefits of Drill-Through
- Drill-Through Process
Integrating External Data
- Working with External Data
- Upload Data File Wizard
- Data Modules
Workshops
Audience
- Professional Report Authors
Prerequisites
- There are no prerequisites for this course
Instructor Led In Classroom
Newcomp can directly deliver IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.
Currently, in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.
Instructor Led Online
Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples
ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.