SAP BI

Ex saepe accusata duo, vel ne summo option delenit.

CCHS_SAP_BI

SAP

SAP BI (Business Intelligence)

SAP BI also called as SAP Business Warehouse (BW) is an analytical, reporting and Data Warehousing solution produced by SAP AG. It is often used by companies who run their business on SAP. BI is a part of the SAP NetWeaver technology platform. It also includes end-user reporting tools such as Report Designer, BEx Query Designer, BEx Web Application Designer and BEx Analyzer.

This course focuses on the core capability of SAP BI software and the wide application of BI/BW within an enterprise environment. During the course candidates will work on case scenarios, configurations and more. This course will focus more on the practical angle thus bringing real world application of SAP Business Intelligence to the classroom.


Course Curriculum

  • 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
  • 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
  • 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
  • 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)
  • 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

Program Details

Duration 40 Hours
Tuition Please call 416.850.1456 or email [email protected] for more information.
 © Canadian College for Higher Studies, 2020