ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £50K WITH YOUR COGNOS ANALYTICS & REPORTING SKILLS.

 

PERFECT INTERACTIVE TRAINING MATERIAL (COMPUTER BASED TRAINING - CBT) WITH VERY GOOD SIMULATIONS USING REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.

IDEAL FOR THOSE DESIGNING AND DEVELOPING COGNOS OLAP,  ANALYTICS AND REPORTING APPLICATIONS IN ANY COGNOS DEPLOYMENT ENVIRONMENT. ALSO GOOD FOR THOSE PREPARING FOR IBM BI CERTIFICATION EXAMS AS WELL AS THOSE WHO WORK WITH OTHER BI/OLAP TOOLS OR WISH TO UPSKILL TO AN IBM COGNOS BI ENVIRONMENT.

 

IBM COGNOS 8 BI QUERY STUDIO: AD-HOC DATA ANALYSIS & REPORTING BOOT CAMP SELF-STUDY CBT

How This Course Is Organised

The Cognos BI - Query Studio - Ad Hoc Data Analysis and Reporting Boot Camp course provides step-by-step instructions on how to perform a variety of Cognos BI Analysis tasks for activities based on real-life work scenarios.  

The BI Query Studio: Ad Hoc Data Analysis and Reporting Boot Camp is designed for Project Leads, Analysts and Business authors who want to learn how to Create, modify and organize ad hoc reports. The course covers how to use different report capabilities, how to graphically display the data, and how to Create reports with a consistent look and feel through the use of templates. The course also covers basic administrative tasks, such as scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.)..

This course provides step-by-step instructions for creating and managing reports with Cognos BI - Query Studio Studio, and use RDBMS as the data source. You Create and Analyse reports, report objects; and Format reports. Exercises help you practice the skills taught.

The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

Certification 

This course will assist in preparation for the Cognos BI Certification exam.

Duration           

N/A

Audience 

Business Analysts

Reporting Authors and Developers

BI Team Members

Functional Implementer

 

Prerequisites:

Suggested Prerequisites:

Knowledge of your business requirements

Experience using basic Windows functionality

Experience using a Web browser

Course Objectives:

Upon completion of this Course, you should be able to:

·         Understand the Cognos BI Life-cycle Method

·         Understand Key BI and OLAP Concepts

·         Explore Query Studio, different report types (list, crosstab, chart)

·         Create and Format reports using grouping, headers, footers, and other formatting options

·         Focus reports by filtering data and using prompts

·         Add value to your reports using calculations and additional report building techniques

·         Enhance reports with advanced formatting and exceptional data highlighting

·         Author reports through query models

·         Set up drill-through access and Create drill-through reports

·         Manage content in Cognos Connection

 

Course Outline

Course Overview

Business Scenario

The Cognos Business Intelligence Value Proposition

Cognos BI Products and Architecture

Cognos BI Reporting and Analysis Tools          

Cognos Connection

Query Studio

Analysis Studio

Reporting Studio

Express Studio

Event Studio

Framework Manager

Key BI and OLAP Concepts

What is Business Intelligence - BI?

The Query and Analysis Continuum

Cognos Business Intelligence and OLAP Concepts

Planning your Cognos Business Intelligence Project

Approach to Cognos BI Projects

Rapid Implementation Method - The Cognos BI Approach

Tactical versus Strategic Solution

Understanding Rapid Implementation Method - RIM

Understanding JAD

Modelling in a Cognos BI Environment

Understanding Business Dimension Modelling

Building a Business Dimension Model

Analysing Data Elements from your Model

Business Dimension Model Design Issues

Identifying Source Data elements for the Model

Relational Data Modelling in Cognos BI Environments

Project management for BI/OLAP

BI/OLAP Model Development Checklist

The Report Development Process

Capturing User Requirements Management

Identify People Involved

Interview Appropriate People

Identify business process requirements

Identify the grain

Identify the dimensions

Identify the facts

Verify the model

Physical (report) design considerations

Meta data management

Create Requirements Definition Document

The Application specification Document

Agree Requirements Definition document with the Users

Project Management and Review

Introduction to Query Studio

List the packages available for reporting

Understand report types

Add and save data to ad hoc reports

View data by using charts

Create Reports in Query Studio

Create list, grouped list, and crosstab reports

List the charts available and their appropriate use

Calculate and sort report data

Define a custom group to Create your own report

Use shared dimensions to Create multi-fact queries

Enhance Reports in Query Studio

Highlight report items using conditional styles

Focus the scope of a report using filters

Format report objects

Apply a report template

Content Management using Cognos Connection

Schedule and manage reports

View lineage information

Add comments to saved output

Personalize and organize content

Set alerts and watch rules 

Event Studio

The role of Event Studio in Performance Management

Benefits of Event Studio

Add tasks to an Agent

Run an agent