Tera Technologies

Tera Technologies offers indepth SAP BW Training in the Houston, Texas area. We are totally commited to developing your SAP BW skills. New batch now forming for Jan 10th, 2009. Here is a great opportunity to acquire skills to enhance or change your career and become an SAP professional; we provide excellent materials and access to live systems at no extra cost. 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 Instructor lead & Hands on Training 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 NetWeaver Business Intelligence (BI) Overview SAP NetWeaver Solution Delivery: IT Practice, Scenarios, and Usage Types SAP NetWeaver Business Intelligence: Data Warehousing Overview Unit 2: Objects in the BI Data Warehouse Layer Data Warehousing Workbench InfoProviders: Business Purpose InfoObjects: Characteristics InfoObjects: Key Figures The BI InfoCube: An Extended Star Schema Creating InfoCubes Unit 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 Hierarchies Unit 4: Data Acquisition from Other Systems Extraction from Non-SAP Systems: Overview Flat File Loading Unit 5: Business Content BI Content Discovery (Metadata Repository) BI Content Activation Unit 6: Other InfoProviders DataStore Objects VirtualProviders and Real-Time Data Acquisition MultiProviders and BI InfoSets Unit 7: Administration of Data Targets System Administration Tasks in BI: Overview Administration of InfoCubes Administration of Data Store Objects Process Chains Unit 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 Overview Unit 2: Navigating in Reports Navigating in Reports Unit 3: First Steps in the BEx Query Designer Query Designer InfoProviders in the BEx Query Designer Unit 4: Key Figures Restricted Key Figures Calculated Key Figures Properties of Key Figures Structures and Cells Unit 5: Characteristics Properties and Attributes of Characteristics Integrating Hierarchies into Reports Creating User-defined Hierarchies Unit 6: Variables Variables Unit 7: Exceptions and Conditions Exceptions Conditions Unit 8: BEx Analyzer BEx Analyzer Unit 9: BEx Web Analyzer BEx Web Analyzer Unit 10: Information Broadcasting Information Broadcasting Overview BEx Broadcaster Workbook Precalculation Unit 11: Enterprise Portal Integration SAP BI Portal Integration Unit 12: Document Integration Document Integration Unit 13: Report-Report-Interface Report-Report-Interface Unit 14: Managing Query Objects Managing Query Objects Unit 15: Business Content Business Content Unit 16: Further SAP BI Reporting Tools Further SAP BI Reporting Tools Unit 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 Content Unit 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 DataSources Unit 3: Delta Management Delta Management: Overview Update Mode and Delta Process Examples from Applications / Source Systems Additional Notes Unit 4: Transfer of Flat Files Transfer of Flat Files Unit 5: Data Transfer With DB Connect Data Transfer with DB Connect Unit 6: Data Transfer with UDC Universal Data Integration Unit 7: XML-Based Extraction Using the Web AS SOAP Service XML Data Load Using a Web Service XML Data Load Using SAP XI Unit 8: Data Transfer with Third-Party ETL Tools Data Transfer with Third-Party ETL Tools Unit 9: Data Mart Interface Data Mart Interface Unit 10: Open Hub Service Introduction to the Open Hub Service Implementing the Open Hub Service Unit 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 Content Unit 2: Tracking History and Hierarchies Tracking History Unit 3: Modeling Characteristics and Key Figures SAP BW Star Schema Characteristic InfoObjects Key Figure InfoObjects Unit 4: Modeling ODS Objects Defining ODS Objects Standard ODS Objects in the SAP BW Data Warehouse Layer Unit 5: Multidimensional Modeling Designing the Dimensions of the SAP BW InfoCube Aggregate Modeling Unit 6: Changing the Data Model Modifying a Data Model Unit 7: Special Modeling Aspects SAP BW InfoSets Partitioning of InfoCubes Intercompany Elimination Cumulative and Non-Cumulative Unit 8: Summary Data Modeling Unit 9: Appendix Standard ODS Object Aggregate Performance Data Mining Unit 10: Data Modeling Case Study Data Modeling Case Study Introduction Data Modeling Case Study - Interviews Unit 11: SAP BW Overview with regards to Authorizations SAP BW Architecture and Administration Business Explorer Unit 12: Security Components in BW Comparison of OLTP and OLAP Security Needs Major Authorizations Objects Used in BW Unit 13: Securing Data Access for Reporting Users Securing Data Access for Reporting Users Unit 14: Securing Data Access for Administration Users Using Templates Monitoring Administration Users Unit 15: System Security System communication Security Maintaining Authorizations Structural Authorizations SAP BW/ mySAP ERP HCM Unit 16: BPS Authorizations Interaction Between Planning and Other SAP BW Activities BW BPS Authorization Objects Unit 17: Appendices Performance Measurement and Recommendation Duration: 5 Weeks (Saturdays) 50 Hours Total Teaching Method: Instructor-led and Hands On

sap bw training in houston, sap training in houston

Head Office 9896 Bissonnet, Suite 320 Houston TX 77036 USA