SAP BW powered by SAP HANA: Data Warehouse Modeling

  • Tuition USD $4,090
  • Reviews star_rate star_rate star_rate star_rate star_half 1131 Ratings
  • Course Code BW330H-v016
  • Duration 5 days
  • Available Formats Virtual, Classroom

Skills Gained

  • This course will prepare you to:
       -Learn procedures within modeling of SAP Business Warehouse
       -Learn how to create a Layered Scalable Architecture

Who Can Benefit

  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant


  • Essential:
       -Basic knowledge of data modeling
  • Recommended:

Course Details

Course Content

  • Data Modeling with SAP Business Information Warehouse (SAP BW) Powered by SAP HANA
       -Understanding Modeling Targets and Issues
       -Understanding SAP HANA From a Modeling Perspective
       -Understanding SAP BW From a Modeling Perspective
       -Comparing SAP BW with SAP HANA
  • Business Review
       -Understanding the Relevant Skills and Exercises
       -Getting toknow the ITelO Case Study
       -Understanding the ERP Model
  • Global Decision Areas and Best Practice Standards
       -Planning Transport Management
       -Separating Master Data and Transactional Data
       -Tracking History
       -Evaluating Global Standards and Local Adaptations
       -Designing a Layered Scalable Architecture (LSA) with Virtual Layers
       -Understanding LSADomains
       -Understanding Reporting Options
  • Process of Modeling
       -Defining the Sequence of SAP BW Projects
       -Planning the Phases of a SAP BW Project
       -Developing a SAP BW Data Model
       -Getting an Overview SAP HANA Live
       -Overviewing Business Content
  • Field-Based Rapid Prototyping
       -Implementing Field-Based Modeling
  • Master Data Modeling with SAP BW Characteristics
       -Listing Tables in the SAP BW Data Model
       -Using Reference Characteristics
       -Using Hierarchies in SAP BW Characterisitcs
  • Key Figure Modeling in SAP BW
       -Defining Key Figures as InfoObjects
       -Creating Key figures for Non-Cumulatives
  • Transactional Data Modeling in SAP BW
       -Modeling Advanced DataStore Objects (ADSOs)
       -Implementing Currency Harmonization
       -Implementing Quantity Conversion
       -Modeling Transformations
       -Modeling a Composite Provider for Agile Data Mart Scenarios
  • Master Data Modeling in SAP HANA Views
       -Modeling Master Data and Hierarchies in SAP HANA Views
  • Transaction Data Modeling with SAP HANA
       -Modeling Transactional Data in SAP HANA Views
  • Hybrid Modeling in Mixed Scenarios
       -Modeling Mixed Scenarios
       -Enhancing Views in SAP HANA
  • Enhanced Scenarios in SAP BW
       -Modeling an SAP BW Workspace
       -Implementing HANA Analysis Processes
  • Existing Model Enhancement
       -Using the SAP BW Remodeling Toolbox
       -Converting Silos or LSAs to LSA


  • This course contains only an overview over the Layered Scalable Architecture++ with SAP HANA, with some example LSA++ and SAP HANA modeling exercises. It is no substitute for a project consulting.
  • This course does not discuss operational solutions or specific technical company scenarios.
  • Courseware available as flipbook in Learning Hub

Course based on software release

  • SAP BW 7.5 powered by SAP HANA
  • BW Modeling Tool
  • BO Enterprise Server

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

This was my first course through ExitCertified. From my initial browsing of their website for courses, assistance getting the course procured for my agency, and finally the course experience itself, I couldn't be more pleased.

J’aime cet environnement, je vois qu’on peut faire beaux de chose la dessus. J’aime ce genre de projet ou environnement bien fait.

I was really happy with the overall experience of attending a remote course through ExitCeritfied.

I really enjoyed the course. It was well designed given that it was online. I would recommend that the higher level courses be taken on-site, but this course was very thorough for those looking to get started with an AWS Certification.

Excellent facilities, excellent staff.. and the coffee is good too! Thanks for helping to advance my career and the career of my colleagues!

1 options available

  • Nov 16, 2020 Nov 20, 2020 (5 days)
    Location Details
    9:30 5:30 EST
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward