“ I really love the instructors of Learn SAP. They are all very knowledgeable and helpful, not only in the material that they teach in the class, but also when it comes to career advice and mentoring. I would highly recommend Learn SAP to anyone who is willing to put in the hard work that it takes to be successful in this course, as well as a future career in SAP Consulting. ”
- David Edwards
What is SAP Business Intelligence
We are confident that with our inputs and the active and dedicated learning hours put in by the participants, SAP BI exam would be a formality.
SAP Business intelligence aims to support better business decision-making. Thus a SAP BI system can be called a decision support system (DSS). Though the term SAP business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, SAP BW (Business Warehouse) uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors.
SAP Netweaver Business Warehouse (SAP NetWeaver BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP AG. It was originally named SAP BIW (Business Information Warehouse), then abbreviated to SAP BW, but is now known as "SAP BI" at the end user level. In contrast, "BW" is still used to describe the underlying Data Warehouse Area and Accelerator components.
Prerequisites
No specific knowledge required to join SAP BI/BW training, but having basic knowledge of SAP overview is always a plus point to understand further concepts of SAP business intelligence module more easily.
Course Curriculum 
All parts of the SAP BI Training (SAP Business Intelligence Training) course have lectures, demonstrations on all topics, customizing settings and a lot of exercises for participants. At the end of the SAP BI training there would be 2 sets of examination for preparing the participants for SAP BW Certification.
Day-1: SAP BI / SAP BW Overview
- Data warehouse fundamentals
- Introduction to SAP R/3, ECC and BW
- BW architecture
- Multi dimensional Modeling
- Star Schema, BW extended Star Schema
- Administrator Work Bench
- InfoObjects ( attributes and texts and hierarchies)
- InfoCubes, Transactional ( Real-time ) InfoCubes
Day-2: ODS, PSA, Update Rules
- ODS ( DSO) -> Standard, Transactional and Write Optimized
- PSA, Source Systems
- InfoSource
- InfoPackage
- Transfer Rules
- Update Rules
- Transformation
- Data Transfer Process
- Loading Master Data using flat files
Day-3: Transaction Data, Managing Delta
- Loading transaction data using flat files
- ODS -> Change Log, Active Table and New Table
- Managing Delta using ODS
- MultiProviders
- Process Chains
- Open Hub service
- Data Marts
- InfoSpokes
- Open Hub Destination
- Aggregates
Day-4: Loading Master Data, Delta Management
- Activating the Business content
- Loading Master data from ECC
- Delta Management
- Various types of R3 Extractors
- Extraction from LO Cockpit
- User Exits
- SAP Landscape and Transports
- Real Time Data Acquisition
- BEx reporting -> BEx Query Designer, Calculated and Restricted Key
- Figures, Variables ( Characteristic, Formula and Text Variables )
Day-5: Query properties
- Query properties, Exceptions and Conditions, BEx Analyzer
- Workbooks, Report to Report Interface ( RRI )
- Information Broadcasting
- Web Application Designer
- Report Designer
- Generic Extractors
- InfoSets
- Slowly changing dimensions and realignments
- Universal Data Connect ( UDC )
- BW and XI integration
- BW and APO integration
- Business Planning and Simulation ( BPS )
- Mini Project
What is included
- 40-hours of Instructor-led Training
- Study Material
- System Access for hands-on practice
- Video recording on request
- Interview Preparation
About the Instructor
Mr. Somil Tiwari has almost 12 years of experience in SAP. He is senior SAP Technical Consultant of SAP BI/ BW and HANA implementation project along with SAP ABAP, SAP SD, PS/CATS and PM modules. He has excellent command over SAP Landscape Integration and Solution Manager (SolMan). more