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

Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | [email protected]: https://www.integrata.de/36719

IBM CL450G - IMPLEMENTATION AND USE OF DB2 BLU ACCELERATION

Dauer: 1 Tag

Durchführungsart: Präsenztraining

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


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

Voraussetzungen: Basic understanding of IBM Cognos Analytics -Reporting



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


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.


Termine und Orte: 28 Juni 2018 – Nr.: 37469

Düsseldorf

16 Jul - 16 Jul 2018

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

Dauer: 2 Tage


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.


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


• 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


Zielgruppe: Report Authors.

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



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.





Programm

Key topics:1: Unit 1 Create query models

• build query models and then connect them to the report layout

• edit an SQL statement to author custom queries

• add filters and prompts to a report using the query models

2: Unit 2 Create reports based on query relationships

• create reports by joining queries

• combine data containers based on relationships from different queries

3: Unit 3 Create advanced dynamic reports

• filter reports on session parameter values

• navigate a briefing book using a table of contents

• create dynamic headers and titles that reflect report data

• create a customer invoice report

4: Unit 4 Design Effective Prompts

• control report displays using prompts

• specify conditional formatting values using prompts

• specify conditional rendering of objects based on prompt selection

• create sorted and filtered reports based on prompt selection

5: Unit 5 Create additional advanced reports

• create a report that displays summarized data before detailed data

• highlight alternate rows in a list report

• create a report using an external data file

• use single data items to summarize report information

• Create a report with tabbed pages. - New

6: Unit 6 Examine the report specification

• examine the report specification structure

• save and edit reports locally

• discuss considerations for modifying a report specification

• discuss adding custom toolbox objects and custom template options

7: Unit 7 Distribute reports through bursting

• distribute reports using bursting

• create burst keys

• identify report recipients and data items using burst tables

• distribute reports using email and the IBM Cognos Analytics portal

8: Unit 8 Enhance user interaction with HTML

• create tooltips that clarify report data

• create a popup window that contains prompts

• send emails using links in a report

9: Unit 9 - End-to-end workshop

Report 1: Burst a sales report by country

Report 2: Create a report letting users choose top and bottom number of product types

Report 3: Let users choose a chart type to display with a crosstab

Appendix A - Explore the Prompt API (Optional)

• describe the Prompt API

• describe the uses of the Prompt API

• describe the primary objects, methods and properties used in the Prompt API

• review prompt values

• explore the enhancement of prompts in reports with the Prompt API

Objectives:

Please refer to course overview



München

06 Aug - 07 Aug 2018

IBM CL451G - DB2 11 BLU ACCELERATION IMPLEMENTATION AND USE

Dauer: 2 Tage


Zielgruppe: This is an advanced course for DB2 LUW experienceddatabase administrators who support DB2 for UNIX, Windows, andLinux databases and want to learn more about the DB2 with BLUacceleration capabilities in DB2 11.1. These skills can also beutilized to support cloud based databases using DB2 on Cloud orIBM dashDB.

Voraussetzungen: Participants should have completed one of thefollowing courses:DB2 11.1 Administration Workshop for Linux (CL206)DB2 11.1Quickstart for Experienced Relational DBAs (CL486)



The course is intended for Data Administrators that need to prepare for using the DB2 BLU Acceleration facilities of DB2 11.1 for Linux,UNIX and Windows systems.The concepts and facilities of the BLU Acceleration feature of DB2 11 are presented including loading data into column-organizedtables and monitoring the processing of SQL statements that access the tables.

The DB2 10.5 Fix Pack 4, referred to as Cancun, added support for Shadow tables, a new type of Materialized Query Table, and alsoColumn-organized User Maintained MQT tables. One lecture unit describes these features. A demonstration allows students toimplement and experiment with these functions.

With DB2 11.1, BLU Acceleration can be used in a clustered multiple database partition DB2 environment. This course includes alecture and demonstration that allows students to create a set of column-organized tables from an existing set of row-organized tablesand execute and analyze the performance of BLU Acceleration in a MPP database.

The lab demonstrations are performed using DB2 LUW 11.1 for Linux.

Programm

Key topics

Topics Covered:

BLU Acceleration ConceptsBLU Acceleration Implementation and UseImplementing Shadow Tables and BLU MQTsDB2 BLU MPP support



Düsseldorf

15 Okt - 16 Okt 2018

IBM DW606G - IBM OPEN PLATFORM WITH APACHE HADOOP - UPDATED

Dauer: 2 Tage


Zielgruppe: This intermediate training course is for those who wanta foundation of IBM BigInsights. This includes: Big data engineers,data scientist, developers or programmers, administrators who areinterested in learning about IBM's Open Platform with ApacheHadoop.

Voraussetzungen: None, however, knowledge of Linux would bebeneficial.



IBM Open Platform (IOP) with Apache Hadoop is the first premiere collaborative platform to enable Big Data solutions to be developedon the common set of Apache Hadoop technologies. The Open Data Platform initiative (ODP) is a shared industry effort focused onpromoting and advancing the state of Apache Hadoop and Big Data technologies for the enterprise. The current ecosystem ischallenged and slowed by fragmented and duplicated efforts between different groups. The ODP Core will take the guesswork out ofthe process and accelerate many use cases by running on a common platform. It allows enterprises to focus on building businessdriven applications.

This module provides an in-depth introduction to the main components of the ODP core --namely Apache Hadoop (inclusive of HDFS,YARN, and MapReduce) and Apache Ambari -- as well as providing a treatment of the main open-source components that are generallymade available with the ODP core in a production Hadoop cluster.

Programm

Key Topics:- Unit 1: IBM Open Platform with Apache Hadoop

Exercise 1: Exploring the HDFS

- Unit 2: Apache Ambari

Exercise 2: Managing Hadoop clusters with Apache Ambari

- Unit 3: Hadoop Distributed File System

