• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

BUY THIS COURSE (USD 41 USD 125)
4.2 (130 reviews)
( 573 Students )

 

Learning Path - SAP DW & BI

Deep-dive into all courses combined together under the SAP DW & BI. Learning Path. Acquire key skills and build your career as Data Engineer/Analyst.
( add to cart )
Save 67% Offer ends on 31-Jul-2024
Course Duration: 100 Hours
Preview Learning Path - SAP DW & BI course
  Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Trending
Job-oriented
Cutting-edge
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

 

Learning Path - SAP DW & BI consists of the following courses:

  1. SAP BO (BusinessObjects Business Intelligence)
  2. SAP BW (Business Warehouse)
  3. SAP BW/4HANA
  4. SAP Data Services

SAP Business Intelligence (BI) means analyzing and reporting of data from different heterogeneous data sources. SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration and staging area.

Uplatz's Training will teach you all the key concepts of SAP Business Warehousing and Business Intelligence domains. Through this SAP DW & BW course, you will master data modelling, Data Warehousing, Data Extraction, Business Explorer and Metadata Repository, Multidimensional Modeling, Data Flow in BW, Extraction of data from R/3 system, and more. Also, during our SAP DW & BI online training, you will work on industry-based Real-time projects that will help you to perform all the tasks related to SAP BW and BI. 

Course/Topic 1 - SAP BO - all lectures

  • In this video tutorial, you will get a brief introduction on SAP BO, how it came to be known as SAP BI, what are the different layers in SAP BI, characteristics in Data Warehouse, schema, master data tables and also a detailed explanation on how a student can access and work on the server for practicing his daily SAP system works.

    • 1:35:18
  • In this tutorial, you will learn how you can access the Business Object components in the SAP system through remote desktop. You will also be able to understand a detailed explanation on the different designing components. Lastly, you will get a detailed demonstration on how to work on the different design tools in the SAP system.

    • 57:33
  • In this lecture, you will be able to understand what a Designer is in the SAP BO module and how to work with the different designing tools available in the SAP system. You will also learn what is a Universe, Role of a Universe and the Semantic Layer in the initial screen of the designing tool.

    • 2:05:35
  • In this tutorial, you will learn how to create a Universe in the designing tool of the BO module, manually. This is explained in a detailed demonstration by the Instructor which will help you in getting a practical experience on the work process. Further, you will also understand what the different types of OLTP systems are and what is their role in the SAP BO design tool.

    • 1:00:08
  • In this tutorial, you will learn how you can create the characters in the SAP BO system, how IDT and UDT helps in the Online Analytic Process (OLAP). You will also learn how to create an infocube and what are the steps to be followed while creating an infocube in the SAP BW system.

    • 2:10:35
  • In this video, you will learn how to create data from scratch using the Universe Design tool in the SAP BO module. You will also learn how you can create the BSO in the system tool, using a pictorial description of the entire work process.

    • 1:30:11
  • To access anything from the ECC server, one needs to know the Transaction Codes. In this video, you will learn about these Transaction Codes or T-Codes which will be used in working on the SAP BO system module. You will also get an overview on the Object Hierarchies, which allows users in performing multi-dimensional analysis.

    • 1:24:06
  • In this tutorial, you will be learning the role of IDT and UDT in the SAP BO Design Tool. You will also learn about the types of Web Intelligence and the entire work process with a detailed demonstration from the instructor. Along with this, you will be learning on how to create reports and the different fields and attributes required in creating the reports.

    • 2:30:53
  • In this video lecture, you will learn the different formatting options available to create and modify reports in the SAP BO Design Tools. You will learn how to add rows and columns, category, margins, pictures, articles and others. Further, you will learn how to work on the sub-reports and the functionalities available in the crystal reports. Moreover, you will also get an overview on the dashboard components.

    • 2:00:16
  • In this lecture, you will learn what are the parameters to be used while working on a crystal report by a user. Also, you will see a detailed demonstration on how to work on the Table Article Label, Article Lookup and the Body of the report.

    • 1:01:37
  • In this lecture, you will learn about the different types of dashboard designing components used in the SAP BO module. Further, you will learn how to work on the SAP Lumira Design component, how to add new data set, characteristic dimensions and the different modes in the Lumira Designing Tool.

    • 1:40:21
  • In this video tutorial, you will get a detailed and practical demonstration on how to work on the Information and Quick Design Tool in the SAP BO module. You will also get some more detail concepts and work around on the SAP Lumira Designing Tool.

    • 1:30:58
  • In this tutorial, you will be learning how to connect to a SAP HANA database. Also, you will learn how to use the database and the data models. Moreover, you will also learn how to do the HANA connectivity. This whole work process will be practically demonstrated by the instructor in detail.

    • 2:23:01
  • In this video, you will learn how to access the views using Information Design Tool (IDT), which can be done using the HANA Data Acquisition Connector. You will also be learning how to assign a data source and also working on the whole of the data source work process.

    • 1:29:35
  • In this tutorial, you will learn what is a Web Application Designer (WAD) and what is its role in connecting with the BW Server. You will also learn how to work on the Basis Analysis Layout Template, which is a pre-defined standard template used for ad-hoc slicing and dicing data sources. You will also learn how to work on the attribute views.

    • 2:14:32
  • In this last video lecture, you will learn how you can connect to HANA tables and modules using IDT. You will further learn to work on the SAP HANA business layer and other concepts related to the SAP BO module.

    • 1:09:15

