• Overview of SAP BI and BW
• Data warehousing concepts
• SAP BW architecture
• OLAP vs OLTP systems
• Data flow in BW
• Reporting landscape overview
• Characteristics and key figures
• InfoProviders overview
• DataStore Objects (DSO)
• InfoCubes configuration
• CompositeProviders basics
• Extracting data from SAP systems
• Generic extraction methods
• Delta handling concepts
• Data replication process
• Monitoring data loads
• Data Transfer Process (DTP)
• Data cleansing techniques
• Error handling in DTP
• Data activation process
• Performance optimization basics
• Scheduling data loads
• Monitoring process execution
• Error handling in process chains
• Restarting failed loads
• Automation of data workflows
• Creating queries
• Using filters and variables
• Calculated and restricted key figures
• Query execution
• BEx Analyzer basics
• Creating advanced queries
• Exception and condition handling
• Hierarchy usage in reports
• Drill-down techniques
• Performance tuning in queries
• Ad-hoc reporting
• HANA modeling concepts
• HANA optimized objects
• Real-time data reporting
• Performance enhancement techniques
• In-memory processing advantages
• Open Hub services
• Flat file integration
• Database connectivity
• API-based data extraction
• Data validation techniques
• BW system administration basics
• User management
• Authorization concepts
• System performance monitoring
• Data consistency checks
• Transport management







