IBM Cognos Analytics: Author Reports Fundamentals (v11.1.x)
COURSE OUTLINE:
This course provides you with an introduction to report building techniques using relational data models. You�ll learn techniques to enhance, customize, and manage professional reports. Hands-on activities will illustrate and reinforce key concepts and skills.
Audience
Report Authors and Business Analysts
Prerequisites
You should have:
- Knowledge of your business requirements
- Experience using the Windows operating system
- Experience using a Web browser
Learning Objectives
- Dimensionally modeled relational data
- How to use personal data sources and data modules
- Examining list reports
- Aggregating fact data
- Using multiple facts and repeated information
- Add repeated information to reports
- Create crosstab reports
- Complex crosstab report creation
- Work with crosstab data
- How to create discontinuous crosstab reports
- Visualization report creation
- How to use filter and prompts
- Use calculations
- How to customize reports using conditional formatting
- Drill-through definitions
- How to enhance report layouts
�
While class exercises are performed within a Cognos Analytics v11.1 environment, our expert instructors can provide guidance on previous Cognos versions and their differences.
What is IBM Cognos Analytics Reporting?
- The Welcome page
- Consume report content
- Interactive filtering
- Working with reports
�
Dimensionally modeled relational data
�
Use personal data sources and data modules
- Upload personal data
- Upload custom images
- Using navigation paths in a data module
�
Examine list reports
- Group data
- Format columns
- Include headers and footers
�
Aggregate fact data
- Identify differences in aggregation
�
Multiple facts and repeated information
- Use shared dimensions to create multi-fact queries
- Present repeated information
�
Add repeated information to reports
- Create a mailing list report
�
Create crosstab reports
- Add measures to a crosstab
- Data sources for a crosstab
�
Create complex crosstab reports
- Add items as peers
- Create crosstab nodes and crosstab members
�
Work with crosstab data
- Format, sort, and aggregate a crosstab
�
Create discontinuous crosstab reports
�
Create visualization reports
- Visualization categories
- Customize visualizations
- Client side visualizations
- Enhanced map visualizations
�
Focus reports using filters
- Create filters to narrow the focus
- Use advanced detail filters
- Apply a filter with aggregation
- Use summary filters
�
Focus reports using prompts
- Examine parameters and prompts
- Create a parameter for a report item
- Add a prompt page
- Add a prompt item to a report
- Identify a prompt type
- Create a cascading prompt
�
Using calculations
- What are calculations?
- Add Date and Time functions
- Add string functions
- Display prompt selections in report titles
�
Customize reports with conditional formatting
- Three steps for conditional formatting
- Create a variable
- Assign the variable to a report object
- Format based on the conditional value
- Conditionally render report objects
�
Drill-through definitions
- Navigate to related data
�
Enhance report layouts
- View the structure of a report
- Use Guided report layout
- Force page breaks
- Create horizontal pagination
- Modify the report structure
- Format objects across reports
�
Additional report-building techniques
- Enhance a report design
- Add objects to reports
- Convert a list to a crosstab
- Explore reuse