How This Course Is Organised

The Cognos BI - Analysis Studio – Professional Data Analysis course provides step-by-step instructions on how to perform a variety of  multi-dimensional exploration and analysis tasks using Cognos BI Analysis Studio for activities based on real-life work scenarios. The Analysis Studio: Professional Data Analysis course teaches Developers, Analysts and Business authors to navigate and analyze data in Analysis Studio. You will learn techniques such as ranking, filtering, asymmetrical crosstabs, and graphing to help them analyze large volumes of data (whether OLAP or dimensionally modelled relational metadata). They will also learn to manage reports through Cognos Connection.

This course provides step-by-step instructions for creating and managing reports with Cognos BI - Analysis Studio, and use RDBMS or Powerplay OLAP Cubes 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 8 BI Certification exam.

Duration           

N/A

Audience 

Reporting Developers

Business Analysts
Project Managers  

 

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 Reports Development Method

·         Understand Key BI and OLAP Concepts

·         Explore Analysis Studio's different report types (list, crosstab, charts)

·         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 8 Business Intelligence and OLAP Concepts

 

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

 

Analysis Studio Fundamentals

Inserting Reporting objects

Defining and creating sets

Identify the work area, overview area, and properties pane

 

Exploring Data 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 behaviour in nested rows and columns

Demonstrate how to swap nested levels

 

Build Advanced Crosstabs in Analysis Studio

Design a crosstab without retrieving data

Compare multiple measures

Apply stacked sets to the crosstab

Construct an asymmetrical crosstab

Compose a custom sort

 

Using 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

 

Enhancing the Analysis

Apply summary calculations

Apply item-based calculations

Ranking items

Demonstrate how to customize the report display

 

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

Design a portal page and dashboard

Set permissions using Cognos 8 BI groups and roles

 

The role of Event Studio in Performance Management

Benefits of Event Studio

Add tasks to an Agent

Run an agent

     

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING  FORMAT. PRICES DIFFER

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice..

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

NOTE:WebLearning Publishing CBT and Courseware products are now delivered with FULL LICENCE KEY.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning. 

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied

.