메뉴 건너뛰기

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

 

번호 제목 글쓴이 날짜 조회 수
198 ♥ 청년취업사관학교 새싹(SeSAC) 영등포캠퍼스 6기 SW과정 모집 (~ 04.21) ♥ file 새싹SeSAC 2024.03.25 60
197 [솔데스크] SAP ABAP개발자 교육 50% 할인 프로모션 과정 교육생 모집중!!!(~4/26) file 솔데스크 2024.03.14 117
196 [3/15 패널 토크, 기프티콘 이벤트] S/4HANA와 외부의 좋은 어플리케이션을 통합 사용하기 KSUG(한국SAP사용자그룹) 2024.03.04 81
195 [SAP교육사업본부] 3월 SAP 추천과정 (BC 아카데미, S/4HANA SD 아카데미, S/4HANA 프로그래밍 기초 등) file SAP교육사업본부 2024.02.21 198
194 [2월 16일 패널 토크/사전 등록 기프티콘 이벤트] 사전에 꼭 알아야 하는 S/4HANA 클라우드 구축에 대한 핵심 정리 및 사례 KSUG(한국SAP사용자그룹) 2024.02.06 73
193 [로그원코리아 - SAP 온라인 교육] 신규 론칭 : SAP S/4HANA 마스터 패키지 (화상교육+인강+응시권) *Cloud ABAP 추가* SAPedu 2024.01.30 197
192 [SAP교육사업본부] 카톡 플친 맺고, 할인 쿠폰 받으세요! (SAP 정규교육/ 인증시험) file SAP교육사업본부 2023.12.29 226
191 [솔데스크 3월 개강반 ] SAP ABAP 개발자 과정 24년 첫 기수 모집중~!! file 솔데스크 2023.12.20 346
190 [SAP교육사업본부] 12월 SAP 추천과정 (S/4HANA FI, HANA system admin, ABAP programming for HANA 등) SAP교육사업본부 2023.11.29 310
189 [12월 8일 패널 토크/사전 등록 기프티콘 이벤트] SAP와 연계하여 디지털 전환을 선도하는 혁신 솔루션 소개 KSUG(한국SAP사용자그룹) 2023.11.28 53
188 [11월 10일 패널 토크/사전 등록 기프티콘 이벤트] SAP PMC (Partner Managed Cloud)는 무엇이고 기존의 SAP클라우드와 어떻게 다른가? KSUG(한국SAP사용자그룹) 2023.11.01 93
187 [솔데스크12월 개강반 ] SAP ABAP개발자 과정 올해 마지막 교육과정 선착순 모집중!! [4] 솔데스크 2023.10.18 461
186 [SAP교육사업본부] 11월 SAP 추천과정 (CDS ABAP 과정, SFSF EC 기초과정, ABAP 아카데미 등) SAP교육사업본부 2023.10.17 196
185 [SAP교육사업본부] (무료웨비나) 최적의 ROI로 국내/외 직원 효과적으로 교육하기 SAP교육사업본부 2023.10.13 90
184 [10월 13일 패널 토크/사전 등록 기프티콘 이벤트] 특집 - SAP 데이타를 활용한 혁신적인 통합 분석 사례 KSUG(한국SAP사용자그룹) 2023.10.12 61
183 [SAP교육사업본부] ★전액무료/ 취업지원★ SAP Young Next Cloud 아카데미 4기 교육생 모집! (~11/7) SAP교육사업본부 2023.09.27 420
182 [SAP교육사업본부] BTP 전문가로 스킬-업! SAP Integration Suite 과정 SAP교육사업본부 2023.09.15 146
181 [SAP교육사업본부] 10월 SAP 추천과정 (SAP Integration Suite, BTP 기초 과정 등) SAP교육사업본부 2023.09.14 175
180 [SAP교육사업본부] 강의 만족도 만점! SAP SuccessFactors EC 컨설턴트 과정 SAP교육사업본부 2023.09.08 115
179 [9월 8일 패널 토크/사전 등록 기프티콘 이벤트] 보다 심도 있는 SAP 구축 및 운영 사례 - 서비스 산업 KSUG(한국SAP사용자그룹) 2023.09.01 70