Course/Topic 2 - SAP BW - all lectures

  • In this first tutorial on SAP BW, you will get an in-depth knowledge and some core concepts on this module, how it helps in the reporting process in the SAP system, what is cube and ADSO in SAP BW, the Architecture level and also you will get a deeper understanding on the Info Objects. You will also learn the initial

    • 48:35
  • This is the continuation of Lecture 1.1 - Overview of SAP BW

    • 43:10
  • In this tutorial, you will learn about the whole of the ETL process, how the data flows and how ETL process is implemented in the SAP BW. This will be proceeded with a detailed and practical demonstration by the instructor on the following concepts.

    • 35:50
  • This is the continuation of Lecture 2.1 - Working on the ETL process.

    • 30:28
  • In this tutorial, you will clearing doubts on the practical sessions.

    • 34:09
  • In this tutorial, you will be getting the practical demonstrations on how to work with the ETL process, creating InfoArea, working with the InfoObject Catalog, adding new BW system and defining Master Data and Attribute Data. Also, you will be seeing the instructor explaining each and every step to the student on how to work with some of the concepts of BW module in the SAP system screen.

    • 25:23
  • This is the continuation of Lecture 4.1 - Working with the ETL Process

    • 14:59
  • This is the continuation of Lecture 4.2 - Working with the ETL Process

    • 21:58
  • In this tutorial, you will learn how you can load your data in the SAP BW system. You will get a detail demonstration from both the instructor as well as will be seeing the student practicing the process of working on the Data Warehousing Workbench, changing data source, creating and changing transformation, mapping the attributes through InfoProvider and also the Data Transfer process

    • 26:33
  • This is continuation of Lecture 5.1 - How to load data in SAP BW system

    • 30:05
  • This is the continuation of Lecture 5.2 - How to load data in SAP BW system

    • 19:12
  • In this tutorial, you will be seen the instructor helping the student in creating InfoObjects in BW system. This will be practical demonstration of the entire work being done by the student and not by the instructor.

    • 25:29
  • In this tutorial, you will be learning on how to create the Data Source in the SAP BW system and also will get a detailed and practical demonstration of loading Transaction Data. You will also understand the terms sales quantity, sales amount and key figures/measures which are the vital elements of Sales in the SAP system. You will also learn how to work on the Data Warehousing Workbench and also understand the terms ADSO Advanced and ADSO Classic and what is its work in the SAP BW system.

    • 25:22
  • This is the continuation of Lecture 7.1 - Creating Data Source and Loading Transaction Data - Part 1

    • 22:08
  • In this tutorial, you will be learning about the DSO and the cube in the BW system. This will be demonstrated with a detailed explanation by the tutor on the SAP system screen.

    • 29:57
  • This is the continuation of Lecture 8.1 - Working with DSO

    • 29:14
  • In this tutorial, you will be learning on how to work with the Joined Operations in the SAP BW system along with the Sales Cost of the Joined Operations, attributes like Multi-Provider and InfoSet and a deeper understanding on the components like DS, ADSO, CP and Query. You will also be learning about the input of query’s in the Query Designer Screen of the SAP BW system.

    • 32:59
  • In this tutorial, you will learn a detailed understanding on how to load data in the BW system, what are the different examples of data that might be associated with Sales in the BW system and a detailed explanation on the Info Object and the different attributes.

    • 30:25
  • This is the continuation of Lecture 10.1 - Loading data in BW system - Part 2

    • 22:37
  • In this tutorial, you will learn how you can create a Data Source for InfoObjects and manage InfoProvider in the SAP BW system. You will also learn how data moves between different tables i.e. the Active and the Change Log table while working with creating the Data Source process. The complete video tutorial will be a practical demonstration by the instructor in the SAP system.

    • 34:00
  • This is the continuation of Lecture 11.1 - Creating Data Source for InfoObject - Part 1

    • 34:58
  • In this tutorial, you will learn how to work with the tables in cube process, some concepts on BW reporting and third-party reporting tools, 0 data services, what is a Star and Extended Star Schema, how to connect the Fact Table with the Dimension Table and the M:N Relationship Modeled in Two Dimension Tables.

    • 28:25
  • This is continuation of Lecture 12.1 - Working with Tables in Cube

    • 24:06
  • Lecture 13 - Star Schema in Data Warehousing Model

    • 29:07

