Course Overview

Please note that with the speed of updates to SAP Analytics Cloud, we endeavor to update this course quarterly. The course material will be delivered in English.

Course Objectives

This course will prepare you to:

• This course provides the learner with the knowledge needed to create SAP Analytics Cloud (SAC) models.
• Topics include modeling basics, dimensions and measures, import models, and live models integrating with SAP Systems and datasets.
• The live model integrates SAP BusinessObjects, SAP Business Warehouse, SAP HANA Cloud, and S/4HANA.

Course Content

• Explaining the basics of data structures in SAP Analytics Cloud
• Designing and creating dimensions
• Creating import models
• Creating live models
• Working with geographic data
• Defining data security

Course Overview

Virtual and Classroom learning – V&C Select™

V&C Select™ is a simple concept and a flexible approach to delivery. You can ‘select’ a course from our public schedule and attend in person or as a virtual delegate. Virtual delegates do not travel to this course, we will send you all the information you need before the start of the course and you can test the logins.

Course Objectives

This course will prepare you to:

• This course provides a high-level introduction and overview of SAP Analytics Cloud (SAC) capabilities as well as applications that interface with SAC.
• Through expert demonstrations and hands-on exercises or simulations, learners are exposed to data connections,
• both basic and advanced stories, data analyzer, Microsoft Office integration, modeling basics, planning basics, augmented analytics, and collaboration.

Course Content

• Getting Started with SAP Analytics Cloud
• Establishing Data Sources and Connections
• Using Modelling
• Using Basic and Advanced Stories
• Using Planning
• Using Basic Augmented Analytics in SAC
• Using Collaboration Features

Course Overview

This course provides participants with a high-level overview of the IBM Cognos Analytics Dashboard tool and its underlying architecture. They will explore the powerful features of IBM Cognos Analytics dashboards to transform raw data into actionable insights. Through interactive lessons, practical exercises, and real-world scenarios, learners will gain the skills to create, customize, and share dynamic dashboards that drive data-informed decisions.

Learners will gain hands-on experience through exercises that enhance their ability to create and customize dashboards, stories, and explorations.

By the end of this course, learners should be proficient in creating and customizing dashboards, using Cognos Analytics tools and AI Assistant, integrating and visualize data from multiple sources, employing advanced features like 3D maps, forecasting, and drill-through definitions to enhance insights, and much more.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Course Objectives

After completing this course, learners should be able to:

• Customize dashboard visualizations
• Explore and use AI Assistant for dashboard design
• Select and integrate at least two different types of data sources into a dashboard
• Customize a dashboard with widgets
• Configure a dashboard with interconnected visualizations
• Adjust the timeline of objects in a scene to control appearance and disappearance during playback
• Create an exploration from a data source
• Apply forecasting techniques to predict future trends using historical data in visualizations
• Apply cascading filters to guide logical data exploration in dashboards

Course Content

Unit 1: Introduction to Dashboards

• Define key features of dashboards
• Identify dashboard interface components
• Upload data files for dashboard creation
• Customize dashboard visualizations
• Explore and use the AI Assistant for dashboard design

Unit 2: Create a Basic Dashboard

• Select and integrate at least two different types of data sources into a dashboard
• Add visualizations to a dashboard using drag-and-drop, AI Assistant queries, and Pinned tabs
• Customize a dashboard with widgets
• Share a dashboard with custom configurations

Unit 3: Advanced Dashboard Functions

• Implement filters into a dashboard
• Configure a dashboard with interconnected visualizations
• Use the Visualization feature to change the type of a chart in an advanced dashboard and customize the chart’s properties
• Use the AI Assistant to generate relevant visualizations
• Apply natural language queries and refine output with filters and aggregations

Unit 4: Create a Story

• Create a basic story by adding scenes and integrating visualizations and animations
• Adjust the timeline of objects in a scene to control appearance and disappearance during playback
• Enhance a story by adding animations to objects and highlighting key data points to emphasize insights

Unit 5: Create an Exploration

