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
Types of Projects
- Real-Time Implementation Projects
- Up-Gradation project
- Enhancements to the existing Implementation project
- Support projects