Exercise 3: File access and basic commands with HDFS

- Unit 4: MapReduce and Yarn

Topic 1: Introduction to MapReduce based on MR1

Topic 2: Limitations of MR1

Topic 3: YARN and MR2

Exercise 4: Creating and coding a simple MapReduce job

Possibly a more complex second Exercise

- Unit 5: Apache Spark

Exercise 5: Working with Spark's RDD to a Spark job


- Unit 6: Coordination, management, and governance

Exercise 6: Apache ZooKeeper, Apache Slider, Apache Knox

- Unit 7: Data Movement

Exercise 7: Moving data into Hadoop with Flume and Sqoop

- Unit 8: Storing and Accessing Data

Topic 1: Representing Data: CSV, XML, JSON, and YAML

Topic 2: Open Source Programming Languages: Pig, Hive, and Other [R, Python, etc]

Topic 3: NoSQL Concepts

Topic 4: Accessing Hadoop data using Hive

Exercise 8: Performing CRUD operations using the HBase shell

Topic 5: Querying Hadoop data using Hive

Exercise 9: Using Hive to Access Hadoop / HBase Data

- Unit 9: Advanced Topics

Topic 1: Controlling job workflows with Oozie

Topic 2: Search using Apache Solr

No lab exercises

Objectives:

- List and describe the major components of the open-source Apache Hadoop stack and the approach taken by the Open DataFoundation.

- Manage and monitor Hadoop clusters with Apache Ambari and related components

- Explore the Hadoop Distributed File System (HDFS) by running Hadoop commands.

- Understand the differences between Hadoop 1 (with MapReduce 1) and Hadoop 2 (with YARN and MapReduce 2).

- Create and run basic MapReduce jobs using command line.

- Explain how Spark integrates into the Hadoop ecosystem.

- Execute iterative algorithms using Spark's RDD.

- Explain the role of coordination, management, and governance in the Hadoop ecosystem using Apache Zookeeper, Apache Slider,and Apache Knox.

- Explore common methods for performing data movement (Configure Flume for data loading of log files, Move data into the HDFSfrom relational databases using Sqoop)

- Understand when to use various data storage formats (flat files, CSV/delimited, Avro/Sequence files, Parquet, etc.).

- Review the differences between the available open-source programming languages typically used with Hadoop (Pig, Hive) and forData Science (Python, R)

- Query data from Hive.

- Perform random access on data stored in HBase.

- Explore advanced concepts, including Oozie and Solr

IBM B6019G - IBM COGNOS ANALYTICS: ARCHITECTURE AND LOGGING (V11.0)

Dauer: 2 Tage


Zielgruppe: Administrators responsible for administering the IBMCognos Analytics 11.0 environment

Voraussetzungen: IBM Cognos Analytics: Administration (v11.0)course or equivalent experience administering the IBM CognosAnalytics environment.



This course is designed to teach participants how to identify components and sub-components of the IBM Cognos Analyticsarchitecture and how to use tools and techniques to provide a foundation to troubleshoot issues. Through lecture and interactiveexercises participants will identify IBM Cognos Analytics components, examine how these components interact with Java, and willexplore logging to assist when troubleshooting issues.

Programm

Key topics

Architecture Overview

1: Introduction and Service-Oriented Architecture

• Identify IBM Cognos 11.0 architectural components

• Describe Service-Oriented Architecture in IBM Cognos Analytics

2: Explore the IBM Cognos Dispatcher

• Describe IBM Cognos Dispatcher

• Describe request routing and the routing process

• Describe Content Manager Cache Service

3: Examine IBM Cognos services

• Identify IBM Cognos services

• Explore the architecture in IBM Cognos 11.0

4: Examine Java memory management

• Describe Java memory layout

• Manage Java memory

• Use tools to monitor Java memory

5: Examine audit logging and Indication Processing Facility logging

• Describe installation logs and configuration logs

• Explore audit logging


• Explore IPF logging

6: Perform dye tracing

• Identify dye tracing requirements

• Perform dye tracing

7: Explore Dynamic Query Mode

• Explain Dynamic Query Mode (DQM) logging

• Explain IBM Cognos Dynamic Query Analyzer (DQA)

8: Explore component logging

• Explore component logging for Gateway, Dispatcher, Report Server, and Universal Data Access layer

9: Examine additional tools and special task logging

• Explore diagnostic tools and utilities for special task logging

IBM P8221G - IBM COGNOS CONTROLLER: DEVELOP APPLICATIONS (V10.2)

Dauer: 5 Tage


Zielgruppe: Application Developers.

Voraussetzungen: Basic knowledge of group accounting.



This course teaches application developers how to set up a Controller application and effectively use Controller in their organization’sconsolidation process. Students will also design and generate financial reports using Controller. Through a series of lectures andhands-on exercises, students will set up a Controller application by creating the necessary structures (such as accounts andcompanies), and then test the application to ensure that it works properly. Students will also learn how to work with currencytranslation, allocations, intercompany transactions, investments in subsidiaries, advanced formula calculations, and user-definedbusiness rules, as well as define configuration settings and user access to the application.

Programm

Key topics:- Create companies, consolidation types, and account structures

- Create and organize forms for entering data into the Controller application

- Generate movement accounts to show changes to data over time

- Create extended dimensions to enhance data analysis

- Link structures to customize end users’ access to Controller data

- Define and schedule the data entry process

- Test the Controller application setup

- Adjust data through journal entries

- Translate foreign currencies

- Enable automatically created journal entries

- Allocate values

- Reconcile and eliminate intercompany transactions

- Work with shareholdings and investments in group companies

- Calculate and eliminate acquisition values

- Consolidate a group’s reported values

- Define security restrictions to different parts of the application

- Eliminate intercompany profit

- Create complex stored calculations

- Customize the consolidation process using user-defined business rules (UDBRs)

