IBM Analytics

B6359G : IBM Cognos Analytics: Author Reports Advanced (v11.2)

Course Duration

2 Days

Delivery

ILT VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

This course teaches Professional Report Authors about advanced report building techniques using relational data models, and ways of enhancing, customizing, and managing professional reports. The course builds on topics presented in the Fundamentals course. Attendees will participate in interactive demonstrations and exercises that illustrate key concepts while learning how to use advanced features in the product builds on topics learned in the Fundamentals course.

What You'll Learn

Unit 1: Create query models

build query models and then connect them to the report layout
edit an SQL statement to author custom queries
add filters and prompts to a report using the query models

Unit 2: Create reports based on query relationships

create reports by joining queries
combine data containers based on relationships from different queries

Unit 3: Introduction to dimensional reporting concepts and dimensional data in reports

List and describe the data model types
Describe the OLAP data structure and elements
Differentiate between report authoring styles
use members to build reports
identify and use sets and tuples in reports Unit 4: Dimensional report context
understand report context
root members
default members
current members
default measures
current measures

Unit 5: Focus your dimensional data

understand how relational data sources behave
understand how dimensional data sources behave
create efficient queries
understand filtering techniques
use dimensional objects and functions
create slicers and prompts

Unit 6: Calculations and dimensional functions

understand the different types of dimensional functions within Cognos Analytics
create reports utilizing dimensional functions
use calculations within reports

Unit 7: Create advanced dynamic reports

filter reports on session parameter values
create dynamic headers and titles that reflect report data
create a customer invoice report

Unit 8: Design effective prompts

control report displays using prompts
specify conditional formatting values using prompts
create sorted and filtered reports based on prompt selection

Unit 9: Examine the report specification and distribute reports

work with the report specification
report specification flow
considerations when modifying a report specification
Create custom toolbox and template objects
distribute reports using bursting
create burst keys
identify report recipients and data items using burst tables
distribute reports using email and the IBM Cognos Analytics portal

Unit 10: Enhance user experience with HTML and Custom Controls

create interactive reports by using HTML
Include additional information with tooltips
Send emails by using links in a report
understand custom controls
AMD models
adding a custom control
using JavaScript files

Unit 11: Advanced techniques

understand advanced features
booklet and reference reports
table of contents
tabbed reports
classes and class extensions
global parameters
create a report binder

Who Should Attend

Report Authors

Prerequisites

Knowledge of your business requirements
Fundamental report authoring knowledge

Learning Journey

Coming Soon...

Unit 1: Create query models

build query models and then connect them to the report layout
edit an SQL statement to author custom queries
add filters and prompts to a report using the query models

Unit 2: Create reports based on query relationships

create reports by joining queries
combine data containers based on relationships from different queries

Unit 3: Introduction to dimensional reporting concepts and dimensional data in reports

List and describe the data model types
Describe the OLAP data structure and elements
Differentiate between report authoring styles
use members to build reports
identify and use sets and tuples in reports Unit 4: Dimensional report context
understand report context
root members
default members
current members
default measures
current measures

Unit 5: Focus your dimensional data

understand how relational data sources behave
understand how dimensional data sources behave
create efficient queries
understand filtering techniques
use dimensional objects and functions
create slicers and prompts

Unit 6: Calculations and dimensional functions

understand the different types of dimensional functions within Cognos Analytics
create reports utilizing dimensional functions
use calculations within reports

Unit 7: Create advanced dynamic reports

filter reports on session parameter values
create dynamic headers and titles that reflect report data
create a customer invoice report

Unit 8: Design effective prompts

control report displays using prompts
specify conditional formatting values using prompts
create sorted and filtered reports based on prompt selection

Unit 9: Examine the report specification and distribute reports

work with the report specification
report specification flow
considerations when modifying a report specification
Create custom toolbox and template objects
distribute reports using bursting
create burst keys
identify report recipients and data items using burst tables
distribute reports using email and the IBM Cognos Analytics portal

Unit 10: Enhance user experience with HTML and Custom Controls

create interactive reports by using HTML
Include additional information with tooltips
Send emails by using links in a report
understand custom controls
AMD models
adding a custom control
using JavaScript files

Unit 11: Advanced techniques

understand advanced features
booklet and reference reports
table of contents
tabbed reports
classes and class extensions
global parameters
create a report binder

Frequently Asked Questions (FAQs)

Why get IBM certified?

IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.
These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.
IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.
What to expect for the examination?

IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.
Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is IBM certification valid for?

The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.
However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By IBM

Browse All Courses

System Z

B6359G : IBM Cognos Analytics: Author Reports Advanced (v11.2)

What You'll Learn

Who Should Attend

Prerequisites

Learning Journey

Frequently Asked Questions (FAQs)

Why get IBM certified?

What to expect for the examination?

How long is IBM certification valid for?

Why take this course with Trainocate?

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By IBM

Advanced Parallel Sysplex Operations and Recovery Workshop

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

IBM z/OS Management Facility Implementation and Use 2.1

Ready to Take Your Business from Great to Awesome?

Request More Information