SAP BW/BI is an online course beautiful designed SAP to integrates data from different sources, transforms and consolidates the data, data cleansing, and storing of data as well.
Instructor-Led Live Online Training
SAP BW/BI is the ETL (data warehousing) tool provided by SAP which helps in extracting the data from different sources and make the decision in the right time. The demand for SAP BW/BI is going day by day and the need for trained and experienced SAP BW/BI professionals has increased exponentially.
SAP BW/BI Training Curriculum
SAP BI Overview
ERP and Why ERP?, SAP history and different Sap Products, Sap Cross Industry Applications, Sap Industry Specific solutions, Role of SAP BI, Implementation, Support, Upgrade and Migration, Basics of Data Warehousing, Star Schema, Extended Star Schema, Advantages of Extended Star Schema, Terminology and Project Orientation.
Data Modelling, DW Design and Data loading From File sys
BI System architecture, Data warehouse, ETL, BEx Suite, Functions of Data warehousing workbench, Development of Info objects, Characteristics, Key figures, Development of Attributes and all the Tabs of Chars and Key figure, Display attribute, Navigational attributes, Transitive attribute, Compounding attribute, Designing the different types of Infocubes and DSO, Hybrid Providers/Transient Providers/Composite Providers/Semantic.
Master Data loading—Attribute/Text/Hierarchy, Transaction data loading—-Loading to DSO and Info cube, Full upload, Initialization, Delta uploads, Real time Data acquisition and direct data Access (Virtual Provider), Error Stack and Error DTP //Issues in data Loading, Installing Objects from BI content, Info sets and Multi Providers, Inner Join/Left Outer Join, Union, Placing Flat Files in Application Server, Data Modelling Tasks in a Project Environment.
Data loading from SAP ERP-R/3 and Database systems
Source system interfaces and logical systems. Remote function calls, Source system application and data source overview. Types of Extractors, Logistics Data Extraction, Full upload, Initialization of data source, Delta uploads, Generic Extraction, Full upload, Initialization of data source, Delta uploads, DB extraction, Controlling Data Extraction, Full upload, Initialization of data source, Delta uploads, Finance Extractors, Master data Extraction from Sap ERP sys, Data source Enhancement.
Business Explorer Business Intelligence
Basics of Reporting. Components and Tools of Reporting, Query Designer and Different Elements, Free chars, Filters/Restriction, Conditions/Exceptions, Restricted key figure/Calculated key figure/New selection/New formula, Variables-all type, Analyser, Design Mode, Analysis Mode, Report Designer and Formatting Techniques of Report Designer, Web application Designer and Web Analyser, BEx Broadcaster, Visual Composer Reporting.
BW 7.4 Topics & Supporting
Start, End & Expert routines, Remodelling, Repartitioning, BI Accelerator, BW Statistics, Performance Issues, Query Performance, Compression, Aggregates/Rollup, Indexes, Line item Dimension, Cardinality Height, Query trace/SQL Trace, Attribute and Hierarchy change run/etc…, Extraction performance, PSA partitioning/PSA and Change log Table Data Deletion, Transportation, Process chains Designing and Monitoring, Supporting Issues, Tickets and Miscellaneous topics.
The online course session was good with a lot of discussion on the subject in depth. Demo's were good and the trainer cleared my doubts clearly.The trainer having a very good command on the subject.
Real time/live scenario's were included in the training sessions. The trainer's has very good command on the subject. Thank you..
I like the training period from Tekslate. The course is very well designed that helps to keep track until we demonstrate subject mastery.
Using most innovative teaching techniques, Tekslate intended to help students to learn through online. A great part of the coursework is allowed to use and earn certification by the time they finish t ...