You will be provided with most effective training in SAP BW/BI with different scenarios based on real time issues. All the topics will be covered from basics till the complex level.

Topics Covered

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 Info cubes and DSO 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 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.3 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

Who should attend

Graduates who are from B-Tech/BE, MCA, BSC, Any one who did Masters in any stream are eligible. Further counseling will be provided if it suitable or not for people with different education back ground

Pre-requisites

N/A

What you need to bring

A computer with good internet speed and a Headset.

Key Takeaways

Knowledge in SAP BW/BI, how to handle interview questions, different issues which can be expected in real time projects, approach in a logical way & many