Каталог курсов

Курсы IBM

Основы IBM Cognos BI (V10.2)

Код курса  Код: B5270    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 40 , Кол-во дней: 5


Подробное описание курса.


Essentials for IBM Cognos BI (V10.2) is a blended offering consisting of five-days of instructor-led training and
21 hours of Web-based, self-paced training. This accelerated offering is intended for core project team
members wishing to acquire a broad understanding of a Business Intelligence platform implementation.
During the ILT segments, participants will perform hands-on demos and workshops that cover four essential
topic areas: Modeling, Report Authoring, Workspace Advanced, and Administration of a BI platform.
Throughout the ILT, participants will be guided to more-in depth training offerings and paths leading to


Please refer to Course Description for description information.


This course is intended for Project Managers,Technical Analysts and Developers.


  • Experience using the Windows operating system
  • Experience using a web browser


1. Overview of IBM Cognos BI
  • discuss IBM Cognos BI and Performance Management
  • describe IBM Cognos BI components
  • describe IBM Cognos BI architecture at a high level
  • define IBM Cognos BI groups and roles
  • explain how to extend IBM Cognos BI

2. Identify Common Data Structures
  • Define the metadata modeling role in IBM Cognos BI
  • examine the characteristics of operational databases and databases designed for reporting
  • examine dimensional data sources (OLAP, ROLAP, DMR)

3. Gather Requirements
  • examine key modeling recommendations
  • define reporting requirements
  • explore data sources t identify data access strategies

4. Create a Baseline Project
  • examine the IBM Cognos BI workflow processes
  • define a project and its structure
  • describe the Framework Manager environment
  • create a baseline project
  • enhance the model with additional metadata

5. Prepare Reusable Metadata
  • identify facts and dimensions
  • examine relationships, and data traps
  • verify relationships and query item properties
  • ensure efficient filters by configuring prompt properties

6. Model for Predictable Results: Identify Reporting Issues
  • describe multi-fact queries and when full outer joins are appropriate
  • describe how IBM Cognos BI uses cardinality
  • identify reporting traps
  • use tools to analyze the model

7. Model for Predictable Results: Virtual Star Schemas
  • identify the advantages of modeling metadata as a star schema
  • model in layers
  • create aliases to avoid ambiguous joins
  • merge query subjects to create as view behavior

8. Model for Predictable Results: Consolidate Metadata
  • create virtual facts to simplify writing queries
  • create virtual dimensions to resolve fact-to-fact joins
  • create a consolidated modeling layer for presentation purposes
  • consolidate snowflake dimensions with model query subjects
  • simplify facts by hiding unnecessary codes

9. Calculations and Filters
  • use calculations to create commonly-needed query items for authors
  • use static filters to reduce the data returned
  • use macros and parameters in calculations and filters to dynamically control the data returned

10. Implement a Time Dimension
  • make time-based queries simple to author by implementing a time dimension
  • resolve confusion caused by multiple relationships between a time dimension and another table

11. Specify Determinants
  • use determinants to specify multiple levels of granularity and prevent double-counting

12. Create the Presentation View
  • identify the dimensions associated with a fact table
  • identify conformed vs. non-conformed dimensions
  • create star schema groupings to provide authors with logical groupings of query subjects
  • Rapidly create a model using the Model Design Accelerator

13. Create Analysis Objects
  • Define dimensionally modeled relational (DMR) metadata
  • apply dimensional information to relational metadata to enable OLAP-style queries
  • define members and member unique names

14. Introduction to the Reporting Application
  • Examine Report Studio and its interface
  • Explore different report types
  • Create a simple, sorted, and formatted report
  • Explore how data items are added to queries

15. Create List Reports
  • Format, group, and sort list reports
  • Describe options for aggregating data
  • Create a multi-fact query
  • Create a report with repeated data

16. Focus Reports Using Filters
  • Create filters t narrow the focus of reports
  • Examine detail and summary filters
  • Determine when t apply filters on aggregate data

17. Create Crosstab Reports
  • Format and sort crosstab reports
  • Convert a list to a crosstab
  • Create crosstabs using unrelated data items
  • Create complex crosstabs using drag and drop functionality

18. Present Data Graphically
  • Create charts containing peer and nested items
  • Present data using different chart type options
  • Add context to charts
  • Create and reuse custom chart palettes
  • Present key data in a single dashboard report

