Overview
The Essentials for IBM Cognos 8 BI (V8.4) course is a 5 days bundled offering that provides you with knowledge on how to get started with building IBM Cognos 8 BI applications. The bundle includes a 5-day instructor led training online (ILOT) section. Fundamental topics on Report Authoring, Metadata Modeling, and Administration are covered during the ILOT portion. Throughout the ILOT, you will be guided to further training offerings and paths leading to certification.
Audience
This intermediate course is intended for Project Managers, Partners, Business Analysts/Developers.
Prerequisites
You should have:
* Knowledge of your business requirements
* Experience using the Windows operating system
* Experience using a web browser
Objectives
Please refer to course overview for description information.
Course outline
Instructor Led Online Training
Report Authoring
* Explore Report Studio, different report types (list, crosstab, chart, map)
* Focus reports by filtering data and using prompts
* Add value to reports by using calculations
* Highlight exceptional data
* Show and hide data
* Handle reports with no data
* Drill-through from a specific report to a target report
Metadata Modeling
* Create a baseline project
* Prepare reusable metadata
* Model for predictable results (identify reporting issues, virtual star schemas, consolidate metadata)
* Calculations and filters
* Implementing a time dimension
* Specify determinants
* Create a presentation view
* Creating different presentation types
* Working with different query subject types
Administration
* Introduction to IBM Cognos 8 BI administration
* Examining the IBM Cognos 8 BI architecture
* Securing the IBM Cognos 8 BI environment
* Setting security in Framework Manager
Introdudtion of below mentioned topics will be part of training
· IBM Cognos 8 BI Cognos Connection for Consumers (v8.4)
· IBM Cognos 8 BI Report Studio: Intermediate (v8.4)
· IBM Cognos 8 BI Report Studio: Express Authoring Mode (v8.4)
· IBM Cognos 8 BI Query Studio: Build Ad Hoc Reports (v8.4)
· IBM Cognos 8 BI Analysis Studio: Analyze Data (v8.4)
· BM Cognos 8 BI Event Studio: Create and Manage Agents (v8.4)
· IBM Cognos 8 Go! Office: Integrate with Microsoft Office (v8.4)
· IBM Cognos 8 BI Analysis for Excel: Analyze Data (v8.4)
· Introduction to creating IBM Cognos Power Cubes in Transformer
TOP
DataStage Essential (V8.1) 4 Days
Overview
Learn about the features of IBM WebSphere DataStage V8.1 and learn how to build and run DataStage Extract, Transform and Load (ETL) jobs.Learn about DataStage V8.1 in its IBM Information Server environment. Learn how to build DataStage parallel jobs that read and write data to and from a variety of data stores including sequential files, data sets, and relational tables. Also, learn how to build parallel jobs that process data in a variety of ways: business transformations, data filtering, data combining, data generation, sorting, and aggregating.
Audience
This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage
Prerequisites
You should have:
* Knowledge of UNIX or Windows NT administration
* Knowledge of TCP/IP and basic network principles
* Data modeling experience
* Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Skills taught
* Combine data using lookup, join, and merge stages
* Create jobs that read from and write to sequential files
* Make jobs that read from and write to a relational database using the connector stages
* Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
* Conduct searches and impact analyses
* Produce job reports
* Construct DataStage users
* Administer the DataStage environment
Course outline
* Deployment
* Administration console
* Designer
* Director
* Administrator
* Accessing sequential data
* Retrive relational data using connectors
* Combining data
* Transforming data
* Repository
* Job control
* Metadata
* Parallel framework
* Complex Flat File stage
* Slowly Changing Dimensions
* MQ Connector
* Performance Analyzer and Resource Estimator utilities
|
