Course Description IBM Cognos Report Studio Intermediate is a one day instructor-led online course. It is designed for professional report authors to learn intermediate report building techniques to provide polished reports to executives, managers and end users within your organization. Using a combination of lectures, instructor led demos, hands-on exercises, workshops and group exercises in a high-quality learning environment, participants will learn how to customize reports using Report Studio features including conditional formatting, master-detail reports and drill through. Pricing $595 US Intended Audience This is an intermediate course intended for professional report authors. Prerequisites Knowledge of your business requirements Experience using Windows and Web functionality Completion of Report Studio Essentials or working knowledge of Report Studio Course Outline Module 1: Introduction to IBM Cognos 10 BI Module 2: Highlight Data with Conditional Formatting Module 3: Creating a Master-Detail Report Module 4: Defining Drill Through Definitions for Reporting Module 5: Examining a Query Model

You will learn

• Recognize various components of IBM Cognos BI
• Describe the primary benefits of creating reports with IBM Cognos BI
• Understand the Cognos portal and various activities that can be performed within it
• Understand different reporting styles in Report Studio
• Understand the concept of dimensions, measures, and dimensional reporting styles
• Use conditional variables to customize reports.
• Hide and show report objects, which can be based on input or defined condition or calculation.
• Highlight data in a report based on user input or defined condition or calculation.
• Add multiple layouts to the report
• Create multilingual reports
• Understand Master Detail Relationships
• Create Master Detail Reports
• Setup drill-through reports
• Understand drill-through scenarios
• Understand different types of drill-through reports
• Create and setup different types of drill-through reports
• Understand relational queries
• Understand Query Model
• Effect of data Aggregation/Summarization on queries
• Filtering effect on Queries
• Working with Joins/Unions/Intersect/Except
• Create a Join Relationship
• Create a Query using various operators (Union, Intersect and Except Operators) in Report Studio
• Working with Queries in Custom SQL/MDX