Course/Topic 3 - SAP BW/4HANA - all lectures

  • In this first tutorial, you will get an introduction to SAP BW/4HANA, how it is different from the classical SAP BW, what are the changes the updated module has gone through and a short walk around on the BW/4 HANA system.

    • 1:57:35
  • In this session, you will be presented with a live demo session on how to setup the BW/4HANA in the HANA studio and further it will be proceeded with creating objects and the settings to be implemented in the BW/4 HANA module.

    • 52:03
  • In this tutorial, you will learn about creating Info Area, Info Catalog and Types of Info Object. Further, you will be able to understand what is ADSO, its different properties and types. Also, you will be presented with a live demo example on how to work on the Advanced DataStore Object.

    • 43:51
  • In this video tutorial, you will learn what are the different types of Master Data, what is an Attribute and Text Master Data, a live example on how to work on the Master Data and a detailed session on the Attribute and Text Data in a BW/4 studio.

    • 1:47:25
  • In this video, you will learn what is a Transactional Data Load and a detailed live session on how to work on the transactional data in the BW/4HANA studio.

    • 1:19:34
  • In this video tutorial, you will be able to understand the transformation layer and a detailed demonstration on how to work on the transformation layer in SAP BW/4HANA. You will also learn what is a standard ADSO in transformation layer and how to create a standard ADSO, activate and change the log table.

    • 1:26:35
  • In this lecture, you will be able to understand what is a Routine in BW/4HANA and what are the different types of Routine. You will also learn about the ABAP functional module. Further, it will be proceeded with a live demo session on how to work on the different types of routines in SAP BW/4HANA.

    • 1:00:05
  • This video is a continuation to the first part where you will a deeper understanding of the different types of Routines and will get a live example on how to work on it in the SAP BW/4HANA studio.

    • 1:12:19
  • This video is all about the questions put up by students and clearing the doubts on the SAP BW/4HANA module.

    • 1:16:43
  • This video is a continuation to the questions put up by the students on different topics covering ADHOC and the whole of SAP BW/4HANA.

    • 1:17:08
  • This video is regarding questions put up by students on creation of DataSource Template, setting up of runtime properties and the number of parallels used in ABAP settings. Also, he is seen putting questions on what does the server setting on the run time properties do on DTP settings.

    • 56:02
  • In this video tutorial, you will be learning what is ADSO activation, which is nothing but moving of data from new table to active table or change log table and the entire process of ADSO activation in the SAP BW/4HANA studio.

    • 1:00:08
  • In this lecture, you will understand the DTP and a walk around on how to work with the DTP in BW/4HANA. Further, you will be having a deep understanding on the topic by taking the example of the currency updation in the BW system. Users can do it by: Go to T-Code RSA1 -> Source System -> Select the ECC Source -> Right Click -> Go to Transfer Exchange Rates

    • 1:13:31
  • In this video, you will be able to get a deep understanding on what is Info Object and how to work on the Info Object in the SAP BW/4HANA studio.

    • 1:39:21
  • In this video, you will learn a detailed concept on InfoProvider, what attributes and properties we can add in InfoProvider and a detailed live example on how to work on it in BW/4HANA. You will also have a detailed understanding on creation of composite provider, what is Navigational Attribute and how to work on these in SAP BW/4HANA.

    • 1:11:02
  • In this video, you will learn how to install the standard content dataflow. For this users need to: To Install the standard content dataflow -> Go to T-Code RSA1 -> Business Content This theoretical approach will be followed by a live session along with working on the FI-Account Payable system.

    • 1:15:16
  • In this video tutorial, you will be able to understand what are the different types of Extractors in ECC system, which is basically of three types namely; Standard Extractor, Generic Extractor and Customized Extractor. You will also get an overview on these three extractors and what exactly they do and a detailed demonstration of working with these extractors in the SAP system.

    • 1:16:27
  • In this video, the tutor will be seen answering different questions of the students like questions on InfoObject attribute, aggregate summary setting, a revision on the data activation concept. You will also see resolving queries on different data types for key figure and when to use them and others.

    • 55:04
  • In this lecture, you will be learning on how to create Open Hub Destination, working with the activities and opening hub using automated scheduling. You will also see an overview on the SAP HANA graphical view. Further, it will be proceeded with the workings on the above three in the BW/4HANA studio.

    • 57:43
  • In this video tutorial, you will be learning the calculation view which is used to do any calculation on the fly. You will also get to learn about the different kinds of calculations like Auto Generated Calculation View and how it is done in the BW/4HANA system. Further, you will get to understand the different kinds of nodes available and what is the real concept behind these nodes.

    • 1:51:28
  • In this video, you will be learning the method of Process Chain, what exactly is it and how it works on the SAP BW/4HANA system. You will also get to know the order in which the data gets loaded in the system, Master Data and Transactional Data.

    • 1:22:38
  • In this video, you will be seeing a live demonstration on how to work on the variables in the SAP BW/4HANA system.

    • 59:03
  • In this last video tutorial, you will be seeing questions put up by students on BI and other topics related to the SAP BW/4HANA and will get to see a detailed demonstration of the works on the BW/4HANA studio.

    • 1:45:54

