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