BW – Enterprise Data Warehousing

BW - Enterprise Data Warehousing

COURSE OUTLINE:

Description

This course is based on software release SAP Business Warehouse 7.4.

Certification:

SAP Certified Application Associate - SAP Business Planning and Consolidation 10.0
SAP Certified Application Associate - SAP Planning and Consolidation 7.5

Audience

Application consultant
Business analyst
Business process owner / team lead / power user
Program / project manager
Technology consultant
User

Prerequisites

Basic knowledge of data warehousing
Experience and sound knowledge of the subject matter in at least one SAP is recommended
ERP application course is recommended

Learning Objectives

Implementation and administration within a heterogeneous SAP NetWeaver BW system landscape

1. Data Warehousing

Describing Data Warehouse Systems
Describing Data Warehouse Architecture
Using the Data Warehousing Workbench

2. Master Data Modeling in SAP BW

Describing InfoObjects
Creating Characteristic InfoObjects

3. The Loading of Master Data from SAP Data Sources

Describing Data Flow
Modeling a Master Data Flow
Loading a Master Data Flow
Modeling with the Graphical Data Flow Tool

4. Loading of Transaction Data from SAP DataSources

Describing the Core InfoProviders
Creating a Key Figure InfoObject
Creating a DataStore Object (DSO)
Loading Transaction Data into a Data Store Object
Describing the Extended Star Schema of an InfoCube
Creating InfoCubes
Loading Transaction Data into an InfoCube

5. Master Data Loading from Flat File Data Sources

Loading Data From a Flat File
Describing the Data Flow in Detail
Describing the Data Loading Process in Detail

6. InfoProviders in SAP BW

Explaining the InfoProviders Used in SAP BW - Introduction
Creating MultiProviders

7. Usage of SAP BI Content

Using BI Content

8. Query Performance Optimization

Optimizing Query Performance
Monitoring Performance
Creating and Filling Aggregates

9. The SAP BW Administration

Describing Administrative Tasks and Tools
Administrating the InfoCubes
Administrating the DataStore Objects
Creating Process Chains

RELATED COURSES

Technical Training
Additional Technical Training

ViPR Implementation and Management

In this course, you will learn how to install, configure, and manage the base ViPR solution. You will be given an introduction to integrating ViPR with cloud stacks for provisioning, and also learn about VCO/vRealize orchestration, SCMM, and OpenStack. Additionally, you will learn how to integrate and build applications using the ViPR Controller. Hands-on labs allow you to experience the environment, installation of ViPR, and initial discovery and configuration of the solution.

Technical Training
Additional Technical Training

Certified ScrumMaster®

Your success is accelerated in Scrum methodology with this highly interactive learning experience.

Come learn from one of today’s most experienced and sought-after Scrum trainers – you will leave inspired and empowered to drive lasting improvements in the way your organization builds software and manage projects.

Technical Training
Additional Technical Training

Applied Analytics Using SAS Enterprise Miner

In this course, you will learn how to assemble analysis flow diagrams using the rich tool set of SAS Enterprise Miner for both pattern discovery (segmentation, association, and sequence analyses) and predictive modeling (decision tree, regression, and neural network models).

Technical Training
Additional Technical Training

Avaya Auraï¿½ Contact Center Administration

This course is designed for personnel responsible for administering and managing Avaya Auraï¿½ Contact Center Administration. In this course, you will learn how to access Contact Center Manager Administration, and configure Threshold Classes, Call Presentation Classes, Skillsets, Call Center Agents, and Call Center Supervisors. You will learn how to configure administrators through the multiple components of Access and Partition Management and how to bulk load data into the CCMA using the Configuration Tool. This course covers the CCMA interface and the acquisition of resources. Different methods of system management are discussed, including viewing, creating, and modifying tabular and graphical real time displays, and interpreting, viewing, modifying, and scheduling standard and user-defined historical reports.