Training Bees, Hyderabad

Course Details

Course

SAP in the current business scenario is like a gold mine for job seekers, Training Bees SAP BW, is a comprehensive and beautifully packaged Business Intelligence training program created for SAP R/3 environment around a data warehouse. BW delivers Reporting, Analysis and Interpretation of business data to optimize and enable the organizations to meet the necessity and to take crucial business decisions. 

Unit 1. Overview & Concepts

• Overview of SAP R/3

• Necessity of SAP BW & Version of BW

• OLAP & OLTP

• Data Ware Housing Concepts

• Landscape of SAP BW

• Integration of BW system with different systems

• ERM, MDM, Star Schema & Extended Star Schema.

Unit 2. BI7.3/7.4 Concepts & Overview

• Data warehousing workbench

• Components of data warehousing workbench.

• Difference B/w BW and BI.

Unit 3 . Modelling

• Types Of Data.

• Master Data Loading

1. Attribute Data Loading

2. Text Data Loading

• Transaction Data Loading.

1. Info cube Data Loading and Its Concept.

2. DSO &Difference between ODS & DSO

3. Standard DSO

4.  Direct DSO

5. Write Optimized DSO.

6. Multi provider.

7. Info set

8. Open Hub Destination.

• Concepts of Transformation & Its Types

• Controlling the data-flow with Info packages (IP)& Data Transfer

• Process(DTP)

• Open Hub & Performance Issue

• Deleting data from data target

• Query performance & Load Performances

Unit 4.Excerise for Lab.

 . Types of Info Cubes, Info Sets, Multi Provider

• Open Hub& Performance Issue

• Deleting data from data target

• Query performance & Load Performances

Unit 5 . Extraction

• Flat file Extraction

• LO or Logistic Extraction

• Generic Extraction & Generic Delta

1.Using Table Extraction

2.Using View Extraction

3.Using Info set Query Extraction

4.Using Functional Modular Extraction

• FI-SL, Co-PA, DB Connect

• Business Content Extraction

• Data Enhancements- Tables, View, Query

Unit 6 . BI 7.4 Reporting

• BEx Query Designer

1. Introduction of BEx Query

2. Filters, Columns & Rows

3. Characteristic Restrictions & Free Characteristics

4. Formulas & Calculated Key Figures

5. Restricted Key figures & Variables with Texts.

• Web Application Designer

1. Creating Web Templates

2. Web Item & properties

3. Drop-down Functions

4. Condition & Integration

5. Business Explorer Analyzer

6. Introduction to BEx Analyzer

7. Filtering Option

8. Properties Available in Analyzer

• Report Designer

1. Creating Reports

2. Formatting columns & Rows

3. Changing font styles with background colour.

4. Inserting Rows & columns

• Bo Reporting with BW data

1. Induction and Concept

2. Universal designers

3. Webi

4. Deski

5. Crystal Reports etc

Unit 7.Business Content

• Important of business Content

• Business Content Installation & Activation

• Business Content Data Source, DSO’s, Cubes, Reports, etc…

Unit 8. Meta Data Repository

• Important of Metadata Repository

Unit 9.Process Chain

• Types of Process Chains

• Process Groups & Meta Chain, etc…

Unit 10. Transport Mechanism

• Review of system Landscape

• Collecting Objects

• Creating Transports

• Releasing Transport

• Importing Transport

• Monitoring Transport

Unit 11. Authorization Concepts

• Authorization

Unit 12. Integrated Planning

•  Introduction & Planning Application- On web, MS Excel

Unit 13 . Types of Projects

a)Real Time Implementation Projects

b)Up-Gradation project

c)Enhancements to the existing Implementation project

d)Support project

Unit 14 . Advanced Topics in BI 7.0

• Analysis process Designer

• Modelling/Repartitioning

• Data Mart

• Open Hub Destination

• Info set

• Multi provider

Unit 15. Real Time Implementation Projects

Unit 16.Module

• System landscapes

• SAP BW-Bo landscape

• SAP ERP Landscape

• Non ERP Systems landscape

• Database landscape

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

About SAP BO Course

SAP BO is a suite of front-end applications that allow users to view, sort and analyze business intelligence data. A few of the key applications are Crystal Reports, Dashboards and Web Intelligence. 

Training Bees, SAP BO training curriculum demonstrates that how to increase the flexibility and scalability of business processes and learn to achieve encapsulation, SAP business objects are created as entities with layers are kernel, integrity, interface and access layers.  

Unit 1. Business Objects Introduction

•  SAP Business Objects Web Intelligence and BI Launch Pad 4.1

•  Web-Intelligence Rich Client (Desktop based tool)

•  SAP Business Objects BI Information Design Tool 4.1 (IDT)

•  SAP Business Objects BI Universe Designer tool (UDT)

•  SAP BW Infocubes to Universe with IDT

•  SAP HANA to design the Universe with IDT and UDT (SAP HANA with BO)

•  Lifecycle Management & Upgrade management tool

•  Report Conversion Tool (Deski to Webi Reporting)

•  BO Administration/ Security (CMC)

•  SAP Business Objects Dashboards 4.1 (Crystal Xcelsius 2011)

•  Crystal Reports 

•  Integration with SAP BW& BO (SAP BI Integration with BO)

•  BO Project migration 

•  BO Deployment and Report Scheduling

•  Connecting to Data Sources

•  New features of SAP Business Objects 4.1

•  Differences between different versions of BO

Unit 2. Information Design Tool

• Single Source Connection

• Multiple Source Connection

• Establishing Connection

• Exporting

• Joining

• Inserting the Tables

• What is the Information Design Tool (IDT)

• Create a project

• Create a connection to a relational database (Single and Multiple databases)

• Create the data foundation with Single & Multiple databases

• Define the different types joins in a data foundation

• Create a business layer

• Create folders and objects

• Resolve Loops and Use alias

• Resolve Loops Use contexts

• Resolving the fan traps and Chasm traps problem

• Define data restrictions

• Work with LOVs

• Use Parameters restrict data

• Use @functions also Aggregate Awareness

• Create Derived Tables and Index Awareness

• Maintain universes

• Deploy and manage and maintain universes

• Documentation of the universes

• SAP BW Integration with BO

• SAP HANA with BO

• Creating OLAP Connection(Using BICS middleware)

Unit 3. Universe Designer Tool 4.1

• Understanding Business-Objects Universes.

• Understanding how universes allow users to query databases using their everyday business terms.

• Creating Universe Connections.

• Creating the universe on different databases

• Building and populating the Universe Structure.

• Defining joins in a universe.

• Creating Dimension Objects.

• Understanding classes and objects.

• Creating Measure Objects.

• Understanding measure objects.

• Using List of Values.

• Resolving Loops.

• Resolving loops using aliases.

• Resolving loops using contexts.

• Chasm traps and Fan traps.

• Restricting the data returned by objects.

• Using Functions with Objects.

• Using @ Functions.

• Using Hierarchies.

• Working with hierarchies.

• Aggregate Awareness.

• Derived Tables

• Securing Universes.

• Managing Universes.

Unit 4. Web-Intelligence Rich Client 4.1

• Introducing Web Intelligence

• Create reports using webservises as a Data source

• Using complex filters

• Report Design

• Ranking data to see top or bottom values

• Tracking data changes

• Using alerters to highlight information

• Organizing a report into sections

• Copying data to other applications

• Formatting Reports

• Preparing documents for PDF and print

• Calculating Data with Formulas and Variables

• Understanding formulas and variables

• Understanding how Web Intelligence calculates data

• Creating formulas and variables to calculate data

• Using Multiple Data Sources

• Adding a new query using a personal data provider

• Creating multiple queries in a document

• Synchronizing data with merged dimensions

• Analyzing Data

• Drilling into the data

• Setting Web Intelligence drill options

• Using sub-queries

• Creating a query based on another query

• Changing data sources

• Using the query drill

• Using query sampling

• Understanding dimensions and details

• Character and Date String Functions

• Using character string functions

• Concatenating different data types

• Using date functions

• Calculation Contexts

• Understanding calculation contexts

• Redefining calculation contexts

• Using If Logic

• Using IF/ELSEIF

• Additional Reporting Techniques

• Using data tracking

• Displaying data restricted by a filter or ranking

Unit 5. SAP Business Objects Web Intelligence

• BI launch pad: What's new in 4.1

• Customizing BI launch pad

• Creating Interactive Analysis documents with queries

• Restricting data returned by a query

• Types of filters

• Designing Interactive Analysis reports

• Enhancing the presentation of data in reports

• Formatting reports

• Calculating data with formulas and variables

• Using multiple data sources

• Analyzing data

• Managing and sharing Interactive Analysis documents

• Reporting from Other Data Sources

• Accessing corporate information with Web Intelligence

• Understanding how universes allow you to query databases using everyday business terms.

• Managing documents

• Creating Web Intelligence Documents with Queries

• Modifying a document's query

• Using prompts to restrict data

• Using complex filters

• Displaying data in tables and charts

• Presenting data in free-standing cells

• Enhancing the Presentation of Reports

• Using breaks, calculations, sorts and report filters

• Ranking data to see top or bottom values

• Using alerters to highlight information

• Organizing a report into sections

• Copying data to other applications

• Alternative Query Techniques Using Combined Queries Using Sub-Queries

• Creating a Query based on another Query

• Character and Date String Functions Using the character string functions Concatenating different data types Using date functions

• Using If Logic

• Grouping data using If() logic

• Using If() to modify calculation behavior

• Advanced Reporting Features Formatting breaks

• Creating custom sorts

• Displaying document data in free-standing cells

• Alternative Query Techniques Defining Combined Query Types Using Combined Queries

• Using Sub-Queries

• Creating a Query on a Query

• Character and Date String Functions Understanding Character Strings

• Linking to documents and URLs in Web Intelligence

• Create the reports on top of Sap BEX queries

Unit 6. SAP Business Objects Dashboards 4.1 (4hrs)

• Xcelsius Dashboard Overview

• Creating Dashboards using Query As A Web Service (QAAWS) and Live Office

• Create Drill Down dashboard reports

• What's new in SAP Business Objects Dashboards 4.1

• Creating a Visualization

• Producing interactive visualizations

• Getting around in Xcelsius

• Working with your Excel workbook

• Visualizing data with charts

• Using Xcelsius Components

• Formatting a Visualization

• Applying formatting options

• Using themes and templates to apply formatting

• Adding Interactivity to a Visualization

• Using selectors

• Adding dynamic visibility

• Using live data sources

• Connecting to BO Universes using Query as a Web Service

• Using Live Office data

• Creating Complex dashboards

Unit 7. SAP Crystal Reports 2011 (2hrs)

• Crystal Report Overview

• Creating reports

• Selecting records

• Organizing data on reports

• Grouping & section formatting

• Creating basic and complex formulas

• Using variables

• Using report templates

• Applying conditional reporting

• Building parameterized and specialized reports

• Summarizing data with cross tabs

• Using report sections

• Representing data visually

• Managing reports

• Distributing reports

• Using repository data sources

• Report processing

• Linking Crystal Reports to Webi reports

• Drill down reports

Unit 8. BOBJ Mobile Integration

• Development of core SAP BusinessObjects Mobile reports and dashboards

• Deployment of mobile reports and dashboards to end-users

• Connect to your BI deployments (e.g., Production, Development, UAT)

• Browse your repository securely using folder navigation

• Schedule documents

• Refresh documents

• Schedule objects

• Print and email documents

• View historical and latest instances

• Delete content (provided you have the necessary rights)

Unit 9. Administration

Unit 10. Widgets

Unit 11. Webi-Rich Client

Unit 12. Query as Web Service

Unit 13. OLAP EDITION, BO Analysis MS Excel, MS PPT

Unit 14. Business Objects Explore 4.1

Unit 15. BI Workspace

Unit 16. BI Module

Unit 17. Information Steward

Unit 18. Security Implementation

Unit 19. OLAP Universe

Unit 20. Import Wizards\Publishing Wizard

Unit 21. Business View Manager

Unit 22. Live Office Reporting

