SAP BI Training in Pune & Pimpri Chinchwad

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

• Info Objects: Definitions
• Types: Characteristics, Key Figures, Time, and Unit.
• Info Cubes: Definitions.
• Types: Standards, real time, remote.
• Design of Info cube: Star Schema concepts. Precautions.
• Data Store objects (DSO):
• Types: Standards, Real time.
• Info Sets
• MultiProviders: Scenarios to create Multiproviders.
• Info cube VS DSO

Metadata and Document Management

• BI Content: Definitions, How to install BI contents, 

Defining extraction

• For SAP source systems: Creating Generic data Source and maintaining SAP delivered data Source.
• Or for files: Creating Data Sources 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 Info Cube
• 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, Style sheets, 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: Recalculating 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.

 

Contact Us:

Pune Center:

ERP  Infotech

1st Floor, ‘Jagat Anand’ Apartment,

Opposite Badami Haud Gym,

Near Kelkar Museum, Bajirao Road

(5 Min. From Tilak Road, Dagdusheth Ganpati, Laxmi Road, Swargate, Appa Balwant Chowk)

Phone No :: 0091-9623579140

                    / 020-65292422

E-Mail:  sap.info@in.com

(Between 9 AM to 9 PM) 

Pimpri-Chinchwad:

ERP Infotech

Behind ICICI ATM, Sant Tukaram Nagar,
Opposite Sant Tukaram Temple,
Near D. Y.Patil College of Engg.
Pimpri, Pune 411018.

Phone No:  020-65292423

(Between 9 AM to 9 PM)