- Create ad hoc reports to quickly analyze and compare figures

- Run standard reports to verify and analyze data for consolidation

- Create custom reports using the Report Generator

- Create, modify, and run reports in Excel using the Excel Link

- Run multiple reports simultaneously by grouping reports into report books

- Identify different consolidation models (Optional)



Köln

17 Sep - 21 Sep 2018


IBM 1R119G - IBM COGNOS ICM: BUILDING REPORTS (V9.0)

Dauer: 3 Tage


Zielgruppe: Report Author.

Voraussetzungen: Training Paths that reference this course are:- IBM Cognos ICM 9.0 – Implementer Role- IBM Cognos ICM 9.0 –Report Builder Role



IBM Cognos ICM: Build Reports (v9.0) is designed for professional report authors to learn report building techniques using ICM toenhance, customize, and manage professional reports. Attendees will participate in interactive Demos and Workshops that illustratekey concepts while learning how to use the product.

Programm

Key topics:- Overview of IBM Cognos ICM

- Sample Outdoors Company model overview

- Overview of ICM reports

- Creating Presenter report templates

- Displaying data in columns and rows

- Filtering Presenter report data

- Using process lists to test Presenter reports

- Displaying single values

- Linking Presenter reports

- Adding computed columns and rows

- Row form sources and editable data grids

- Using Workflow Manager

- Displaying charts and gauges

- Adding maps

- Using Web Forms

- Tailored Reports and Compensation Plans

- Enabling Reports for Web viewing

IBM PLANNING ANALYTICS (TM1): DATENMODELLIERUNG

Dauer: 3 Tage


Zielgruppe: Planungsanwender.

Voraussetzungen: Verständnis für IT-Systeme, Daten undbetriebswirtschaftliche AnforderungenTeilnahme an dem Kurs Nr. 54151 „IBM Cognos AnalyticsBasistraining“ oder vergleichbares Wissen


Schulungsmethode: Vortrag, Demonstrationen und praktischeÜbungen.

Der Kurs „IBM Planning Analytics: Datenmodellierung“ ist ein dreitägiges Aufbautraining für Planungsanwender. Die Teilnehmererlernen, wie sie Unternehmensdaten in IBM Planning Analytics bereitstellen. Außerdem werden die grundlegenden Funktionen zurDatenmodellierung anhand von Planszenarien und Trainingsaufgaben erarbeitet.

In diesem Aufbautraining erweitern Sie Ihr IBM Planning Analytics-Wissen um die Möglichkeiten der Modellierung von Dimensionen undWürfeln. Sie lernen Abhängigkeiten zwischen Würfeln zu schaffen, die Datenbeschaffung zu automatisieren und dieworkflowgesteuerte Planung einzurichten.

Programm

Überblick über die Architektur und die Komponenten von IBM Planning AnalyticsErstellen und Bearbeiten von DimensionenErstellen von Cubes und AnsichtenLaden und Verwalten von Daten in IBM Planning AnalyticsVerwendung von Rules und FeedersSkripte zum Laden von Daten in ein ModellErstellen von Subset, Ansichten und FilternVerwendung der Workflowkomponente (optional)Integration in IBM Cognos Analytics (optional)



Hamburg

10 Sep - 12 Sep 2018

München

03 Dez - 05 Dez 2018

IBM B6058G - IBM COGNOS ANALYTICS: AUTHOR REPORTS FUNDAMENTALS(V11.0)B6058G

Dauer: 3 Tage


Zielgruppe: Authors

Voraussetzungen: - Knowledge of your business requirements�- Experience using the Windows operating system�- Experienceusing a Web browser


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

Build Data Models with Cognos Analytics. Learn report building techniques using relational data models. Techniques to enhance,customize, and manage professional reports will be explored.

Programm

Introduction to the Reporting Application:- Author Reports

- Report types

- Create a simple, sorted, and formatted report

- Explore how data items are added queries

Create List Reports:

- Format, group, and sort list reports

- Aggregating data

- Multi-fact query

- Create reports

Focus Reports Using Filters:

- Create filters

- Apply filters

Create Crosstab Reports:

- Format and sort crosstab reports

- Create crosstabs

Present Data Graphically:

- Create charts

- Present data

- Add context to charts

- Create and reuse custom chart palettes

- Visualization

- Present key data in a dashboard report

Focus Reports Using Prompts:

- Prompt types

- Parameters and prompts

- Navigate between pages

Extend Reports Using Calculations:

- Create expressions using functions

- Add run-time information

Use Additional Report Building Techniques:

- Report design

- Reuse objects

- Share layout components among separate reports

- Report templates

- Handle reports with no available data

Customize Conditional Formatting:

- Multi-lingual reports

- Exceptional data

- Show and hide data

- Render objects in reports

- Format one crosstab measure based on another

Drill-Through from One Report to Another:

- Navigate from a specific report to a target report

- Pass parameter values to filter data

Drill Through Defininitions:

- Parameter-driven and dynamic drill through

- Package-based drill through definitions

- Use the Drill-Through Assistant

Enhance Report Layout:

- Page breaks in reports

- Modify reports

- Horizontal formatting

- Print options for PDF reports

- Format data and report objects

Hinweis

Class language is German, student notebooks in English.



Hamburg

05 Nov - 07 Nov 2018

IBM B6055G - IBM COGNOS ANALYTICS: ENTERPRISE ADMINISTRATION (V11.0)

Dauer: 3 Tage


Zielgruppe: Administrators

Voraussetzungen: Knowledge of Web application serverarchitecturesSecurity systems administrationExperience using basic WindowsfunctionalityExperience using a Web browserKnowledge of yourbusiness requirements


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

