IBM Cognos Query Studio: Build Ad Hoc Reports

Displaying courses for Australia [Change]


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 organise ad hoc reports.


Attendees will learn 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. You will also learn about basic administrative tasks, such as scheduling reports and delivering reports in different formats (e.g. HTML, PDF, Excel).


This course is intended for business authors.


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


  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. Manage Content in IBM Cognos Connection
    • Schedule and manage reports
    • View lineage information
    • Add comments to saved output
    • Personalise and organise content
    • Set alerts and watch rules
    • Design a portal page and dashboard
    • Set permissions using IBM Cognos BI groups and roles

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Business analysis
This skill has an average salary of
and is mentioned in
of job ads in this area.
Business intelligence
This skill has an average salary of
and is mentioned in
of job ads in this area.