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 | ||
Abhishek Anand
its been great
Rajagopal Devarajan
Overall, the Training is very good and It really helped me in understanding the concepts in depth. Thanks
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
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.
Vijay Hejmadi
In detail explanation about DTP
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.
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.
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.
Pawel Grabiec
Great course, lots of practical knowledge!
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
Mahmoud Osman
Good hand-on exercise. Should have spent more time on the high level of BW and its components.
Syed Azaharuddin
Excellent Course. Delighted to subscribe to this course.
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.
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
Danny Michaels
Great for starting out in SAP BW.
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 .
Regards
Srinivas
Werner Wessels
Very well explained. Looking forward to more projects.
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.
Kokila varun kumar
I have taken many training, this one of the best. Trainer makes us to understand every step with explanation.
Mohamed Isse
The instructions were very clear and the instructor gave step by step walk-through of the necessary steps to setup the system.
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.
Atif Ghaffar
Hi
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
Atif
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.
Matheus Rangel Cardoso
It is helping me learn and practice the skills for my current job. Actually I’m an IT Trainee, which means I’m still learning how to use SAP BW system. This course is definitely going to help me speed up my learning process.
Thoudoju Prasad
Good one for the beginners to start with.
Naganarahari Chand Budigi
Has everything that I need to complete the course. Will recommend this to all
Chaabane Seifeddine
Structured course and very informative. thanks !
Tafadzwa Chirwa
The course content was on point. The delivery championed the call for clarity and completeness.
Haryono Samad
Very informative
Avinash Choudhary
This is a detailed course which helped me understand step by step process. Previous experience of Data warehousing helped me understand quickly. Instructor is very good to explain the importance of steps. His speed of teaching is very good.
Syed Muhammad Ifrahim Ur Rehman
Able to get enough for DA and BW using SAP for hands on training.
Siddhant Rath
Yes it was a good match to understand basic concepts for BI/BW 7.4
Manishkumar Shukla
Amazing
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.