SAP BW/BI

The reporting, analysis, and intSAPretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market. With Business Intelligence (BI), SAP NetWeaver provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools with which an entSAPrise can attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in BI with the toolset provided.

BI provides flexible reporting, analysis, and planning tools to support you in evaluating and intSAPreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis.

Section Heading

Course Information

Duration: 40 Hours

Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Method: Online/Classroom Training

Study Material: Soft Copy

System Access: For 1 month

Course Content

Introduction

  • General Introduction
  • SAP introduction
  • Data warehousing/ BW/ BI Introduction
  • Master data; Attributes, Texts, and Hierarchies
  • Standard Naming conventions in SAP and BI

Data Modelling

  • 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 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 SUIT: 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, and Checkboxes, Dropdown Box and other web items and their attributes

Activities

  • BEx Analyser
  • BEx Web Application Designer
  • BEx Report Designer

BI platform

  • Information Broadcasting
  • Functions of the Broadcaster: Precalculating and Exporting into EntSAPrise 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

Key Features

Instructor Led Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request For Demo

Training Calendar

Module Classroom/Online Location
SAP EWM  Online Instructor-Led Online
SAP TM Online Instructor-Led Online
SAP GTS Online Instructor-Led Online
SAP MM Online Instructor-Led Online

Our Clients