4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

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


Course Description


Overview

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).  

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

Key topics

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

Objectives

Please refer to the Course Overview for description information.

Course Duration

1 day
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form