title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle BI 11g: Create Analyses & Dashboards
Duration
2 Days
Course
DBOR-940
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle BI 11g: Create Analyses & Dashboards course is designed to provide students with a step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. Students will learn the concepts, methods and techniques for building sophisticated data analytic modules, along with organizing analytic results into interactive dashboards. Students will have a solid in order to progress onto the latest and most advanced data analytic capabilities.Objectives
Upon completion of the Oracle BI 11g: Create Analyses & Dashboards course, students will be able to:
- Understand background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
- Explain background concepts regarding logical data models, star schema and snowflake schema warehouse models.
- Build analytical models using fact tables, dimensions, dimension hierarchies, cubes, measures and other multidimensional data model objects.
- Use interactive Dashboards to analyze data, uncover trends and make strategic business decisions.
- Export BI results to productivity software such as Microsoft Office or other external systems.
- Design customized Dashboards to reflect an individual's role, perspective or business interest.
- Create data analyses and dynamically interact with results produced from Oracle BI.
- Form analyses using sorts, filters and prompts.
- Format column output, subtotaling, customization of column properties and transforming column data using formulas.
- Create results with compound layouts, including views such as tabular, chart, pivot table, gauge and others.
- Manage content, permissions and access within the Presentation Catalog.
- This textbook includes dozens of learning exercises, with detailed point-and-click solutions also provided.
Audience
- The target audience for this course is any business professional seeking to analyze enterprise-wide or departmental information collected into an organization data warehouse including:
- Data architects
- Data warehouse administrators and analysts
- Business analysts
- Financial managers
- Market research professionals
- Human resource managers
- Procurement and vendor management professionals
- Field representatives
- Business development managers
Prerequisites
- ORACLE FUSION MIDDLEWARE 11G: WEBLOGIC & BI SERVER ARCHITECTURE & INSTALLATION.
Topics
- THE technology behind BI
- WAREHOUSE models & schemas
- DATA analytics & the warehouse
- ACCESS BI presentation services
- GLOBAL header & home page
- STAR & snowflake schema models
- THE presentation catalog
- THE dashboard interface
- VIEWING the analyses results
- WORKING with the analysis results
- FILTERING data via prompts
- DASHBOARD page options
- MANAGING page customizations
- CREATING a new analysis
- ADDING columns to the analysis
- MANAGING the analysis definition
- VIEWING the results
- WORKING with subject areas
- SORTING data
- FILTERING data
- REUSING filters
- PROMPTS
- CUSTOMZING column properties
- SYSTEM-WIDE column formatting
- COLUMN formulas
- ABOUT views
- WORKING with views
- TABLE view
- TITLE view
- CHART view
- GAUGE view
- PIVOT table concepts
- DEFINING the pivot table
- SECTIONS & pages
- TOTALS within pivot tables
- FILTERS view
- COLUMN selector view
- VIEW selector view
- TICKER view
- LEGEND view
- NARRATIVE view
- USING dashboard prompts
- PREPARING objects for dashboard deployments
- CREATING a dashboard
- UNDERSTANDING the dashboard structure
- USING the dashboard editor
- MANAGING saved content
- MANAGING dashboard objects
Related Courses
-
Oracle Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation
DBOR-939- Duration: 2 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,400.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart