SAP BW/BI-BO

Module 1 - Introduction to Architecture of SAP

Overview and details

R.3 architecture

SAP BI landscape

Star and extended star schema

OLAP vs OLTP

Module 2 - 3.x Objects

Info area and info object Catalog

Application component

Info source and Data source

Transfer and Update laws

Communication structure

Info Cubes and package

ODS

Module 3 - 7.X Objects

Info Area and Info Object catalog

Data source

System and Application component

Transformations

Info Cube and package

DTP and DSO

Module 4 - Introduction to Datastore Objects (DSO)

What is DSO?

Types of DSO (Standard, direct update and write optimized)

Info set

Multi providers

Analysis process designer

Module 5 - Flat File extraction

Master data extraction (attribute, text and hierarchy)

Transaction data extraction (To DSO, info cube)

BW3.x vs 7.x

Migration strategy

Data mart concept

Module 6 - Info providers 3x and 7x

Module 7 - SAP BW 7.3

New options in RSA1 screen

New Master Data Deletion

Graphical Data flow modelling option in RSA1 screen

Data Flow generation wizard

Migration of 3.X data flow to 7.X data flow

New options in Info Area Context Menu, Create / Edit DSO screen, Create Infocube screen, DSO, Transformation and DTP Extraction Tab & Execute Tab

Delta Init without Data

Parallel Extraction

Semantic Partitioned Objects

More options while creating Multi Providers and Data Extraction from Multi Provider

Management of Version

DB partitioning for DSO

Use of Navigational attributes

Module 8 - SAP BO 4.X

Module 9 - Transformation

What is Transformations?

Transformation Rule types

Direct assignment, Routines, Initial value, Time Distribution

No update, Constant, read master data, Read from DSO

Transformation rules

Module 10 - Open Hub destination

Destination as table and database table

Remodeling

Error Stack

Module 11 - Process chain

Process chain overview

Develop master data process chain

Develop transactional data process chain

Monitoring and scheduling process chain

Rescheduling process chain

Removing scheduling

Module 12 - Transportation

BW system landscape

Create transport and package requests

Transport objects to BW landscape

Collect objects in BW

Delete or re-import transport request

Error and solution in transportation

Module 13 - SAP BO

SAP BO overview

SAP BI 4.0 architecture

Classes and objects

WEBi reports

BO universe

Sub reports

Variables

Tracking

Merging

Drilling

Crystal reports

Static and dynamic dashboards

Dashboard using query and live office

Module 14 - Performance management

Different types of performance management techniques

Backened and data load performance techniques

Aggregates and collapse

DB statistics

Deleting indexes

BI performance tuning

Partition and repartition

Module 15 - ABAP for BW

Overview of ABAP.

Creating Tables and views

Concepts and Types of Routines

Field Level Routine

Start Routine

End Routine

Expert Routine

Module 16 - BI Content

What is Meta Data Repository?

Overview of Business content

Grouping & Collection Mode options in BI Content

Finding and Installing right Object in Business Content.

Module 17 - Reporting

BEx query designer and analyser

Conditions and variables

Calculated and restricted key figures

Formulas and selections

Filters, exceptions and structures

Query monitoring

Navigational attributes

RRI,

Publishing SAP Bi report

Module 18 - SAP BW 7.4

Features of BW 7.4

Powered by HANA

Overview SAP BW 7.4 on SAP HANA and further Roadmap

Eclipse-based Modeling Tools

Maintenance Composite Provider

SAP HANA optimized Transformations.

Module 19 - SAP BW POWERED BY HANA

What is HANA?

Landscape and Features of HANA

SAP HANA-Optimized Data Store Objects and Info Cubes

Consumption of SAP HANA models in BW on HANA

Mixed Scenarios

Module 20 - Live UAT activities

Module 21 - Verify BW system prior going live

Module 22 - BW and BPC integration concept

Module 23 - Extraction

Data extraction overview

Extracting data from different tables

Master and transaction data extraction

Create generic data source and BI Side info package

Logistic data extraction

Direct delta method

Queued delta method

V3 Un serialized detla

Controlling and profitability analysis extraction

Working of Cost-based and Account based extraction

CO-PA extraction

Module 24 - BI launch pad

Introduction to BI launch pad

Log on and off BI launch pad

Using other apps

Create new folder

Upload, copy, delete new document

Develop category

Make shortcuts to documents

Make shortcuts to documents

Assign documents and create categories

Functioning with documents in BI lauch pad

Module 25 - Information design tool

Overview of information design tool

Create universe and joins using universe wizard

Navigating interface

Create project

Make connections with RDBMS

Develop data foundation with single source RDBMS

Create business layer based on single RDMBS

Universe publishing

Create OLAP connection using BICS

Develop equi join, shortcut join, theta join

Develop calculated strings, numeric values, data value, column

Module 26 - Central Management Console

What is CMC?

Developing and managing groups and users

Publishing applications and objects

Managing and Scheduling Web Intelligence Reports and Crystal Reports.

Administering Universes and Universe connections.

Develop OLAP Connections to BW

Module 27 - Web intelligence

Overview of SAP business object web intelligence

Nativating the interface

Functioning of semantic layer

Developing query

Module 28 - Dashboard

SAP BO dashboard overview

Working of dashboard design tools

Components of dashboard

Creation of responsive and innovative dashboards

Dashboard design using SAP Bex query and Excel source

Creating Dashboard design using BO IDT universe

Static and dynamic dashboard

Alert based dashboards

Module 29 - Query as A Web Services (QAAWS)

Introduction to QMWS.

Creating a QAAWS using Universe source

Module 30 - Lumira

What is SAP lumira?

SAP lumira connectiosn

Exploring data

Data preparation

Visualization

Sharing datasets

Composing stories board