Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreSAP BW 7.4 ZERO TO HERO - MODELING
SAP BW 7.4 ZERO TO HERO - MODELING
LEARN SAP BW MODELING FROM THE SCRATCH
Highest Rated
Created byKiran Kumar
Last updated 3/2017
English
What you'll 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
Explore related topics
Course content
2 sections • 55 lectures • 10h 46m total length
- Introduction to SAP BW6:55
Introduction of SAP BW, Terminology of SAP, BW version information
- What is ERP?8:53
In this class you are going to learn what is an ERP?
- What is the Data?7: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?
- What is the Business Intelligence?8: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.
- Difference between OLTP vs OLAP3: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.
- What is Data Warehouse?2:01
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 an ETL?2: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.
- Layers of SAP BW8: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.
- What is SAP BW?1:40
In this class you are going to learn what is SAP BW, Feactures and Advantages.
- Why SAP BW?2:51
In this class you are going to learn why we need to use SAP BW as Data Warehousing system in your organization
- Architecture Overview of SAP BW6:09
This Class explains about Architecture over of SAP BW, what are the components are available in BW Server
- Data Marting and Data Mining3:27
This class explains about What is Data Marting and Mining? and the difference between Data Marting and Data Mining.
- Data Warehousing Work Bench (DWW) Walkthrough16: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
- What is the Source System3:24
Learn how to identify the source system—where data is created and stored—and how BW connects to various sources, including flat files, ERP, and CRM.
- How to Create Flat File Source System(Demo)3:55
- Demo 1 : Creation of InfoArea and InfoObject Catalog?20:46
This class explains about, what is an InfoArea? purpose of creation? how can we organize InfoObject Catalogs by creating or using InfoArea.
- What is an InfoObject?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 Access0:20
- Demo 2 : Creation of InfoObject16:20
Step by Step explanation how to create InfoObject
- Student Activity : Create Characteristic InfoObjects0:02
- Demo 3 : Master Data Loading Manually in BW - Part 116: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.
- Demo 3 : Master Data Loading Manually in BW - Part 28:54
After loading Master Data Attributes manually this video shows how to create a simple BEX Query
- Copying InfoObjects from One Catalog to Another9: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.
- Master Data Attributes Loading from Flat File (Excel)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.
- Master Data Text loading from Flat File12: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.
- Master Data Hierarchies loading from Flat File23: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.
- How to check the data in PSA and other Master Data Tables8: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
- Key Figure Part 120: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 21: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?
- What is an InfoCube16: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.
- Star Schema and Extended Star Schema7: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.
- Transaction Data Loading to Std. InfoCube with Fixed Units and Currencies24: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.
- Transaction Data Loading to Std. InfoCube with Variable Units and Currencies20:27
This Video Explains about how to Load Transaction Data with Variable Units and Currencies into Standard InfoCube from Flat File.
- Process Chains4:30
Process Chains helps to automate most common Data loading and monitoring tasks in SAP BW this video helps to understand about process chains.
- Transaction Data Loading by using Process Chains Part 120: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 217:19
This video explains how to automate transaction data loading from Flat files in to standard Infocube by using Process Chains.
- Managing InfoCube and PSA (Deleting and Reloading the data)4: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.
- Virtual InfoProvider/Remote InfoCube with DTP Direct Access19:39
This video explains Virtual Provider or Remote InfoCube with DTP Direct Access
- How to Test DTP Direct Access3: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.
- Error Stack DTP16: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.
- How to Allow/Loading Special Characters into BW5:03
This video explains how to set up BW to allow data loading with special characters.
- Data Store Object (DSO)12:05
Data Store Object, another data target for transaction data. This video explain about DSO and types of DSOs.
- Transaction Data Loding into Standard DSO20:27
This video explains Transaction Data loading from Flat File into Standard DSO
- Overwrite functionality of DSO9:16
This video explains the difference between InfoCube and DSO and DSO overwrite functionality.
- APD & Direct Update DSO20: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?
- Transaction Data Loading into Write-optimized DSO13:53
This video explains Transaction Data Loading from Flat File into Write Optimized DSO
- Delta Loading with Non-SAP Data Part 120:55
How to load newly created records or modified records after full load.
- Delta Loading with Non-SAP Data Part 215:38
How to load newly created records or modified records after full load.
- Data Extraction from Single Source into Multiple Targets - Part 121: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 219: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 316: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.
- InfoCube Performance Tuning - Compression4:22
What is Compression? Why we need to compress the InfoCube? What are benefits to Compress the Cube.
- InfoCube Compression - Demo12:27
What is Compression? Why we need to compress the InfoCube? What are benefits to Compress the Cube.
- InfoCube Performance Tuning - Re-Partitioning1:48
- InfoCube Re-Partitioning - Demo26:58
- Quiz for Data Modeling
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.
- Anyone can take this course with basic computer knowledge
- Learn SAP BW Modeling step by step from the scratch
- Step by step instructions with hands-on lab videos
- 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 this course is for:
- Anyone Who Wants to Learn SAP BW
- Looking for Changing Career in SAP BW
- Preparing SAP BW Certification Exam
- This is not Administration Course