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
“Instructor was very passionate about Databricks and helped me to stay engaged. Great pace, great knowledge, and the trainer was fantastic overall :) ”
- Emma Darling, Platform Engineer, Barclays Bank
“Our Informatica Data Quality training class was very good. The trainer knew the tool and the Informatica platform very well. We recommed ExistBI for Informatica training.”
- Darren Jackson, CIO, US Bank
“Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.”
- Blaine Clark, KPERS
