IBM B6063G - IBM COGNOS CUBE DESIGNER - Integrata IBM Cognos Dynamic Query Review Dimensional Data ... - Analytics Business Intelligence - IBM Cognos ... utilization of a the DB2 BLU

  • View
    219

  • Download
    0

Embed Size (px)

Text of IBM B6063G - IBM COGNOS CUBE DESIGNER - Integrata IBM Cognos Dynamic Query Review Dimensional Data...

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/36719

    IBM CL450G - IMPLEMENTATION AND USE OF DB2 BLU ACCELERATION

    Dauer: 1 Tag

    Durchfhrungsart: Prsenztraining

    Zielgruppe: This is an intermediate course for DB2 LUWexperienced database administrators who support DB2 for UNIX,Windows, and Linux databases and want to learn more about theDB2 BLU acceleration capabilities in DB2 10.5.

    Voraussetzungen: You should have completed:- DB2 10 for LUW: Basic Administration for Linux and Windows(CL2X3) or - DB2 10 for LUW: Basic Administration for AIX (CL213)or - DB2 10.1 for Linux, UNIX, and Windows Quickstart forExperienced Relational DBAs (CL484) - Or have equivalentexperience

    Nr.: 36719Preis: 790,00 (netto) / 940,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    This course is designed to teach you how to:- Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database.

    - Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression forcolumn-organized tables.

    - Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects toefficiently use system resources.

    - Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions.

    You get practical experience in the planning and utilization of a the DB2 BLU Acceleration functions, using DB2 LUW commands,utilities and SQL statements performing a lab exercise using DB2 Advanced Enterprise Edition 10.5 installed on a Linux platform.

    Programm

    Agenda:- DB2 10.5 BLU Acceleration Concepts

    - DB2 10.5 BLU Acceleration Implementation and Use

    - Exercise 1:Using DB2 BLU Acceleration to improve performance for analytics query processing.

  • IBM B6098G - IBM COGNOS ANALYTICS - AUTHOR ACTIVE REPORTS (V11.0)

    Dauer: 1 Tag

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Report authors wanting to develop interactive reportcontent, or content disconnected from IBM Cognos servers.

    Voraussetzungen: Basic understanding of IBM Cognos Analytics -Reporting

    Nr.: 37469Preis: 790,00 (netto) / 940,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    This course provides participants with an understanding of Active Report content and functionality within IBM Cognos Analytics -Reporting. Through lecture, demonstrations, and exercises, participants increase their IBM Cognos Analytics experience by buildinghighly interactive reports using Active Report controls, which can then be distributed to and consumed by users in a disconnectedenvironment, including on mobile devices.

    Learning Journeys or Training Paths that reference this course:

    - Analytics Business Intelligence

    - IBM Cognos Analytics 11.0 - Author Role

    - IBM Cognos Analytics 11.0 - Author Role

    Programm

    Key topics:1. Introduction to IBM Cognos Active Reports

    Examine IBM Cognos Active Reports

    Convert an existing report into an Active Report

    Add interactions in Active Reports using Active Report connections

    Create a basic Active Report

    Examine interactive behavior of Active Report controls

    Save a report in the IBM Cognos Analytics portal

    Save an Active Report to an MHT file

    Save an Active Report as a report template

    Use an Active Report as a prompt page

    Understand Active Report security

    2. Use Active Report Connections

    Examine Active Report connections

    Filter and select in controls using Active Report connections

    Examine variables

  • Use a single variable to control multiple controls

    Use multiple variables to show different data in different controls

    Use Active Report controls to support mobile device usage

    3. Active Report Charts and Decks

    Add charts to active reports

    Understand and optimize chart behavior

    Examine decks and data decks

    Optimize use of decks

    Review Master Detail relationships

    Examine RAVE visualizations

    Objectives:

    Please refer to course overview.

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/37469

    Termine und Orte: 28 Juni 2018 Nr.: 37469

    Dsseldorf

    16 Jul - 16 Jul 2018

  • IBM B6063G - IBM COGNOS CUBE DESIGNER - DESIGN DYNAMIC CUBES (V11.0)

    Dauer: 2 Tage

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Data Modelers

    Voraussetzungen: Knowledge of dimensional modeling and design.Experience using the IBM Cognos Analytics portal andAdministration.

    Nr.: 37482Preis: 1.390,00 (netto) / 1.654,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting andanalysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initialproject creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.

    Programm

    Key topics:1: Introduction to IBM Cognos Dynamic Cubes

    Define and differentiate Dynamic Cubes

    Dynamic Cubes characteristics

    Examine Dynamic Cube requirements

    Examine Dynamic Cube components

    Examine high level architecture

    IBM Cognos Dynamic Query

    Review Dimensional Data Structures

    Dynamic Cubes caching

    2: Create and design a Dynamic Cube

    Explore the IBM Cognos Cube Designer

    Review the cube development process

    Examine the Automatic Cube Generation

    Manual development overview

    Create dimensions

    Model the cube

    Best practice for effective modeling

    3: Deploy and configure a Dynamic Cube

    Deploy a cube

    Explore the Estimate Hardware Requirements

  • Identify cube management tasks

    Examine Query Service administration

    Explore Dynamic Cube properties

    Schedule cube actions

    Use the DCAdmin comment line tool

    4: Advanced Dynamic Cube modeling

    Examine advanced modeling concepts

    Explore modeling caveats

    Calculated measures and members

    Model Relative Time

    Explore the Current Period property

    Define period aggregation rules for measures

    5:Advanced features of Cube Designer

    Examine multilingual support

    Examine ragged hierarchies and padding members

    Define Parent-Child Dimensions

    Refresh Metadata

    Import Framework Manager packages

    Filter measures and dimensions

    6: Optimize performance with aggregates

    Identify aggregates and aggregate tables

    In-memory aggregates

    Use Aggregate Advisor to identify aggregates

    User defined in-memory aggregates

    Optimize In-Memory Aggregates automatically

    Aggregate Advisor recommendations

    Monitor Dynamic Cube performance

    Model aggregates (automatically vs manually)

    Use Slicers to define aggregation partitions

    7: Define Security

    Overview of Dynamic Cube security

    Identify security filters

    The Security process - Three steps

    Examine security scope

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/37482

    Identify scope rules

    Identify roles

    Capabilities and access permissions

    Cube security deep dive

    8: Model a virtual cube

    Explore virtual cubes

    Create the virtual cube

    Explore virtual cube objects

    Examine virtual measures and calculated members

    Currency conversion using virtual cubes

    Security on virtual cubes

    A: Introduction to IBM Cognos Analytics (Optional)

    Define IBM Cognos Analytics

    Redefined Business Intelligence

    Self-service

    Navigate to content in IBM Cognos Analytics

    Interact with the user interface

    Model data with IBM Cognos Analytics

    IBM Cognos Analytics components

    Create reports

    Perform self-service with analysis and Dashboards

    IBM Cognos Analytics architecture (high level)

    IBM Cognos Analytics security

    Package / data source relationship

    Create Data modules

    Upload files

    Objectives:

    Please refer to course overview

  • IBM B6059G - IBM COGNOS ANALYTICS: AUTHOR REPORTS ADVANCED (V11.0)

    Dauer: 2 Tage

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Report Authors.

    Voraussetzungen: - Knowledge of business requirements- B6088: IBM Cognos Analytics for Consumers (v11.0) - eLearning

    Nr.: 37466Preis: 1.390,00 (netto) / 1.654,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    This course teaches Professional Report Authors about advanced report building techniques using relational data models, and ways ofenhancing, customizing, and managing professional reports. The course builds on topics presented in the Fundamentals course.Attendees will participate in interactive demonstrations and exercises that illustrate key concepts while learning how to use advancedfeatures in the product builds on topics learned in the Fundamentals course.

    Learning Journeys or Training Paths that reference this course:

    - Analytics Business Intelligence

    - IBM Cognos Analytics

Recommended

View more >