Cognos BI Training: Report Studio and Authoring against Dimensional Data

ExistBI is an IBM Cognos Partner

Course Description

Dimensional Authoring Fundamentals with IBM Cognos Report Studio is a two-day, instructor-led course. Students will create dynamic reports against multidimensional data sources such as PowerCubes by leveraging best practices with Report Studio. Students will be exposed to multidimensional expressions, functions and prompting techniques.

This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student’s computer screen and offer guidance. A full set of course materials is included and hard copies are sent prior to the class.

Course Outcomes

  • To provide an Introduction to Business Intelligence/Analytics.
  • To be able to describe the relationship between BI/BA and the associated Cognos studio.
  • To provide an Introduction to the Cognos10 (c10) toolset.
  • To provide an overview of Report Studio
  • To develop a range of skills within Report Studio that will enable the user to create/author reports

Course Summary

Next Public Course Dates

UK & Europe:

  • 23 - 24 July 2024
  • 13 - 14 August 2024
  • 27 - 28 August 2024

US & Canada:

  • 6 - 7 August 2024
  • 20 - 21 August 2024
  • 3 - 4 September 2024

More dates

Prerequisites
  • None, however it would be beneficial to be familiar with a web browser and comfortable with using laptops/PC’s and a mouse.
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Users who need to create and develop reports (authors) within Cognos Report Studio against a dimensional data source. This course is provided to give new users of Report Studio an overview of the user interface, together with an introduction to authoring techniques and functions used against a Dimensional (Cube) Data source.

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 Report Studio interface and overview of workshops.
  • Utilising and discussing various methods that can be used whilst building your reports.
  • Creation of basic reports, introduction to lists, crosstabs and charts within Report Studio.
  • Using insertable objects in your report and usage of various tools from within the toolbox. Creation of calculations and review of aggregation methods such as total, average, max, min…etc
  • Grouping and sorting your data.
  • Utilising dimensional functions to assist with report development against a dimensional data source.
  • Creating hard coded and parameterised filters and the creation of prompts and prompt pages.
  • Setting up variables, general formatting and conditional formatting.
  • Utilising and discussing various methods that can be used whilst building your reports.
  • Creation of queries, sql/mdx overview and understanding queries.
  • Creation of Profit & Loss/Balance Sheet/Cash Flow report in Report Studio.
  • Course Review and Feedback.
  • Recap – Q/A and course review/feedback.

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line