Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

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

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

Course#: B5150G

IBM Cognos Query Studio: Build Ad Hoc Reports (V10.1/10.2) is a one-day, instructor-led course designed for business authors who want to learn how to create, modify and organize ad hoc reports. This course covers how to use different report capabilities, how to graphically display 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 (e.g. HTML, PDF, Excel).

Please Note: Screen captures and labs in this course are taken from the V10.1 of the product. However, the concepts, procedures, and tasks are all applicable to a V10.2 environment and are suitable for V10.2 user education.

Audience

This course is intended for business authors.

Prerequisites

You should have:

  • Knowledge of your business requirements
  • Experience using basic Windows and Web functionality
  • Experience using a Web browser

Duration

1 Day

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

Overview of IBM Cognos BI

  • Discuss IBM Cognos and Performance Management
  • Describe IBM Cognos BI components
  • Describe IBM Cognos architecture at a high level
  • Define IBM Cognos BI groups and roles

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

End to End Workshop

  • Create a grouped list report
  • Filter data based on revenue and order year
  • Add a prompt to view sales of selected sales representatives
  • Format the report
  • Create a crosstab report
  • Add a chart to the crosstab report
  • Generate report outputs

Manage Content in IBM 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 IBM Cognos BI groups and roles
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.