Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

IBM Cognos Query Studio: Build Ad Hoc Reports (V10.1/10.2)

Gain an introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager.

GK# 9063 Vendor# B5150G

Course Overview

TOP

This course provides you with introductory to advanced knowledge of metadata modeling concepts and how to model metadata for predictable reporting and analysis results using Framework Manager. In this course, you will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the Web, enabling end users to easily author reports and analyze data.

What You'll Learn

TOP
  • Overview of IBM Cognos BI
  • Common data structures
  • Requirements and projects
  • Reusable metadata
  • Establishing predictable results
  • Using calculations and filters
  • Time dimension
  • Specifying determinants
  • Establishing the presentation view
  • Query subject types
  • Security
  • Creating objects
  • Managing OLAP data sources
  • SQL concepts and queries
  • Using advanced parameterization
  • Maintenance
  • Optimizing and tuning models
  • Multi-Modeler environment
  • Managing packages

Outline

TOP
Viewing outline for:

Self-Paced Outline

Introduction to Query Studio

  • Examine Query Studio
  • Examine packages
  • Explore report types
  • Add data to ad hoc reports
  • Save ad hoc reports

Create Reports

  • Create list, grouped list, and crosstab reports
  • Examine the available charts and their appropriate use
  • Use dimensional data to create reports and analyze the report details
  • Calculate and sort report data
  • Define a custom group to create your own report item
  • Create multi-fact queries

Enhance Reports

  • Highlight report values using conditional styles
  • Focus the scope of a report using filters
  • Format report objects
  • Apply a report template

Prerequisites

TOP

You should have:

  • Knowledge of common industry standard data structures and design
  • Experience with SQL
  • Experience gathering requirements and analyzing data

Who Should Attend

TOP

This intermediate course is intended for business authors.

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Self-Paced

On-demand content enables you to train on your own schedule.



Request this course in a different delivery format.
Enroll