for below course content video tutorials are available. SAP-BI (7.0) online training With Project Introduction General Introduction. SAP introduction. Data warehousing/ BW/ BI Introduction Data Modeling OLAP v OLTP ERM, MDM, Star schema, extended star schema Data warehouse workbench functions: Characteristics, Key Figures, Data Sources for File Source Systems, Info Package, PSA, Transformations, data transfer processes InfoCubes: Standards, real time, Virtual Providers Data Store objects (DSO): Standards, direct update, write optimized Infocube VS DSO Master data- texts, Attributes, Hierchies. Remodeling Infosets Multiprovider Open hub destination Process chains Metadata and Document Management BI Content: Definitions, How to install BI contents Defining extraction For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource. Or for files: Creating DataSources for File Source Systems User management: Authorizations Transports: Real business scenarios on different system environments, Moving objects from one system to another. Data Extraction: Business flow: SD, MM, PP, FI. BW overview –R/3 extraction Generic data extraction Data Extraction from LIS Data Extraction from LO cockpit Data Extraction from CO-PA Data Extraction from FI Delta Management BEx Query Designer Introduction to BW-Bex reporting (Bex analyzer, query designer, report designer, web application designer) Reporting features & properties Rows, columns, Free Characteristics, Filters, Exceptions, Conditions, Calculated and Restricted Key Figures, structures. Cell Definition New selection, new formula. Column&row properties. Query properties Report-to-Report Interface Variables: (5 types) Characteristic value variables, Hierarchy Variables, Hierarchy node variables, Text variables, Formula variables Query designer Information broadcasting Design mode (web items) Web application designer Performance Line item dimension High cardinality Aggregates Partition Compression Indexes Olapcashe ABAP (related to BI) Data source enhancements Start routine End routine Characteristics routine Additional: Differences between 3.5 and 7.0 version. Upgradation from BW 3.5 to BI 7.0 IP( Integrated Planning) VC (Visual Composer) theory Business Objects with BI integration ( theory) Project: ASAP methodology Functional specifications Technical Specifications Responsibilities of BI consultant (implementation & support project) Unit testing