IBM Cognos BI Analysis Studio: Analyze Data is a one day, instructor-led course that teaches business authors to navigate and analyze data in Analysis Studio. Attendees will discover trends, identify opportunities, and learn how to make better business decisions. Participants will learn techniques such as ranking, filtering, asymmetrical crosstabs, and graphing to help them analyze large volumes of data (whether OLAP or dimensionally modeled relational metadata).
This intermediate course is intended for business authors
Cognos Training Course duration
1 day
Cognos Training Course outline
Overview of IBM Cognos
- Discuss IBM Cognos and Performance Management
- Describe IBM Cognos components
- Describe IBM Cognos architecture at a high level
- Define IBM Cognos groups and roles
Analysis Studio Fundamentals
- Define the fundamental terms of Analysis Studio
- Explain how to insert objects
- Define and create sets
- Identify the work area, overview area, and properties pane
Tools for Investigation in Analysis Studio
- Employ drilling down and up to different levels of detail
- Apply changes to rows, columns, and measures in the analysis
- Explain how to change the display of data
- Use charts to display data graphically
Nest Data in Crosstabs in Analysis Studio
- Apply depth to rows and columns by nesting data
- Recognize drill behavior in nested rows and columns
- Demonstrate how to swap nested levels
Build Advanced Crosstabs in Analysis Studio
- Demonstrate how to view a complete level of data
- Design a crosstab without retrieving data
- Compare multiple measures
- Apply stacked sets to the crosstab
- Construct an asymmetrical crosstab
- Compose a custom sort
Focus with Filters in Analysis Studio
- Apply filters using expressions
- Apply filters using the Context area
- Create top and bottom lists
- Use several techniques to remove rows and columns
Extend the Analysis
- Apply summary calculations
- Apply item-based calculations
- Practice ranking items
- Demonstrate how to customize the report display