• Explain the purpose and advantages of using Explorations, including how they reveal insights and correlations
• Create an exploration from a data source
• Interact with the Relationship Diagram to filter unique fields, select starting points, and generate corresponding visualizations

Unit 6: Visualizations

• Identify and describe at least five types of visualizations, including their appropriate use cases
• Demonstrate how to configure a drill-through definition for a visualization in a dashboard
• Apply forecasting techniques to predict future trends using historical data in visualizations
• Create and import a custom visualization into a dashboard, ensuring its integration and usability

Unit 7: Features in Cognos Analytics 11.2

• Demonstrate how to create and manipulate 3D hexbin maps
• Customize visualization properties, such as bullet charts and axis-specific formatting in a dashboard
• Apply cascading filters to guide logical data exploration in dashboards
• Utilize and customize tooltip features to add context to data visualizations

Course Overview

This course provides participants with a high-level overview of the IBM Cognos Analytics suite of products and their underlying architecture. They will examine each component as it relates to an Analytics solution. Participants will be shown a range of resources to provide additional information on each product.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Course Objectives

• Consume content in IBM Cognos Analytics
• Create reports in IBM Cognos Analytics
• Create dashboards in IBM Cognos Analytics
• Create metadata models in IBM Cognos Analytics
• What’s new in Cognos V11.2
• Compare IBM Cognos Analytics and IBM Cognos BI (Optional)
• Explore IBM Cognos Analytics AI capabilities

Course Content

Unit 1. Introduction to IBM Cognos Analytics

• Describe IBM Cognos Analytics offerings and its position within an Analytics solution
• Describe IBM Cognos Analytics components
• Describe IBM Cognos Analytics at a high level
• Describe IBM Cognos Analytics security at a high level
• Explain how to extend IBM Cognos Analytics

Unit 2. Consume content in IBM Cognos Analytics

• Identify where consumers access IBM Cognos Analytics content
• Use published reports
• Drill through to related data
• Run reports with options
• Specify properties of an entry

Unit 3. Create reports in IBM Cognos Analytics

• Create ad hoc reports and analyze data with IBM Cognos Analytics with Watson
• Create professional reports in IBM Cognos Analytics with Watson
• Import personal data by using Upload Files and Data Modules

Unit 4. Create custom dashboards in IBM Cognos Analytics

• Describe IBM Cognos Analytics Dashboards
• Explore navigation and general functionality
• Create a dashboard from existing content
• Modify an existing dashboard

Unit 5. Create metadata models in IBM Cognos Analytics

• Describe the capabilities and role of IBM Cognos Framework Manager
• Describe Web-based modeling
• Create Data Modules

Unit 6. What’s new in Cognos v11.2

• Describe new features in Cognos Analytics
• Describe support for mobile
• Describe new navigation paths
• Describe IBM Carbon user experience
• Describe expanded job options
• Describe enrichment enabled for OLAP
• Describe dashboard enhancements
• Describe home page and content navigator

Unit 7. Compare IBM Cognos Analytics to IBM Cognos BI (Optional)

• Describe new features in Cognos Analytics
• Describe Changes from Cognos BI to Cognos Analytics
• Examine the Legacy option
• Examine Event Studio and its role in Performance Management
• Track initiatives with projects

Unit 8. Explore IBM Cognos Analytics AI Capabilities

• Describe the AI capabilities in Cognos Analytics
• Define the benefits of the embedded AI capabilities in Cognos Analytics
• Explore the AI capabilities in Cognos Analytics

Course Overview

After completing this Oracle R12 Reporting (FSG & Report Manager) course delegates will be able to create and submit both standard and customized reports using data within the General Ledger module. The focus is on working with the capabilities of the Financial Statement Generator within Oracle R12 General Ledger to build a suite of reports from a set of pre-defined report components. The Report Manager section of the course shows how to publish and analyse these reports and apply security where required.

Course Objectives

By the end of this Oracle R12 Reporting course,delegates will be able to build a financial report using both the mandatory and optional report components provided by the Financial Statement Generator. They will practice running and modifying such reports. They will use Report Manager as a publishing and analysis tool where a higher standard of presentation is required together with the capability to drill down to individual sub-ledger transactions.

