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

COURSE OUTLINE:

Description

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

RELATED COURSES

Uncategorized

Data Modeling

Since a business analyst needs to accurately elicit, define, and document user requirements, understanding the users’ needs is key to an analyst’s success. By using logical data modeling, a business analyst can convey requirements in a way that can easily be validated, and doing so allows stakeholders to understand the requirements, business rules, and data management methods for any given project.

In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.

Students pursuing a university-recognized and/or accredited certificate in Canada or continuing education units in the US must attend at least 90% of class time, participate in class exercises and section-knowledge checks, and score at least 70% on an end-of-class, multiple-choice assessment.

Uncategorized

IBM Cognos Analytics: Enterprise Administration (v11.0.x)

Learn the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, you will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. You will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.

Uncategorized

Microsoft Cloud Workshop – Internet Of Things

Implement an end-to-end solution simulating high velocity data emitted from smart meters and analyze in Azure. Create a lambda architecture, filtering a subset of the telemetry data for real-time visualization on the hot path, and storing all the data in long-term storage for the cold path.

Uncategorized

Agile Boot Camp for Non-Software Work

Agile methodologies have become a mainstream component in the world of software development. Not surprising, Agile methods can be applied to many other types of business work. In our Agile Boot Camp for Non-Software Work, we apply agile techniques to addressing business processes, infrastructure, operations, and other types of work.

While not a silver bullet, Agile Methodologies have become the most practical way to create outstanding results. We will look at leading Agile methodologies for both discovery and operational work. You will learn the basic concepts behind Agility and how Agile can help you in your daily efforts.