LOGIN
ثبت نام یا ورود
Avatar
هنوز ثبت نام نکرده اید؟

هم اکنون عضو پلاک آبی شوید .و به اطلاعات وب سایت ما دسترسی داشته باشید

تنظیم مجدد کلمه عبور - نام کاربری را فراموش کرده ام

نام کاربری
کلمه عبور
مرا به خاطر بسپار

placabi consulting co.

  • کد دوره

    IBIG-TR-166
  • عنوان دوره

    Oracleابزار BI و visualization اوراکل:  Build Repositories 
  • معرفی دوره، هدف و کاربرد

    در این دوره دانشجویان با ابزار ساخت لایه MetaData در OBIEE آشنا خواهند شد و خواهند توانست برای ساخت داشبورد ها و گزارشات از این ساختار استفاده نمایند. اهداف:

    فراگیری نحوه ایجاد لایه های فیزیکی ، لایه مدل و لایه ارایه

    فراگیری نحوه ساخت فیلد های محاسباتی ، Messure ها ، Dimension ها

    فراگیری نحوه ساخت MetaData Repository  

  • نحوه برگزاری

    حضوری
  • مدت دوره

        40 ساعت
  • روزهای برگزاری

    یکشنبه و سه‌شنبه: 18:00 تا 21:00
  • مخاطبین دوره

    کاربران  BI

    توسعه دهندگان سامانه های BI

    تحلیل گران داده

    تحلیل گران کسب وکار

    کارشناسان انباره داده   

  • پیش نیاز

    آشنایی با مفاهیم BI

    آشنایی با مفاهیم انباره داده

    آشنایی با مفاهیم Dimensional Modeling

  • محتوای دوره

    Repository Basics

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

    Building the Physical Layer of a Repository

    • Importing data sources
    • Setting up Connection Pool properties
    • Defining keys and joins
    • Examining physical layer object properties
    • Creating alias tables
    • Printing the physical layer diagram

    Building the Business Model and Mapping Layer of a Repository

    • Building a business model
    • Building logical tables, columns, and sources
    • Defining logical joins
    • Building measures
    • Examining business model object properties
    • Printing the business model and mapping layer diagram

    Building the Presentation Layer of a Repository

    • Exploring presentation layer objects
    • Creating presentation layer objects
    • Modifying presentation layer objects
    • Examining presentation layer object properties
    • Nesting presentation tables
    • Controlling presentation layer object visibility

    Testing and Validating a Repository

    • Checking repository consistency
    • Turning on logging
    • Uploading the repository through Enterprise Manager
    • Executing analyses to test the repository
    • Inspecting the query log

    Managing Logical Table Sources

    • Adding multiple logical table sources to a logical table
    • Specifying logical content

    Adding Calculations to a Fact

    • Creating new calculation measures based on logical columns
    • Creating new calculation measures based on physical columns
    • Creating new calculation measures using the Calculation Wizard
    • Creating measures using functions

    Working with Logical Dimensions

    • Creating logical dimension hierarchies
    • Creating level-based measures
    • Creating share measures
    • Creating dimension-specific aggregation rules
    • Creating presentation hierarchies
    • Creating parent-child hierarchies
    • Creating ragged and skipped-level hierarchies

    Enabling Usage Tracking

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

    Using Model Checker and Aggregates

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

    Using Partitions and Fragments

    • Exploring partition types
    • Modeling partitions in an Oracle BI repository

    Using Repository Variables

    • Creating session variables
    • Creating repository variables
    • Creating initialization blocks
    • Using the Variable Manager
    • Using dynamic repository variables as filters

    Modeling Time Series Data

    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data

    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

    • Ensuring the correct results for dimension-only queries
    • Selecting a predetermined fact table source
    • Specifying a default join path between dimension tables

    Importing Metadata from Multidimensional Data Sources

    • Importing a multidimensional data source into a repository
    • Incorporating horizintal federation into a business model
    • 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

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

    Cache Management

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

    Exploring the Summary Advisor Tool

    • Setting up Summary Advisor
    • Running the Summary Advisor wizard to create the aggregate script
    • Running the aggregate script to create the aggregates

    Using Administration Tool Utilities

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

    Multiuser Development

    • Setting up a multiuser development environment
    • Developing a repository using multiple developers
    • Tracking development project history

    Performing a Patch Merge

    • Comparing repositories
    • Equalizing objects
    • Creating a patch
    • Applying a patch
    • Making merge decisions

     

    •   

    • پیشنهاد تکمیلی

     

     تماس با ما

    شهرک غرب، بلوار فرحزادی، خیابان تربیت معلم،
    انتهای خیابان گلبان،
    مجتمع موج، واحد 105
    کد پستی: 1998963193
    تلفن: 5 - 88560784
    فکس: 88560786
    پست الکترونیک:
    info @ p l a c a b i . com
    ibig @ p l a c a b i . com

     

    We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…