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
“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”
- Grahame Welch, Head of BI, UK Home Office
“The Informatica Cloud Data Integration for Developers training class was excellent, the teacher was very knowledgeable and the materials were very useful”
- James Martin, Data Engineer, RoyOMartin
“Instructor was very passionate about the subject and definitely helped me to stay engaged. Great pace, great knowledge, and instructor was amazing overall :) ”
- John Smith, Analyst, Dept. of Homeland Security
