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
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?
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
No Reviews found for this course.