Unit 23. BO-SAP Integration/Edge series

Unit 24. BO-SAP HAN integration

Unit 25. SAP Webi/Dashboards Reporting

Unit 26. BO XI Certification Guidelines

Unit 27. SAP BO 4.1 Launch Pad

Unit 28. New Enhancements of BO BI 4.0

• Information Design Tool.

• BI Launch Pad

• Dashboards Design Tool

• SAP BO 4.0, BW 7.4 Integration

• SAP BO BI 4.0 SAP HANA Integration

Unit 29. New Enhancement of BO BI  4.1

• Designer Studio

• SAP  Visual Intelligence

• Information Steward

• Bew Enhancements in Different Tools Comparing with SAP BO BI 4.0.

Unit 30. SAP BO BI 4.1 with SAP HANA 1.0 SPS6 Senarios:

• COPA Scenarios

• Sales Scenarios

• Procurement Scenario

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Training Bees online training program for SAP HANA, will help individuals and professionals stay ahead in competition, it is beautifully designed for those who want to learn and make their career in SAP HANA but don’t know where to start. Our expert trainers will make your learning journey very much easy.  

Our training program is a perfect blend of online training, assignments, tests and live projects. 

Unit 1 : SAP HANA STUDIO

·         Modeler

·         Administration View

·         Navigator

·         System Monitor

Unit 2 :ARCHITECTURE OF SAP HANA

·         Row Store

·         Column Store

·         Database engine of HANA

·         Data modeling

·         Reporting Architecture

·         Administration

Unit 3 :  MODELING IN SAP HANA

·         Create Attribute Views

·         Design Analytical Views

·         Create Calculation Views from multiple analytical Views

·         Best Practices while Creating Information Models

·         Performance Optimization techniques in SAP HANA

·         Currency Conversion

·         Variables in HANA

·         Meta data import to SAP HANA Using SAP BODS

·         Export Models

·         Import Models

·         SQL Script

·         CE Functions

·         Procedures

·         Hierarchies - Level Based Hierarchies and Parent Child Hierarchies

·         Restricted Measures & Calculated Measures & Calculated Attributes

·         Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities

·         Auto Documentation of Information Models

Unit 4 : REPORTING

·         Reporting SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA

·         IMCE Clients - ODBO , ODBC, JDBC, BICS

·         Microsoft Excel 2010 Connection to HDB

·         Create Universe through Information Design Tool using JDBC Connections.

·         Web Intelligence Document on SAP HANA Universe.

·         Design studio

·         Lumira

·         BO Analysis for Office

·         BO Analysis for OLAP

·         BO Explorer

·         Crystal Reports for enterprise

Unit 5 : DATA PROVISIONING OR DATA LOADING

·         SAP LANDSCAPE Transformation - SLT

·         SAP BODS Load to SAP HANA - ODP Enabled Data Sources

·         SAP DXC - Direct Extractor Connection

·         Flat File Upload to SAP HANA

·         SAP BODS : Overview Data Services Workbench and Designer

·         Creating Data store for ECC and HANA

·         Create Data Services Job and Load the data to SAP HANA DB

Unit 6 : ADMINISTRATION IN SAP HANA

·         Backup & recovery

·         SAP HANA Studio Installation and Configuration

·         Clients installation

·         Create ODBC Connections

·         Monitor HDB

·         Multi Version Concurrency Control - MVCC

·         IMDB Installation

·         Distributed System Handling - Cold backup and Hot Backup

·         Persistency Layer

Unit 7 :  USER MANAGEMENT & SECURITY

·         Creating Users

·         Creating Roles

·         Assign privileges to Users/Roles

·         Template Roles

·         SQL Statements for user management

·         Analytical Privileges, Package Privileges, System Privileges, SQL Privileges

Unit 8: COPA ACCELERATOR

·         COPA Overview COPA Reporting in HANA

·         Architecture for CO - PA Accelerator , Use Case Scenarios , Scope

·         DBSL - Database Shared Library Connection for HANA as secondary Database

·         SLT Replication - SAP HANA Model.

Unit 9 :  SAP BW ON HANA

·         Overview of SAP BW

·         SAP BW Powered By Hana as database

·         In Memory Optimized Info cube

·         In Memory Optimized DSO

·         Bex Report on SAP HANA Transient Provider

·         SAP BW Composite provider on HANA model

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

This course enables from Training Bees enables learners to implement and maintain SAP BW powered by SAP HANA and outlines advantages of the new "In-Memory" Solution with SAP BW. It is designed with every minute details and explains HANA specific or optimized elements and aspects of SAP BW. 

Unlike every other course from BPT, he also you get:

• Assignments

• Live examples

• Live Projects 

• Periodic Assessments

Course curriculum

UNIT 1 : OVERVIEW OF THE SAP BW IN HANA

Module One: Enterprise Structure Introduction to ERP

SAP, Data Warehouse Overview of BW, BI, Data Base.

Overview of BW Architecture, Landscape Basic Modeling:

Create a valid Schema Multi-Dimensional Model - The Star

Schema (Classical Approach) Multi-Dimensional Star

Schema in

BW (Extended star Schema) The OLAP Concept

Differences between OLAP and OLTP Business Modeling

Info Area

Info Object Catalogs

Info Objects

PSA

Application Component

Info Source

Data Source

Transfer Rules

Update Rules

Transfer Structure

Communication Structure

Info Package

Transformation

Data Transfer Process

Loading Transactional Data into BW info Cube Loading MD

with TD into BW System BW and BI Comparisons Master

data loading-new(BI) ETL process

Info cube & Types

Standard Info cube and Loading with new ETL Process

Generate Report with BI master and Transaction Data

Manual Uploading of MD like Attributes, Text, Hierarchy

Different Types of Attributes Transformations

UNIT 2 : RULE TYPES ROUTINES

Start Routine

End Routine

Expert Routine

UNIT 3 : DTP (DATA TRANSFER PROCESS)

Standard DTP

Error DTP

Direct Access DTP

Real time DTP

UNIT 4 : DSO (DATA STORE OBJECT)

Standard DSO

Write optimized DSO

Direct update DSO

APD (Analysis Process & Design)

Update Methods

Full updates

Initialization

Delta Updates

UNIT 5 : INFO PROVIDERS

Multi Providers

Info set

Virtual Providers

Re-Modeling

Re-Partitioning

Open-Hub Destination

Data Marts

UNIT 6 : INFO CUBE MAINTENANCE

Aggregates

Roll-up

Compression

Reconstruction

UNIT 7 : PROCESS MANAGEMENT

Process Chains, Process Types

Scheduling

Monitor (Header, Status, Details)

UNIT 8 : REPORTING - BUSINESS EXPLORER

BEX Query designer

BEX Analyzer

BEX WAD

BEX Report Designer

Visual Composer

Functional Overview of Bex Query

Designer Reusable Query Elements

Query Controls with Variables

Calculated Key Figures

Restricted Key Figures

Formulae

Structures

Variable Definition in Detail

Characteristic values variables

Text Variables

Formula Variables

Hierarchy Variable

UNIT 9 : ANALYSIS FUNCTIONS

Conditions

Exceptions

Reporting Drilldown

Drilldown to DSO from Info Cube (RRI)

Copying Queries from Cubes

Bex Analyzer Bex WAD Bex Report Designer

Visual Composer Migration Objects from BW 3.x to BI 7.0

Transportation Extraction

Generic Data Extraction using MD/TD Tables

COPA Extraction

Business Content Extractions using MD/TD

LO-COCKPIT Data Extraction

Delta types for

Generic Extraction

LO Extraction

ASAP methodology

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Training Bees commited to provide the best training for SAP XI – PI which is SAP's Enterprise Application Integrations software, a component of the NetWeaver product group used to facilitate the exchange of information among a company's internal software and systems and those of external parties. 

Unit 1 : Overview Of XI/PI

Introduction to integration

Introduction to SAP Net Weaver

Modules in SAP Net Weaver

Components in SAP XI

Design Time Components

Administrative and monitoring components

Runtime Components

Architecture of XI

Unit 2 : SLD (System Landscape)

Technical System

Technical System Types

Business System

