SAP Business Warehouse or SAP BW is an enterprise data warehouse product by SAP, which can integrate and transform business information from any possible source system. SAP BW using SAP HANA is the first application by SAP to run entirely on SAP HANA, and SAP BW 7.5 is the latest update in SAP BW. SAP is known for Data Warehousing worldwide and clients will gain immensely from the planning functions, query runtime, and improvements in data load seen in this product. This has highly simplified data modeling and reduced Info Provider. Also, all data modeling is done within a new user interface, which is distinct across all modeling tools.
Pre-requisites
Should have basic knowledge of data warehousing concepts along with business knowledge on different application areas
Experience in SAP ABAP language will be an added advantage
Pre-requisites Materials provided: SQL Tutorial, Data Modeling and DW concepts
Who should attend this Training?
– SAP BW Practitioners
– SAP BW Application Consultants
– SAP Technical and Functional Consultants
– Â Professionals with interest in Data Warehousing
– Software Analysts and Mainframe professionals
– Project Managers and Business Objects Professionals
– Those aspiring for a career in SAP BI/BW
# 40 hrs. of Instructor lead online and physical classroom training
# Learn by Certified Industry experts
# 100% practical approach of teaching for better understanding of the concepts
# Real world use cases and scenarios
# Cloud server access
# Interview preparation for freshers
# Flexible timings which suits you
# Free demonstration if required
# The training is rendered by certified experts from the industry and tutorials prepared by them. The classes are available for the individuals on weekdays and weekends as per their flexibility. The help desk can be called for more details.
Who can attend this training?
Any graduate or post graduate who have minimum 2 years of work experience (domain) or a person who already knows SAP and want to upgrade their skill set can attend this training.
Who will be the Trainer?
All our trainers are well versed in their respective skills and they are best in the industry. Aiuto verifies all their trainer’s technical skills, expertise and their background.
Will any project exposure be given in training?
The training itself is real-time project oriented and 100% particle approach is followed for better understanding and hands on.
If I cancel my enrollment, will I be getting the refund?
If one wants to cancel the enrollment for certain reason before the commencement of the training the 75% of the submitted amount can be refunded. Once the session is started no refund will be given back to the candidate. For more details please refer to the cancelation polity at our website.
Introduction to Data Warehousing:
# Architecture of Data Warehousing
# OLTP Vs OLAP
# Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling
# Enterprise Reporting, Query and Analysis
# ETL and Reporting Tools
# Evolution of SAP BW/BI and HANA Landscape
Introduction to SAP BW/BI :
# Evolution of HANA
# Evolution and Architecture of SAP BW with HANA
# Modeling, Extraction and Reporting
# Installation of SAP HANA Studio and SAP GUI
MODELING of SAP BW 7.5 with SAP HANA:
# Introduction of basic terminology and objects
# Data Extraction and Data Flows
Info Providers:
# Master Data – Attributes, Texts, Hierarchies
# Standard, Write-optimized , Direct Update DSO’s
# Standard Info Cube and Virtual Provider
# Logical Layers: Info Set and Multi Provider
# Open Hub Destination
# Analysis Process designer
HANA Optimized Objects
# HANA-Optimized InfoCube
# Semantically Partitioned Object
# Advanced Data Store Object
# Open ODS Views
# Composite Provider
# HANA Analysis Process
Importing SAP BW models in SAP HANA
Importance of Business Content, Installation and Activation
Data Acquisition/Extraction:
# Flat file Extraction
# Overview of ECC6.0 Extractions
# Master Data extraction Customer, Vendor, Material
# Finance(FI), Sales and Distribution(SD) and Material Management modules
# Generic Data Extraction using Master and Transaction data tables
Process Chains:
# Process Chains and Process Types
# Administration activities
# Real time scenarios from support projects
Transport Mechanism:
# Review of system Landscape
# Creating Transports
# Releasing, Importing and Monitoring Transports
Reporting:
# Business Explorer Query Designer and Analyzer
# Reusable Query Elements
# Filters, Columns & Rows
# Characteristic Restrictions & Free Characteristics
# Formulas & Calculated Key Figures
# Restricted Key figures and Variables with Texts
# Report to Report Interface or Jump Starts
# Exceptions, Conditions, Structures, Cell Definitions
# Business Explorer Analyzer
# Introduction to Business Explorer Analyzer
# Filtering
# Properties available in Analyzer
Performance Improvement
# Column Store and Row Store
# Aggregates
# Compression
# Partitioning
# Indexes and DB Statistics
# Read Mode & OLAP cache
# Line Item Dimension & High Cardinality
Introduction to SAP ABAP
# SAP ERP Introduction and Architecture
# SAP ABAP
ABAP Programming Techniques:
# ABAP Development Workbench Tools
# Object Navigator
# Workbench Organizer and Data Dictionary
# ABAP Dictionary
# Tables
# Views
# Lock Objects
# Reports Statement
# Declarations
# Tables
# Includes
# Variables (Data Types and Data Objects)
# Structures
ABAP for SAP BI requirements:
# Field level Routine
# Start Routine
# End Routine
# Expert Routine
# Info package level Routine
# Data Source Enhancements
