Embed Size (px)
Citation preview
MANAGEMENT INFORMATIQUE 33 RUE GEORGES POMPIDOU
78690 LES ESSARTS LE ROI
TELEPHONE + 06 78 77 97 78
mailto:[email protected]
1
B5A08 : Overview of IBM Cognos BI (v10.2.2)
Durée : 1 j
Objectifs : présenter les différents logiciels constituant l'offre IBM COGNOS 10.2.2 :
Workspace, Workspace Advanced, Insight, Report Studio, Framework Manager, Transformer, Cognos BI pour EXCEL...
Public : Business, Développeurs IBM Cognos Report Studio, responsables
MOE/MOA.
Moyens pédagogiques : PC avec Windows 7 Professional 64bits
- Serveur IBM COGNOS 10.2.2 BI installé + serveur Web IIS
- Machine virtuelle VMWARE donnant accès à IBM Cognos BI 10.2.2 ainsi qu’au portail IBM
COGNOS Connection
- Formation dispensée en français ou en anglais. ( supports en anglais )
Cours présenté sous forme de slides PDF + exercices d’application.
Prérequis : Si possible connaissance de la BI et de la modélisation en étoile
Planning détaillé ( EN )
Mod 01: IBM Cognos Business Intelligence Objectives
IBM Smarter Analytics
Anticipate, Predict, and Shape Business Outcomes
IBM Cognos Business Intelligence (BI) Capabilities
IBM Cognos 10 Family
IBM Cognos BI Enterprise Components
IBM Cognos BI Architecture (high level)
IBM Cognos BI Security
IBM Cognos BI Groups and Roles
Package/Data Source Relationship
Demo 1: Explore IBM Cognos BI / Report Studio / Framework Manager / IBM Cognos
Administration / IBM Data Studio
Extend IBM Cognos BI Enterprise
Summary
Mod 02: Consume Content in IBM Cognos BI
MANAGEMENT INFORMATIQUE 33 RUE GEORGES POMPIDOU
78690 LES ESSARTS LE ROI
TELEPHONE + 06 78 77 97 78
mailto:[email protected]
2
Objectives
Where Do Consumers Access BI Content
Use Published Reports
Drill Through to Related Data
Specify Run Report Options
Specify Properties of an Entry
Demo 1: Run a Report, Create a Report View, and Email the Different Versions of the Reports
Add Comments to Saved Output
Demo 2: Add Comments to Saved Output
Overview of IBM Cognos BI (v10.2.2)
Set Alerts and Watch Rules
Demo 3: Set up Watch Items
Summary
Mod 03: Create Reports in IBM Cognos BI Objectives
Identify Reporting: Overview
Identify the Package Types
What is IBM Cognos Workspace Advanced?
Identify Drivers for IBM Cognos Workspace Advanced
Explore the User Interface Components
Identify Analysis and Data Exploration Capabilities
View Set Definitions
Modify the Formatting and Layout
Integrate with Report Studio
Use External Data
Demo 1: Explore IBM Cognos Workspace Advanced
Create Reports in Report Studio
Examine the Report Studio Interface
Examine the Report Studio Interface (cont’d)
Identify Report Templates
Demo 2: Enhance a Report in Report Studio
Business Drivers for Active Reports
Create an Active Report in Report Studio
Examine Active Report Controls
Describe Active Report Variables
Preview Active Reports
Demo 3: Create a Simple Active Report Using Static and Data Controls
Import Personal Data
Demo 4: Import and Report on Personal Data
MANAGEMENT INFORMATIQUE 33 RUE GEORGES POMPIDOU
78690 LES ESSARTS LE ROI
TELEPHONE + 06 78 77 97 78
mailto:[email protected]
3
Summary
Mod 04: Create Workspaces Objectives
What is IBM Cognos Workspace
IBM Cognos Workspace Capabilities/Benefits
Demo 1 : Import and Report on Personal Data
Use Content to Create Workspaces
Add Report Content
Add Active Report Content
Add PowerPlay Content
Add Tools
Widget-to-Widget Communication
Disable Widget Communication
Filter Data in the Workspace
Sort, Group, and Ungroup Data
Calculate Data
Access IBM Cognos Workspace Advanced
Demo 2: Create a Workspace from Existing Content
Collaborate in a Workspace
Collaborate Using Comments
Collaborate Using Connections Activities
Collaborate Outside the Workspace Using IBM Connections
Demo 3: Collaborate Using Comments
Identify Additional Workspace Capabilities
Summary
Mod 05: Create Metadata models in IBM Cognos BI Objectives
Examine the Role of a Metadata Model
What is Framework Manager?
What is Framework Manager (cont'd)
Examine a Framework Manager Project
Examine the Model from the Author’s Point of View
The Framework Manager Workflow
Define Framework Manager Metadata Elements
Demo 1: Explore Framework Manager
Identify Transformer
Describe Transformer Key Capabilities
Build, Test, and Deploy in Transformer
What is a Transformer Model?
From Model to PowerCube
MANAGEMENT INFORMATIQUE 33 RUE GEORGES POMPIDOU
78690 LES ESSARTS LE ROI
TELEPHONE + 06 78 77 97 78
mailto:[email protected]
4
What is a PowerCube?
Describe Measures
What are Dimensions and Levels?
Describe the OLAP Structure
Describe the Result: Dimensional Analysis
Demo 2: Explore a Transformer Model
Dynamic Cubes
Why Dynamic Cubes?
Dynamic Cube Characteristics
Dynamic Cube Requirements
IBM Cognos Dynamic Query
Components and Tools
Demo 3: Explore the Dynamic Cube Lifecycle
Summary
Mod 06: Extend IBM Cognos BI Extend IBM Cognos BI
Objectives
Extend IBM Cognos BI: Overview
Identify IBM Cognos Mobile
Describe IBM Cognos for Microsoft Office
Demo 1: Explore IBM Cognos for Microsoft Office
Describe Event Studio
Identify the Event Studio Process Flow
Add a Task
Specify the Task Execution Rules
Schedule an Agent
Demo 2: Explore IBM Cognos Event Studio
Describe IBM Cognos Metric Studio
Identify Requirements
Map Requirements to the Application
Map Requirements: Example
Enhance the Metric Studio Application
Summary
