Course :BI 7.0 as Application of Netweaver 2004s
Type : Hands-On Training

Come and learn the exciting Business intelligence (BI) capabilities of Netweaver 2004s. From Enterprise Data Warehousing to BI Suite and BEx Web to Performance enhancement through the new BI Accelerated Index, this course uncovers the powerful features of SAP’s latest technology. In BI 7.0 course, you will learn how SAP’s Business Intelligence solution allows you to convert data into valuable information through hands on practices backed by extensive study material. Through the Data Warehousing Workbench, practice Data Modeling, Data Acquisition and the new Transformation Procedures, to name a few. Also, discover how Integrated Planning of BI has revolutionized and eased the decision-making process.

Enterprise Data Warehousing
Introduction

1. General Introduction.
2. SAP introduction.
3. Data warehousing/ BW/ BI Introduction
4. Master data; Attributes, Texts, and Hierarchies.
5. Standard Naming conventions in SAP and BI

Data Modeling

InfoObjects: Definitions
Types: Characteristics, Key Figures, Time, and Unit.

InfoCubes: Definitions.
Types: Standards, real time, remote.
Design of Infocube: Star Schema concepts. Precautions.

DataStore objects (DSO):
Types: Standards, Real time.

InfoSets

MultiProviders: 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 DataSources 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 KeyFigures

Variables: The Variable Wizard, Variable Types and Processing Types, query Properties

Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures

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

Career Related Support

Resume Building with sample resumes

Frequently asked interview questions

Common Production Issues

Advanced Topics
Hot Bonus Topics:

Overview of Planning with SEM-BPS.

Architecture of BPS components.

Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages).

Characteristic relationships, Variables.

Data Slice

Web Interface and Planning Folders.

Performance in depth

Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent

BW Statistics: Query Analysis Tools, Performance Tables

Reporting Performance: Effective query design, Line-Item, Compression, Partitioning

Aggregates: Creating Aggregates, Finding effective aggregates

Data Load Performance: Parallelism, Impact of Aggregates

Partitioning: Logical Partitioning, Table Partitioning.