★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Aarti SharmaSenior Project Manager · TCS
— The journey
Course Outline
What the programme covers, module by module.
Module 1: Introduction to SAP BW/4HANA
- SAP BW/4HANA overview
- Enterprise data warehousing
- Business intelligence
- Analytics concepts
- SAP data ecosystem
- Common use cases
Module 2: SAP BW/4HANA Architecture
- Architecture overview
- Application layer
- Database layer
- SAP HANA integration
- Data flow
- Analytics architecture
Module 3: SAP HANA Fundamentals
- SAP HANA overview
- In-memory computing
- Column storage
- Data processing
- HANA architecture
- Analytics capabilities
Module 4: BW/4HANA Modelling Concepts
- Data modelling
- Layered architecture
- Data flows
- Persistent data
- Virtualisation
- Modelling strategy
Module 5: InfoObjects
- Characteristics
- Key figures
- Attributes
- Master data
- Texts
- Hierarchies
Module 6: Advanced DataStore Objects
- ADSO concepts
- ADSO types
- Data tables
- Activation
- Reporting
- Data management
Module 7: CompositeProviders
- CompositeProvider concepts
- Joining data
- Union operations
- Provider scenarios
- Field mapping
- Virtual data models
Module 8: Open ODS Views
- Open ODS concepts
- External data
- Source connections
- Field properties
- Data integration
- Reporting scenarios
Module 9: Data Acquisition Fundamentals
- Source systems
- DataSources
- Data extraction
- Replication
- Data loading
- Acquisition architecture
Module 10: SAP Source System Integration
- SAP source systems
- Operational data
- Extractors
- DataSources
- Replication
- Data transfer
Module 11: Non-SAP Data Integration
- External sources
- Flat files
- Database sources
- Data connectivity
- Data import
- Integration scenarios
Module 12: Transformations
- Transformation concepts
- Field mapping
- Rules
- Calculations
- Lookups
- Data conversion
Module 13: Data Transfer Processes
- DTP concepts
- Data transfer
- Filters
- Extraction modes
- Error handling
- DTP monitoring
Module 14: Data Flow Design
- Data flow architecture
- Source-to-target mapping
- Staging
- Transformation
- Data propagation
- Flow management
Module 15: Process Chains
- Process chain concepts
- Process variants
- Scheduling
- Dependencies
- Monitoring
- Error handling
Module 16: Delta Management
- Delta concepts
- Full loads
- Delta loads
- Change records
- Data synchronisation
- Load strategies
Module 17: Master Data Management
- Master data
- Attributes
- Texts
- Hierarchies
- Data loading
- Master data maintenance
Module 18: BW Query Fundamentals
- Query concepts
- Query Designer
- Characteristics
- Key figures
- Filters
- Query structures
Module 19: Advanced Query Design
- Restricted key figures
- Calculated key figures
- Variables
- Conditions
- Exceptions
- Hierarchies
Module 20: Reporting & Analytics
- Analytical reporting
- Query execution
- Business metrics
- Drill-down analysis
- Data visualisation
- Report consumption
Module 21: SAP Analytics Cloud Integration
- SAP Analytics Cloud concepts
- BW connectivity
- Live connections
- Data consumption
- Dashboards
- Analytical scenarios
Module 22: HANA-Optimised Analytics
- Pushdown concepts
- HANA processing
- Calculation concepts
- Query execution
- Data virtualisation
- Performance considerations
Module 23: BW/4HANA Security
- Users
- Roles
- Authorisations
- Analysis authorisations
- Data access
- Security administration
Module 24: Data Lifecycle Management
- Data retention
- Data archiving concepts
- Data temperature
- Historical data
- Storage optimisation
- Lifecycle planning
Module 25: Monitoring Data Loads
- Load monitoring
- DTP monitoring
- Request management
- Process chain monitoring
- Error analysis
- Data validation
Module 26: Performance Optimisation
- Query performance
- Data load performance
- Modelling optimisation
- HANA optimisation
- Runtime analysis
- Performance troubleshooting
Module 27: Administration & Housekeeping
- System administration
- Data management
- Request cleanup
- Process monitoring
- Housekeeping activities
- Operational maintenance
Module 28: Troubleshooting BW/4HANA
- Data load errors
- Transformation issues
- DTP failures
- Query issues
- Process chain errors
- Root cause analysis
Module 29: BW/4HANA Solution Design
- Business requirements
- Data architecture
- Modelling strategy
- Data integration
- Reporting requirements
- Solution optimisation
Module 30: Integrated BW/4HANA Analytics Project
- Source data integration
- ADSO modelling
- Transformation design
- CompositeProvider creation
- Query development
- Reporting and performance analysis
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Who it's for
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
What's included
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device