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

4.5

80 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
        Profile photo of Suneel Kumar
        Chrissteve
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Profile photo of Suneel Kumar
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Profile photo of Suneel Kumar
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Profile photo of Suneel Kumar
        Alison Benhar
    drop query

    Send us a Query

    Enroll into this course

    Register for Free Demo

    3 + 5

    Related Articles

    No Related Articles found

    Support


    Please leave a message and we'll get back to you soon.

    3 + 5