Brainmatics

Oracle Business Intelligence

Master Oracle Business Intelligence 11g Report dan Dashboard memberikan informasi bisnis yang sangat berarti kepada pengguna kapan saja, di mana saja dan pada perangkat apapun, dengan Oracle Business Intelligence 11g. Laporan bisnis dan dashboard sangat penting, maka training Oracle Business Intelligence 11g ini sangatlah anda butuhkan untuk dapat membangun Business Intellegence yang mencakup desain laporan terbaru BI dan teknik distribusi sehingga kebutuhan penyajian informasi bisnis tersebut dapat tercapai dan tersampaikan ke pengguna dengan lengkap, akurat, up to date dan flexible.

Pada trainng ini anda akan mempelajari bagaimana mengeksekusi query yang efektif, membangun model yang akurat, menggunakan Scorecard dan KPI, membuat laporan dinamis, membuat dashboard, dan mempublikasikan ke smartphone dan perangkat nirkabel.

SKILL REQUIREMENTS

  1. Memiliki pengetahuan mengenai Dimensional modeling.
  2. Memiliki pengetahuan dasar SQL.
  3. Memiliki pengetahuan mengenai desain Data Warehouse.

 

OBJECTIVES

1. Install atau upgrade ke Business Intelligence 11g
2. Membangun dan mengatur repositori Oracle Business Intelligence
3. Mengakses relational, file, dan sumber data multidimensional
4. Mendesain laporan dengan Oracle Business Intelligence Publisher
5. Mengaktifkan analisis berbasis web, membuat dashboard, and visualisasi
6. Mengintegrasikan dengan aplikasi lain menggunakan Oracle Business Intelligence 11g Action Framework
7. Menggunakan authentication, authorization, dan row-level security
8. Konfigurasi dan penerapan Oracle Exalytics In-Memory Machine

CONTENT

I. Understanding the Oracle BI 11g Architecture

  1. Understanding the Oracle Fusion Middleware
  2. An application server by any other name
  3. A database repository
  4. WebLogic Server
  5. Oracle Process Management and Notification system
  6. Security
  7. System requirements
  8. Scaling out Oracle BI 11g
  9. Directory folder structure

II. Installing the Metadata Repository

  1. Repository Creation Utility (RCU)
  2. Running the RCU

III. Installation Options

  1. Oracle BI on its own server
  2. Simple versus Software Only Installation
  3. Custom static ports
  4. Installing Oracle BI 11g on *Nix
  5. Listening on port 80
  6. Automate starting and stopping
  7. Ancillary application integration awareness
  8. Recommendations for further learning

IV. Understanding the Systems Management Tools

  1. Management tools
  2. WebLogic Server Administration Control
  3. Using WLST
  4. Enterprise Manager Fusion Middleware Control
  5. Creating the Tennis users, roles, and associations
  6. Configuring an LDAP identity provider in WLS
  7. JMX, MBeans, and Java
  8. Migrating FMW Security to other environments
  9. Oracle BI Publisher system management
  10. Monitoring system performance
  11. Backup plan

V. Upgrading the RPD and Web Catalog to 11g

  1. Upgrading an RPD and Web Catalog
  2. Upgrade Assistant
  3. Verification
  4. Upgrading BI Scheduler
  5. Manual migration
  6. Consistency check
  7. Security
  8. Regression testing

VI. Reporting Databases

  1. Theories and models
  2. Designing your database — objectives, rules, and goals
  3. Creating a warehouse

VII. Developing a BI Repository

  1. Prerequisites
  2. Repository architecture
  3. Physical layer
  4. Business layer
  5. Presentation layer
  6. Calculated measures
  7. Federated and fragmented content
  8. Variables and initialization blocks

VIII. Features of the Presentation Catalog

  1. Integrated tools
  2. The Home screen
  3. Administration
  4. The Presentation Catalog

IX. Creating Dashboards and Analysis

  1. Analysis versus Reporting
  2. Creating an Analysis
  3. Building Dashboards
  4. Some advanced options
  5. Security
  6. Design — best practices
  7. Additional research suggestions

X. Agents and the Action Framework

  1. Agents
  2. Actions

XI. Developing Reports Using BI Publisher

  1. The installation integration checkpoint
  2. BI Publisher excels
  3. BI Publisher – Published Reporting
  4. Oracle BI Foundation versus Oracle BI Publisher
  5. New features and enhancements
  6. Report design basics, terminology, and locations
  7. Let’s get publishing
  8. Auditing and monitoring BI Publisher
  9. BI Publisher nuances

XII. Customizing the Style of Dashboards

  1. Multiple skins and styles in one environment
  2. A strategy for something seemingly simple
  3. General knowledge and tools
  4. Third-party tools
  5. Developing/designing a new look and feel

XIII. Improving the Performance

  1. What is poor performance?

XIV. Using the BI Admin Change Management Utilities

  1. Problems with multiple developers
  2. Merges
  3. Multi-User development

XV. Usage Tracking

  1. Understading usage tracking
  2. System setup

XVI. Oracle Essbase and OLAP Integration

  1. A bit about OLAP
  2. Oracle Essbase Studio
  3. Oracle BI SampleApp v107+ VM image
  4. Getting started — let’s get set up
  5. Modeling Essbase into Oracle BI
  6. Federation of data
  7. Oracle BI/EPM roadmap

 

 OPERATING SYSTEM

  1. Windows

 

INSTRUCTOR

 

Ananias Ardiles Sembiring. Lahir di Pematang Siantar, 3 September 1983. Menyelesaikan pendidikan S1 di ITB pada tahun 1996, telah tersertifikasi OCP, dan OCA. Berpengalaman menjadi Database Administrator selama 7 tahun, dan berpengalaman mengajar Oracle selama 5 tahun di beberapa lembaga training di Jakarta.