SAP BW/BI Instructor was excellent. I got more than what I expected from Ytek. I sincerely thank Ytek and Instructor for such a wonder full job “    

                           -- Mike C..

Home About Us Services Training Careers Contact Us

SAP Business Intelligence ( BI 7.0 / BW 3.5 )

 

          In BI 7.0 / BW 3.5 course, you will learn how SAP’s Business Intelligence solution allows you to convert data into valuable information through hands on practices backed by extensive study material. Through the Data Warehousing Workbench, practice Data Modeling, Data Acquisition and the new Transformation Procedures, to name a few. Also, discover how Integrated Planning of BI has revolutionized and eased the decision-making process.

Total Course Hours  :  50                                                                                                                                                                                           

Introduction

  • Introduction to ERP
  • Introduction to SAP
    • Why SAP
    • Different SAP systems
    • Overview of Modules in SAP
    • Navigation in SAP (using SAP GUI)
    • Concept of Client
    • SAP Users
  • Introduction to SAP Netweaver 2004 & 2004s system

Data Warehouse & Modeling

  • Star Schema, Extended star schema
  • Master Data, Transaction Data.
  • Source Systems
  • InfoObjects, InfoCubes, ODS/DSO, PSA
  • MultiProviders, InfoSet
  • DataSource, InfoSource, InfoPackage
  • InfoCube Administration
  • DataMart Interface, InfoSpokes
  • Business Content

Extraction

  • Extracting Master Data
  •   – Attributes, Texts, Hierarchies
  • Extracting Transaction data
  • Extraction from SAP systems
  • Flat file extraction
  • Concept of Delta management
  • Generic Extraction
  • LO Extraction
  • BC Extraction
  • Business Scenarios : Extracting FI data
  • COPA Extraction
  • Concept of DB & UD Connect
  • Monitoring the data loads
  • Automation of data load process using Process Chains
  • How to monitor and debug process chains

Reporting

  • BEx browser
  • BEx Query Designer
  • Calculated & Restricted key figures
  • Exceptions & Conditions
  • Variables
  • Query Properties
  • Web Application Designer
  • Web Templates
  • Reporting Agent
  • Information Broadcasting
  • Web items

Performance Tuning & Administration

  • BW Statistics
  • Aggregates
  • Query Read Modes
  • Line Item Dimension
  • Cardinality
  • Indexing
  • Partitioning
  • Transport Management

SAP Netweaver 2004s (BI 7.0)

  • New GUI object Navigation
  • BI System Upgrade
  • Migration of dataflow from BW 3.x to BI 7.0
  • New concept of DataSource
  • Process chains – The must
  • Write-optimized DSO
  • Technical enhancements in DSO
  • Transformation & UoM Conversions
  • DTP & DTP error handing.
  • How to write routines in Transformations
  • Debugging routines
  • New capabilities in InfoSet
  • Remodeling InfoCube
  • Real time Data Acquisition
  • Issues faced in BI upgrade in a project
  • BI Accelerator
  • Visual Composer
  • Repartitioning
  • Enhancements in BEx Query designer
  • New Web Items & charts
  • Information Broadcasting
    • BEx Broadcaster
    • Events, Time Points
    • Alerts & Exceptions

Career Related Support

  • Job placement assistance

Other Support

  • 3 months of SAP remote access with new version (BI 7.0, ECC 6.0) with fully connected system
  • Full Course material including certification guides
  • Assignments, quiz and mini projects
  • Tips and Tricks for SAP Certification and Interviews
  • Students are allowed to attend classes conducted in next batch if they are unclear in any of the topics
  • Students can get extended access by paying nominal monthly fee.                      

Assumptions

  • 10 hours class on Saturday or Sunday (8.00 AM - 6.00 PM) For 5 weekends
  • Classes will not be held on long weekends unless a request made by majority of Students and Instructor
  • Lunch break is from 12 - 12.45 PM
  • Additional breaks will be scheduled in AM and PM necessary
  • Instructor will arrive on day of the class at 8.00 AM and leave same day after 6.00 PM
  • Ytek will provide Logistics and Course material, Instructor will bring-in supplemental material where needed 

Please contact training@yteksolutions.com to enroll this program, Course Fee and Other additional information.

© 2007-2012 Ytek Solutions Inc. All Rights Reserved.