Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle BI 11g: Create Analyses & Dashboards
Oracle Training Overview

This textbook offers an exhaustive, step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. One will learn the concepts, methods and techniques for building sophisticated data analytic modules. Analytic results are then organized into interactive dashboards. A solid foundation is laid for one to progress onto the latest and most advanced data analytic capabilities.

Oracle Training Objectives

The following specific topics are included in this guide book:
  • Background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
  • Background concepts regarding logical data models, star schema and snowflake schema warehouse models.
  • How to 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.
  • Creating data analyses and dynamically interact with results produced from Oracle BI.
  • Format 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.


Oracle Training 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. Among those for whom this course might be particularly useful would be:
  • 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
Oracle Training Prerequisites

It is assumed that you have access to a valid installation of the Oracle WebLogic Server and a deployment of the Oracle BI Server. Therefore, it is a mandatory prerequisite that this environment be configured in advance. A step-by-step guide to creating such an installation along with overview information about the technical architecture which supports these platforms is provided in the textbook
  • ORACLE FUSION MIDDLEWARE 11G: WEBLOGIC & BI SERVER ARCHITECTURE & INSTALLATION.
Advanced or power users who may not be responsible for the actual installation but who are interested in Oracle BI architecture and administration topics may consider that textbook to be an optional prerequisite.

Otherwise, a general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.


Suggested Next Courses

After completing this textbook, advanced users should proceed onto the next textbook in the Oracle BI learning series entitled
  • ORACLE BI 11G: ADVANCED ANALYSES FOR POWER USERS.
Oracle Training Course duration

2 Days

Oracle Training Course outline

DATA WAREHOUSING, BUSINESS INTELLIGENCE & DATA ANALYTICS
  • THE TECHNOLOGY BEHIND BI
  • WAREHOUSE MODELS & SCHEMAS
  • DATA ANALYTICS & THE WAREHOUSE
GETTING STARTED WITH ORACLE BI
  • ACCESS BI PRESENTATION SERVICES
  • GLOBAL HEADER & HOME PAGE
  • STAR & SNOWFLAKE SCHEMA MODELS
  • THE PRESENTATION CATALOG
USING A DASHBOARD
  • THE DASHBOARD INTERFACE
  • VIEWING THE ANALYSES RESULTS
  • WORKING WITH THE ANALYSIS RESULTS
  • FILTERING DATA VIA PROMPTS
  • DASHBOARD PAGE OPTIONS
  • MANAGING PAGE CUSTOMIZATIONS
CREATING AN ANALYSIS
  • CREATING A NEW ANALYSIS
  • ADDING COLUMNS TO THE ANALYSIS
  • MANAGING THE ANALYSIS DEFINITION
  • VIEWING THE RESULTS
  • WORKING WITH SUBJECT AREAS
SELECTING & ORDERING DATA
  • SORTING DATA
  • FILTERING DATA
  • REUSING FILTERS
  • PROMPTS
COLUMN FORMATTING
  • CUSTOMIZING COLUMN PROPERTIES
  • SYSTEM-WIDE COLUMN FORMATTING
  • COLUMN FORMULAS
EMPLOYING TABLE & TITLE VIEWS
  • ABOUT VIEWS
  • WORKING WITH VIEWS
  • TABLE VIEW
  • TITLE VIEW
EMPLOYING GRAPH & GAUGE VIEWS
  • CHART VIEW
  • GAUGE VIEW
EMPLOYING PIVOT TABLE VIEWS
  • PIVOT TABLE CONCEPTS
  • DEFINING THE PIVOT VIEW
  • SECTIONS & PAGES
  • TOTALS WITHIN PIVOT TABLES
EMPLOYING SECONDARY VIEWS
  • FILTERS VIEW
  • COLUMN SELECTOR VIEW
  • VIEW SELECTOR VIEW
  • TICKER VIEW
  • LEGEND VIEW
  • NARRATIVE VIEW
DEPLOYING ANALYSES TO DASHBOARDS
  • USING DASHBOARD PROMPTS
  • PREPARING OBJECTS FOR DASHBOARD DEPLOYMENT
BUILDING A DASHBOARD
  • CREATING A DASHBOARD
  • UNDERSTANDING THE DASHBOARD STRUCTURE
  • USING THE DASHBOARD EDITOR
  • MANAGING SAVED CONTENT
  • MANAGING DASHBOARD OBJECTS

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy