سر فصل دوره  BI for Oracle

Concepts of Business Intelligence and Data Warehouse

• Introduction to BI
• OLAP & OLTP
• Fact & Dimension
• Star schema & Snowflake Models

Installation

• Install Oracle Business Intelligence

Introduction to Oracle Business Intelligenc

Enterprise Edition

• Introduction to Oracle BI EE

• Oracle BI 12c Highlights

• Oracle BI 12c Architecture

Working with Oracle Business Intelligence Analyses

• Adding basic formatting

• Working with analyses in Oracle BI

• Introduction to Oracle BI Analysis Editor

• Setting analysis properties

• Oracle BI column types

• Using advanced formatting

Filtering Data for Analyses

• Adding prompts to analyses

• Using saved analyses as filters

• Dynamic filtering

• Creating, editing, and grouping filters

• Introduction to filters and selections

Selecting and Grouping Data for Analysis

• Creating calculated items

• Including advanced SQL clauses in your analysis

• Creating selection steps

• Creating direct database analysis requests

• Creating groups

Advance Visualization in Analysis

• Working with views in Compound Layouts

• Performing common view tasks

• Introduction to views, graphs, and editors

• Creating and editing graphs

Showing Results with Pivot Tables

• Using hierarchical columns

• Building calculations and displaying running sums

• Showing an item's relative value

• Creating, arranging, and formatting a pivot table

• Setting aggregation and using totals

• Sorting in pivot tables

Working with Additional Views in Analyses

• Creating simple and advanced trellis views

• Creating performance tile views

• Linking master-detail views

• Working other view types like Treemap and Heat Matrix

Visualizing Data on Maps

• Oracle spatial components

• Managing map data

• Other applications and points of integration for map views

• Interacting with map views

• Creating and editing Map views

Creating Oracle Business Intelligence Dashboards

• Publishing dashboard pages

• Using the Dashboard Builder

• Exploring dashboard object properties and options

• Creating and editing dashboards

• Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

• Embedding content in dashboards

• Exploring types of dashboard content

Creating Dashboard Prompts and Variables

• Adding variable prompts to a dashboard

• Creating additional prompt page and setting page preferences

• Adding a named dashboard prompt to a dashboard

• Understanding variables

• Adding a hidden named dashboard prompt to a dashboard

Scorecards and Key Performance Indicators

• Editing scorecards and KPIs

• Objects and components of Oracle Scorecard and Strategy Management

• Creating scorecard documents

• Scorecard document types

• Creating scorecards and KPIs

• Key Performance Indicator (KPI) overview

Working with BI Content in Smart View

• Creating and publishing views using the View Designer

• Inserting BI views in to Smart View clients

• Working with Views in Smart View Clients

• Customizing BI data in MS Office

Oracle Business Intelligence Mobile

• Navigating the Oracle BI mobile application

• Oracle BI Mobile Security Toolkit

• Downloading and using the Oracle BI mobile application

• Working with BI content

• Working with favorites and local content

Administering the Presentation Catalog

• Working with Oracle BI Briefing Books

• Setting object permissions

• Setting system privileges

• Managing security using roles

• Oracle BI and catalog security overview

• Understanding security inheritance

• Archiving catalog items

Direct Database Analysis

• Creating and Executing a Direct Database Analysis

• Changing Direct Database Analysis Privileges

• Direct Database Analysis Overview

Repository Basics

• Loading a repository into Oracle BI Server

• Exploring a repository's structure, features, and functions

• Exploring Oracle BI architecture components

• Using the Oracle BI Administration Tool

• Creating a repository

• Installing the BI Client software

Building the Physical Layer of a Repository

• Examining physical layer object properties

• Importing data sources

• Setting up Connection Pool properties

• Defining keys and joins

Building the Business Model and Mapping Layer of a Repository

• Building logical tables, columns, and sources

• Building a business model

• Building measures

• Examining business model object properties

• Defining logical joins

Building the Presentation Layer of a Repository

• Exploring presentation layer objects

• Modifying presentation layer objects

• Examining presentation layer object properties

• Creating presentation layer objects

Testing and Validating a Repository

• Executing analyses to test the repository

• Uploading the repository through Enterprise Manager

• Checking repository consistency

Adding Calculations to a Fact

 

• Creating new calculation measures based on physical columns

• Creating measures using functions

• Creating new calculation measures using the Calculation Wizard

Working with Logical Dimensions

• Creating logical dimension hierarchies

Security

• Setting up object permissions

• Creating users and groups

• Exploring Oracle BI default security settings

• Creating application roles

 

Basic SQL Database design

♦ کارشناسان و توسعه دهندگان هوش تجاری

 

با خرید این دوره، ویدئوهای آموزشی در اختیار دانش پذیران عزیز قرار می گیرد که می توانید به طور کامل سرفصلهای اشاره شده را در ویدئوهای آموزشی مختلف دنبال نمایید. 

علاوه بر یادگیری مفاهیم هوش تجاری به اجرای کامل هوش تجاری در ارواکل خواهید پرداخت و به صورت عملی تمامی تمرینها و سرفصلها را دنبال خواهید کرد.

همچنین این امکان فراهم شده است که با گذراندن این دوره و مشاهده کامل ویدئوها، در آزمون پایانی شرکت نمایید و با کسب حدنصاب لازم گواهینامه پایان دوره را نیز دریافت نمایید.