SAP BW 7.4 ZERO TO HERO - MODELING
4.4 (120 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.
568 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP BW 7.4 ZERO TO HERO - MODELING to your Wishlist.

Add to Wishlist

SAP BW 7.4 ZERO TO HERO - MODELING

LEARN SAP BW MODELING FROM THE SCRATCH
4.4 (120 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.
568 students enrolled
Created by Kiran Kumar
Last updated 3/2017
English
Learn Fest Sale
Current price: $10 Original price: $200 Discount: 95% off
2 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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 Design and Do Modeling in SAP BW
  • Complete and In-Depth knowledge of SAP BW Modeling
  • You can work on SAP BW projects
View Curriculum
Requirements
  • Basic Computer knowledge
  • Remote access to SAP BW System
Description

Learn SAP BW Modeling by KIRAN KUMAR

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

  1. Anyone can take this course with basic computer knowledge
  2. Learn SAP BW Modeling 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

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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse All 55 Lectures 10:46:14
+
Introduction to SAP BW
13 Lectures 01:18:12

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

Preview 06:55

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

What is ERP?
08:53

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?

What is the Data?
07:46

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.

What is the Business Intelligence?
08:00

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.

Difference between OLTP vs OLAP
03:38

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

What is Data Warehouse?
02:01

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.

What is an ETL?
02:06

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.

Layers of SAP BW
08:16

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

What is SAP BW?
01:40

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

Why SAP BW?
02:51

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

Architecture Overview of SAP BW
06:09

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

Data Marting and Data Mining
03:27

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.

Data Warehousing Work Bench (DWW) Walkthrough
16:30

Quiz1
4 questions
+
BW Modeling
42 Lectures 09:28:01

How to Create Flat File Source System(Demo)
03:55

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

Demo 1 : Creation of InfoArea and InfoObject Catalog?
20:46

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.

What is an InfoObject?
14:13

Server Access
00:20

Step by Step explanation how to create InfoObject

Demo 2 : Creation of InfoObject
16:20

Student Activity : Create Characteristic InfoObjects
00:02

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.

Preview 16:26

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

Demo 3 : Master Data Loading Manually in BW - Part 2
08:54

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.

Copying InfoObjects from One Catalog to Another
09:01

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.

Master Data Attributes Loading from Flat File (Excel)
31:19

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.

Master Data Text loading from Flat File
12:41

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.

Master Data Hierarchies loading from Flat File
23:46

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

How to check the data in PSA and other Master Data Tables
08:47

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?

Key Figure Part 1
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?

Key Figure Part 2
01:31

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.

What is an InfoCube
16:36

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.

Star Schema and Extended Star Schema
07:46

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.

Transaction Data Loading to Std. InfoCube with Fixed Units and Currencies
24:33

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

Transaction Data Loading to Std. InfoCube with Variable Units and Currencies
20:27

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

Process Chains
04:30

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

Transaction Data Loading by using Process Chains Part 1
20:11

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

Transaction Data Loading by using Process Chains Part 2
17:19

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.

Managing InfoCube and PSA (Deleting and Reloading the data)
04:36

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

Virtual InfoProvider/Remote InfoCube with DTP Direct Access
19:39

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.

How to Test DTP Direct Access
03:29

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.

Error Stack DTP
16:02

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

How to Allow/Loading Special Characters into BW
05:03

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

Data Store Object (DSO)
12:05

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

Transaction Data Loding into Standard DSO
20:27

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

Overwrite functionality of DSO
09:16

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

APD & Direct Update DSO
20:00

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

Transaction Data Loading into Write-optimized DSO
13:53

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

Delta Loading with Non-SAP Data Part 1
20:55

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

Delta Loading with Non-SAP Data Part 2
15:38

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.

Data Extraction from Single Source into Multiple Targets - Part 1
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.

Data Extraction from Single Source into Multiple Targets - Part 2
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.

Data Extraction from Single Source into Multiple Targets - Part 3
16:22

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

InfoCube Performance Tuning - Compression
04:22

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

InfoCube Compression - Demo
12:27

InfoCube Performance Tuning - Re-Partitioning
01:48

InfoCube Re-Partitioning - Demo
26:58

Quiz for Data Modeling
10 questions
About the Instructor
Kiran Kumar
4.2 Average rating
146 Reviews
810 Students
4 Courses
Sr.SAP BW/HANA/BO Project Manager

Certified Project Manager(ITIL,Prince2 Practitioner, Six Sigma Green Belt, CSM) and 14+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.