+44 7459 302492
support@uplatz.com
Job Meter = High
SAP BW 7.4
45 Hours
Online Instructor-led Training
USD 1399 (
About this Course
Full course on SAP BW on any Database.
-- Procedures within modeling of SAP Business Warehouse
-- How to create a Layered Scalable Architecture
-- How to extract data from SAP source systems with Service API and how to manage delta data
-- Acquire data from other source systems using different interfaces such as: DB Connect, Universal Data Integration, XML, and Data Services
-- Acquire extended knowledge and skills in SAP BW Operations
-- Acquire extended knowledge and skills in SAP BW Perfomance Optimization
-- Procedures within modeling of SAP Business Warehouse
-- How to create a Layered Scalable Architecture
-- How to extract data from SAP source systems with Service API and how to manage delta data
-- Acquire data from other source systems using different interfaces such as: DB Connect, Universal Data Integration, XML, and Data Services
-- Acquire extended knowledge and skills in SAP BW Operations
-- Acquire extended knowledge and skills in SAP BW Perfomance Optimization
SAP BW 7.4
Course Details & Curriculum
- Data Warehousing
- Describing Data Warehouse Systems
- Describing Data Warehouse Architecture
- Using the Data Warehousing Workbench
- Master Data Modeling in SAP BW
- Describing InfoObjects
- Creating Characteristic InfoObjects
- The Loading of Master Data from SAP Data Sources
- Describing Data Flow
- Modeling a Master Data Flow
- Loading a Master Data Flow
- Modeling with the Graphical Data Flow Tool
- Loading of Transaction Data from SAP DataSources
- Describing the Core InfoProviders
- Creating a Key Figure InfoObject
- Creating a DataStore Object (DSO)
- Loading Transaction Data into a Data Store Object
- Describing the Extended Star Schema of an InfoCube
- Creating InfoCubes
- Loading Transaction Data into an InfoCube
- Master Data Loading from Flat File Data Sources
- Loading Data From a Flat File
- Describing the Data Flow in Detail
- Describing the Data Loading Process in Detail
- InfoProviders in SAP BW
- Explaining the InfoProviders Used in SAP BW – Introduction
- Creating MultiProviders
- Usage of SAP BI Content
- Using BI Content
- Query Performance Optimization
- Optimizing Query Performance
- Monitoring Performance
- Creating and Filling Aggregates
- The SAP BW Administration
- Describing Administrative Tasks and Tools
- Administrating the InfoCubes
- Administrating the DataStore Objects
- Creating Process Chains
- Enterprise Data Warehouse (EDW) Architecture
- Determining EDW Architecture
- Planning the Architecture of an EDW
- Using the EDW Layers
- Determining the Purpose of the Data Mart Layers
- Determining the Purpose of the Operational Data Store Layer
- The Modeling Process
- Identifying Decision Areas within SAP BW Projects
- Performing Requirements Analysis
- Creating a Logical Data Model
- Developing the SAP BW Data Model
- Creating Graphical Data Models and Templates
- Data Modeling Practice
- Drafting a Data Model
- Summarizing Data Modeling Practice
- BI Content Analysis
- Listing the Uses of BI Content
- Comparing a Data Model with BI Content
- InfoObject Models
- Listing the Tables in the SAP BW Data Model
- Implementing Tracking History Scenarios
- Using Reference Characteristics
- Using Hierarchies
- Using Key Figures
- Creating Translation Types for Currency Translation
- Creating Translation Types for Quantity Conversion
- Creating a Data Model for Mapping Non-Cumulative Values in SAP BW
- Modeling DataStore Objects
- Modeling DataStore Objects
- Using Real Time Data Acquisition (RDA)
- Multi-Dimensional Modeling
- Determining the SAP BW Star Schema
- Designing the Dimensions of the SAP BW InfoCube
- Enhanced InfoProvider Modeling
- Modeling MultiProviders
- Modeling an SPO
- Modeling an InfoSet
- Modeling a VirtualProvider
- Modeling a HybridProvider
- Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree
- Data Model Remodeling
- Modifying a Data Model
- Information Lifecycle Management
- Describing Information Lifecycle Management
- LSA++ with SAP BW on SAP HANA
- Determining the Advantages of SAP BW on SAP HANA
- Determining the Enhancements of LSA++ with SAP HANA
- SAP BW Data Acquisition Process
- Explaining Data Acquisition in SAP BW
- Creating SAP BW 3.x Data Flow
- Comparing and Migrating 3.x / 7.x SAP BW Data Flows
- Directly Accessing Source System Data
- Loading Directly Without Persistent Staging Area (PSA)
- Reviewing Details of Real-Time Data Acquisition (RDA)
- Data Acquisition with the SAP BW Service API
- Connecting SAP Source Systems to SAP BW
- Displaying the Configuration of SAP BW Service API
- Explaining BI Content
- Examining the Transfer of GL Data
- Examining Generic DataSources
- Enhancing BI Content DataSources
- Configuring Logistics Data Extraction
- Delta Data Flow Management
- Describing Delta Management
- Explaining Terms and Basic Processes of Delta Enabled DataSources
- Analyzing Delta Management
- Data Acquisition with Operational Data Provisioning (ODP) and SAP Landsape Transformation (SLT)
- Describing Data Acquisition with ODP
- Analyzing Operational Delta Queue (ODQ)
- Replicating Data with SLT
- Acquiring Data in Real Time with SLT
- Flat File Data Transfer
- Loading Data from a Flat File
- Loading Hierarchies in SAP BW Using the Hierarchy Framework
- Exporting a hierarchy using OpenHub
- Data Acquisition with DB Connect
- Creating a DB Connect DataSource
- Data Acquisition with Universal Data (UD) Integration
- Creating UD Connect DataSources
- XML-Based Data Acquisition
- Explaining XML-Based Extraction
- Acquiring Data Using an XML-Based Web Service
- Creating HybridProviders
- Data Acquisition with SAP Business Objects Data Services
- Integrating SAP Business Objects and SAP BW
- Data Mart Interface and Open Hub
- Examining the Data Mart Interface for Data Transfers
- Implementing OpenHub Destinations
- An Overview of SAP NetWeaver Business Warehouse (BW), BW Accelerator, and SAP HANA
- Identifying the Components and architecture of SAP NetWeaver BW, BW Accelerator, and SAP HANA
- InfoProvider Administration
- Managing InfoCubes
- Managing DataStore Objects
- Managing MultiProviders
- Managing HybridProviders
- Managing Semantically Partitioned Objects (SPOs)
- Managing TransientProviders
- Managing Analytical Indexes
- Managing VirtualProviders
- Managing Real-Time Providers
- Creating a DataStore Object for Direct Update
- Process Chain Administration
- Designing Process Chains
- Maintaining Process Chains
- Monitoring Process Chains
- Data Acquisition Administration
- Describing the Data Load Cycle
- Examining the Technical Details of Data Loading
- Loading Master Data
- Using Transformations
- Monitoring Data Load
- Working with the BW Trace Tool
- Working with the BW Trace Tool
- Information Lifecycle Management
- Classic Archiving in Information Lifecycle Management
- Making Archived Data Available for Queries Using BW Near-Line Storage
- BW Transports
- Describing the BW Transport System Landscape
- Determining Object Versions and Metadata
- Managing BW Transports
- Transporting BEx Objects
- Transporting Roles and Workbooks
- Investigating Transport Strategies and Troubleshooting
- Performance Management with BW InfoProvider Indexes
- Determining Relational DBMS Indexes
- Indexing for InfoProviders
- Optimizing Performance for InfoProviders
- Optimizing Performance for DataStore Objects
- Optimizing Performance for InfoCubes
- Optimizing Performance Using Semantically Partitioned Objects
- Optimizing Performance Using Analytical Indexes
- Optimizing Performance Using TransientProviders
- Working with Aggregates
- Optimizing Performance Using MultiProviders
- Optimizing Performance Using HybridProviders
- Optimizing Data Acquisition Performance
- Configuring Data Acquisition Parallel Processing
- Improving Data Acquisition Performance
- Loading and Activating DataStore Objects
- Performance Through Partitioning
- Performing Table Partitioning
- Reporting Performance
- Designing Queries for Optimal Performance
- OLAP Caching
- Maintaining Query Properties
- Managing Performance with BW Statistics
- Getting an Overview of BW Statistics
- Implementing Technical Content for BW Statistics
- Administering and Analyzing BW Statistics Data
- Monitoring with BW Administration Cockpit and BO Dashboard
- Performance Management with BW Accelerator
- Performance Optimization with BW Accelerator
- Determining BW Accelerator Architecture
- Increasing Query Read Performance Using BW Accelerator Indexes
- Monitoring BW Accelerator
- Envisioning the Future of SAP HANA with BW
FAQ
Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +
