SAP BI Training London | SAP Courses, Certification & Job Placement, London (UK)

METHOD OF DELIVERY: Online & Classroom
COURSE DURATION: 50hrs online / 16 day / 8 Weekend in class
COURSE CONTACT: 0800 135 7371, 0207 993 65 93 (UK), +44 207 993 65 93



COURSE CURRICULUM:

The course focuses on the most important BW features, and the course is divided into these main subjects:
(a) BW overview and navigation,
(b) Important BW standard reports
(c) Basic BW report editing
(d) Advanced BW report editing,
(e) BW query designer
(f) BW data load monitor
The course also focuses on the most important SAP – BI features, and the course is divided into these main subjects:
(a) BW Data warehousing
(b) BW Data Modeling
(c) BW Reporting
(d) BW Extraction
(e) BW Performance Tuning

COURSE CONTENTS

Enterprise Data Warehousing
Introduction
General Introduction. SAP introduction.
Data warehousing/ BW/ BI Introduction
Master data; Attributes, Texts, and Hierarchies.
Standard Naming conventions in SAP and BI
Data Modeling
InfoObjects: Definitions
Types: Characteristics, Key Figures, Time, and Unit.
InfoCube: Definitions.
Types: Standards, real time, remote.
Design of InfoCube: Star Schema concepts. Precautions.
Data Store objects (DSO):
Types: Standards, Real time.
InfoSets
MultiProvider: Scenarios to create Multiproviders.
InfoCube VS DSO

Metadata and Document Management

BI Content: Definitions, How to install BI contents,

Defining extraction


For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
Or for files: Creating DataSource for File Source Systems
Defining transformations
Transformations and different scenarios.

Defining the data flow:
Creating data transfer processes
Creating process chains

Scheduling and monitoring:
Checking process chain runs
Monitor for extraction processes and data transfer processes

Performance optimization:
Creating the first aggregate for an InfoCube
Using the BIA index maintenance wizard

User management:


Setting up standard authorizations
Defining analysis authorizations


Transports:


Real business scenarios on different system environments, Moving objects from one system to another.


BI SUITE: Business Explorer


BEx Query Designer


Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
Structures: Creating Re-usable structures
Functions on BW Server: Copying queries between Cubes, Deleting Query Elements


Web Application Designer


WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties
Design: Designing the Layout of Web Templates, working with Library for Web Items
Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes
Activities


BEx Analyzer


BEx Web Application Designer
BEx Report Designer
BI Platform


Information Broadcasting


Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.


OLAP


OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
Metadata Repository: Searching for Metadata




COURSE REQUIREMENT: Previous Educational Background Required

EXAM TRACK / FEES: Technical & Application Certification - £350


COURSE BENEFITS / PROSPECTUS IN UK AND OVERSEAS


Being a part of SAP means being a part of one of the most successful companies in the world, a recognized market leader. It also means being challenged like never before, taking risks, growing, and succeeding. The day you have a SAP qualification is the day you begin playing a key role in making SAP customers' businesses the best-run businesses in the world.

ALSO ON THIS COURSE WE OFFER THE FOLLOWING:


Hands on Experience
Real Time project work
Interview based Training
CV Building Service

CALL US FOR BOOKING/MORE DETAILS:

Telephone: 0800 135 7371, 0207 993 65 93. +44 207 93 65 993 ( international Calls )

REQUEST A CALLBACK