IBM Cognos Analytics introduces smarter self-service that guides you in generating insights from data for impressive and effectivepresentation. Cognos Analytics helps you meet all your organization’s needs in one integrated solution.This course provides training to new administrators on the fundamental tasks of installing and configuring IBM Cognos Analytics, andadministering servers and content in the environment, including security, monitoring, scheduling tasks, create data sources, andmanage and deploy content.

Programm

Introduction to IBM Cognos Analytics administration:- IBM Cognos Analytics enterprise components

- role of the Administrator in relation to the IBM Cognos Analytics administration workflow process

- IBM Cognos Administration and Configuration

Identify IBM Cognos Analytics architecture:

- IBM Cognos Analytics architecture

- the three architectural tiers

- Servlets and services

- default servlet container and alternatives

- Request processing

- installation and configuration

- load balancing

- the IBM Cognos Application Firewall

Secure the IBM Cognos Analytics environment:

- Security model

- Authentication in IBM Cognos Analytics

- Security policies

- Secure the IBM Cognos Analytics Environment

Administer the IBM Cognos Analytics server environment:

- Administer the IBM Cognos Analytics server environment

- Dispatchers and services

- Log message facility

- Tune performance of servers

- Troubleshoot the server environment

- Backup

- Dynamic cubes

Manage run activities:

- Current, upcoming, and past activities

- Schedules

Manage content in IBM Cognos Administration:

- Add a data source

- Visualizations in the Library

- Deployments

- Maintain the IBM Cognos Analytics content store

- Content management considerations

Additional configuration and customization:

- User profiles

- Packages through the IBM Cognos Analytics portal

Hinweis




Hamburg

08 Okt - 10 Okt 2018

IBM COGNOS ANALYTICS REPORTING: BERICHTSERSTELLUNG AUF BASISMULTIDIMENSIONALER DATEN

Dauer: 2 Tage


Zielgruppe: Fortgeschrittene Berichtsersteller.

Voraussetzungen: Grundlagen der Berichtserstellung (Teilnahmean einem der beiden Kurse „IBM Cognos Analytics Basistraining“oder „IBM Cognos Analytics Reporting: Grundlagen derBerichtserstellung“ oder vergleichbares Wissen).



Der Kurs „IBM Cognos Analytics Reporting: Berichtserstellung auf Basis multidimensionaler Daten“ ist ein zweitägiges Praxistraining fürfortgeschrittene Berichtsersteller. Ziel ist es, das Wissen rund um die Berichtserstellung auf Basis multidimensionaler Daten zuvertiefen.

Nach Abschluss des Trainings können Sie dimensionale Konzepte verstehen und anwenden. Sie kennen eine Reihe von Funktionen undsind in der Lage, multidimensionale Datenquellen in Berichten zu verwenden.

Programm

Einführung in dimensionale KonzepteDimensionale und relationale Modelltypen vergleichenDatensätze in Berichten definieren und verwendenDimensionale Funktionen für Mitglieder, Datensätze und Tupel untersuchenEingrenzen von dimensionalen DatenBerichte anhand von Mitgliedern eingrenzenBerichte anhand von Kennzahlen eingrenzenBerechnungen und dimensionale FunktionenNavigieren in dimensionalen HierarchienBerichte auf aktuelle Zeiträume eingrenzenDaten mit entsprechenden Zeiträumen vergleichenFortgeschrittene Drilltechniken und erweiterte MitgliedersätzeKonfigurieren von Drill-through-Berichten



Hamburg

17 Jul - 18 Jul 2018

IBM COGNOS ANALYTICS REPORTING: BERICHTSERSTELLUNG FüRFORTGESCHRITTENE

Dauer: 3 Tage


Zielgruppe: Berichtsersteller.

Voraussetzungen: Grundlagen der Berichtserstellung (Teilnahmean einem der beiden Kurse „IBM Cognos Analytics Basis Training“oder „IBM Cognos Analytics Reporting: Grundlagen derBerichtserstellung“ oder vergleichbares Wissen).



Der Kurs „IBM Cognos Analytics Reporting: Berichtserstellung für Fortgeschrittene“ ist ein dreitägiges Praxistraining fürBerichtsersteller und baut auf Kenntnissen des IBM Cognos Analytics Basistrainings auf. Ziel ist es, das Wissen rund um dieBerichtserstellung mit demIBM Cognos Report Studio zu vertiefen.

Nach Abschluss des Trainings verfügen Sie über weiterführende und fortgeschrittene Techniken der Reporterstellung. Sie können IhrWissen in der Nutzung von aktiven Berichten anwenden und vertiefen. Zudem sind Sie in der Lage, erste Agenten in IBM CognosAnalytics

Event zu erstellen und zu automatisieren.

Programm

Vertiefung der Kenntnisse in Filter- und AggregationsmethodenVerwenden und Verstehen von komplexen BerichtsabfragenErstellen von Beziehungen zwischen BerichtsabfragenAbfragemodelle erstellen und mit dem Berichts-Layout verbindenBerichtszustellung durch automatisierte ZielgruppenverteilungAutomatische Berichtsverteilung ins DateisystemErstellen erweiterter dynamischer Berichte mit Lesezeichen und InhaltsverzeichnissenDesign effektiver Berichte durch fortgeschrittene BerichtstechnikenVerbesserung der Benutzerinteraktionen mit HTML-ElementenEinführung und Nutzung von „Active Reports“Filtern und Auswählen in „Active Reports“Erweiterte Funktionen für „Active Reports“ verwendenDrill-through in „Active Reports“Drill-up und Drill-down in „Active Reports”Kaskadierende Abfragen in „Active Reports“Einführung in das IBM Cognos Analytics Event (optional)



Düsseldorf

08 Okt - 10 Okt 2018

Berlin

13 Nov - 15 Nov 2018

IBM COGNOS ANALYTICS REPORTING: GRUNDLAGEN DER BERICHTSERSTELLUNG

Dauer: 2 Tage


