메뉴 건너뛰기

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

 

번호 제목 글쓴이 날짜 조회 수
118 ★전액무료/ 취업지원★ SAP Young Next Cloud 아카데미 1기 교육생 모집! (~5/26) SAP교육사업본부 2022.04.29 850
117 [솔데스크 7월 개강반모집] SAP ABAP 개발자 과정 프로모션 50% 할인 과정 모집중!! file 솔데스크 2022.04.29 249
116 [SAP교육사업본부] 강사가 추천하는 SAP 5월 핫 과정 SAP교육사업본부 2022.04.27 168
115 [SAP교육사업본부] 5월 SAP 추천 과정 (SAP S/4HANA CO아카데미, SAP HR 아카데미 등) SAP교육사업본부 2022.04.19 214
114 SAP 자동화 교육 소개(무료 RPA Power Automate) file sapjoy 2022.04.10 573
113 [SAP교육사업본부] 5월 HR 아카데미 개강 확정 SAP교육사업본부 2022.03.31 175
112 [4월 KSUG 패널토크/스타벅스 기프티콘 이벤트] ERP 운영 효과를 극대화 할 수 있는 사례 엿보기 세션 사전등록 시작! KSUG(한국SAP사용자그룹) 2022.03.29 114
111 [SAP교육사업본부] 4월 SAP 추천 과정 (S/4HANA BC, SAP UI5, HANA 이중화/재해복구 과정 등) SAP교육사업본부 2022.03.25 204
110 [SAP교육사업본부] 3월 BC 아카데미 개강 확정 SAP교육사업본부 2022.03.15 177
109 [로그원코리아-SAP온라인교육] SAP S/4HANA FI/CO/MM/PP/SD 올인원패키지 런칭!(4월부터 구매 가능) SAPedu 2022.03.11 302
108 [3월 KSUG 패널토크/스타벅스 기프티콘 이벤트] "클라우드 시대의 주요 보안 위협 요소와 솔루션 알아보기" 세션 사전등록 시작! KSUG(한국SAP사용자그룹) 2022.02.28 87
107 [SAP교육사업본부] 3월 SAP 추천 과정 (S/4HANA SD, S/4HANA DO, BC 등) SAP교육사업본부 2022.02.23 240
106 [패스트레인] SAP 2-3월 개설과정입니다. file 패스트레인 2022.02.16 168
105 SAP 교육 수강하고 카카오톡 기프티콘 선물 받자! file 패스트레인 2022.02.16 116
104 [솔데스크 4월 개강안내]SAP ABAP개발자 프로모션 할인 과정 모집!(교육비 인상전 마지막 과정) file 솔데스크 2022.02.16 280
103 [SAP교육사업본부] 2월 SAP 추천 과정 (S/4HANA SD, S/4HANA Fi, BC 등) SAP교육사업본부 2022.02.07 242
102 [2월 KSUG 패널토크] "부정한 자금 유출 등, 리스크 관리를 통한 부정 방지 방안에 대해 알아보기" 세션 사전등록 시작! (2/10, 목요일 이벤트 마감) file KSUG(한국SAP사용자그룹) 2022.02.03 91
101 [1월 KSUG 패널토크] "클라우드 SAP를 위한 혁신적 인프라에 대해 알아보기" 세션 사전등록 시작! (1/13, 목요일 마감) file KSUG(한국SAP사용자그룹) 2022.01.03 159
100 [SAP개발자 과정 할인 프로모션] 솔데스크 22년 2/12일 개강반 접수 시작합니다.(선착순 마감) file 솔데스크 2021.12.30 310
99 [SAP교육사업본부] 1월 SAP 추천 과정 (S/4HANA Programming, S/4HANA Overview, SAP Fiori 등) SAP교육사업본부 2021.12.29 353