Cognos Data Manager
ETL software that delivers an integrated reporting data foundation
for the enterprise. Cognos Data Manager is powerful ETL (Extraction,
Transformation, and Load) software that lets you extract and unite
data from disparate sources and deliver coordinated Business Intelligence
across your organization. Cognos Data Manager’s advanced data
merging, aggregation and transformation capabilities let you unite
data from different sources, and transform it into information
using best-practices dimensional design. Cognos Cognos Data Manager
is comprised of a Windows-based dimensional design environment,
and a multi-platform, server-based ETL engine with native support
for all major relational databases. The design environment’s
intuitive graphical interface makes defining and implementing
transformation processes easy, while the high-performance transformation
engine processes large volumes of data quickly. Cognos Data Manager’s
generation of Business Intelligence metadata, and tight integration
with Cognos Business Intelligence components, delivers the fastest
route to Business Intelligence implementations.
Cognos Data Manager
| ADMINISTRATOR |
- Cognos Data Manager for Data Warehouse Developers
- Cognos Data Manager– What’s New in Series 8
|
Cognos Data Manager FOR DATA WAREHOUSE DEVELOPERS
5-DAY COURSE WITH WORKSHOPS
This five-day course will teach users how to move, merge, consolidate,
and transform data from a range of data sources to build and maintain
subject-area data marts. Cognos Data Manager data mart targets include
all the major relational databases and are typically designed
to create best practices dimensional data mart solutions (star
schema). Specifically, the course deals with the Dimensional Framework,
builds, and templates. The Dimensional Framework is a repository
for reference structures (dimensions, hierarchies, lookups, and
dimension templates) that promotes the reuse of these structures.
Builds are units of work that progress through the steps of data
acquisition, transformation, and delivery. Templates are objects
that define source and target attributes for dimension data.
| INTENDED
AUDIENCE |
PREREQUISITES |
| This course is
intended for developers who are planning a data warehouse
or have a data warehousing background. It is designed for
the more experienced systems professional involved in the
provision of MIS solutions. Typically, this audience includes
BI project consultants, project analysts, project leaders,
and database administrators. |
- Knowledge of Windows 98/ME/2000/XP
- Knowledge of database concepts
- Knowledge of dimensional analysis concepts
- Working knowledge of SQL
|
| TOPICS
COVERED |
|
- Dimensional modeling using DecisionStream
- Template development and the Dimensional Framework
- Dimension build creation and delivery
- Fact build creation and delivery
- JobStreams and the data mart development lifecycle
|
|
Cognos Data Manager– WHAT’S NEW IN SERIES 8
1-DAY COURSE WITH WORKSHOPS
Cognos Data Manager Series 8 has many new and exciting features, and
to get the best from this release, existing DecisionStream administrators
would benefit from attending this course.
| INTENDED
AUDIENCE |
PREREQUISITES |
| Data warehouse
designers and administrators who have working knowledge and
experience with Cognos DecisionStream 7. |
- DecisionStream 7 Administration course
- Working knowledge of SQL
- Knowledge of database concepts and dimensional analysis
concepts
All participants must be an existing Cognos Customer/Partner.
|
| TOPICS
COVERED |
|
- Release objectives for Cognos Cognos Data Manager Series
8
- Cognos SQL
- Using reference structure visualizations
- Tracking dimensional history
- On-demand caching
- Handling late arriving facts and dimensions
- Function library enhancements
- New ways to use derivations, mapping and pivoting
- Enhancements to JobStreams
- Collaborative projects
- Upgrading DecisionStream projects
|
|
|