19. Focus Reports Using Prompts
  • Identify various prompt types
  • Use parameters and prompts to focus data
  • Search for prompt items
  • Navigate between pages

20. Extend Reports Using Calculations
  • Create calculations based on data in the data source
  • Add run-time information to the reports
  • Create expressions using functions
  • Highlight exceptional data
  • Show and hide data
  • Conditionally render objects in reports
  • Conditionally format one crosstab measure based on another
  • identify changes that impact a MUN
  • sort members for presentation and predictability

21. Customize Reports with Conditional Formatting
  • Create multi-lingual reports
  • Highlight Exceptional Data
  • Create a Conditionally Rendered Column
  • Conditionally Format One Crosstab Measure Based on Another

22. Drill-Through From One Report t Another
  • Let users navigate from a specific report t a target report
  • Pass parameter values t filter the data in drill-through targets
  • Navigate through multiple reports

23. Create Reports using Relational Data
  • Define Relational Data
  • Define report layouts
  • Build a report
  • Explain how to add data query items
  • Use calculations

24. Introduction t IBM Cognos BI Administration
  • Describe the role of the Administrator in relation to the IBM Cognos BI administration workflow process.
  • Describe the role of IBM Cognos Administration and IBM Cognos Configuration.

25. Identify IBM Cognos BI Architecture

26. Identify and explain:
  • the features of the IBM Cognos BI architecture
  • the three architectural tiers
  • IBM Cognos BI servlets and services
  • the default servlet container and alternatives t its use
  • an example of IBM Cognos BI request processing
  • installation options
  • load balancing mechanisms
  • configuration options
  • the IBM Cognos Application Firewall

27. Secure the IBM Cognos BI Environment
  • Identify the IBM Cognos BI security model
  • Define authentication and authorization in IBM Cognos BI.
  • Identify security policies
  • Secure the IBM Cognos BI environment

28. Manage Run Activities
  • Manage current, upcoming and past activities
  • Manage schedules

29. Manage Content in IBM Cognos Administration
  • View Data Sources Associated with a Package and Add a Data Source
  • Add Multiple Connections for a Single Data Source
  • Create a Distribution List
  • Create an Export and Import Archive
  • Save Content t the File System

30. Post class e-Learning:
  • IBM Cognos for Microsoft Office: Integrate with Microsoft Office (V10.1/10.2) (B5130)
  • IBM Cognos BI Event Studio: Create and Manage Agents (V8.4/10.1) (B5131)
  • IBM Cognos Transformer: Create PowerCubes (V10.1) (B5169)
  • IBM Cognos Workspace Advanced: Introduction (V10.2) (B5283)
  • IBM Cognos Workspace Advanced: Intermediate (V10.2) (B5284)
  • IBM Cognos BI for Consumers (V10.2) (B5288)
  • IBM Cognos Workspace: Create Workspaces (V10.2) (B5217)


You may also be interested in the following courses
IBM Cognos Workspace Advanced: Author Self-Service Reports (V10.2) is a two-day course. This
course will develop the skills the participants ...

IBM Cognos Workspace Advanced: Author Self-Service Reports (V10.2) B5281UA

Course materials for this course are available in:
  • English
  • Spanish (Latin America)
  • Portuguese (Brazil)
The course image is available in English only.
IBM Cognos Report ...

IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.2) SPVC J2261UA


Дополнительную информацию по учебным программам IBM в Украине вы можете получить на сайте: www.ibm.com/training/ua (Учебный центр в Украине).


Ссылка курса обучения
Назад в раздел

Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.

Свежие новости

20.11.2017 Расписание Учебного центра МУК 2018
До конца 2017 года осталось 6 недель, самое время начинать планировать следующий год

13.11.2017 Бесплатные практические вебинары MICROSOFT
Приглашение на бесплатные практические вебинары "Portal and billing MUK CSP" и "Trials and reseller’s Storefront" для партеров на базе Учебного центра МУК

06.11.2017 Со скидкой 20,18% на все курсы IBM с Учебным центром МУК в 2018 год

Планируйте курсы IBM на 2018 год вместе с нами до 31 декабря 2017 и получайте скидку 20,18%.

31.10.2017 HPE Education Brunch in Tbilisi 2017 собрал партнеров и заказчиков со всей Грузии

19 октября 2017 года прошло масштабное мероприятие - HPE Education Brunch in Tbilisi 2017 - организованное Учебным центром МУК Грузия совместно с Hewlett Packard Enterprise.