SAP - BI

SAP Business Intelligence (BI) Training in Pune

As the Leading SAP Training Institute in Pune Global Techsys and Solutions offers online as well as class room training for SAP BI/BW module. We have excellent training experience in SAP and as well as Real –time working experience in all SAP modules. Training at Global Techsys and Solutions is incomparable with any other and they will train you in such a way you will have clear balancing between the theoretical knowledge and real world environment.

SAP NETWEAVER BUSINESS WAREHOUSE 7.3.

1. SAP BI Overview.

ERP overview.

• What is 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

2. Data Modeling, DW Design and Data loading From File sys.

BI System architecture.

• Data warehouse
• ETL
• Bex Suite
   o Functions of Data warehousing workbench.
   o Development of Info objects.
• Characteristics
• Key Figures
    o Development of Attributes and all the Tabs of Chars and Key figure.
• Display attribute
• Navigational attributes
• Transitive attribute
• Compounding attribute
   o Designing the different types of Infocubes and DSO
   o Master Data loading—Attribute/Text/Hierarchy
   o Transaction data loading—-Loading to DSO and Info cube.
• Full upload
• Initialization
• Delta uploads
   o Real time Data acquisition and Direct data Access (Virtual Provider)
   o Error Stack and Error Dtp //Issues in data Loading
   o Installing Objects from BI content.
   o Info sets and Multi Providers.
• Inner Join/Left Outer Join
• Union
   o Placing Flat Files in Application Server.
   o Data Modeling Tasks in a Project Environment

3. Data loading from SAP ERP 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
   o Generic Extraction
• Full upload
• Initialization of data source
• Delta uploads
   o DB extraction
   o Controlling Data Extraction.
• Full upload
• Initialization of data source
• Delta uploads
   o Finance Extractors.
   o Master data Extraction from Sap ERP sys.
   o Data source Enhancement.

4. Business Explorer Business Intelligence.

• Basics of Reporting. Components and Tools of Reporting.
   o Query Designer and Different Elements
• Free chars
• Filters/Restriction
• Conditions/Exceptions
• Restricted key figure/Calculated key figure/New selection/New formula
• Variables-all types.
   o Analyzer
• Design Mode
• Analysis Mode
• Report Designer and Formatting Techniques of Report Designer.
• Web application Designer and Web Analyzer.
• Bex Broadcaster.
• Visual Composer Reporting.

5. BW 7.0 Topics & Supporting.

• Start , End & Expert routines
• Remodeling
• BI Accelerator,
• BW Statistics.
• Performance Issues.
• Query Performance
   o Compression
   o Aggregates/Rollup
   o Indexes
   o Line item Dimension, Cardinality Height
   o Query trace/SQL Trace
   o Attribute and Hierarchy change run/etc…
• Extraction performance
• PSA partitioning/PSA and Change log Table Data Deletion
   o Transportation
   o Process chains Designing and Monitoring
   o Supporting Issues, Tickets and Miscellaneous topics.

6. BW 7.3 DeltaS


• Hybrid Providers
• Composite Providers
• Transient Providers.
• Scenarios For New Info providers.
• Semantic partitioned objects
• DSO Partitioning
• Data Flow Copy and Data Flow Migration tool
• Loading Hierarchies By using 7.3
• Other 7.3 Features.

ADDITIONAL

• Project Assignment Work & Queries.
• Technical And Practical Overviews
• Interview Preparations
• Feedback Form For Each Consultant On Technical & Project Concepts