Sap bi&bw -course content

1. SAP BI Training - Complete Course Details SAP BI Trainings for beginners looking to improve their SAP Business Intelligence technical skills. 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. SAP BI Course Curriculum: 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. SAP BI / SAP BW Overview Data warehouse fundamentals  Introduction to SAP R/3, ECC and BW  BW architecture  Multi dimensional Modeling 

2. Star Schema, BW extended Star Schema  Administrator Work Bench  Info Objects ( attributes and texts and hierarchies)  Info Cubes, Transactional ( Real-time ) Info Cubes  ODS ( DSO) -> Standard, Transactional and Write Optimized  PSA, Source Systems  Info Source  Info Package  Transfer Rules  Update Rules  Transformation  Data Transfer Process  Loading Master Data using flat files  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  Info Spokes  Open Hub Destination  Aggregates  Activating the Business content  Loading Master data from ECC  Delta Management  Various types of R3 Extractors  Extraction from LO Cockpit  User Exits 

3. SAP Landscape and Transports  Real Time Data Acquisition  BEx reporting -> BEx Query Designer, Calculated and Restricted Key  Figures, Variables ( Characteristic, Formula and Text Variables )  Query properties, Exceptions and Conditions, BEx Analyzer  Workbooks, Report to Report Interface ( RRI )  Information Broadcasting  Web Application Designer  Report Designer  Generic Extractors  Info Sets  Slowly changing dimensions and realignments  Universal Data Connect ( UDC )  BW and XI integration  BW and APO integration  Business Planning and Simulation ( BPS )  Mini Project 