SAP BI/BW Enterprise Data Warehousing (BW310)

Participants will gain SAP Business Warehouse knowledge necessary for successful project implementation and administration within the SAP NetWeaver BW system landscape. We encourage you to also enroll in the BW305 (BEx Query Design) course which teaches front end BI/BW report development.

Included in the Gold & Silver Training Packages

Course Description

This is a truly a step-by-step course that will take you into the incredible world of SAP BI/BW. Even after the first section of our course, you will understand how to develop with SAP BW!

Learn by doing! Each section of our training comes with a new dataset for you to download and a new set of lessons and exercises that will challenge you to learn in a fun and engaging way.

After our introductory section, every module is independent so you can start from wherever you’d like. The more you learn and practice these skills, the better you will get. Feel free to take your time while you master this valuable set of BI/BW skills.

This class will make you a highly proficient SAP BI/BW Analyst. By the end of this course you will confidently add SAP BI/BW to your CV.

BONUS: This course will be updated with brand new sections as SAP releases new versions of their software in the future. So when you enroll – you enroll for life!

What are the requirements?

  • Basic knowledge of SAP

What am I going to get from this course?

  • Over 40 Video Lectures and 12 hours of content!
  • Introduction to the SAP Business Warehouse
  • Importance of BI Content
  • The impact of SAP HANA on BW
  • Loading ECC data into BW
  • InfoProvider types and uses
  • Understand the BW Transport and Migration Process
  • Important Transaction Codes in BW
  • Create Source Systems and DataSources
  • Navigating the Data Warehousing Workbench (RSA1)
  • Understand OLTP vs OLAP
  • Describing Data Warehouse Architecture
  • Data Modeling in SAP BW
  • Create Key Figure InfoObjects
  • Create Unit InfoObjects
  • Create Characteristic InfoObjects
  • Create InfoObject Catalogs
  • Create InfoAreas
  • Create DataStore Objects (DSOs)
  • Create InfoCubes
  • Learn SAP BW Table Structures
  • Fact tables
  • Dimension tables
  • Line-Item Dimensions
  • SID tables
  • Understand how Master data is shared
  • DSO tables (active, new data, change log)
  • PSA tables
  • Load Master Data into BW
  • Load Transactional Data into BW (DSO and Cube)
  • Describe the Extended Star Schema of an InfoCube
  • DSO activation
  • Transform your data
  • Assign an InfoObject to be an InfoProvider
  • Modeling a Master Data Flow
  • Learn various Data Flows
  • Create InfoPackages and Data Transfer Processes (DTP)
  • Learn to Optimize Query Performance (Transaction RSRT)
  • Monitor BW System Performance (SM37 / SM51 / SM66)
  • Understand Aggregates
  • Learn about the Business Warehouse Accelerator (BWA)
  • In-memory data acceleration
  • BW Administration and Monitoring
  • Explore the differences between Delta and Full DTP loads
  • Create Process Chains
  • Managing your InfoCubes and DataStore Objects
  • Administrative Tasks and Tools

What is the target audience?

  • You should take this course if want to learn SAP BI/BW completely from scratch
  • You should take this course if you know some SAP BI/BW skills but want to get better
  • You should take this course if you are good in SAP BI/BW and want to take your skills to the next level and truly leverage the full potential of BI/BW

Enroll Multiple Users?

Simply add multiple courses to your cart and checkout.  After checking out, send us an email with the email address of each attendee and who is aligned to which course/package

Course Curriculum

Section 1: Introduction to SAP BW
SAP BW Overview – Part 1 of 4 FREE 00:19:00
SAP BW Overview – Part 2 of 4 00:18:00
SAP BW Overview – Part 3 of 4 00:16:00
SAP BW Overview – Part 4 of 4 00:16:00
SAP HANA 00:12:00
Section 2: Documentation and Handouts
BW Functional and Technical Design Documents 00:30:00
BW Mapping Document 00:00:00
Important BW Transactions, Tables, and Programs 01:00:00
Section 3: End to End BW Design and Implementation (Project 1)
Project 1 – Data File Download 00:01:00
Logging on and RSA1 Overview FREE 00:12:00
Creating an InfoArea FREE 00:03:00
InfoObject Catalogs – Characteristic and Key Figure 00:06:00
InfoObject Creation – Characteristics 00:17:00
InfoObject Creation – Key Figures and Unit InfoObjects 00:14:00
DataSource Creation FREE 00:12:00
InfoPackage Creation and PSA Overview 00:09:00
DataStore Object (DSO) Creation 00:09:00
DSO – Transformations and Formulas 00:13:00
DSO – Data Transfer Process (DTP) – Creation and Load Monitoring 00:09:00
DSO Activation and Table Contents Overview 00:05:00
InfoCube Creation 00:09:00
InfoCube – Transform, Load, Monitor, View Data 00:14:00
Load Automation with Process Chains 00:27:00
SAP BW Back End Data Analysis 00:10:00
Edit Data at PSA Level 00:10:00
DTP – Full vs Delta 00:26:00
SAP BW Transport Video Overview and Demo 00:20:00
Section 4: End to End Project Development Exercise - Transactional and Master Data (Project 2)
Project 2 – Introduction and Overview FREE 00:05:00
Project 2 – Data File Download 00:01:00
Creating an InfoArea 00:02:00
Creating InfoObject Catalogs 00:03:00
Creating an InfoObject – Customer 00:14:00
Creating an InfoObject – Material 00:03:00
Creating an InfoObject – Sales Rep 00:11:00
Key Figure Creation and BI Content Activation 00:08:00
Setting up InfoObjects to be Master Data InfoProviders 00:05:00
DataSource Creation for Master Data InfoObjects 00:20:00
Creating and Executing InfoPackages 00:06:00
Master Data – Transformation Layer 00:07:00
Master Data – DTP Execution and Load Verification 00:15:00
Create DataSource and InfoPackage – Sales Transactions 00:13:00
DataStore Object (DSO) – Create, Transform, Load, Activate Data, Verify Data 00:12:00
InfoCube – Create, Transform, Load, Verify Data 00:25:00
Process Chain – Load Master Data 00:26:00
Process Chain – Load Transaction Data 00:10:00
Certification and Interview Prep Material
Certification Reading Material 04:00:00
BI/BW Interview Questions and Answers 01:00:00
BW310 Quiz Unlimited

