ابزار مصورسازی اوراکل: Create Analyses and Dashboards

IBIG-TR-165

  ابزار BI و visualization اوراکل: Create Analyses and Dashboards 

در این دوره دانشجویان با ابزار ساخت گزارشات ORACLE آَشنا خواهند شد و پس از اتمام دوره خواهند توانست گزارشات و داشبورد های تحلیلی را بر حسب نیاز های اطلاعاتی تولید و پیاده سازی نمایند. اهداف:

فراگیری نحوه ایجاد گزارشات در OBIEE

فراگیری نحوه ساخت داشبورد ها در OBIEE

فراگیری نحوه کار با فیلتر ها و عملگر ها

فراگیری مدیریت کاربران  

حضوری

    32  ساعت

یکشنبه و سه‌شنبه 18:00 تا 21:00

کاربران  BI

توسعه دهندگان سامانه های BI

تحلیل گران داده

تحلیل گران کسب وکار   

آشنایی با مفاهیم BI

آشنایی با مفاهیم مدیریت و IT

Introduction to Oracle Business Intelligence Enterprise Edition

• Introduction to Oracle BI EE
• Architecture overview
• Oracle BI EE sample application
• Overview of Oracle Exalytics Machine

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

Selecting and Grouping Data in Analyses

• Creating selection steps
• 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
• Performing common view tasks

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

Working with Additional Views in Analyses

• Creating simple and advanced trellis views
• Creating performance tile views
• Working other view types
• Linking master-detail views

Visualizing Data: Gauges and Maps

• Working with Gauge views
• 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

Working with BI Content in Smart View

• Working with Views in Smart View Clients
• Customizing BI data in MS Office
• Copying and pasting views between Smart View clients
• Copying and pasting views from Oracle BI Presentation services to Smart View
• Creating and publishing views using the View Designer
• Federating data from multiple data sources

Oracle Business Intelligence Mobile

• Downloading and using the Oracle BI mobile application
• Navigating the Oracle BI mobile application
• Working with favorites and local content
• Working with BI content
• Oracle BI Mobile Security Toolkit

Creating Mobile Applications with Oracle Business Intelligence Mobile App Designer

• Creating basic mobile apps
• Previewing mobile apps
• Creating apps with tile pages
• Creating subpages and navigation pages

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

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

 

Oracle BI Suite 11g R1: Build Repositories