Zielgruppe: Dieser Kurs richtet sich an Berichtsautoren, dieTechniken der Reporterstellung und Verwaltung vonprofessionellen Berichten auf Basisrelationaler Datenmodelle erlernen möchten.

Voraussetzungen: Verständnis für Daten undbetriebswirtschaftliche Anforderungen.



Der Kurs „IBM Cognos Analytics Reporting: Grundlagen der Berichtserstellung“ ist ein zweitägiges Praxistraining für Berichtsersteller.Anhand von Beispielen und Trainingsaufgaben wird die Verwendung des Produktes nähergebracht.

Nach Abschluss des Trainings verfügen Sie über Basiskenntnisse zur Erstellung professioneller und interaktiver Berichte.

Programm

Übersicht IBM Cognos Analytics:

Allgemeiner Überblick zu IBM Cognos Analytics

Grundlagen zum IBM Cognos Analytics Reporting:

Einführung ins IBM Cognos Analytics ReportingErkunden von IBM Cognos Analytics Reporting sowie verschiedener BerichtstypenErstellen von einfachen Listen und KreuztabellenBerichtserstellung und -formatierung mithilfe von Gruppierung, Kopf- und FußzeilenFokussierung von Berichtsinhalten durch DatenfilterBerichtserweiterung und -aufwertung durch Verwendung von BerechnungenBerichtsoptimierung mit umfassenden Formatierungs- und LayouttechnikenGrafische Darstellung von InhaltenParameterweitergabe für die Filterung in Zielberichten per Drill-through-DefinitionEingrenzen von Daten mithilfe von EingabeaufforderungenOptimierung der Eingabeaufforderungsseiten durch kaskadierende Quellen



Frankfurt

10 Dez - 11 Dez 2018

IBM COGNOS ANALYTICS (V.11X) BASISTRAINING

Dauer: 3 Tage


Zielgruppe: Dieser Kurs richtet sich an Anwender undBerichtsersteller.




Das IBM Cognos Analytics Basistraining ist ein dreitägiger, von einem Dozenten geführter Basiskurs zur Einführung in die Nutzung vonIBM Cognos Analytics. Die Teilnehmer erlernen von Grund auf die ersten Schritte im Umgang mit dieser BI-Lösung. Zudem werdengrundlegende praktische Beispiele im IBM Cognos Dashboard und IBM Cognos Bericht erarbeitet.

Nach Abschluss des Trainings sind Sie mit den Funktionalitäten Ihrer Reporting-Umgebung vertraut. Sie sind in der Lage, eigeneleistungsfähige und interaktive Arbeitsbereiche zu erzeugen und einfache und übersichtliche Dashboards im IBM Cognos Dashboard zuerstellen. Weiterhin verfügen Sie über Basiskenntnisse, um erste professionelle und interaktive Berichte im IBM Cognos AnalyticsReportings zu erstellen.

Programm

Übersicht IBM Cognos Analytics:

Datenherkunft (dimensional & relational) und ArchitekturNavigation, Verwaltung von Objekten und persönlichen Einstellungen im IBM Cognos Portal ‚Willkommen‘Anlegen und Verwalten von Ordnern, Zeitplänen, Aufgaben und BerichtsansichtenBerichtsexporte in PDF, Excel, CSV

Einführung ins IBM Cognos Dashboard:

Einführung in die Nutzung von IBM Cognos DashboardErstellen einfacher DashboardsNutzen neuer Visualisierungen zur besseren TransparenzEinbindung von Berichtselementen diverser BerichteErstellen einfacher Interaktionsfelder zur besseren NavigationDatenanalyse über grafische Auswertungen und Diagramme

Grundlagen des IBM Cognos Analytics Reportings:

Einführung ins IBM Cognos Analytics ReportingErkunden von IBM Cognos Analytics Reporting sowie verschiedener BerichtstypenErstellung von einfachen Listen und KreuztabellenBerichtserstellung und -formatierung mithilfe von Gruppierung, Kopf- und FußzeilenFokussierung von Berichtsinhalten durch DatenfilterBerichtserweiterung und -aufwertung durch Verwendung von BerechnungenBerichtsoptimierung mit umfassenden Formatierungs- und LayouttechnikenGrafische Darstellung von InhaltenParameterweitergabe für die Filterung in Zielberichten per Drill-through-Definition

Eingrenzen von Daten mithilfe von EingabeaufforderungenOptimierung der Eingabeaufforderungsseiten durch kaskadierende Quellen

Einführung ins IBM Cognos for Microsoft Office (optional):

Installation & Einrichtung von IBM Cognos in Microsoft Office-ProdukteNutzung von IBM Cognos for Microsoft OfficeImport von IBM Cognos Analytics-Elementen in MS Excel, MS Word und MS PowerPoint



München

06 Nov - 08 Nov 2018

IBM COGNOS ANALYTICS REPORTING: AKTIVE BERICHTE ERSTELLEN

Dauer: 1 Tag


Zielgruppe: Fortgeschrittene Berichtsersteller.

Voraussetzungen: Grundlagen der Berichtserstellung (Teilnahmean einem der beiden Kurse „IBM Cognos Analytics Basistraining“oder „IBM Cognos Analytics Reporting: Grundlagen derBerichtserstellung“ oder vergleichbares Wissen).



Der Kurs „IBM Cognos Analytics Reporting: Aktive Berichte erstellen“ ist ein eintägiges Praxistraining für fortgeschritteneBerichtsersteller. Ziel ist es, das Wissen rund um die Berichtserstellung von „aktiven Berichten“ zu vertiefen, um interaktive Berichtezu erstellen, die offline verwendet werden können.

Nach Abschluss des Trainings haben Sie Kenntnisse über einen neuen Teilbereich des IBM Cognos Analytics Reportings erlangt: IBMCognos Analytics Active Reports. Sie sind in der Lage, interaktive Berichte zu erstellen und zu optimieren.

