|
<1일차>
Data Warehousing
┕ Describing Data Warehouse Systems
┕ Describing Data Warehouse Architecture
┕ Using the Data Warehousing Workbench
Master Data Modeling in SAP BW
┕ Describing InfoObjects
┕ Creating Characteristic InfoObjects
The Loading of Master Data from SAP Data Sources
┕ Describing Data Flow
┕ Creating a Characteristic for a Master Data Flow
┕ Creating a Data Source and Transformation for a Master Data Flow
┕ Loading a Master Data Flow
┕ Modeling with the Graphical Data Flow Tool
<2일차>
Loading of Transaction Data from SAP DataSources
┕ Describing the Core InfoProviders
┕ Creating a Key Figure InfoObject
┕ Creating a DataStore Object (DSO)
┕ Loading Transaction Data into a DataStore Object (DSO)
┕ Activating data in a DataStore object
┕ Describing the Extended Star Schema of an InfoCube
┕ Creating InfoCubes
┕ Loading Transaction Data into an InfoCube
<3일차>
Master Data Loading from Flat File Data Sources
┕ Loading Data From a Flat File
┕ Describing the Data Flow in Detail
┕ Describing the Data Loading Process in Detail
<4일차>
InfoProviders in SAP BW
┕ Explaining Different InfoProviders Used in SAP BW
┕ Creating MultiProviders
SAP BI Content
┕ Using BI Content
<5일차>
Query Performance Optimization
┕ Optimizing Query Performance
┕ Monitoring Performance
┕ Creating and Filling Aggregates
SAP BW Administration
┕ Describing Administrative Tasks and Tools
┕ Administering the InfoCubes
┕ Administering the DataStore Objects
┕ Creating Process Chains
<6일차>
Enterprise Data Warehouse (EDW) Architecture
┕ Determining EDW Architecture
┕ Planning the Architecture of an EDW
┕ Using the EDW Layers
┕ Determining the Purpose of the Data Mart Layers
┕ Determining the Purpose of the Operational Data Store Layer
The Modeling Process
┕ Identifying Decision Areas within SAP BW Projects
┕ Performing Requirements Analysis
┕ Creating a Logical Data Model
┕ Developing the SAP BW Data Model
┕ Creating Graphical Data Models and Templates
<7일차>
Data Modeling Practice
┕ Drafting a Data Model
┕ Summarizing Data Modeling Practice
BI Content Analysis
┕ Listing the Uses of BI Content
┕ Comparing a Data Model with BI Content
InfoObject Models
┕ Listing the Tables in the SAP BW Data Model
┕ Implementing Tracking History Scenarios
┕ Using Reference Characteristics
┕ Using Hierarchies
┕ Using Key Figures
┕ Creating Translation Types for Currency Translation
┕ Creating Translation Types for Quantity Conversion
┕ Creating a Data Model for Mapping Non-Cumulative Values in SAP BW
<8일차>
Modeling DataStore Objects
┕ Modeling DataStore Objects
┕ Using Real Time Data Acquisition (RDA)
Multi-Dimensional Modeling
┕ Determining the SAP BW Star Schema
┕ Designing the Dimensions of the SAP BW InfoCube
<9일차>
Enhanced InfoProvider Modeling
┕ Modeling MultiProviders
┕ Modeling an SPO
┕ Modeling an InfoSet
┕ Modeling a VirtualProvider
┕ Modeling a HybridProvider
┕ Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree
Data Model Remodeling
┕ Modifying a Data Model
<10일차>
Information Lifecycle Management
┕ Describing Information Lifecycle Management
LSA++ with SAP BW on SAP HANA
┕ Determining the Advantages of SAP BW on SAP HANA
┕ Determining the Enhancements of LSA++ with SAP HANA
<11일차>
SAP BW Data Acquisition Process
┕ Explaining Data Acquisition in SAP BW
┕ Creating SAP BW 3.x Data Flow
┕ Comparing and Migrating 3.x / 7.x SAP BW Data Flows
┕ Directly Accessing Source System Data
┕ Loading Directly Without Persistent Staging Area (PSA)
┕ Reviewing Details of Real-Time Data Acquisition (RDA)
Data Acquisition with the SAP BW Service API
┕ Connecting SAP Source Systems to SAP BW
┕ Displaying the Configuration of SAP BW Service API
┕ Explaining Business Intelligence (BI) Content
┕ Examining the Transfer of GL Data
┕ Examining Generic DataSources
┕ Adapting BI Content DataSources
┕ Configuring Logistics Data Extraction
<12일차>
Delta Data Flow Management
┕ Describing Delta Management
┕ Explaining Terms and Basic Processes of Delta Enabled DataSources
┕ Analyzing Delta Management
Data Acquisition with ODP and SLT
┕ Describing Data Acquisition with ODP
┕ Analyzing Operational Delta Queue (ODQ)
┕ Replicating Data with SLT
┕ Acquiring Data in Real Time with SLT
<13일차>
Flat File Data Transfer
┕ Loading Data from a Flat File
┕ Loading Hierarchies in SAP BW Using the Hierarchy Framework
┕ Exporting a Hierarchy with OpenHub
Data Acquisition with DB Connect
┕ Creating a DB Connect DataSource
<14일차>
Data Acquisition with Universal Data (UD) Integration
┕ Creating UD Connect DataSources
XML-Based Data Acquisition
┕ Explaining XML-Based Extraction
┕ Acquiring Data Using an XML-Based Web Service
┕ Creating HybridProviders
<15일차>
Data Acquisition with SAP Data Services
┕ Integrating SAP Data Services and SAP BW
Data Mart Interface and OpenHub
┕ Examining the Data Mart Interface for Data Transfers
┕ Implementing OpenHub Destinations
<16일차>
SAP Business Warehouse (BW), Business Warehouse Accelerator (BWA)와 SAP HANA (High-performance Analytic Appliance) Overview
┕ Identifying the Components and Architecture of SAP BW, BWA, and SAP HANA
InfoProvider Administration
┕ Managing InfoCubes
┕ Managing DataStore Objects
┕ Managing MultiProviders
┕ Managing HybridProviders
┕ Managing Semantically Partitioned Objects (SPOs)
┕ Managing TransientProviders
┕ Managing Analytical Indexes
┕ Managing VirtualProviders
┕ Managing Real-Time Providers
┕ Creating a DataStore Object for Direct Update
<17일차>
Process Chain Administration
┕ Designing Process Chains
┕ Maintaining Process Chains
┕ Monitoring Process Chains
Data Acquisition Administration
┕ Starting the Data Load Cycle
┕ Examining the Technical Aspects of Data Acquisition
┕ Loading Master Data
┕ Using Transformations
┕ Monitoring Data Load
Trace Creation with BW Trace Tool
┕ Performing Traces with BW Trace Tool
Information Lifecycle Management
┕ Archiving Data in Information Lifecycle Management
┕ Querying Archived Data Using BW Near-Line Storage
BW Transports
┕ Describing the BW Transport System Landscape
┕ Determining Object Versions and Metadata
┕ Managing BW Transports
┕ Transporting BEx Objects
┕ Transporting Roles and Workbooks
┕ Troubleshooting Transport Strategies
<18일차>
Performance Management with BW InfoProvider Indexes
┕ Determining Relational Data Base Management System (DBMS) Indexes
┕ Indexing InfoProviders
Performance Optimization for InfoProviders
┕ Optimizing Performance for DataStore Objects
┕ Optimizing Performance for InfoCubes
┕ Optimizing Performance Using Semantically Partitioned Objects
┕ Optimizing Performance Using Analytical Indexes
┕ Optimizing Performance Using TransientProviders
┕ Improving Query Performance with Aggregates
┕ Optimizing Performance Using MultiProviders
┕ Optimizing Performance Using HybridProviders
Data Acquisition Performance Optimization
┕ Configuring Data Acquisition Parallel Processing
┕ Improving Data Acquisition Performance
┕ Loading and Activating DataStore Objects
<19일차>
Performance Through Partitioning
┕ Performing Table Partitioning
Performance in Reporting
┕ Designing Queries for Optimal Performance
┕ Optimizing Query Performance Using the Online Analytical Processing (OLAP) Cache
┕ Maintaining Query Read Mode Properties
Performance Management with BW Statistics
┕ Optimizing Performance with BW Statistics
┕ Implementing Technical Content for BW Statistics
┕ Administering and Analyzing BW Statistics Data
┕ Monitoring with BW Administration Cockpit
Performance Management with BWA
┕ Optimizing Performance with BWA
┕ Analyzing BWA Architecture
┕ Increasing Query Read Performance Using BWA Indexes
┕ Monitoring BWA
<20일차>
┕Certification
|
