Sap bi/bw online tutorial in Hyderabad www. magnifictraining.com CONTACT US: MAGNIFIC TRAINING INDIA +91-9052666559,905266558 USA : +1-678-693-3475
info@magnifictraining.com
LOGO
OUR MAGNIFIC IT COMPANEY Magnific technology is a leading training institute in the online world We provide work based training, according to your specific educational and technical needs We have one excellent centre fully operational training Magnific name : SAP bi/bw 24*7 technical support Faculty : real time experience Magnific trainings : it is a brand and providing quality online and offline trainings to students in world wide We are providing best online training for SAP bi/bw We offer investment options to our students, if necessary info@magnifictraining.com www. magnifictraining.com
LOGO
Sap bi/bw online training SAP BI/BW Overview SAP BI/BW is analytical, reporting and data warehousing software produced by SAP AG. It is still used to describe the
underlying data warehouse area and accelerator components Extract, transform, load (ETL) layer – responsible for extracting data from a specific source, applying transformation rules, and
loading it into the Data Warehouse Area.
info@magnifictraining.com www. magnifictraining.com
LOGO
Sap bi/bw online training Material Data Warehouse Area – responsible for storing the information in various types of structures (e.g. Data Store Objects, Info Objects and
multidimensional structures called Info Cubes that follows star schema design). Reporting – for accessing the information in data warehouse area and presenting it in a user-friendly manner to the analyst or business user. Planning and analysis – Provides capabilities for the user to run simulations and perform tasks such as budget calculations
info@magnifictraining.com www. magnifictraining.com
LOGO
Sap bi/bw online training India Sap bi/bw Course Content:Introduction • • • •
Enterprise Structure Introduction to ERP, SAP, Data Warehouse Overview of BW, BI, Data Base. Overview of BW Architecture, Landscape
Basic Modeling • • • •
Create a valid Schema Multi-Dimensional Star Schema (Classical Approach) Multi-Dimensional Star Schema in BW (Extended star Schema) The OLAP Concept and differences between OLAP and OLTP
info@magnifictraining.com www. magnifictraining.com
LOGO
Sap bi/bw online training Tutorials Business Modeling • Info Area • • • • • • • • •
Info Object Catalogs Info Objects PSA Application Component Info Source Data Source Transfer Rules Update Rules Info Package
info@magnifictraining.com www. magnifictraining.com LOGO
sap bi/bw online Classes Routines
•Start Routine 1 •End Routine •Expert Routine DSO (Data Store Object)
2
•Standard DSO •Write optimized DSO 3 DSO •Direct update
Update Methods
4 •Full updates •Initialization •Delta Updates info@magnifictraining.com www. magnifictraining.com
LOGO
sap bibw(business intelligence warehousing) online training Info Providers
3 Providers •Multi •Info set •Virtual Providers 2 •Re-Modeling •Re-Partitioning Info Cube Maintenance •Aggregates •Roll-up 4 •Compression •Reconstruction
info@magnifictraining.com www. magnifictraining.com
LOGO
SAP bi/bw online training by real time experts - Classes Process Management
•Process 3 Chains, Process Types •Scheduling •Monitor (Header, Status, Details)
2
Reporting
Business Explorer •BEX Query designer •BEX Analyzer Functional 4 Overview of Bex Query Designer
info@magnifictraining.com www. magnifictraining.com
LOGO
Online Knowledge Product SAP bi/bw Reusable Query Elements
3 Key Figures •Calculated •Restricted Key Figures •Formulae 2
Variable Definition in Detail •Characteristic values variables •Text Variables •Formula Variables •Hierarchy Variable
4
info@magnifictraining.com www. magnifictraining.com
LOGO
Sap bi/bw online training India Analysis Functions •Conditions 3 •Exceptions
Reporting Drilldown
2
•Drilldown to DSO from Info Cube (RRI) •Migration Objects from BW 3.x to BI 7.0 •Transportation Extraction •Generic Data Extraction using MD/TD Tables 4 •Business Content Extractions using MD/TD •LO-COCKPIT Data Extraction
info@magnifictraining.com www. magnifictraining.com LOGO
Sap bi/bw online training in Hyderabad Delta types for •Generic Extraction •LO Extraction •Hybrid providers •Graphical Dataflow modeler •Accelerated data loads •Semantic partitioning objects •Integrated planning front-end Analytical indexes Key Features of BW 7.3 are Hybrid providers 4 Graphical Dataflow modeler Accelerated data loads Semantic partitioning objects Integrated planning front-end Analytical indexes info@magnifictraining.com www. magnifictraining.com LOGO
sap bi/bw online training
ďƒ˜ We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3. Learn Right from Your Place 4. Customized Curriculum 5. 24/7 system access 6. Highly Affordable Courses 7. Support after Training a. Resume Preparation b. Certification Guidance c. Interview assistance info@magnifictraining.com www. magnifictraining.com
LOGO
sap bi/bw certification
info@magnifictraining.com www. magnifictraining.com LOGO
Sap bi/bw overview
CONTACT US: www.magnifictraining.com MAGNIFIC TRAINING INDIA +91-9052666559 USA : +1-678-693-3475 ---> info@magnifictraining.com info@magnifictraining.com www. magnifictraining.com
LOGO
info@magnifictraining.com www. magnifictraining.com
LOGO