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

VCE Vblock Systems Administration and Management

In this course, you will learn the concepts and tasks required to provision, manage, and monitor the Vblock Infrastructure Platforms. You will focus on the EMC Ionix Unified Infrastructure Manager (UIM) product, as well as certain aspects of the various system element managers.

Technical Training
Additional Technical Training

Implementing Desktop Application Environments

In this course, you will gain the skills and knowledge needed to design, deploy, and manage a virtual and physical Windows Server 2012 application management infrastructure and focus on using Microsoft System Center 2012 Service Pack 1 (SP1). You will also learn to design, deploy, and manage Windows 8 Enterprise applications in a physical, virtual, and cloud environment.

This course incorporates material from the Microsoft Official Course 20416 and it can assist you in your preparation for Exam 70-416: Implementing Desktop Application Environments.

Technical Training
Additional Technical Training

Avaya Communication Server (CS) 1000 7.x System Administration and Management

This foundation-level course is the starting point for your Communication Server 1000 (CS 1000) 7.5 training. Through presentations and interactive practices, you will learn how to use the system management tools to perform basic system administration and management tasks. This course emphasizes using Element Manager for a CS 1000 system running on a Linux platform, and it assumes the system is fully installed and operational.

Important: If you have successfully completed Meridian 1 or CS 1000 trainingat Release 6.0, please contact a training consultant to identify which coursesbest meet your needs.

Technical Training
Additional Technical Training

VMAX3 Business Continuity Management

In this course, you will learn how to deploy and manage VMAX3 array-based local and remote replication solutions for business continuity needs. Operational details and implementation considerations for EMC TimeFinder SnapVX and Symmetrix Remote Data Facility (SRDF) are covered. Lessons include considerations for performing local and remote replication operations in physical and virtualized environments. Hands-on lab exercises using Symmetrix Command Line Interface (SYMCLI) and Unisphere for VMAX provide the opportunity to learn and validate the material covered in the lectures. Lab exercises will be performed in physical (Sun Solaris and Windows 2008) and virtualized (VMware ESXi) hosts attached to VMAX3 arrays

Certification:

EMC Proven Professional – Specialist