Course Reviews


108 ratings
  • 5 stars89
  • 4 stars14
  • 3 stars5
  • 2 stars0
  • 1 stars0
  1. Abhishek Anand


    its been great

  2. Rajagopal Devarajan


    Overall, the Training is very good and It really helped me in understanding the concepts in depth. Thanks

  3. Anonymized User


    I find this is very impressive module to learn and the trainer has walkthrough very well. As i have some good knowledge on BW . Nothing was new to me. but for a beginner it must be very learning experience

  4. Rishav Garg


    It was good exercise and course, however it would be awesome if the instructor update the course with the more real world scenarios like process chains scheduling from managed system ERP etc.

  5. Vijay Hejmadi


    In detail explanation about DTP

  6. Shalabh Shrivastava


    I think with some prior practical knowledge, I was able to grasp the concepts and what was going on but a side flowchart would add to the clarity and make it easier for a newcomer to connect the dots. All the Best and thanks for the wonderful course.

  7. Pankaj Bhatt


    The course did really well in explaining SAP BW screens and doing hands on exercises to make it better understandable for someone who has just started working in SAP BW.
    My only suggestion would be to add hand- on exercise with ERP tables as source instead of both projects using just flat files as source.

  8. Ramesh Nagadatta Palla


    Very efficient teaching. Appreciate the effort put in to keep it simple and interesting at the same time. Very useful course for both freshers as well as experienced.

  9. Pawel Grabiec


    Great course, lots of practical knowledge!

  10. Matthias Bertsch


    The course offers a good overview over SAP BW and introduces you to the fundamentals. The final quiz is quite heavy with 45 questions, but not very difficult if you paid attention to the lessons.
    Overall a recommendable course

  11. Mahmoud Osman


    Good hand-on exercise. Should have spent more time on the high level of BW and its components.

  12. Syed Azaharuddin


    Excellent Course. Delighted to subscribe to this course.

  13. Guilibaldo Atkinson


    Good course to help you decipher what you see in BW as well as providing instruction on how to create objects and navigate.

  14. Nishant Khanolkar


    From a course delivery point of view, the instructor and the course material was up to the mark. All the recordings were legible.

    Thanks to Rob

  15. Danny Michaels


    Great for starting out in SAP BW.

  16. Srinivas


    Hi Rob,

    Thank you very much for easily understandable training.

    This was covered with all basics of BW which will be helpful for all of us and if possible please explain all the options available in cubes and info objects so we will be aware of usage of those also.

    I hope if you can add some performance tuning activities.It will be very helpful .


  17. Werner Wessels


    Very well explained. Looking forward to more projects.

  18. Hamza Abdullah


    it is good in general, but some videos too long ,if it is 5 minutes or less will be good for the students and more comfortable.

  19. Kokila varun kumar


    I have taken many training, this one of the best. Trainer makes us to understand every step with explanation.

  20. Mohamed Isse


    The instructions were very clear and the instructor gave step by step walk-through of the necessary steps to setup the system.

  21. K Gulshan Tejaswi


    The way of teaching is very Good. All the chapters are covering different topics and they are told practically instead of some narration from a slide show. Really if somebody wants to learn BW all they need is one BW environment and this course.

  22. Atif Ghaffar



    Everything is amazing for the beginners, If you can include the following tips will be ideal for person like me.

    What SAP Certification Exam to Go for after completion this course
    Exam Name with Helping Material (Book Names)

    Just a little bit more explanation about the job how and who interact with SAP BW person for any task.

    Which tables to extracts for what kind of reporting (Which Fields), Any best practices to or helping material to recognize these tables in real time. Related Sales, MM, etc etc

    If some explanation of full environment of SAP BW JOB can be explained, How to start the task and after finishing the Task like Info provider what you do who takes over the control of that finished task

    Sorry if i am asking a lot but you have done a pretty amazing job!

    Kind Regards

  23. Gnaneshwar Kakde


    For a new person to BW this was an engrossing training. I sat through and completed this in two days. Rob was to the point and delivered the content systematically and coherently. Wish he comes up with a session on reporting tools as well.