Course Content

Oracle R12 Reporting (FSG & Report Manager) Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: AN OVERVIEW OF REPORTING TOOLS

• Oracle General Ledger Reports
• Oracle General Ledger Standard Reports
• Financial Statement Generator
• Oracle Financial Analyzer
• Oracle Discoverer
• Rxi Reports Administration Tool
• Oracle Reports
• SQL Reports
• Report Manager
• Comparison of Reporting Tools

Session 2: STANDARD GENERAL LEDGER REPORTS

• Overview
• Concurrent Manager
• Concurrent Processing Definitions
• Useful Standard Reports
• Submit Request Flow
• Run a Standard General Ledger Report
• Scheduling Options
• Completion Options
• View Requests

Session 3: THE FINANCIAL STATEMENT GENERATOR

• Introduction to FSG Reporting
• FSG Components
• Plan a FSG Report
• Use Row and Column Sets
• Define Row Sets
• Define Column Sets
• Generate an ad hoc FSG Report
• Define a FSG Report
• Run a FSG Report
• Use a Content Set

Session 4: REPORTING WITH REPORT MANAGER

• Overview of Report Manager
• Report Manager structure and access
• Publish a report to Reports Repository
• View a report in Reports Repository
• Publish a report from eBusiness Homepage
• Analyse a Financial Report with Report Manager

Session 5: FSG EXERCISES

• Define a Row Set
• Define a Column Set
• Define an FSG Report
• Run an FSG Report
• View Report Requests
• Define a Content Set
• Define Display Groups and Display Sets
• Define a Row Order

Session 6: REPORT MANAGER EXERCISES

• Publish a Report from a Form Function
• Analyse Report Output
• Export Analysis to MS Excel
• View a Report from Repository Management

Course Overview

This Oracle R12 New Features Seminar is suitable for existing Oracle 11i users with an interest in learning more about the new features introduced with R12 of Oracle Financials. This includes finance personnel,IT support staff,contractors or Oracle functional implementers.

Course Objectives

By the end of this Oracle R12 New Features Seminar delegates will be able to explain the significant areas of improvement introduced within R12,This includes those which cross a number of modules such as eBusiness Tax and Sub-ledger Accounting,and those improvements specific to core modules such as General Ledger,Payables and Receivables.

Course Content

Oracle R12 New Features Seminar Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE R12 FINANCIALS SUITE

Session 2: NAVIGATION

• The Swan User Interface
• New search functionality

Session 3: MOAC – MULTI-ORG ACCESS CONTROL

• MOAC Profile Options
• Security Profiles
• Setting User Preferences

Session 4: LEGAL ENTITIES

• Defining Legal Entities
• New purposes for Legal Entities

Session 5: BANK ACCOUNTS

• Relationship to Legal Entities
• Structure

Session 6: TAX ENGINE

• Tax Configuration
• Regime to Rate Flow
• Party Tax Profiles

Session 7: AGIS – ADVANCED GLOBAL INTERCOMPANY SYSTEM

• Key Set ups
• Transaction processing
• Integration with Accounts Payable and Accounts Receivable

Session 8: GENERAL LEDGER

• Ledgers and Ledgers Sets
• Secondary Ledgers and Reporting Currencies
• Data Access Sets
• Definition Access Sets

Session 9: SUBLEDGER ACCOUNTING ENGINE

• The function of SLA – Subledger Accounting
• Accounting Methods Builder
• SLA Methods
• Application Accounting Definitions
• SLA Online Inquiries

Session 10: PURCHASING

• The Professional Buyers Work Centre
• Changes in iProcurement structure

Session 11: PAYABLES

• Integration with MOAC
• Invoice processing enhancements
• The Payments Manager
• AR / AP Netting

Session 12: RECEIVABLES

• Enhanced Revenue Recognition features
• Integration with MOAC
• Enhanced cash application features
• Working with Advanced Collections for credit control tasks

Session 13: ASSETS

• Removal of depreciation rollback function
• Auto Preparation of Mass Additions

Course Overview

The Oracle R12 iProcurement User course is designed for anyone who needs to raise requisitions or process receipts using Oracle R12 iProcurement.

Course Objectives

By the end of this course delegates will be able to use Oracle iProcurement to manage the requisition process. They will learn how to search for items to purchase,make comparisons between similar items and create a Shopping List for frequently purchased items. The approval process will be demonstrated so that delegates know how to monitor the progress of their requests. Delegates will learn how to process receipts,make corrections and record details of any returns.

Course Content

Oracle R12 iProcurement User Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE iPROCUREMENT

• Introduction
• Oracle iProcurement in the Procure to Pay Flow
• Content Management
• Shopping
• Checkout
• Requisition Tracking and Management

Session 2: PURCHASE ORDER PROCESSING

• Introduction
• AutoCreate a Standard Goods Purchase Order

Session 3: RAISING iPROCUREMENT REQUISITIONS

• Introduction
• Shopping
• Checkout Process

Session 4: RECEIPTING A PURCHASE ORDER IN iPROCUREMENT

• Introduction
• Express Receive
• Standard Receipting
• Returning Ordered Items
• Receipt Corrections
• View Receipts

Session 5: NON-CATALOG REQUESTS

• Smart Forms
• Information Templates
• Requisition Information
• Review Approver List
• Review and Submit

Session 6: iPROCUREMENT EXERCISES

Course Overview

This course is designed for buyers,finance staff,systems administrators and any other user who needs to be able to administer Oracle iProcurement content.

Course Objectives

By the end of this course delegates will be able to use Oracle iProcurement Catalog Administration to review or make changes to local content such as stores and content zones. They will also be able to explain key set up steps in relation to externally-managed content.

Course Content

Oracle R12 iProcurement Super User Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE iPROCUREMENT

• Introduction
• Oracle iProcurement in the Procure to Pay Flow
• Content Management
• Shopping and Checkout

Session 2: STORES

• Store types
• Creating Local Stores
• Sequencing Stores
• Test Stores Set Up

Session 3: CONTENT ZONES

• Content Zone Types
• Create a Local Content Zone
• Content Zone Security
• Assign Content Zone to a Store
• Create an Informational Content Zone
• Delete a Content Zone
• Content Zone Schema
• Create Item Categories
• Create Browsing Categories
• Add or Remove Category Mapping

Session 4: ADDING INTERNAL ITEMS

• Introduction
• Raising Blanket Purchase Agreements

Session 5: UPLOADING ITEMS FROM CATALOG ADMINISTRATION

• Introduction
• Raising Blanket Purchase Agreements
• Downloading Resource Files
• Completing the Template
• Uploading the Template
• Monitor and Test the Upload

Session 6: DESCRIPTORS

• Base Descriptors
• Add Edit or Delete a Base Descriptor
• Hide the Images in Search Results
• Category Descriptors
• Add Edit or Delete a Category Descriptor

Session 7: SMART FORMS

• Create a Smart Form
• Enter Header information
• Enter Default Item and Supplier Details
• Assign an Information Template
• Assign Smart Forms to a Store
• Edit Copy or Delete a Smart Form
• Define an Information Template
• Create Template Association
• Create Validation Sets
• Test Set Up

Session 8: PUNCHOUT OVERVIEW

• Overview of Punchout and Transparent Punchout
• Oracle Exchange
• Punchout
• Transparent Punchout
• Double Punchout
• Set up Steps for the Buyer

Session 9: IPROCUREMENT EXERCISES

Course Overview

This course is designed to give delegates the knowledge to set up and use Oracle General Ledger. Delegates will learn how to create an Accounting Setup,set up journals,define budgets and budget organisations and set budgetary controls. There will be opportunities to practice implementing many of the new features introduced in R12 General Ledger such as Primary and Secondary Ledgers,Reporting Currencies,Ledger Sets and Data & Definition Access Sets.

Course Objectives

By the end of the Oracle R12 General Ledger Setup & Management course,delegates will be able to identify the key implementation and setup issues of the Oracle General Ledger.

Course Content

