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)
培训特色 授课讲师特聘原厂讲师,拥有丰富的企业应用能力、实际经验和丰富的授课经验