Course/Topic 4 - SAP BW/4HANA (basic to advanced) - all lectures

  • In this lecture session we learn about SAP BW on HANA and BW4/HANA are different application suites running on the same database. SAP BW on HANA uses SAP's legacy BW software, but moves it to the HANA database. BW/4HANA uses a reengineered software suite designed to fully harness the power of the HANA database.

    • 2:08:54
  • In this tutorial we learn about SAP Data Warehouse Cloud is an analytic and persona-driven data warehouse-as-a-service solution tailored for business and IT users. It provides instant access to data via pre-built business content and adapters to integrate data from various sources.

    • 2:11:49
  • In this lecture session we learn about SAP HANA is an in-memory database technology which acts as the core technology for a lot of other SAP or non-SAP applications whereas SAP S/4 HANA is a new generation ERP solution which runs on SAP HANA database architecture.

    • 2:09:15
  • In this tutorial we learn about S/4HANA stands for Suite for HANA, as the product was written to take advantage of HANA, which debuted in 2011. S/4HANA was completely rewritten for HANA, differentiating it from Business Suite on HANA, a version of S/4HANA's predecessor, SAP ERP Central Component (ECC), released in 2013 that ran on HANA.

    • 2:09:20
  • In this lecture session we learn about Fiori is a streamlined application, delivering a role-based user experience that can be personalized across all lines of business, tasks and devices. It uses tiles to encapsulate standard tasks like viewing sales orders or approving timesheets.

    • 35:23
  • In this tutorial we learn about SAP Business One, or are already using SAP Business One on Microsoft SQL, you've probably heard a lot of talk about HANA. SAP HANA and Microsoft SQL are relational database management systems developed by SAP and Microsoft respectively.

    • 1:31:50
  • In this lecture session we learn about what is Hana calc view star join in SAP BWHANA SAP HANA (High-performance ANalytic Appliance) is a multi-model database that stores data in its memory instead of keeping it on a disk.

    • 2:06:02
  • In this lecture session we learn about Flow graphs The flowgraph comprises two data sources which are joined (MARA + MARC), filtered and pushed into some data sink, a target table. The source tables can be based on a remote source of any adapter, it is generally applicable for such kinds of ELT flows.

    • 2:25:53
  • In this tutorial we learn about SAP BW/4HANA is a packaged data warehouse based on SAP HANA. As the on-premise data warehouse layer of SAP's Business Technology Platform, it allows you to consolidate data across the enterprise to get a consistent, agreed-upon view of your data.

    • 1:51:56
  • In this lecture session we learn about An SAP extractor is a program that can be used to retrieve data in a SAP source system and transfer it to an SAP BW or BI system. The extractor prepares and captures data through an extract structure for transferring to SAP BW.

    • 1:16:33
  • In this lecture session we learn about Double click on MC11VA0ITM or go to SE11, give the exact structure name and display. Click on Append Structure and click on Create and give an append name. Here give the component and component type. Save, check, and activate.

    • 2:35:21
  • In this lecture session we learn about Enhancement points are the positions in a SAP ABAP program where enhancements are made. The enhancements, when compiled with the current source code work as if it was a part of the source code.

    • 2:13:04
  • In this lecture session we learn about A DataSource is a set of fields that provide the data for a business unit for data access and extraction and data transfer into SAP BW∕4HANA.

    • 2:18:03
  • In this lecture session we learn about SAP CDS stands for SAP Core Data Services. SAP CDS is an infrastructure for data modeling that enables data models to be defined and consumed on the database server rather than the application server.

    • 1:57:31
  • In this lecture session we learn about ABAP CDS Views allow developers to create semantically rich data models which the application services expose to UI clients. It is the central pillar of S/4HANA development and is used as the core technology in most of SAP's programming models.

    • 2:26:08
  • In this lecture session we learn about The delta process is a feature of the extractor and specifies how data is to be transferred. As a DataSource attribute, it specifies how the DataSource data is passed on to the data target.

    • 2:43:49
  • In this tutorial we learn about The delta process is a feature of the extractor and specifies how data is to be transferred. As a DataSource attribute, it specifies how the DataSource data is passed on to the data target.

    • 2:15:03
  • In this tutorial we learn about Data flow in data acquisition involves transformation, info package for loading to PSA, and data transfer process for distribution of data within BI. In SAP BI, you determine which data source fields are required for decision making and should be transferred.

    • 1:10:28
  • In this lecture session we learn about how a CDS view serves to define the structure of an SQL view and represents a projection onto one or several Dictionary tables or Dictionary views. Note SQL views and CDS entities are part of one and the same namespace. Therefore, you must assign different names for an SQL view and the entity.

    • 1:20:31
  • In this tutorial we learn about A data mart is a simple form of a data warehouse that is focused on a single subject or line of business, such as sales, finance, or marketing. Given their focus, data marts draw data from fewer sources than data warehouses.

    • 2:03:32
  • In this tutorial we learn about Data mart is focused only on a particular function of an organization and it is maintained by single authority only, e.g.m finance, Marketing.

    • 2:32:29