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
“Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.”
- Blaine Clark, KPERS
“Last week’s Informatica PowerCenter Bootcamp training was really good. It was very practical, and we had the opportunity to try out what was being taught. The trainer was incredibly kind and professional, and since there were only two of us, he was able to give us his full attention. I would definitely recommend this training to anyone.”
- Dilane Azangue, Data Integration Consultant, PTA IT Consulting
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
