: contact@londontraininginstitute.co.uk

: (+44) 0203 617 1437 | Contact Us | Corporate Training | Blog

Home

SAP BW Training

About the course

SAP BW Training course focuses on SAP Business Warehouse (BW). It is an Enterprise Data Warehouse that provides tools and functions to report, analyse and interpret business information virtually. SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, and cleans and stores data.

SAP Business Warehouse provides a high-performance infrastructure allowing the user to make the right decisions and identify target orient activities. It also includes data modelling, administration and staging area. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals.

Obtaining any SAP certification boosts your career success and is a valuable credential in any competitive career market. Validate your knowledge with SAP Certification. Become a recognised SAP-certified solution expert.

We offer the following courses under SAP BW training:

BW305 SAP Business Warehouse Query Design and Analysis
BW310 SAP BW – Enterprise Data Warehousing

Benefits of SAP Global Certification:

Gain a highly recognised, on-demand accreditation of excellence
Differentiate yourself in a crowded market
Execute tasks with confidence and skills
Attain higher wages and billable rates with a highly valued credential

Starting Date	Timing	Days	Duration	Booking
16.02.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
23.02.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
02.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
09.03.2026	10:00 – 16:00	Mon - Fri	5 Days	Book Now
16.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
23.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
30.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
13.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
20.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
27.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
11.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
18.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
25.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
01.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
08.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
15.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
22.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
29.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
06.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
13.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
20.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
27.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
03.08.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now

Syllabus

SAP Introduction

SAP Data warehousing

• Introduction to Data warehousing
• Fundamentals of Data warehouse
• Definition of Data Warehousing
• Key functions of Data Warehousing
• Applications & Types of SAP
• Difference between OLTP vs OLAP
• Types of Data in SAP
• Multi-Dimensional Modelling
• Star Schema and Extended Star Schema

SAP BW/BI Introduction

• Introduction to SAP BW/BI
• History of SAP BW/BI
• Necessity of SAP BW/BI

SAP BW/BI Architecture

• Source System & Target System
• Source system connections
• Data Modelling, Extraction & Loading
• Data Reporting

SAP BW Data Modelling

• Data Warehousing Workbench
• Info Objects & Types of Info Objects
• Info Area4. Info Object Catalog
• Application Component6. Activation of Business Content
• Master data & Transaction data
• Data Source, Info Source
• Data transfer methods for SAP Systems (PSA and IDOC)
• Info cube
• DSO/ODS
• Info Set
• Info Provider
• Multi Provider
• Transformation
• Route
• DTP
• Info Package
• Open Hub Destination
• Transfer Rules
• Update Rules
• Authorisations
• Roles

SAP BW Data Extraction

• Application-Specific Extractors (BW Content Extractors & Customer Generated Extractors)
• Cross Application-Specific Extractors ( Generic Extractors)
• LIS Extraction
• LO Extraction
• COPA Extraction
• Data Extraction using other tools
• BW Data Source Enhancement
• SAP BW Data Loading & Scheduling
• Introduction to Process Chains
• Process Chains in SAP BW/BI
•Types of Views in Process Chains
• Process Chain Creation
• Process Chain Monitoring

BW Data Reporting

• Bex Query Designer
• Bex Analyzer
• Bex WAD
• Restricted & Calculated Key figure
• Filters
• Rows & Columns
• Free & Filter Characteristics
• Types of Variables
• Conditions & Exceptions

SAP BW Real-Time/Project Scenarios

• Production Support Issues
• Implementation Project Issues
• Migration/Up-gradation Project Issues
• Tickets Handling
• Batch Jobs Monitoring
• Ticketing Tool Tracker
• SAP BW Clients & Projects Discussions
• Importance of SAP BW Projects in Market
• Type of Domain Industries & Clients using SAP BW/BI

SAP BW Data Transportation

• System Landscape
• Transportation Landscape
• Overview of Transports
• Objects Collection in Transports
• Sequence of Transports Migration
• Transports Collection & Setting
• Transport Issues

SAP BW Performance Tuning Techniques

• Aggregates
• Partitioning
• Compressions
• PSA Tabe Deletions
• BI Accelerators

SAP Knowledge Sharing Sessions

• SAP OSS Notes
• SAP Marketplace
• SAP Developer Forum
• SAP Issues Forum

Target Audience

Obtaining any SAP certification is a boost for your career success and a valuable credential in any competitive career market.

If you are,

a Business Objects Professional, business analyst, business owner, Project Manager or Data Warehousing professional who wants to improve your SAP skills,
a company who wants to use SAP products to streamline your business processes,
a novice looking to add a highly recognised credential to your professional skills,

SAP training with SAP Training London is for you!

Why Choose Us

Our instructors are highly skilled with industry experience of  many  years, working in best and renowned organization. Our Trainers follow an approach to engage students during instruction and thus the training methods are modified as per the trainees needs which may include direct 1-1 discussions, group discussions, Q&A rounds etc.  Also you get many more advantages along with highly professional approach.

Flexible course timing to suit you
Offer highly competitive course prices
You will get Certificate of completion at the end of course
We are centrally located and have good access from all corners of London.
We offer  Hands on training with lab access
Small group training approach is followed, up to 5

Book Now

Starting Date	Timing	Days	Duration	Booking
16.02.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
23.02.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
02.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
09.03.2026	10:00 – 16:00	Mon - Fri	5 Days	Book Now
16.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
23.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
30.03.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
13.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
20.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
27.04.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
11.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
18.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
25.05.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
01.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
08.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
15.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
22.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
29.06.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
06.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
13.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
20.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
27.07.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now
03.08.2026	09:00 – 17:00	Mon - Fri	5 Days	Book Now