Oracle BI 商业智能实战应用培训 OBIEE

课程周期：24学时 
培训费用：6000 元
使用教材：ORACLE 官方教材  
教材费用：包含教材费
学员收益：ORACLE最新商业智能技术，交大慧谷独家开班
咨询电话：021-64482972  64470100   
 
1、Introducing Oracle Business Intelligence Enterprise Edition
• Introduction to Oracle BI
• Architecture overview

2、Working with Oracle Business Intelligence Analyses
• Introduction to Oracle BI Analysis Editor
• Oracle BI column types
• Working with analyses in Oracle BI
• Using advanced formatting

3、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

4、Limiting and Grouping Data in Analyses
• Introduction to filters and selections
• Creating, editing, and grouping filters
• Adding prompts to analyses
• Dynamic filtering
• Using saved analyses as filters
• Creating groups
• Creating calculated items
• Creating selection steps

5、Oracle Business Intelligence Analyses: Advanced Features
• Setting analysis properties
• Combining analysis criteria by using set operations
• Executing direct database analyses
• Editing logical SQL generated by an analysis
• Creating a link to a saved analysis
• Creating an Excel Web Query file

6、Working with Views and Graphs in Analyses
• Introduction to views, graphs, and editors
• Working with views in Compound Layouts
• Creating and editing graphs
• Linking master-detail views
• Performing common view tasks

7、Visualizing Data: Gauges, Maps, and Mobile
• Working with Gauge views
• Creating and editing Map views
• Working with and searching content in BI Mobile

8、Measuring Results with Key Performance Indicators
• Creating KPIs, setting trending, dimensionality, and thresholds
• Creating a KPI Watchlist
• Changing Dimensionality for a KPI Watchlist event

9、Showing Results With Pivot Tables
• 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

10、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

11、Configuring Oracle Business Intelligence Dashboards
• Exploring types of dashboard content
• Embedding content in dashboards

12、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

13、Using Oracle Business Intelligence Delivers
• Configuring delivery devices and adding delivery profiles
• Adding an Alert Section to a dashboard
• Configuring an Agent
• Using Analysis and KPI conditions to deliver content with Agents
• Subscribing to an Agent

14、Integrating Analyses with MS Office
• Working with Oracle BI content in Microsoft Office applications

15、Working with Oracle Business Intelligence Briefing Books
• Adding content to Briefing Books
• Editing Briefing Books
• Downloading and viewing Briefing Books
• Adding a list of Briefing Books to a dashboard
• Using Briefing Books with Oracle BI Delivers

16、Scorecarding
• Identifying the objects and components of Oracle Scorecard and Strategy Management
• Creating a scorecard
• Editing a scorecard

中文大纲

第一部分
• ORACLE BI应用介绍和分析
• BIEE基础知识介绍
• Oracle BIEE的安装
• 分析器与仪表盘概况
• Oracle BIEE的概况
• 分析器的基本使用
• 展现目录的管理
• 分析器的过滤限制和排序

第二部分
• 分析器的高级功能
• 分析器的视图和图表的使用
• 分析器中使用计量器和地图功能显示结果
• KPI的度量结果
• 使用透视表展现结果
• 项目练习

第三部分
• 创建仪表盘展现结果
• 仪表盘的设置和排版
• OBIEE的建模
• 建模实验

对应认证:
Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist
（1Z0-591）