contact learnsap

Please note that LearnSAP LLC is an independent training provider and is not affiliated with, endorsed by, or in any way officially connected with SAP.

Mon ~ Fri, 9 AM ~ 5 PM (US CST)
Phone: +1-832-419-7371
Email: info@LearnSAP.com

SAP BI Training

Technical Consultant Training

In-Class, Instructor-led Online

Business Intelligence video preview

★★★★★   I highly recommend training here. The instructor is passionate and dedicated, very descriptive and detail oriented. The course is easy to follow. All relevant tools were provided. Great course. ”

- Delia Tira

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.

more

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


Have a question?
☎+1-832-419-7371 || +1-832-481-9144
info@learnsap.com

© 1999 LearnSAP All Rights Reserved; Privacy Policy

Designed and Managed by LearnSAP.com

Back to Top