SAP Business Warehouse/ BW/BI

You will be provided with most effective training in SAP BW/BI with different scenarios based on real time issues. All the topics will be covered from basics till the complex level.

Topics Covered

SAP BI Overview

ERP overview
ERP and Why ERP?
SAP history and different Sap Products.
Sap Cross Industry Applications
Sap Industry Specific solutions.
Role of SAP BI
Implementation
Support
Upgrade and Migration
Basics of Data Warehousing
Star Schema
Extended Star Schema
Advantages of Extended Star Schema
Terminology and Project Orientation




Data Modelling, DW Design and Data loading From File sys

BI System architecture
Data warehouse
ETL
BEx Suite
Functions of Data warehousing workbench
Development of Info objects.
Characteristics
Key figures
Development of Attributes and all the Tabs of Chars and Key figure
Display attribute
Navigational attributes
Transitive attribute
Compounding attribute
Designing the different types of Info cubes and DSO
Master Data loading—Attribute/Text/Hierarchy
Transaction data loading----Loading to DSO and Info cube.
Full upload
Initialization
Delta uploads
Real time Data acquisition and direct data Access (Virtual Provider)
Error Stack and Error DTP //Issues in data Loading
Installing Objects from BI content.
Info sets and Multi Providers.
Inner Join/Left Outer Join
Union
Placing Flat Files in Application Server
Data Modelling Tasks in a Project Environment






Data loading from SAP ERP and Database systems

Source system interfaces and logical systems. Remote function calls.
Source system application and data source overview. Types of Extractors
Logistics Data Extraction
Full upload
Initialization of data source
Delta uploads
Generic Extraction
Full upload
Initialization of data source
Delta uploads
DB extraction
Controlling Data Extraction
Full upload
Initialization of data source
Delta uploads
Finance Extractors
Master data Extraction from Sap ERP sys
Data source Enhancement.

Business Explorer Business Intelligence

Basics of Reporting. Components and Tools of Reporting
Query Designer and Different Elements
Free chars
Filters/Restriction
Conditions/Exceptions
Restricted key figure/Calculated key figure/New selection/New formula
Variables-all type
Analyser
Design Mode
Analysis Mode
Report Designer and Formatting Techniques of Report Designer.
Web application Designer and Web Analyser
BEx Broadcaster.
Visual Composer Reporting



BW 7.3 Topics & Supporting

Start, End & Expert routines
Remodelling
Repartitioning
BI Accelerator
BW Statistics
Performance Issues
Query Performance
Compression
Aggregates/Rollup
Indexes
Line item Dimension, Cardinality Height
Query trace/SQL Trace
Attribute and Hierarchy change run/etc…
Extraction performance
PSA partitioning/PSA and Change log Table Data Deletion
Transportation
Process chains Designing and Monitoring
Supporting Issues, Tickets and Miscellaneous topics

Who should attend

Graduates who are from B-Tech/BE, MCA, BSC, Any one who did Masters in any stream are eligible. Further counseling will be provided if it suitable or not for people with different education back ground

Pre-requisites

N/A

What you need to bring

A computer with good internet speed and a Headset.

Key Takeaways

Knowledge in SAP BW/BI, how to handle interview questions, different issues which can be expected in real time projects, approach in a logical way & many