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
|
|
|
|