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.

648 STUDENTS ENROLLED
  • Profile photo of abdullah
  • Profile photo of Kalyanr
  • Profile photo of shilpa.banerjee15
  • Profile photo of rooseveltgtoe@icloud.com
  • Profile photo of David Rivera
  • Profile photo of AYODEJI MESHE
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 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 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 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

50 ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

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