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

IBM Cognos BI Administration (V10.2)

This course provides training to administrators on the fundamental tasks of installing and configuring IBM Cognos BI and administering servers and content in the environment. In the course, you will install and configure the IBM Cognos BI software, implement security, and manage the server components. You will also monitor and schedule tasks, create data sources, manage and deploy content in IBM Cognos Connection and IBM Cognos Administration.

Note: While class exercises are performed within a Cognos BI v10.2 environment, our expert instructors can provide guidance on all versions and their differences.

Uncategorized

Building your Business IQ

In todayï¿½s complex business environment, leaders are faced with making decisions every day about how to maximize their time, productivity, and achieve business results. Making good decisions requires not only effective time management and judgment but also an in-depth knowledge of your organizationï¿½s business model and strategy as well as the ability to understand how you contribute to the bottom line. The challenge is that most leaders lack the business understanding required to make decisions from a business perspective.

Uncategorized

Deploying Microsoft 365 Teamwork Track (MS-300)

Content is the most critical digital asset for every organization. In this course you will learn how to plan, configure, and manage SharePoint Site Collection and OneDrive for Business to enable modern content services which transform the content lifecycle. Specifically, this course discusses the modern SharePoint site structure, such as SharePoint hub sites.ï¿½ It provides best practices for the adoption and deployment of OneDrive for Business within your organization. It also covers sharing, security, and monitoring in SharePoint Online and OneDrive for business.

In this course you will learn how to manage user profiles and apps with proper permission settings. We will also discuss how to plan and configure Managed Metadata, Business Connectivity Services, and search allowing content to be found, consumed, and governed across Office 365.

Microsoft Teams is the hub for Teamwork in Microsoft 365.ï¿½ In this course you will learn how to plan, deploy and manage Microsoft Teams.ï¿½ Specifically, this course discusses the relationship of Teams with SharePoint, OneDrive and Office 365 Groups.ï¿½ It provides best practices for the adoption and deployment of Teams within your organization. It also covers how to establish guest policies and data governance for your Teams data.

Transforming teamwork and collaboration inside and outside the organization becomes more critical in a modern workspace.ï¿½ In this course you will learn how to leverage Office 365 Collaboration Workloads to improve your organizations productivity, such as Yammer, Stream, PowerApps, and Flow. We will evaluate available collaborative toolsets and analyze business requirements. You will also learn how to plan and develop governance for digital transformation including user adoption and change management.

Uncategorized

Microsoft Lync 2013 Depth Support Engineer (M55070)

This advanced level course will take qualified support engineers beyond design and deployment to troubleshooting Microsoft Lync Server 2013. You will review Lync Server architecture from the perspective of a depth support engineer in order to support customers with Lync Server service issues. You will use a variety of tools and resources to troubleshoot real-world scenarios related to Enterprise Voice, conferencing, application sharing, IM, and Presence. Learn how to implement solutions to trouble tickets for common Lync Server issues and practice walking a typical customer through a solution.