• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

SAP BW 7.4

45 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
SAP BW 7.4 course and certification
188 Learners

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

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

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? +

Didn't find what you are looking for?  Contact Us