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.
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?
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 | ||
SYED RIZVI
So Far So good
KRITHIKA DYAVEGOWDA
I was impressed with the presentation
LUIS ADDERLIN LOPEZ MONTES
me parece un exelente curso 😀
ENG. ALEX COTOARA
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 !
Simon Taylor
I am getting a good understanding!
OKE OWHEYA
Instructor demonstrates deep understanding of the subject matter area. Well paced, illustrated and a very good logical development of the material. Excellent Job!
DIMITRIOS APOSTOLOPOULOS
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!
MICHAL
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.
JERRY MENSON
instructor speaks clearly and goes step by step
MUKESH KUMAR LOHANA
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.
PADMA LANKA
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
ANTHONY JOHNSON
Very detailed
AFURAYI
The instructor is clear and shows a lot of necessary experience
Olufunmilayo Eddo
Narrative is too advanced for a beginner
RUSHANE FERNANDO
Well Explained.
LETSTEST SW
Awesome beginner course for SAP BW
SURESHMANDIA
very descriptive and clear.
RAFAEL ARÉVALO
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.
SIMPHIWE NCAYIYANA
very helpful,in depth & practical training
ANXIOUS ZHOU
It was a good course for me as a beginner for SAP BW. The facilitator is clear and knowledgeable on the subject matter.
KEVIN KOO
Great Course INstructor is clear and knowledgeable
YOUNUS KHAN
This is small project based, expedite pace training that enhanced your basic knowledge to intermediate level. Nice to watch
ETINOSA GARY ODIGIE
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.
ABHISHEK GUPTA
Very Nice presentation
PRASANTTHII
I feel the tutor is not giving lecture in detail.
SHAWN K
Very clear and easy to follow the trainer and the topics are covered in detail…
JEFF LEE
Well-crafted course which ran through at a comfortable pace!
ROBERT MAJEWSKI
That course is very well prepared wit step by step explanations
KARTHIK
Perfect Course!
FAWAD
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.
ADEDAMOLA HAASTRUP
I LOVE THIS INSTRUCTOR. I WILL BE WILLING TO TAKE YOU FURTHER
MANJUNATH H K
Yes, Material is good and i was able to learn from Scratch.
YANIEZHANG
Very structured training, easy to understand and follow
NARENGUNNA
The course is great!
VISHAL ADHVARYU
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.
MEHMET KOCAKOGLU
Excellent, very valuable course. Thank you Rob.
HARSH JAIN
Good quality videos and teaching level as well
K K*
Precise and just what I needed. Crystal clear explanation, and most important for me is learning hands on !
JAGANMOHAN REDDY BADVELI
Very effective. Thank You
C P
Excellent work. But please cover hierarchies too.
MIGUEL GÓMEZ
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.
MIKE BRILLANTE
Great tutorial videos, step by step and clear presentation.
MARTIN
Very good. Need to take the course how to install SAP BW before or to have access to one
JOEL P
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
PATRICK DANESHMAND
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!
IAN R
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.
CHRISTOPHER G
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 😉
SATISH P
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
KUDA H
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!
DAVE R
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.
MICHAEL THAI
Overall a great course! Very well structured, with clear explanations and demos to grasp the key concepts of. One suggestion would be to include some additional section about other Infoobjects such as multiprovider, infosets etc… as well as more advanced scenarios of multiple datasources consolidated into the same DSO. Anyway great job!
GILSON FONTES
Gostei bastante do metodo aplicado, gostaria de ter legenda no curso, mesmo que em inglês para facilitar o entendimento.
BRYANT JOHNSTON
Awesome course. Information is covered in great detail, but is still easy to follow along.
NSIKAN UMANA
He explained everything perfectly
PAUL DON
Explanatory course, but for a complete beginner, the Speaker uses some terms that are still not clear. But it is just part of a normal learning process. Maybe first course could have been on a more General Basis, explaining high Level concepts. But I would still give a good Rating.
KUMAR KUMAR
Good Intro
LUIS EDUARDO POLANIA
It’s Excellent
JIGHGIGH GBERBO
I really enjoyed this course and Rob`s style of teaching. He doesn’t cut corners in the hands-on exercises and they helped me to be familiar with the GUI and how it all works and hangs together. Most importantly, this is much better than I expected from online training and I will be taking more courses. (I just wish Rob was teaching other modules too). Great job. I have already following his fb page!
MOHAN KUMAR
Really love the step by step detailed course. Thanks to instructor for such great course taught with such ease.
ANUSUYA BABURAJENDRAN
Its very good course for Beginners
DETLEF WARDA
No error so far!
STOYANPEEV
Great course!
ANTHONY JOHNSON
Very detailed
WILLEM EWOUD MODDERMAN
Excellent training stuff
CYRIL DEKOYA
The configuration steps ,the logic and pitfalls were well high-lighted. The explanations were easy to follow;not too fast and not boring either. Good stuff. The tutorial is a real value for money,I will recommend the package as a good material for reference.
KRANTHI
Wow..wish i came across this training module a bit earlier. The training would be very useful to a beginner for a step-by-step understating of BW concepts.
MARCELO ANTONIO THOMAZELLI
Excellent word pass!
RAVIVARMA YALAGON
Good Explanations
BRETT SPELMAN
Good coverage, easy to follow, well-paced and appropriate length – with good explanations and examples.
IMRAN KHAN
I enjoyed the course and learned a lot from it.
ABDIRAHMAN
Very clear and easy to follow
SUJEETH ETAKOTA
Just as what is expected out of it
MANJUNATH
The best training video that I have seen. Awesome Rob!
MAREK TOMAN
Very good course for beginners. I’ve managed to understand everything presented within course. Definitely recommending to everyone looking for insights. Recommend also enrolling in included SAP installation guide to follow up instructor’s steps.
AVINASH PRATAP SINGH
As I am new to BW, I found this video more technical than I expected.