ERP BI & BW

ERP BI & BW TRAINING IN NOIDA

📷 4.5 out of 5 based on 1699 Votes.

The ERP Business Information Warehouse provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools for the reporting, analysis, and interpretation of business data.

Course Content for ERP BI 7.0/BW 7.3:

INTRODUCTION TO ERP BUSINESS INTELLIGENCE

ERP Net weaver BI Architecture / BI Platform
Star Schema and Extended Star Schema
Multidimensional modeling
Entity Relationship Modeling
Enterprise Data Modeling
Enterprise Reporting, Query, and Analysis
ERP BW vs Other Data warehousing Tools
Data Acquisition / Data Extraction concepts

ERP BW Phases

Modeling
Extraction
Reporting

Modeling

Info Area,Info Object Catalogs
Info Objects(Characteristics & Key Figures)
Application Component
Data Source
Transfer Rules
Info Source
Update Rules
Different types of Routines
Info Package
Transformations
Data Transfer Process(DTP)
Error DTP
Metadata Repository

BI 7.0 Info Providers

Master Data – Attributes, Texts, Hierarchies
Standard DSO
Write-optimized DSO
Direct Update DSO
Standard Info Cube
Virtual Providers
InfoSet
MultiProvider
Aggregation Level
Others
Open Hub Destination
Analysis Process designer

BW 7.3 Info Providers

ERP NetWeaver BW 7.3 Features Overview
Graphical Data Modeling
Graphical Data Flow Modeling Basics
Data Flow Copying
Data Flow Generation
Data Flow Migration
Advanced InfoProviders
Semantically Partitioned Object (SPO)
Hybrid InfoProviders
Transient Providers
The New BW 7.3 Hierarchy ETL

Business Content

Importance of Business Content
Business Content Installation & Activation
Business Content Data Source, DSO’s, Cubes, Reports, etc…
Data Acquisition / Data Extraction
Flat file Extraction
Business Content Extractions using MD/TD SD, MM and FI
Logistics Extraction
Generic Data Extraction using MD/TD Tables
Delta mechanism
CO-PA Extraction
FI-SL Extraction
Data source Enhancement

Process Chains

Process Chains, Process Types
Scheduling
Monitor (Header, Status, Details)
Real-time scenarios from support projects

Transport Mechanism

Review of system Landscape
Collecting Objects
Creating Transports
Releasing Transport
Importing and Monitoring Transport

Reporting:

Introduction of Various Reporting Tools
Functional Overview of Business Explorer Query Designer
Introduction of BEx Query
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
Query Extracts using RSCRM_BAPI
Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer

Introduction to BEx Analyzer
Filtering Option
Properties available in AnalyzerERP BW BI Online Training

Performance Improvement

Aggregates
Compression
Re-Modeling
Re- Partitioning
Indexes and DB Statistics
Number Range Buffering
Read Mode & OLAP cache
Line Item Dimension & High Cardinality
Read Mode & OLAP cache
Business Warehouse Accelerator
Others

Course