Business System Types

Software Components

Unit 3 : IR (Integration Repository)

Name Spaces

Integration Scenarios & Integration Processes

Message Interfaces

Message Types

Fault Message Types

Data Types

Data Type Enhancements

Context Objects

External Definitions

Interface Mappings

Message Mappings

Mapping Templates

Imported Archives

Adapter Objects

Unit 4 : ID (Integration Directory)

Party

Service without Party

Business System

Communication Channels

Business Service

Integration Process

Receiver Determination

Interface Determination

Sender Agreement

Receiver Agreement

Unit 5 : Integration Monitoring

Component Monitoring

Message Monitoring

Knowledge on End-to-End Monitoring

Knowledge on Performance Monitoring

Adapters Statuses

Unit 6 : ccBPM

Integration Process Scenario

Abstract Interface

Graphical Definition

Send Steps

m:n transformation

Unit 7 : Proxies

Introduction to Proxies

Creating ABAP proxies

Proxy Runtime

Unit 8 : Scenarios

File to File

IDOC to File

File to IDOC

IDOC to Flat file

Flat file to IDOC

IDOC to JDBC

JDBC to IDOC

HTTP to RFC

SOAP to RFC

XSLT Mapping

BPM1(File to File)

BPM2(File to RFC)

ABAP Proxy (Client Proxy)

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Training Bees expert trainers have designed this course to give learners the opportunity to gain an understanding of SAP SAPUI5. Participants will learn how to program applications using SAPUI5 by creating a new project in Eclipse. There will be hands-on exercises, assignments, assessments and projects will be performed during the course to gain experience with SAP SAPUI5 so as to become a master of the subject.

Course curriculum 

Overview

Control Libs

Architecture

Exercise - Application

Programming Applications

UI5 Bootstrap

Core Controls

Exercise

SAP UI5 Developer Studio

Overview about IDE

Creating sample project

Exercise - Sample project

Resource Handling

Localization & Modularization

Exercise - localization

MVC Architecture of SAPUI5

Views and Controllers

Exercise

Data Binding

Overview

Model

Binding Model with UI element

Types of Bindings

Odata

Styling and Theming

Adjusting Styles

Themes

Exercise

Extending UI5

Overview

Exercise

Notepad controls

Overview

Exercise

Charting

Types of charting Exercise

Optimizing UI5 Applications

Overview

Caching

SAPUI5 Mobile Application development

Overview

Split App control

MVC pattern Core controls

Charting Controls

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

trainingbees expert trainers specialize in delivering SAP FIORI trainings. Our training content is a perfect blend of demonstrations and hands on exercises of SAP Fiori components. This course will introduce you to the fundamentals and latest features of the SAP Fiori UX. You will learn about product installation, configuration, and best practices for extensibility.

An online course curriculum designed to make you an expert in using SAP FIORI, we have made sure that the curriculum is easy to understand and is highly effective.

• Overview of the SAP Fiori solution

• Introduction to SAP Fiori Apps (Manager & Employee)

• SAP UX strategy relating to SAP Fiori

• SAP Fiori architectures and technology (App types, Architecture structure/details, hardware & software requirements)

• Role of SAP SAPUI5

• Basics of SAP NetWeaver Gateway OData Services

• Configuration overview - Transactional, Fact Sheets, Analytical &   Launchpad

• Launchpad overview and functions

• Launchpad configuration

• Theme Designer overview

• SAP Fiori security

• Installation overview & tasks

• Configure Transactional Apps & Factsheets (Search, NW Gateway, Central UI Add-On, Product Specific Add-On)

• Introduction of end to end Data Flow

• SAP Business Workflow basics

• Custom Workflow scenarios to Approve Requests

• Extensibility overview (Concept, skills, tools)

• OData extensibility (Taskflow& SAP NW Gateway)

• UI Field extensibility (Tools, method, concepts)

• HANA XS Engine overview & architecture

• Analytical Apps overview

• Installation of the XS Engine for SAP Fiori Analytical Apps

• Configuration of Analytical Apps (KPI prerequisites, general overview how to create KPIs)

• Configuration of a KPI

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No