Audience
Users who need to create and develop reports (authors) within IBM Cognos Analytics Reporting against a dimensional data source. This course is provided to give new users of Cognos Analytics an overview of the user interface, together with in depth knowledge of basic and more advanced authoring techniques and functions against a Dimensional Data source.
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. Hands on.
Course Objectives
The objectives of this course are:
- To provide an Introduction to Business Intelligence/Analytics
- To be able to describe how the various Cognos Analytical tools can be used against a typical BI requirement, overviews on Dashboards, Data Modules and Stories
- To provide an overview of Reporting within Cognos Analytics
- To develop a range of skills within Reporting that will enable the user to create/author reports against a cube/dimensional data
Course Content
Discuss and provide an overview of Business Analytics
Overview of Cognos Analytics, covering the Connection Portal, general navigation and understanding of the interface and features available within the analytics tool
Introduction to the Reporting interface and overview of workshops
Understanding the differences between Relational/Dimensional techniques, creation of sql/mdx
Understanding dimensional reporting concepts, MUNs, members functions and queries
Utilising and discussing various methods that can be used whilst building your reports
Creation of basic reports, introduction to lists, crosstabs and charts within Reporting
Dimensional Terminology and setting up the report context, filtering using dimensional techniques, including sets, slicers and tuples
Utilising dimensional and relative 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
Understanding hierarchies and drill down/up and through options, general navigation
Course Review and Feedback, including recap and Q/A session