Programm

Einführung und Nutzung von „Active Reports“Filtern und Auswählen in „Active Reports“Erweiterte Funktionen für „Active Reports“ verwendenDrill-through in „Active Reports“Drill-up und Drill-down in „Active Reports“Kaskadierende Abfragen in „Active Reports“



Hamburg

24 Sep - 24 Sep 2018

IBM B5280G - IBM COGNOS DATA MANAGER: BUILD DATA MARTS WITHENTERPRISE DATA (V10.2)

Dauer: 5 Tage


Zielgruppe: This course is intended for Developers.

Voraussetzungen: You should have:- a knowledge of basic Windows functionality, database anddimensional analysis concepts, as well as a working knowledge ofSQL



IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.2) is a five-day, instructor-led course that teaches participantshow to move, merge, consolidate, and transform data from a range of data sources to build and maintain subject-area data marts. Inthe process, students will create a catalog and add connections to data sources and targets. They will also deliver fact and dimensiondata to a data mart through the use of builds and the dimensional framework. In addition, students will learn how to automatecommon functionality and handle complex data issues, such as unbalanced hierarchical structures.

Training Paths that reference this course are:

- IBM Cognos BI 10.2 – Developer Role

- IBM Cognos BI 10.2 - Developer Role

Programm

Key topicsGetting Started:

- Identify the purpose of IBM Cognos Data Manager

- Define data warehousing and its key underlying concepts

- Identify how Data Manager creates data warehouses

- Examine the Data Manager architecture and user interface

Create a Catalog:

- Examine the purpose and contents of Data Manager catalogs

- Create a catalog

- Define connections to source and target data

- Access data using SQLTerm

- Configure flat data source files using SQLTXT

Create Hierarchies:

- Examine the role of the dimensional framework in Data Manager

- Examine hierarchies and their data sources

- Identify how to create hierarchies from the columns of one table, the rows of one table, and from multiple tables

- Test and view hierarchies

- Create a hierarchy of static date values

- Handle weeks in a date hierarchy

Create Basic Builds:

- Examine Data Manager builds and build-related terminology

- Create a dimension build using the Dimension Build wizard

- Create a fact build using the Fact Build wizard

- Test and execute a fact build

- Document a catalog

- Create catalog schema

Create Derivations:

- Examine derivations

- Apply operators and functions to derivations

- Examine the derivation timing model

- Add derivations to a fact build

Create Conformed Dimensions:

- Examine conformed dimensions and their advantages

- Design conformed dimensions

- Create conformed dimensions

- Create data integrity lookups that use conformed dimensions

Customize Reference Structures:

- Create hierarchies manually using different approaches

- Examine the features of a hierarchy

- Examine literals

- Set data access for hierarchy levels

- Examine static and dynamic members

- Examine fostering

- Use derivations in a hierarchy

Process Dimensional History and Late Arriving Facts:

- Examine slowly changing dimensions (SCDs)

- Use surrogate keys in SCDs

- Manage type 1 and type 2 changes to dimensional data

- Load historical data for a dimension

- Examine late arriving facts

- Process late arriving facts in a fact build

Transform Data Using Lookups and Derived Dimensions:

- Identify when to use lookups

- Identify the requirements for a lookup

- Create a translation lookup

- Create an optional lookup

- Add derived dimensions to fact builds

Customize Data Delivery:

- Configure fact and dimension delivery modules

- Create indexes on fact and dimension tables

- Update fact data using keys

Customize Fact Data Processing:

- Filter fact data

- Merge duplicate fact data

- Examine fact data integrity checking

- Reject fact data

Aggregate, Filter, and Partition Fact Data:

- Aggregate fact data

- Examine aggregate rules

- Vertically restrict fact data

- Horizontally restrict fact data

- Partition fact data

Implement Job Control:

- Examine where job control fits into the data warehouse lifecycle

- Create a JobStream

- Add, link, and reposition nodes

- Execute a JobStream and view the results

Automate Functionality Using Commands:

- Differentiate between the Command Line Interface (CLI) and Data Manager Designer

- Identify common commands

- Use commands in a batch file

- Examine variables

Customize Functionality with User-Defined Functions and Variables:

- Examine user defined functions (UDFs)

- Create an internal UDF

- Create a user-defined variable

Process Unbalanced Hierarchical Data:

- Examine balanced, unbalanced, and ragged hierarchies

- Add a recursive level to a hierarchy

- Identify ways to balance a hierarchy and delivered flattened data

- Examine circular references

Pivot Fact Data:

- Examine pivoting

- Use the single pivot technique

- Use the advanced pivot technique

- Examine reverse pivoting

Resolve Data Quality Issues:

- Identify data quality and cleansing issues

- Handle fostered and unmatched members

- Perform debugging using SQLTerm and functions

- Assess the quality of output data

Troubleshoot and Tune the Data Manager Environment:

- Use build logging to ensure that data marts are being loaded properly

- Perform dimension breaking

- Manage memory and resources

- Export DDL statements

Organize and Package Data Manager Components:

- Export and import components using packages

- Search for components in a catalog using Navigator

Integrate with IBM Cognos BI:

- Examine IBM Cognos BI

- Identify the role of metadata dimensions, metadata collections, and metadata stars

- Export Data Manager metadata to XML

- Import Data Manager XML into Framework Manager

- Use Data Manager metadata with IBM Cognos BI

- Publish a data movement task to IBM Cognos Connection

End-to-End Workshop:


Entity-Relationship Model of the GO_Demo Database (Optional):

Work in a Multi-Developer Environment (Optional):

- Examine collaborative development support

- Examine the source code repository

- Examine the component dependency model

- Identify planning considerations

Standardizing Dimensions and Facts Exercise (Optional):

Review of Data Manager Essentials (Optional):

