메뉴 건너뛰기

SAP 한국 커뮤니티

edmimage.png

 

[아카데미] BW All: Business Warehousing

본 과정은 SAP ERP의 데이터(관계사 MIS, Non SAP)를 중심으로 경영층 및 현업직원들에게 경영정보 및 의사결정 분석기반 제공을 가능하게 하는 SAP의 솔루션으로 Business Information Warehouse (BW)에 대한 전반적인 이해와 구축방법을 습득하게 됩니다. .

 

과정목표

 

 

SAP Net Weaver BI 개요

 

BI Data Warehouse 레이어 내의 오브젝트

 

SAP 소스 시스템으로부터의 데이타 수집 및 변환

 

▷ 타 시스템에서의 데이타 수집

 

▷ 기타 InfoProviders

 

▷ 데이타 대상 관리

 

▷ 쿼리성능 최적화 소개

 

 

본 교육을 이수하신 분들은 아래 SAP Certification에 응시하실 수 있습니다.

 

[C_TBW60] SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4

 

시험 범위 확인하기

 

교육일정

2019-05-06() ~ 2019-05-31() ( 20)

교육시간

09:00 ~ 17:00

교육내용

 

 

<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

 

 

교 육 비

6,640,000 (VAT별도)

교육신청

바로가기


SAP Korea Off-line Education Center
Tel : 02-2194-2660 | E-mail : education.korea@sap.com | Website : www.saptraining.co.kr | 카카오톡 1:1 문의 : 바로가기

SAP Korea On-line Education Center
Tel : 02-552-6120 | E-mail : sap@edserv.co.kr | Website : www.sapelearning.co.kr

SAP Korea Certification Center
Tel : 02-2194-2490 | E-mail : certification.korea@sap.com | Website : www.saptraining.co.kr