|
SAP 교육을 통하여 SAP 솔루션을 다양하게 활용하고, 투자대비 효율성을 최대화하실 수 있습니다.
SAP 교육은 SAP의 지식과 기술을 다양한 교육커리큘럼과 서비스를 통해 보다 효율적으로 제공하고, 지속적이고 종합적인 교육을 위한 설계와 이행을 도와드립니다.
* IT 투자 대비 수익 향상
* 비즈니스 프로세스 관리의 효율화와 고급화
* 업무능력향상으로 인한 총비용 절감
* 시스템 이해도 향상으로 인한 비즈니스 위험 완화
|
| Analytics > [아카데미] BI 1: BW Query Design and Analysis |
|
|
|
|
| 과정 개요 |
|
본 과정은 BW를 위한 쿼리의 구성와 분석을 수행할 수 있도록 합니다.
|
|
|
| 과정 목표 |
▷Data Warehousing
▷Navigation Options in Reports
▷Simple Queries
▷Key Figures and Structures in Queries
▷Queries with Multiple Structures
▷Characteristics and Hierarchies in Queries
▷Variables in Queries
▷Exceptions and Conditions in Queries
▷Report-Report Interface
▷Query Performance Optimization
▷Queries Management and Authorizations Overview
▷Reporting Options
|
|
|
|
|
|
| 교육 대상 |
애플리케이션 컨설턴트
비즈니스 애널리스트
비즈니스 사용자
개발자
|
|
|
| 교육 내용 |
<1일차>
Data Warehousing
┕ Describing Data Warehousing
┕ Describing Data Warehouse Architecture
┕ Using Reporting Tools
Navigation Options in Reports
┕ Using the Navigation Options in Reports
┕ Saving Analysis Views and Workbooks
Simple Queries
┕ Creating Simple Queries
┕ Finding a Query
┕ Filtering Query Definition Data
┕ Configuring Query Properties
<2일차>
Key Figures and Structures in Queries
┕ Creating Restricted Key Figures
┕ Creating Calculated Key Figures
┕ Creating a New Formula with Boolean Operators
┕ Configuring Properties of Key Figures
┕ Using Exception and Nested Exception Aggregation
Queries with Multiple Structures
┕ Creating Structures
┕ Resolving Formula Collision
┕ Designing Detailed Queries with the Cell Editor
<3일차>
Characteristics and Hierarchies in Queries
┕ Configuring the Properties of Characteristics
┕ Running Display and Navigation Attribute Queries
┕ Adding Hierarchies to Reports
┕ Using Hierarchies and Structures
┕ Adding External Hierarchies to a Report
┕ Creating External Hierarchies
Variables in Queries
┕ Using Variables
┕ Creating Characteristic Value and Text Variables in Queries
┕ Creating Hierarchy and Hierarchy Node Variables in Queries
┕ Creating Formula Variables in Queries
┕ Activating Business Content Variables
<4일차>
Exceptions and Conditions in Queries
┕ Creating Exceptions in Query Design
┕ Creating Conditions in Query Design
Report-Report Interface
┕ Using the Report-Report Interface
<5일차>
Query Performance Optimization
┕ Optimizing Query Performance
┕ Configuring Query Read Mode
┕ Using Performance Monitoring Tools
Queries Management and Authorizations Overview
┕ Managing Query Objects 21 Describing Authorizations
Reporting Options
┕ Outlining Reporting Options for SAP BW
|
|
|
|