Oracle R12 General Ledger Setup & Management Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION TO THE GENERAL LEDGER

• General Ledger Keywords and Concepts
• Overview of the General Ledger
• Define a Ledger
• Define a Ledger Set
• Define a Data Access Set

Session 2: ACCOUNTING CALENDARS

• Accounting Periods
• Accounting Calendars
• Define an Accounting Calendar
• Post Account Balances

Session 3: CHART OF ACCOUNTS STRUCTURE

• Flexfield Considerations
• Good Design Principles
• Define the Accounting Flexfield
• Parent/Child Accounts
• Rollup Groups and Summary Account Templates

Session 4: JOURNALS

• Key Set Up Considerations for GL Journals
• Set Up Options for Journaling
• Set Up Journal Options
• Journal Profile Options
• Journal AutoReversal Set Up Steps
• Define an AutoPost Criteria set
• Reports Listings and Inquiry Options for Journals

Session 5: GENERAL LEDGER SECURITY RULES

• Security Rules and Cross Validation Rules
• Define a Security Rule
• Cross Validation Rules

Session 6: MULTI CURRENCY

• Key Processes
• Defining a Reporting Currency
• Define a Cumulative Translation Adjustment Account
• Enter Daily Rates
• Enter Foreign Currency Journals
• Enter Period rates
• Enter Historical Rates
• Profile Options
• Work With Multiple Currencies in General Ledger
• Translate From Functional to Reporting Currency
• Transaction Level Conversion
• Inquiry and Reporting

Session 7: BUDGETING

• Overview of Budgeting
• Create Master and Detail Budgets
• Define Budgets
• Define Budget Organizations
• Protect a Budget Organization with a Password
• Set Budgetary Control Options for an Account Range
• Copy Account Ranges from an Existing Budget Organization
• Add or Change Individual Accounts
• Delete a Budget Organization
• Budget Reports and Listings
• Define a Rollup Group
• Assign Rollup Groups to Account Segment Values
• Create a Summary Account Template
• Carry Out a Budget Inquiry

Session 8: MULTI COMPANY ACCOUNTING

• Automatic Balancing of Inter-company Transactions
• Consolidating Multiple Companies

Session 9: ENCUMBRANCE ACCOUNTING

• Set up steps in General Ledger
• Set up steps in Purchasing
• Funds Inquiry
• Encumbrance reports
• Transaction processing examples

Course Overview

This Oracle R12 General Ledger New Features for Experienced 11i Users course is designed to give delegates practical experience of implementing and using the new features available in the Oracle R12 General Ledger module. Delegates will learn how to implement the new features introduced in R12 General Ledger such as Primary and Secondary Ledgers,Reporting Currencies,Ledger Sets and Data and Definition Access Sets.

Course Objectives

By the end of the Oracle R12 General Ledger New Features for Experienced 11i Users course,delegates will be able to identify and implement the key implementation and setup issues of the Oracle General Ledger.

Course Content

Oracle R12 General Ledger New Features for Experienced 11i Users Training Course

Course Contents – DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF THE NEW GENERAL LEDGER FEATURES

• Overview of the Oracle R12 New General Ledger Features

Session 2: DEFINE A CHART OF ACCOUNTS

• Ledgers and Ledger sets
• Primary and Secondary Ledgers
• Legal Entities
• Create a New Accounting Setup with the Accounting Setup Manager
• Define a Ledger
• Define a Ledger Set
• New Reporting Currency Features
• Define Data Access Sets
• Define and Assign Definition Access sets
• New Flexfield Qualifiers Features
• Generate the GL Ledger Flexfield
• Define Intercompany Accounts
• Define Intercompany Balancing Rules

Session 3: NEW JOURNAL FEATURES

• Manual Journal Entry New features
• Account Analysis and Drilldown
• Journal Reconciliation Processes

Session 4: WEB ADI

• Use the Journal Wizard to Enter and Upload a Journal
• Use the Budget Wizard to Enter and Upload Budgets
• Use the Currency Rates Manager to Enter and Upload Exchange Rate information

Session 5: GL SETUP EXERCISES