바로가기 메뉴
본문 바로가기
주메뉴 바로가기

Oracle

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 중급 Oracle BI 11g R1: Build Repositories 1차
교육기간 2019-04-15 ~ 2019-04-19
교육시간 09:30~17:00(1일 6시간, 총 30시간)
교육장 영우글로벌러닝  지도보기
강사
정원 20명
교육비 3,005,000원(VAT별도)


교육소개
This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three
교육목표
○ Build and run analyses to test and validate a repository
○ Build simple and calculated measures for a fact table
○ Create logical dimension hierarchies and level-based measures
○ Check the model and then model aggregate tables to speed query processing
○ Model partitions and fragments to improve application performance and usability
○ Use variables to streamline administrative tasks and modify metadata content dynamically
○ Use time series functions to support historical time comparison analyses
○ Set up security to authenticate users and assign appropriate permissions and privileges
○ Build the Physical, Business Model and Mapping, and Presentation layers of a repository
○ Apply cache management techniques to maintain and enhance query performance
○ Set up query logging for testing and debugging
○ Set up a multiuser development environment
○ Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
○ Enable usage tracking to track queries and database usage, and improve query performance
○ Perform a patch merge in a development-to-production scenario
○ Describe Exalytics machine and the Summary Advisor tool used in the machine
교육대상
Application Developers / Business Analysts / Data Warehouse Analyst / Technical Consultant
/ Data Modelers / Reports Developer / Business Intelligence Developer / Data Warehouse Administrator
교육내용

 

□ Course Topics

 

○ Repository Basics
Using the Oracle BI Administration Tool
Creating a repository
Overview of Exalytics Machine
Loading a repository into Oracle BI Server
Exploring a repository's structure, features, and functions
Exploring Oracle BI architecture components
Installing the BI Client software 


○ Building the Physical Layer of a Repository
Setting up Connection Pool properties
Creating alias tables
Printing the physical layer diagram
Examining physical layer object properties
Defining keys and joins
Importing data sources


○ Building the Business Model and Mapping Layer of a Repository
Building logical tables, columns, and sources
Examining business model object properties
Building measures
Building a business model
Defining logical joins
Printing the business model and mapping layer diagram


○ Building the Presentation Layer of a Repository
Creating presentation layer objects
Nesting presentation tables
Modifying presentation layer objects
Controlling presentation layer object visibility
Exploring presentation layer objects
Examining presentation layer object properties


○ Testing and Validating a Repository
Checking repository consistency
Uploading the repository through Enterprise Manager
Turning on logging
Inspecting the query log
Executing analyses to test the repository


○ Managing Logical Table Sources
Specifying logical content
Adding multiple logical table sources to a logical table


○ Adding Calculations to a Fact
Creating new calculation measures based on logical columns
Creating measures using functions
Creating new calculation measures based on physical columns
Creating new calculation measures using the Calculation Wizard


○ Working with Logical Dimensions
Creating level-based measures
Creating logical dimension hierarchies
Creating share measures
Creating parent-child hierarchies
Creating dimension-specific aggregation rules
Creating presentation hierarchies
Creating ragged and skipped-level hierarchies


○ Enabling Usage Tracking
Using usage tracking statistics to optimize query performance and aggregation strategies
Tracking and storing Oracle BI Server usage at the detailed query level
Creating the usage tracking tables
Setting up the sample usage tracking repository


○ Using Model Checker and Aggregates
Using the Aggregate Persistence Wizard
Testing aggregate navigation
Modeling aggregate tables to improve query performance
Setting the number of elements in a hierarchy
Using Model Check Manager


○ Using Partitions and Fragments
Exploring partition types
Modeling partitions in an Oracle BI repository


○ Using Repository Variables
Creating repository variables
Using the Variable Manager
Creating initialization blocks
Creating session variables
Using dynamic repository variables as filters


○ Modeling Time Series Data
Using Oracle BI time series functions to model time series data
Using time comparisons in business analysis


○ Modeling Many-to-Many Relationships
Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables


○ Setting an Implicit Fact Column
Selecting a predetermined fact table source
Specifying a default join path between dimension tables
Ensuring the correct results for dimension-only queries


○ Importing Metadata from Multidimensional Data Sources
Incorporating horizintal federation into a business model
Importing a multidimensional data source into a repository
Incorporating vertical federation into a business model
Adding Essbase measures to a relational model
Displaying data from multidimensional sources in Oracle BI analyses and dashboards


○ Security
Setting row-level security (data filters)
Setting up object permissions
Creating application roles
Exploring Oracle BI default security settings
Creating users and groups
Setting query limits and timing restrictions


○ Cache Management
Modifying cache parameters and options
Seeding the cache
Purging cache entries
Using Cache Manager
Inspecting cache reports
Restricting tables as non-cacheable


Exploring the Summary Advisor Tool
Setting up Summary Advisor
Running the aggregate script to create the aggregates
Running the Summary Advisor wizard to create the aggregate script


○ Using Administration Tool Utilities
Using the various Administration Tool utilities
Using BI Server XML API to create XML representation of repository metadata


○ Multiuser Development
Developing a repository using multiple developers
Setting up a multiuser development environment
Tracking development project history


○ Performing a Patch Merge
Applying a patch
Creating a patch
Making merge decisions
Comparing repositories
Equalizing objects

 

학원의 설립ㆍ운영 및 과외교습에 관한 법률 시행령에 따라 다음과 같이 수강료를 환불해드립니다.

  1. 반환기한 : 반환사유가 발생한 경우 반환기준에 따라 반환사유 발생일로부터 5일 이내에 교습비등을 환불해 드리겠습니다.
  2. 반환기준
    • 1) 교습을 할 수 없거나 교습장소를 제공할 수 없게 된 날을 기준으로 이미 납부한 교습비등을 일할 계산한 금액을 환불해 드리겠습니다.
    • 2) 교습기간이 1개월 이내인 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 총 교습시간 1/3 경과 전 : 이미 납부한 교습비등의 2/3에 해당하는 금액
      - 총 교습시간 1/2 경과 전 : 이미 납부한 교습비등의 1/2에 해당하는 금액
      - 총 교습시간 1/2 경과 후 : 반환하지 않음
    • 3) 교습기간이 1개월을 초과하는 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 교습시작 후 : 반환사유가 발생한 해당월의 반환 대상 교습비등(교습기간 1개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액