Hi ALL,
We OCEAN TECHNOLOGIES offer SAP-BI course
Our SAP-BI Program include Training in the following areas
SAP BW / BI Training Outline
ERP background
SAP Company background information & ERP systems
Data warehouse concept and Reporting concept
SAP BW solution for data warehousing and reporting
Why use SAP solution
SAP BW (backend and front-end) – Instructor lead & Hands on Training
Ø Data Warehousing
Ø Data Extraction and Staging
Ø Data Modeling and Authorization
Ø Business Explorer: Reporting and Analysis
Projects: Real world SAP BW deployment scenario –
SAP BW job opportunities and preparation approach
Course content
SAP Business Intelligence - Data Warehousing
Unit 1: SAP Net Weaver and BI: Overview, Positioning and Fundamentals
• Fundamentals of Data Warehousing and Business Intelligence• SAP Net
Weaver Business Intelligence (BI) Overview• SAP Net Weaver Solution
Delivery: IT Practice, Scenarios, and Usage Types• SAP Net Weaver
Business Intelligence: Data Warehousing OverviewUnit 2: Objects in the
BI Data Warehouse Layer • Data Warehousing Workbench• InfoProviders:
Business Purpose• Info Objects: Characteristics• InfoObjects: Key
Figures• The BI InfoCube: An Extended Star Schema • Creating
InfoCubesUnit 3: Data Acquisition and Transformation from SAP Source
Systems • Data Flow: Overview• Loading Master Data from an SAP Source
System• Loading Transaction Data from an SAP Source System• ETL
Processes and Loading HierarchiesUnit 4: Data Acquisition from Other
Systems • Extraction from Non-SAP Systems: Overview • Flat File
LoadingUnit 5: Business Content • BI Content Discovery (Metadata
Repository)• BI Content ActivationUnit 6: Other InfoProviders •
DataStore Objects• VirtualProviders and Real-Time Data Acquisition •
MultiProviders and BI InfoSetsUnit 7: Administration of Data Targets •
System Administration Tasks in BI: Overview• Administration of
InfoCubes• Administration of Data Store Objects• Process ChainsUnit 8:
Introduction to Query Performance Optimization • Introduction to Query
Performance Optimization in BI• BI Aggregates• BI Accelerator•
Statistics Overview
SAP Business Intelligence - Reporting & Analysis
Unit 1: Introduction to BI Enterprise Reporting• SAP BI OverviewUnit
2: Navigating in Reports • Navigating in ReportsUnit 3: First Steps in
the BEx Query Designer • Query Designer• InfoProviders in the BEx
Query DesignerUnit 4: Key Figures • Restricted Key Figures• Calculated
Key Figures• Properties of Key Figures• Structures and CellsUnit 5:
Characteristics • Properties and Attributes of Characteristics•
Integrating Hierarchies into Reports• Creating User-defined
HierarchiesUnit 6: Variables • VariablesUnit 7: Exceptions and
Conditions • Exceptions• ConditionsUnit 8: BEx Analyzer • BEx
AnalyzerUnit 9: BEx Web Analyzer • BEx Web AnalyzerUnit 10:
Information Broadcasting • Information Broadcasting Overview• BEx
Broadcaster• Workbook PrecalculationUnit 11: Enterprise Portal
Integration • SAP BI Portal IntegrationUnit 12: Document Integration •
Document IntegrationUnit 13: Report-Report-Interface • Report-Report-
InterfaceUnit 14: Managing Query Objects • Managing Query ObjectsUnit
15: Business Content • Business ContentUnit 16: Further SAP BI
Reporting Tools • Further SAP BI Reporting ToolsUnit 17: Appendix • BW
3.5 Query Designer• BI Migration Aspects• Intercompany Elimination
SAP Business Intelligence - Data Staging & Extraction
Unit 1: Overview of SAP BW• SAP BW in SAP NetWeaver• Overview of Data
Staging in SAP BW• BI ContentUnit 2: Data Transfer with the Service
API • Connecting SAP Source Systems to an SAP BW System• Basic of the
SAP BW Service API• Transfer of Business Content DataSources• Generic
Data Extraction• Logistics Data Extraction• Enhancement of Business
Content DataSourcesUnit 3: Delta Management • Delta Management:
Overview• Update Mode and Delta Process• Examples from Applications /
Source Systems• Additional NotesUnit 4: Transfer of Flat Files •
Transfer of Flat FilesUnit 5: Data Transfer With DB Connect • Data
Transfer with DB ConnectUnit 6: Data Transfer with UDC • Universal
Data IntegrationUnit 7: XML-Based Extraction • Using the Web AS SOAP
Service• XML Data Load – Using a Web Service• XML Data Load Using SAP
XIUnit 8: Data Transfer with Third-Party ETL Tools • Data Transfer
with Third-Party ETL ToolsUnit 9: Data Mart Interface • Data Mart
InterfaceUnit 10: Open Hub Service • Introduction to the Open Hub
Service• Implementing the Open Hub ServiceUnit 11: Application-
Specific Extraction • Extracting Data from CO-PA• Extracting Data from
FI-SL (Special Ledger)• LIS Data Extraction
SAP Business Intelligence - BW Modeling & Authorization
Unit 1: Logical Model• Requirement Analysis• Logical Data Model• BW
Data Model• Compare the Model with the Business ContentUnit 2:
Tracking History and Hierarchies • Tracking HistoryUnit 3: Modeling
Characteristics and Key Figures • SAP BW Star Schema• Characteristic
InfoObjects• Key Figure InfoObjectsUnit 4: Modeling ODS Objects •
Defining ODS Objects• Standard ODS Objects in the SAP BW Data
Warehouse LayerUnit 5: Multidimensional Modeling • Designing the
Dimensions of the SAP BW InfoCube• Aggregate ModelingUnit 6: Changing
the Data Model • Modifying a Data ModelUnit 7: Special Modeling
Aspects • SAP BW InfoSets• Partitioning of InfoCubes• Intercompany
Elimination• Cumulative and Non-CumulativeUnit 8: Summary • Data
ModelingUnit 9: Appendix • Standard ODS Object• Aggregate Performance•
Data MiningUnit 10: Data Modeling – Case Study • Data Modeling Case
Study – Introduction• Data Modeling Case Study - InterviewsUnit 11:
SAP BW Overview with regards to Authorizations • SAP BW Architecture
and Administration• Business ExplorerUnit 12: Security Components in
BW • Comparison of OLTP and OLAP Security Needs• Major Authorizations
Objects Used in BWUnit 13: Securing Data Access for Reporting Users •
Securing Data Access for Reporting UsersUnit 14: Securing Data Access
for Administration Users • Using Templates• Monitoring Administration
UsersUnit 15: System Security • System –communication Security•
Maintaining Authorizations• Structural Authorizations SAP BW/mySAP ERP
HCMUnit 16: BPS Authorizations • Interaction Between Planning and
Other SAP BW Activities • BW BPS Authorization ObjectsUnit 17:
Appendices • Performance Measurement and Recommendation
- Show quoted text -
Any graduate or post graduate can undergo this.
Our batches include :
1.Weekend: -
Saturday and Sunday- 3 hrs per day
2.. Online training.
BANGALORE-
PH NO:
+919980212689.
E-mail:vijay...@gmail.com