توضیحات

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

در این دوره دانشجویان با نحوه نصب، ساخت KPI، Dashboards، Analysis، گزارشات مبتنی بر موبایل، Map و مصور سازی جغرافیایی، شخصی سازی گزارشات و اعمال دسترسی های لازم بر روی subjectها ، ایجاد و مدیریتrepository آشنا خواهند شد.

قابل ذکر است این دوره تلفیقی از دوره های Data Warehousing Fundamentals ، Crate Analyses And Dashboards، Build Repositories اوراکل می باشد.


مخاطبان دوره

کارشناسان و توسعه دهندگان هوش تجاری
توانایی پس ازگذراندن دوره

آشنایی با مفاهیم، پیاده سازی، توسعه و پشتیبانی هوش تجاری در سازمان
سرفصلهای دوره



Concepts of Business Intelligence and Data Warehouse

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

Installation

Repository Creation Utility
Install Oracle Business Intelligence

Introduction to Oracle Business Intelligence Enterprise Edition

Introduction to Oracle BI EE
Architecture overview
Oracle BI EE sample application

Working with Oracle Business Intelligence Analyses

Introduction to Oracle BI Analysis Editor
Oracle BI column types
Working with analyses in Oracle BI
Adding basic formatting
Setting analysis properties
Using advanced formatting

Filtering Data for Analyses

Introduction to filters and selections
Creating, editing, and grouping filters
Adding prompts to analyses
Dynamic filtering
Using saved analyses as filters

Grouping Data in Analyses

Creating groups
Creating calculated items
Creating direct database analysis requests
Including advanced SQL clauses in your analysis

Adding Views to Analyses

Introduction to views, graphs, and editors
Working with views in Compound Layouts
Creating and editing graphs

Showing Results with Pivot Tables

OLAP data source compatibility
Creating, arranging, and formatting a pivot table
Using hierarchical columns
Sorting in pivot tables
Setting aggregation and using totals
Showing an item's relative value
Building calculations and displaying running sums

Visualizing Data: Maps

Oracle spatial components
Managing map data
Creating and editing Map views
Interacting with map views
Other applications and points of integration for map views

Scorecards and Key Performance Indicators

Objects and components of Oracle Scorecard and Strategy Management
Key Performance Indicator (KPI) overview
Scorecard document types

Measuring Results with Scorecards and KPIs

Creating scorecards and KPIs
Creating scorecard documents
Editing scorecards and KPIs

Creating Oracle Business Intelligence Dashboards

Creating and editing dashboards
Using the Dashboard Builder
Exploring dashboard object properties and options
Publishing dashboard pages
Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

Exploring types of dashboard content
Embedding content in dashboards

Creating Dashboard Prompts and Variables

Understanding variables
Adding a named dashboard prompt to a dashboard
Adding a hidden named dashboard prompt to a dashboard
Creating additional prompt page and setting page preferences
Adding variable prompts to a dashboard

Integrating BI Content with MS Office

Overview of the Oracle BI Add-in for Microsoft Office
Installing Smart View
Creating Oracle BI EE connections in Smart View
Inserting BI views in to Smart View clients

Creating Mobile Applications with Oracle Business Intelligence Mobile App Designer

Enhancements to Oracle BI Mobile – Android and Apple iOS
BI Mobile App Designer
Creating mobile apps
Previewing mobile apps
Stoplight Formatting
Creating apps with tile pages
Creating subpages and navigation pages

Administering the Presentation Catalog

Oracle BI and catalog security overview
Managing security using roles
Understanding security inheritance
Setting object permissions
Setting system privileges
Archiving catalog items
Working with Oracle BI Briefing Books

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

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

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

Using Repository Variables

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

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