SAP BW 7.4 ZERO TO HERO - MODELING

LEARN SAP BW MODELING FROM THE SCRATCH
4.4 (61 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.
293 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 55
  • Length 11 hours
  • Skill Level All Levels
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 11/2015 English

Course Description

Learn SAP BW Modeling + Extraction + BEx Reporting by KIRAN KUMAR

A complete SAP BW comprehensive training for every one who wants to learn SAP BW from the scratch.

  1. Anyone can take this course with computer knowledge
  2. Learn SAP BW step by step from the scratch
  3. Step by step instructions with hands-on lab videos
  4. After completion of this course, you can work on SAP BW Projects
  5. Learn how to use Business Explorer (Bex tools) to create Reports using BW Data
  6. In-depth of BEx tutorials
  7. Learn SAP BW related ABAP programming
  8. Learn How to Extract Data from SAP R/3 Server/ ECC/ ERP
  9. Learn SAP BW LO-COCKPIT Extraction from the scratch
  10. Learn SAP BW CO-PA Extraction from the Scratch.

Finally, Do you have Zero knowledge in SAP BW and wants to Become Master in it. Then, this is right course for you in great plat form UDEMY.

What are the requirements?

  • Start Learning everything about SAP BW from scratch
  • Remote access to SAP BW System

What am I going to get from this course?

  • Become Zero to Hero in SAP BW Modeling from this course
  • Do Modeling, Extraction and Reporting in SAP BW 7.4
  • Hands on experience on BW Modeling tools
  • You can extracting data from Non-SAP Source Systems
  • You can Design and Do Modeling in SAP BW
  • Complete and In-Depth knowledge of SAP BW Modeling
  • You can work on SAP BW projects

What is the target audience?

  • Anyone Who Wants to Learn SAP BW
  • Looking for Changing Career in SAP BW
  • Preparing SAP BW Certification Exam
  • This is not Administration Course

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.

Curriculum

Section 1: Introduction to SAP BW
06:55

Introduction of SAP BW, Terminology of SAP, BW version information

08:53

In this class you are going to learn what is an ERP?

07:46

In this class you are going to learn what is the data? how data is generated in any business, how to stores and where it sotres?

08:00

In this class you are going to learn what is the purpose of Business Intelligence and how it is going to help to any business to take better business decisions.

03:38

In this Class you are going to learn what is the difference between OLTP and OLAP, how the data created in OLTP systems, how it will be extracted to OLAP systems.

02:01

In this class you are going to learn what is the Data Warehousing system, why we call SAP BW is Data Warehousing system.

02:06

In this class you are going to learn what is the ETL tool, what is the purpose of it and why we call SAP BW as an ETL tool.

08:16

This class explains to the how many layers are there in SAP BW and what each layer helping data to move from one stage to another stage.

01:40

In this class you are going to learn what is SAP BW, Feactures and Advantages.

02:51

In this class you are going to learn why we need to use SAP BW as Data Warehousing system in your organization

06:09

This Class explains about Architecture over of SAP BW, what are the components are available in BW Server

03:27

This class explains about What is Data Marting and Mining? and the difference between Data Marting and Data Mining.

16:30

This Class explains you how to log on to SAP BW system and how to navigate in Data Warehousing workbench tool, and explains about SAP BW data warehousing functionality.

Quiz1
4 questions
Section 2: BW Modeling
What is the Source System
Preview
03:24
How to Create Flat File Source System(Demo)
03:55
20:46

This class explains about, what is an InfoArea? purpose of creation? how can we organize InfoObject Catalogs by creating or using InfoArea.

14:13

InfoObjects are build blocks for SAP BW, before loading data into BW we need to create InfoObjects which helps to organize and holds the data. This class explains about What is an InfoObject? types of InfoObject.

Server Access
Article
16:20

Step by Step explanation how to create InfoObject

Student Activity : Create Characteristic InfoObjects
Article
16:26

In this class you are going to learn how to create Master Data attributes and how to load master data attributes manually in SAP BW by using "Maintain Master Data" function.

08:54

After loading Master Data Attributes manually this video shows how to create a simple BEX Query

09:01

Once you create a required InfoObjects under a particular InfoObject Catalog, this video explains how to move or copy those InfoObjects to New or Existing InfoObject Catalog.

31:19

This video explains how to create Master Data attributes? how to activate them? How to load data from Flat File (MS Excel) in to SAP BW.

12:41

This video Explains about what is Master data text? How to create it? How to load Master Data text from Flat File (MS Excel) into Sap BW.

23:46

This Video Explains about, What are the Master Data Hierarchies?How to create them? How to load Hierarchies data from Flat File(MS Excel) into SAP BW.

08:47

Once Master data loaded into SAP BW it will create few tables in back-end database system. This video explains how to check data in PSA tables and other Master Data Tables by using Transaction Code : SE11

20:56

If you want to load Transaction Data into SAP BW, we need to create Key Figure InfoObjects. This Video Explains What is Key Figure InfoObjects?How to Create them?

01:31

If you want to load Transaction Data into SAP BW, we need to create Key Figure InfoObjects. This Video Explains What is Key Figure InfoObjects?How to Create them?

16:36

InfoCube Plays important role in SAP BW, It provides Multi Dimensional modeling capabilities in SAP BW. This Video explains about what is an InfoCube? types of InfoCubes and purpose of creation.

07:46

Infocube provides Multi Dimensional Modeling by using Start Schema and Extended Start Schema. This video explains about Start Schema and Extended Star Schema and differences.

24:33

This is First Class about Transaction Data Loading, we are using Transaction Data with Fixed Units and Fixed Currencies and we are using Standard InfoCube as Data target for Transaction Data. This video explains about how to load Transaction Data from Flat File into Standard InfoCube.

20:27

This Video Explains about how to Load Transaction Data with Variable Units and Currencies into Standard InfoCube from Flat File.

04:30

Process Chains helps to automate most common Data loading and monitoring tasks in SAP BW this video helps to understand about process chains.

20:11

This video explains how to automate transaction data loading from Flat files in to standard Infocube by using Process Chains.

17:19

This video explains how to automate transaction data loading from Flat files in to standard Infocube by using Process Chains.

04:36

If you find any error after data loading into Infocube or if data loading fails, this video explains how to delete data from PSA and InfoCube and reload the data again.

19:39

This video explains Virtual Provider or Remote InfoCube with DTP Direct Access

03:29

After loading the data into Remote Infocube with DTP direct Access, this video helps to test DTP direct access by changing the data in Flat File and checking the data in InfoCube.

16:02

If you load data with errors, you can handle them by configuring DTP as Error Stack. This video explains how to create DTP error stack, how to handle error or how to fix the errors after loading.

05:03

This video explains how to set up BW to allow data loading with special characters.

12:05

Data Store Object, another data target for transaction data. This video explain about DSO and types of DSOs.

20:27

This video explains Transaction Data loading from Flat File into Standard DSO

09:16

This video explains the difference between InfoCube and DSO and DSO overwrite functionality.

20:00

This video explains What is Direct Update DSO? why we need to Use Analysis Process Designer if you want to use Direct Update DSO?

13:53

This video explains Transaction Data Loading from Flat File into Write Optimized DSO

20:55

How to load newly created records or modified records after full load.

15:38

How to load newly created records or modified records after full load.

21:57

In this example we are extracting data from single source system (Flat File), loading data into multiple data targets InfoCube and DSO (Data Store Object), we are using process chains for data loading process.

19:21

In this example we are extracting data from single source system (Flat File), loading data into multiple data targets InfoCube and DSO (Data Store Object), we are using process chains for data loading process.

16:22

In this example we are extracting data from single source system (Flat File), loading data into multiple data targets InfoCube and DSO (Data Store Object), we are using process chains for data loading process.

04:22

What is Compression? Why we need to compress the InfoCube? What are benefits to Compress the Cube.

12:27

What is Compression? Why we need to compress the InfoCube? What are benefits to Compress the Cube.

InfoCube Performance Tuning - Re-Partitioning
01:48
InfoCube Re-Partitioning - Demo
26:58
Quiz for Data Modeling
10 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kiran Kumar, Corporate Trainer (SAP BW, BO, HANA and Lotus Domino)

Certified Project Manager and 13+years experience as Corporate Trainer for SAP BW, BO, SAP HANA, IBM Certified Lotus Notes Professional, IBM Certified Lotus Domino 8.5 Administrator And IBM Independent Instructor.

9+ years experience in conducting training for Corporate and Individuals on all Lotus Notes and SAP Based Products like : SAP BW, SAP BO and SAP HANA IBM Lotus Notes End User IBM Lotus Domino Administration 8.5 IBM Lotus Domino Application 8.5(With Xpages Development) IBM Lotus Same Time Administration IBM Lotus Quickr Administration, SAP BW, SAP BO AND SAP HANA.

Ready to start learning?
Take This Course