• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Course Details

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 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.

Partitioned objects

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.

Course Reviews


80 ratings
    • 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.
      Profile photo of Suneel Kumar
    • Real time/live scenario's were included in the training sessions. The trainer's has very good command on the subject. Thank you..
      Profile photo of Suneel Kumar
      Claire Edwards
    • I like the training period from Tekslate. The course is very well designed that helps to keep track until we demonstrate subject mastery.
      Profile photo of Suneel Kumar
      Anya Vasilisa
    • 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 ...
      Profile photo of Suneel Kumar
      Alvin Alicia
drop query

Send us a Query

Enroll into this course

Register for Free Demo

I agree to be contacted via e-mail.

Related Articles

No Related Articles found

Site Disclaimer, Copyright © 2016 - All Rights Reserved.