SAP BW/4HANA Modeling Training




Per Participant

Course Description

Users with some BW/4HANA experience or users who have taken BW410 and are familiar with the BW/4HANA terminologies and fundamental data warehousing tasks should enroll in this course. They get knowledge of how to create BW/4HANA data models based on the LSA++ model of layered, scalable architecture and employing modelling elements from SAP BW/4HANA and SAP HANA. The following topics will be covered in-depth: master data (specifically time-dependency and hierarchies), various advanced DataStore object types, open ODS views, currency and unit conversion, staging scenarios with InfoSources, various composite provider scenarios, and hybrid models with SAP HANA Calculation views.

Prerequisites for this training


  • Hands-on experience in data warehousing with SAP BW/4HANA
  • BW410 (SAP BW Enterprise Data Warehousing with SAP BW/4HANA)
  • Recommended

  • HA100 (SAP HANA Introduction)

  • Note

  • With references to extra documentation and information sources, this course gives you a very solid foundation in BW/4HANA modeling concepts.
  • The emphasis of this course is on the presentation of ideas and a range of practical exercises, some of which are based on case studies. Out of the more than 30 available exercises, the trainer will select 20 to 30 that are appropriate.

Who should attend this course?

  • Application Consultant
  • Business Analyst
  • Solution Architect
  • System Architect
  • Technology Consultant


  • Virtual Live Training

Oct 09, 2023

9:30 am - 5:30 pm EST
  • Virtual Live Training

Nov 13, 2023

9:00 am - 5:00 pm EST
Request Batch

What you will learn

  • Describing general benefits of SAP BW/4HANA's new "In-Memory" database foundation.
  • Recognizing modelling needs and contrasting modelling methods
  • Talking about best practises standards like LSA++ and separating master and transactional data
  • Describing the stages involved in creating a data model for SAP BW/4HANA.
  • SAP Business Content Application.
  • Utilising the modelling artefacts in SAP BW/4HANA.
  • Making use of the benefits of field-based modelling.
  • Using native SAP HANA XSA Calculation Views or SAP BW/4HANA InfoObjects, hierarchies can be created and used.
  • Integrating transactional data from many sources.
  • Using native SAP HANA XSA Calculation Views or SAP BW/4HANA to implement Currency and Unit Conversion.
  • Data Tiering Optimization is used
  • XSA-based "Mixed Scenarios" interpretation and creation of external SAP HANA views.
  • Making use of the SAP HANA Analysis Process.
  • Describing scenarios for inventory management and stock coverage


  • SAP HANA modeling
  • SAP BW/4HANA modeling
  • Mixed strategies
  • Understanding Object Changeability
  • Separating Master Data and Transactional Data
  • Using Time-Dependent Master Data, Tracking History
  • Harmonizing Data
  • Designing a BW/4HANA Layered Scalable Architecture (LSA++)
  • Understanding Physical and Logical Partitioning
  • Defining the Sequence and Phases of SAP BW Projects
  • Developing an SAP BW/4HANA Data Model
  • Working with SAP Business Content
  • Introducing ABAP CDS Views provided by SAP BW/4HANA
  • Implementing Field-Based Modeling with Open ODS Views
  • Understanding Snapshot and Corporate Memory Models
  • Modeling and Implementing SAP BW/4HANA Master Data
  • Modeling and Implementing Advanced DataStore Objects (ADSOs)
  • Modeling and Implementing InfoSources and Transformations
  • Modeling and Implementing Composite Providers
  • Describing Multi-Temperature Data Management
  • Introducing SAP BW/4HANA Data Tiering Optimization (DTO)
  • Modeling Master Data and Transactional Data in SAP HANA Views
  • Generating External SAP HANA Views for SAP BW/4HANA Objects
  • Implementing Mixed Scenarios
  • Introducing the HANA Analysis Process (HAP)
  • Defining Inventory ScenariosSAP BW/4HANA Modeling
  • With Microtek Learning, you’ll receive:

    • Certified Instructor-led training
    • Industry Best Trainers
    • Official Training Course Student Handbook
    • Pre and Post assessments/evaluations
    • Collaboration with classmates (not available for a self-paced course)
    • Real-world knowledge activities and scenarios
    • Exam scheduling support*
    • Learn and earn program*
    • Practice Tests
    • Knowledge acquisition and exam-oriented
    • Interactive online course.
    • Support from an approved expert
    • For Government and Private pricing*

    * For more details call: +1-800-961-0337 or Email:

    Request Call

    Our Clients

    For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards
    why choose us
    Accredited By

    Course Details

    • Start Date: Oct 09, 2023
    • Duration: 5 Days
    • Certification: Yes
    • Enrolled: 2718
    • Price: $3999
    • Training Code: BW430
    side post side mode

    Talk to Learning Advisor