Course Description
This IBM Cognos Introduction to Query Studio 1-day training is designed to provide students with a curriculum 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).
Course Outcomes
- To provide an Introduction to Business Intelligence/Analytics.
- To provide an Overview of Cognos 10.
- To introduce the Query Studio interface.
- To develop a range of skills with Query Studio that will enable the user to create/author reports.
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Discuss and provide an overview of Business Analytics.
- Overview of Cognos 10, covering Cognos Connection, common studio’s and Framework Manager.
- Introduction to the Query Studio interface and overview of workshops.
- Creation of basic reports, introduction to lists, crosstabs and charts.
- Utilising and discussing various methods that can be used whilst building your reports.
- Creation of list reports and referencing query subjects through packages.
- Grouping, sorting and aggregation of your data.
- Creating filters, basic and complex. Formatting and working with the report layout.
- Setting up filter parameters and conditional formatting.
- Running and saving the reports in various formats.
- Creation of calculations.
- Re-prompting your filters, alignment of your report and formatting techniques.
- Creation of crosstab and chart reports.
- Authoring against both relational and cube data source, explanation of cubing terminology.
- Course Review and Feedback.
Testimonials
“ExistBI has provided multiple Microsoft Power BI training to our HR, Product and Sales teams. We’ve now engaged them to assist with complex Financial reports”
- Jena Bomboy, HR Director, The Giant Company
“We just finished the course and I’d like to say that Basem was an excellent teacher. I will definitely recommend your company and him in the future”
- Renee Dansereau, Senior Analyst, AXA XL
“Steve was a great instructor and was able to articulate the course material in a way that promoted learning.”
- Ben Ruddock, Analyst, GSP International Airport
