SAP BW Data Modeling For Beginners Training 2016 - SAP BW

Learn about different SAP BW modeling concept which will help you to make Flexible and Efficient Data Flow Designs
3.3 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
795 students enrolled
Take This Course
  • Lectures 28
  • Length 7.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2013 English

Course Description

Course Updated On :09th Nov 2016

SAP BW is very Niche Skills and market has lot of demand for BW consultant as this skill provides best business solutions, eventually giving higher Turnovers & Profits but due to scarcity of such skilled manpower companies are bound to pay High Wages provided you must have sound knowledge about it.

So if you're a fresher or your already working with SAP looking to make your career in SAP BW then this is the perfect course for you.

Why Learn SAP BW? As of 2015, the average SAP BI/BW starting salary is over $150,000! SAP BI/BW is a recession proof career as it is not related to IT. Big Data, Reporting. Analytics. Ride the wave with SAP BI/BW. Recommended For Anyone with an interest in SAP BI/BW Anyone interested in learning about data warehousing Anyone that has some knowledge of SAP and wants to get into the BI/BW space Upon Completion You will be able to successfully perform modeling of any given DataFlow in BW Conceptually understand the inner workings of the SAP BW data warehouse Be proficient in back end SAP BW Development Be able to architect and model solutions

After going through my course you'll get a good knowledge of BW

The course have loads of document on the relevant topics which will not find online.

Topics Covered In The Course:



  • Characteristic
  • Key Figure
  • Time
  • Unit
  • Technical


  1. Physical Data Store
    • Real Time
    • Standard

2. Without Physical Data Store And Its Types

Data Store Object

  • Standard
  • Write Optimized
  • Direct update


  • Direct Assign
  • Constant
  • Routine
  • No Transformation etc.


  • Start Routine
  • End Routine

Data Transfer Process(DTP)

  • Standard
  • Direct Access
  • Error
  • RDA


Virtual Provider and Open Hub Destination

A key feature of this course is you can contact the instructor at any and every step of learning this course

The best part about the course topics will be updated as per students requirement provided it should fall in the realms of Modeling

After you have completed this course you will know each and every steps to complete the Modeling in BW and precautions to be taken so as to get a stable system

*****If you are looking to get a BW Remote Access then just drop us a mail at we would try to help you out or in getting discounts as well.****

What are the requirements?

  • SAP BW Remote Access
  • Note Book, Pen, & Sharp Mind

What am I going to get from this course?

  • Gets you a sound understand of modeling which is bottle neck of BW
  • You will be able to understand the backend of Modeling
  • Gives you Full Conceptual Understanding of BW

Who is the target audience?

  • Freshers, Expirenced Professional
  • SAP Consultant with ABAP background looking to upgrade skills
  • Refresh Modeling Concepts

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction To SAP BW.
What is ERP?
What is SAPR/3?
What is BW?
Explained using a real time example.

Section 2: SAP BW Overview
Topics Covered
SAP Data Warehousing Concept
SAP 3 Tier Architecture
Steps To Login A SAP System
Landscape Architecture

Topics Covered
How the data flows?
What are the objects involved in?
Brief discussion on:
Performance Tuning
Section 3: Conceptual Classess
Star Schema
Extended Star schema
6 questions

Quiz on Start Schema Extended Start Schema



Types of DATA

Types of

  • InfoObjects
  • Transformation
  • DTP

Section 4: Introduction to BW's User Interface
How to login into  SAP system?
Description of all the 7 tabs.
Section 5: InfoPorvider : Info Object

Create complete data flow to load master data as a characteristic type InfoProvider.

So over here we are trying to load Master Data Type Attribute


Create complete data flow to load master data as a characteristic type InfoProvider.

So over here we are trying to load Master Data Type Text.

Section 6: InfoPorvider : Info Cube
What is InfoCube? What are Its type?
Loading Data into InfoCube
Section 7: InfoPorvider : DSO
What is DSO, its internal Structure.
DSO Types
Write Optimized
Direct Update
Create a DataFlow for a Standard DSO
Load the transaction data into this DSO
Types of transformation
Direct Assign
Section 8: Transformation In Depth
Transformation Part 1
Transformation Part 2
Transformation Part 3
Transformation Example
7 pages
Section 9: InfoPorvider : MutiProvider & InfoSet

Steps how will you crate a Multiprovider.

Steps how will you crate a Infoset.

SAP Document on MultiProviders and InfoSets
17 pages
When to use them.
Steps how will you crate a Virtual Provider
Steps how will you crate a OHD
Section 10: New Features of BW7.3
Loading Hierarchy From Flat File And ECC
31 pages
Copying DataFlow in BW 7.3(SAP White Paper)
20 pages
Exploring Semantic Partitioning(SAP White Paper)
21 pages
HybridProvider in BW 7.30(SAP White Paper)
13 pages
Section 11: Conclusion


Section 12: Interview Quesions
Interview Quesions
18 pages
Cetification Questions
14 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

COGENT TUTORIALS, Success Lies In Consistency.

COGENT tutorials is a startup training provider It provides excellent teaching in many fields of information technology of which one is SAP.

So we have launched our 1st course of SAP BW on Udemy. And we will be introducing more courses in time to come

Looking at the increasing demand of BW/BI consultant, We have made a tutorials on BW/BI which can be taken by a fresh graduates or by professionals already working in the field of SAP

For any Details you can catch us at: CogentTutorials@gmailDOTcom

Ready to start learning?
Take This Course