- Data warehouse design

- The purpose of Data Manager components

- Development steps in Data Manager to create data marts

- Track dimensional changes and late arriving facts

Work with SAP R/3 Data (Optional):

- Identify how to access SAP R/3 data sources using the IBM Cognos Data Manager Connector for SAP R/3 tool

IBM B6052G - IBM COGNOS FRAMEWORK MANAGER: DESIGN METADATA MODELS(V11.0)

Dauer: 5 Tage


Zielgruppe: Developers who design metadata models for use in IBMCognos Analytics.

Voraussetzungen: Knowledge of common industry-standard datastructures and design.- Experience with SQL- Experience gathering requirements andanalyzing data.- IBM Cognos Analytics: Author ReportsFundamentals (recommended)



This course provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to modelmetadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of themetadata modeling process, from initial project creation, to publishing of metadata to the Web, enabling end users to easily authorreports and analyze data.



- IBM Cognos Analytics 11.0 - Developer Role

Programm

Key topics:1. Introduction to IBM Cognos Analytics

• Describe IBM Cognos Analytics and its position within an analytics solution

• Describe IBM Cognos Analytics components

• Describe IBM Cognos Analytics at a high level

• Explain how to extend IBM Cognos

2. Identifying common data structures

• Define the role of a metadata model in Cognos Analytics

• Distinguish the characteristics of common data structures

• Understand the relative merits of each model type

• Examine relationships and cardinality

• Identify different data traps

• Identify data access strategies

3. Defining requirements

• Examine key modeling recommendations

• Define reporting requirements

• Explore data sources to identify data access strategies

• Identify the advantages of modeling metadata as a star schema

• Model in layers

4. Creating a baseline project

• Follow the IBM Cognos and Framework Manager workflow processes

• Define a project and its structure

• Describe the Framework Manager environment

• Create a baseline project

• Enhance the model with additional metadata

5. Preparing reusable metadata

• Verify relationships and query item properties

• Create efficient filters by configuring prompt properties

6. Modeling for predictable results: Identifying reporting Issues

• Describe multi-fact queries and when full outer joins are appropriate

• Describe how IBM Cognos uses cardinality

• Identify reporting traps

• Use tools to analyze the model

7: Modeling for predictable results: Virtual star schemas

• Understand the benefits of using model query subjects

• Use aliases to avoid ambiguous joins

• Merge query subjects to create as view behavior

• Resolve a recursive relationship

• Create a complex relationship expression

8. Modeling for predictable results: consolidate metadata

• 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. Creating 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. Implementing 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. Specifying determinants

• Use determinants to specify multiple levels of granularity and prevent double-counting

12. Creating 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

• Rapidly create a model using the Model Design Accelerator

13. Working with different query subject types

• Identify the effects of modifying query subjects on generated SQL

• Specify two types of stored procedure query subjects

• Use prompt values to accept user input

14. Setting Security in Framework Manager

• Examine the IBM Cognos security environment

• Restrict access to packages

• Create and apply security filters

• Restrict access to objects in the model

15. Creating Analysis objects

• Apply dimensional information to relational metadata to enable OLAP-style queries

• Sort members for presentation and predictability

• Define members and member unique names

• Identify changes that impact a MUN

16. Managing OLAP Data Sources

• Connect to an OLAP data source (cube) in a Framework Manager project

• Publish an OLAP model

• Publish a model with multiple OLAP data sources

• Publish a model with an OLAP data source and a relational data source

17. Advanced generated SQL concepts and complex queries

• Governors that affect SQL generation

• Stitch query SQL

• Conformed and non-conformed dimensions in generated SQL

• Multi-fact/multi-grain stitch query SQL

• Variances in IBM Cognos Analytics - Reporting generated SQL

• Dimensionally modeled relational SQL generation

• Cross join SQL

• Various results sets for multi-fact queries

18. Using advanced parameterization techniques in Framework Manger

• Identify environment and model session parameters

• Leverage session, model, and custom parameters

• Create prompt macros

• Leverage macro functions associated with security

19. Model maintenance and extensibility

• Perform basic maintenance and management on a model

• Remap metadata to another source

• Import and link a second data source

• Run scripts to automate or update a model

• Create a model report

20. Optimizing and tuning Framework Manager models

• Identify how minimized SQL affects model performance

• Use governors to set limits on query execution

• Identify the impact of rollup processing on aggregation

• Apply design mode filters

• Limit the number of data source connections

• Use the quality of service indicator

21. Working in a Multi-Modeler Environment

• Segment and link a project

• Branch a project and merge results

22. Managing packages in Framework Manager

• Specify package languages and function sets

• Control model versioning

• Nest packages

Appendix A. Additional modeling techniques

• Leverage a user defined function

• Identify the purpose of query sets

• Use source control to manage Framework Manager files

Appendix B. Modeling multilingual metadata

• Customize metadata for a multilingual audience

Objectives:

Please refer to course overview.



Stuttgart

20 Aug - 24 Aug 2018

IBM B6008G - OVERVIEW OF IBM COGNOS ANALYTICS (V11.0).

Dauer: 1 Tag


Zielgruppe: Multi-role (consumers, business authors, professionalauthors, developers, administrators, modelers, project managers)

Voraussetzungen: - An understanding of your organization’sbusiness intelligence process and reporting needs- Experience using basic Windows functionality



IBM Cognos Analytics turns data into past, present and future views of your organization’s business intelligence software to enabledecision makers to capitalize on opportunities and manage risk.This course provides participants with a high level overview of the IBM Cognos Analytics suite of products and their underlyingarchitecture. They will examine each component as it relates to an Analytics solution. Participants will be shown a range of resourcesto provide additional information on each product.

Programm

IBM Cognos Anlaytics:

IBM Cognos Analytics overview and the components

IBM Cognos architecture and security

