메뉴 건너뛰기

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

 

번호 제목 글쓴이 날짜 조회 수
49 SAP Supply Chain Resilience Conference - recordings file sapjoy 2020.11.24 162
48 [1월 KSUG 패널토크] "클라우드 SAP를 위한 혁신적 인프라에 대해 알아보기" 세션 사전등록 시작! (1/13, 목요일 마감) file KSUG(한국SAP사용자그룹) 2022.01.03 159
47 [사전 등록 시작!] KSUG 패널 토크: SAP S/4HANA 실 적용 기대 효과를 낱낱이 파헤쳐 보기 KSUG(한국SAP사용자그룹) 2021.05.03 153
46 [SAP교육사업본부] 소원빌기 이벤트! SAP 교육 및 자격증에 대한 소원을 남겨주세요! (스타벅스 모바일 쿠폰 증정) SAP교육사업본부 2021.08.31 152
45 [~11/11까지 Panel Talk 무료 사전등록] SAP S/4HANA의 운영효율을 향상시켜주는 방안 file KSUG(한국SAP사용자그룹) 2021.11.05 149
44 [12월 KSUG 패널토크] "SAP S/4HANA, 무엇이든 물어보세요!" 세션. 사전등록 시작! (~12/09 마감) file KSUG(한국SAP사용자그룹) 2021.12.01 145
43 [3월 패널 토크/사전 등록 기프티콘 이벤트] SAP 구축 및 운영 인력 부족을 극복하는 꿀팁 - 두번째 시간 KSUG(한국SAP사용자그룹) 2023.02.28 141
42 [SAP교육사업본부] 이달의 과정 - Processes in SAP Extended Warehouse Management(EWM) (신청 시 10% 할인!) SAP교육사업본부 2022.07.07 141
41 [7월 KSUG 패널토크/베스킨라빈스 기프티콘 이벤트] SAP 클라우드, 효율적인 운영 비결 알아보기 세션 사전등록 시작! KSUG(한국SAP사용자그룹) 2022.06.29 141
40 [SAP교육사업본부] FLASH4 캠페인 - 정규 교육 과정 4명 신청 시 1명은 50% 할인! SAP교육사업본부 2022.06.10 141
39 [SAP교육사업본부] SAP Learning Journey in Workflow Learning (7/14 웨비나 모집중!) SAP교육사업본부 2022.06.29 137
38 [새싹 영등포 캠퍼스] Kaggle, DACON 해커톤 수상, 넷마블 등 대기업 취업 성공한 AI 응용 전문인력 양성 file 새싹SeSAC 2023.06.20 129
37 [KSUG 스페셜 패널 토크 2탄/다양한 상품 이벤트] 2022 SAPPHIRE와 SAP Now Seoul, 핵심을 파헤쳐 보기 KSUG(한국SAP사용자그룹) 2022.06.03 128
36 [패스트레인] 국내최초! S/4HANA 블렌디드 교육 단독 출시! 패스트레인교육센터 2023.05.17 125
35 [12월 패널 토크/사전 등록 기프티콘 이벤트] SAP의 다양한 구축 사례 알아보기 - 효율적 S/4HANA 마이그레이션과 WMS 구축 중심으로 KSUG(한국SAP사용자그룹) 2022.11.25 124
34 [SAP교육사업본부] 강의 만족도 만점! SAP SuccessFactors EC 컨설턴트 과정 SAP교육사업본부 2023.09.08 121
33 [9월 KSUG 패널토크/던킨 기프티콘 이벤트] 전 임직원을 위한 디지털 증빙 기반의 출장 및 경비 관리 - Paperless 기반의 손쉬운 ESG 경영을 전 사원이 체험할 수 있습니다! 세션 사전등록 시작 KSUG(한국SAP사용자그룹) 2022.09.02 119
32 [11월 10일 패널 토크/사전 등록 기프티콘 이벤트] SAP PMC (Partner Managed Cloud)는 무엇이고 기존의 SAP클라우드와 어떻게 다른가? KSUG(한국SAP사용자그룹) 2023.11.01 118
31 SAP 교육 수강하고 카카오톡 기프티콘 선물 받자! file 패스트레인 2022.02.16 118
30 [SAP교육사업본부] 이달의 과정 - SuccessFactors EC 컨설턴트 기초 과정(신청 시 10% 할인!) SAP교육사업본부 2022.06.03 115