SAP BW Training

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.

669 STUDENTS ENROLLED
Included in the Gold & Silver Training Packages

Course Description

Download Course Fact Sheet (Scroll Down for the full Curriculum and video demos)

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

4.8

4.8
50 ratings
  • 5 stars41
  • 4 stars7
  • 3 stars2
  • 2 stars0
  • 1 stars0
  1. KRITHIKA DYAVEGOWDA

    5

    I was impressed with the presentation

  2. LUIS ADDERLIN LOPEZ MONTES

    5

    me parece un exelente curso 😀

  3. ENG. ALEX COTOARA

    5

    This course is very good. Has theory and examples and is well structured. Rob should price this kind of information accordingly, right now it is under priced for the amount of effort he put into it. Great job !

  4. Simon Taylor

    5

    I am getting a good understanding!

  5. OKE OWHEYA

    4

    Instructor demonstrates deep understanding of the subject matter area. Well paced, illustrated and a very good logical development of the material. Excellent Job!

  6. DIMITRIOS APOSTOLOPOULOS

    5

    Interesting course, a good introduction in the BW environment… The lecturer seems to be really confident and he knows what he is talking about… Looking forward for the following sections!

  7. MICHAL

    5

    Really good course. Beginning is rather too complex for beginners, but great to review knowledge if you already have been working with SAP BW. Later on course start to be beginners with two really good hands on tasks.

  8. JERRY MENSON

    5

    instructor speaks clearly and goes step by step

  9. MUKESH KUMAR LOHANA

    4

    Nice overview of all necessary modeling objects in BW. All the Demo exercises are based on the file source system. It would be nice to see in future few more Demo exercises or projects using other types of source data (like from other ECC system). Thanks for giving a good introduction of BW. I highly recommend the course to anyone who is interested to build some competency in BW.

  10. PADMA LANKA

    5

    Everything is explained systematically and Rob is always available to answer any questions or if I get stuck at any step. Thank you very much

  11. ANTHONY JOHNSON

    5

    Very detailed

  12. AFURAYI

    5

    The instructor is clear and shows a lot of necessary experience

  13. Olufunmilayo Eddo

    3

    Narrative is too advanced for a beginner

  14. RUSHANE FERNANDO

    5

    Well Explained.

  15. LETSTEST SW

    5

    Awesome beginner course for SAP BW

  16. SURESHMANDIA

    5

    very descriptive and clear.

  17. RAFAEL ARÉVALO

    5

    The course is good, because it has practical cases that help to strengthen the knowledge. But you need basic prior knowledge of SAP BI to understand better the course and it would be good to have a SAP access for practical purposes.

  18. SIMPHIWE NCAYIYANA

    5

    very helpful,in depth & practical training

  19. ANXIOUS ZHOU

    5

    It was a good course for me as a beginner for SAP BW. The facilitator is clear and knowledgeable on the subject matter.

  20. KEVIN KOO

    5

    Great Course INstructor is clear and knowledgeable

  21. YOUNUS KHAN

    4

    This is small project based, expedite pace training that enhanced your basic knowledge to intermediate level. Nice to watch

  22. ETINOSA GARY ODIGIE

    5

    Good instruction, very good audio, very good step by step method of training and deep insight of SAP BW. A very good and recommended training video.

  23. ABHISHEK GUPTA

    5

    Very Nice presentation

  24. PRASANTTHII

    3

    I feel the tutor is not giving lecture in detail.

  25. SHAWN K

    5

    Very clear and easy to follow the trainer and the topics are covered in detail…

  26. JEFF LEE

    5

    Well-crafted course which ran through at a comfortable pace!

  27. ROBERT MAJEWSKI

    5

    That course is very well prepared wit step by step explanations

  28. FAWAD

    5

    Very well explained and easy to understand. Instructor is very knowledgeable about the topics and always prompt response to any question that you may have.

  29. ADEDAMOLA HAASTRUP

    5

    I LOVE THIS INSTRUCTOR. I WILL BE WILLING TO TAKE YOU FURTHER

  30. MANJUNATH H K

    4

    Yes, Material is good and i was able to learn from Scratch.

  31. YANIEZHANG

    5

    Very structured training, easy to understand and follow

  32. NARENGUNNA

    5

    The course is great!

  33. VISHAL ADHVARYU

    5

    The video quality is very good in terms of visibility as well as the instructor has created videos step by step in such a way that it is very easy to understand and absorb all the material and concept of the training.

  34. MEHMET KOCAKOGLU

    5

    Excellent, very valuable course. Thank you Rob.

  35. HARSH JAIN

    4

    Good quality videos and teaching level as well

  36. K K*

    5

    Precise and just what I needed. Crystal clear explanation, and most important for me is learning hands on !

  37. JAGANMOHAN REDDY BADVELI

    5

    Very effective. Thank You

  38. C P

    5

    Excellent work. But please cover hierarchies too.

  39. MIGUEL GÓMEZ

    5

    I have really enjoyed this course: It goes throw all topics with examples, explaining all the possible options and characteristics. The voice and the sound is perfect. The teacher is also very good, the explanations are clear and he always provides examples. I asked some questions during the course and he has answered me in just a few hours. To sum up, I think it is a perfect course to start learning SAP BW.

  40. MIKE BRILLANTE

    5

    Great tutorial videos, step by step and clear presentation.

  41. MARTIN

    5

    Very good. Need to take the course how to install SAP BW before or to have access to one

  42. JOEL P

    5

    For anyone who want to learn SAP and want to expand their knowledge or break into their BW consultant career I strongly recommend this course. Rob Davis writes in his instructor biography he was trained by the best analytics mentors from various consulting firms, Robs experience and customer support reflects exactly that, very helpful, easy to understand also the methaphorical answers makes it easier to fully grasp. They make it understandable, with help from pdf`s and videos they cover all angles, also the site updates continuously. Worth the investment and alot cheaper then SAP´s extremely high prices. Great content and concise explanation. They really go the extra mile. Greatly appreciated

  43. PATRICK DANESHMAND

    5

    The material in this course is comprehensive and easy to follow along. With detailed handouts and videos this course will help you understand all you need to know about SAP BW. If you are looking to get certified in SAP BW, I would recommend enrolling in this course (and the other courses on this site as well). Great content & Exceptional customer service!

  44. IAN R

    5

    A+ customer service. Your customer service skills are second to none. You truly are a professional who delivers. Do you have any recommendations for training on other SAP modules thats as good as yours? I would like to learn more from you.

  45. CHRISTOPHER G

    5

    I’ve already told all of my coworkers to take this training. It seems like I know more about BW from HALF of your training than most know at my current employer. They don’t even want to refresh queries – they just want my department to email or post refreshed data. I’m going to try to teach them as much as possible – sign as many up for your training as possible 😉

  46. SATISH P

    4

    I am really enjoying learning from your tutorials. The content you put together and explanation (narration) you’ve provided is simply excellent. Thank you very much

  47. KUDA H

    5

    Last year I signed up for your BO & BW training courses. This helped me immensely as I was able to pass the BO Certification exam. Thank you!

  48. DAVE R

    5

    Thanks for working with me. Wow, I must say, the training is extremely comprehensive and informative. I can only imagine what kind of time you put in to get this together. Glad I found you.

top
Copyright © 2016 BUSINESS INTELLIGENCE SOLUTIONS LLC (This website is not affiliated with, sponsored by, or approved by SAP AG)