Consume content in IBM Cognos Analytics:

Where do consumers access BI content?

Use published reports

Drill through to related data

Report options

Properties of an entry

Alerts and Watch Items

Create reports in IBM Cognos Analytics:

Overview of reporting and report authoring

Identify package types, uploaded files, and data modules available for reporting

IBM Cognos Analytics - Reporting

The interface

Different report types

Create a simple, sorted, and formatted report

Create a report view

Import and report on personal data

Create dashboards in IBM Cognos Analytics:

IBM Cognos Dashboarding and the user interface

Add report content and tools to create dashboards

Widget-to-widget communication

Filter data in the dashboard

Sort, group and ungroup, and calculate data

Create metadata models in IBM Cognos Analytics:

Define IBM Cognos Framework Manager

IBM Cognos Cube Designer

Web-based Modeling

Create Data Modules

Extend IBM Cognos Analytics:

Introduction to IBM Cognos Mobile

Key features

Cognos Mobile architecture

Supported products

IBM Cognos BI for Microsoft Office

Cognos Analysis for Excel

Compare IBM Cognos Analytics and IBM Cognos BI (Optional):

Changes from IBM Cognos BI to IBM Cognos Analytics

Legacy option

Event Studio and Performance Management

Metric Studio

Identify scorecards, metrics, and metric types

Organize metrics with strategies

Hinweis




München

31 Aug - 31 Aug 2018


IBM COGNOS FRAMEWORK MANAGER: ERSTELLEN VON METADATEN-MODELLEN

Dauer: 2 Tage


Zielgruppe: Die Schulung richtet sich an Modellentwickler.

Voraussetzungen: Verständnis für IT-Systeme, Daten undbetriebswirtschaftliche Anforderungen.



Der Kurs "IBM Cognos Framework Manager: Erstellen von Metadaten-Modellen" ist ein zweitägiges Praxistraining für Modellentwickler.Ziel ist es, Wissen im Aufbau von Metadaten-Modellen zu erwerben und Packages innerhalb von IBM Cognos BI zu veröffentlichen.

Nach dem Abschluss des Trainings sind Sie in der Lage, Metadaten im IBM Cognos Framework Manager zu modellieren undDatenquellen so zu strukturieren, dass diese von den Berichtserstellern einfach genutzt werden können. Sie verstehen das Prinzipprofessioneller Metadaten-Strukturen und wenden diese in der Praxis an.

Programm

Überblick zur SystemarchitekturAufbau performanter Datenstrukturen

Erstellen eines Projektes und unternehmensspezifischer Ansichten

Arbeiten mit Namespaces

Wiederverwendbare Metadaten

Erstellen von Berechnungen und Filtern

Multidimensionale Datenquellen (OLAP, DMR)

Rechte- und Rollenkonzepte integrieren

Package-Administration

Modellwartung und -erweiterung

Verwendung von Determinanten


IBM COGNOS ANALYTICS DASHBOARD & STORY

Dauer: 1 Tag


Zielgruppe: IBM Cognos-Anwender.




Der Kurs „IBM Cognos Analytics Dashboard & Story“ ist ein eintägiges Praxistraining für IBM Cognos-Anwender, die ihren IBM Cognos-Arbeitsbereich interaktiv und individuell erweitern und mit eigenen einfachen Berichten und Analysen darstellen wollen. Ziel ist dieNutzung verschiedener Datenquellen, um die Ergebnisse in einer Dashboard Oberfläche darstellen zu lassen.

Nach Abschluss des Trainings verfügen Sie über Kenntnisse, eigene Dashboards zu erstellen. Sie sind in der Lage, bestehende, neueund abgewandelte Berichtselemente zu verwenden. Zudem sind Sie mit den Funktionalitäten zur Erstellung von Ad-hoc-Analysen undeinfachen Reports vertraut und können diese mit geeigneten Visualisierungen darstellen.

Programm

Einführung in die Nutzung von IBM Cognos Analytics DashboardEinführung in die Nutzung von IBM Cognos Workspace StoryErstellen und Filtern von ArbeitsbereichenEinbindung von Berichtselementen diverser BerichteDatenuntersuchung mittels neuer VisualisierungenErstellen einfacher DashboardsEingrenzung von Daten durch FilterAnwendung von personalisierten AnsichtenAnbindung anderer Medien, Webseiten, Bilder, Formen und Texte

BIG DATA - WORKSHOP FüR FüHRUNGSKRäFTE

Dauer: 2 Tage


Zielgruppe: Führungskräfte

Voraussetzungen: Voraussetzung für die erfolgreiche Teilnahme istein allgemeines Verständnis für IT und IT-Management.


Schulungsmethode: Workshop

Nach dem Besuch dieses Seminars haben Sie ein generelles Verständnis der aktuellen Möglichkeiten und Vorgehensweisen im Kontextdes Schlagwortes "Big Data". Sie können Potentiale in Ihrer Organisation erkennen und zielgerichtet Projekte auf den Weg bringen.

Programm

Methodische und technische Evolution - von BI zu Big Data und cognitive Computing

Data Warehouse und Business IntelligenceEinsatzszenarien, Nutzen und GrenzenAnalyse großer polystrukturierter DatenmengenBatch- und Echtzeitverarbeitungneue Geschäftsmodelle, neue Herausforderungen

Human readable II - Visual Analytics und Information Design

Anwendungsbeispiele und MusterTraue keiner Statistik, die du nicht selber gefälscht hastStatistik und GrafikenData ScienceMustersuche, Optimierung und Prognose

Cognitive Computing - Natürliche Sprache als Schnittstelle

Aufbau von Teams und Projekten im Bereich Big Data

Projektmanagement



Berlin

20 Sep - 21 Sep 2018 Garantietermin

Stuttgart

12 Dez - 13 Dez 2018 Garantietermin

Documents

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