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 Business Intelligence: Create Reports & Interactive Dashboards
Oracle Training Course Objectives

Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated database requests and to format resulting answers. The following topics are included in this training courseware guide book:
  • Background concepts regarding logical data models, physical data models, star schema and snowflake schema warehouse models.
  • Important data concepts including fact tables, dimensions, cubes, measures and other dimensional data model objects.
  • An introduction to Oracle BI concepts, including the Oracle BI repository layers, Oracle BI Presentation Services, Oracle BI Presentation Catalog and basic navigation of the Oracle BI Answers and Dashboards interface.
  • Use interactive Dashboards to analyze warehouse data, uncover trends and reach important business decisions.
  • Design customized Dashboards to reflect an individual's role, perspective or business interest.
  • Creating requests and viewing answers produced from Oracle BI.
  • Formatting requests using sorts, filters and prompts.
  • Formatting column output and modifying column data using formulas.
  • Creating report results with compound layouts, including views such as tabular, chart, pivot table, gauge and others.
  • Drill-down into report details, navigation and employing variables to create a dynamic and interactive analytics environment.
  • Deploying report results for specific devices, such as mobile devices commonly in use like Apple iPhone, Blackberry or other popular devices.
  • Advanced features such as presenting interactive maps as filter criteria, HTML customization of report output and other topics.
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
Prerequisites

No specific prerequisite courses are required. A general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites

Oracle Training Course duration

3 Days

Oracle Training Course outline

DATABASES & DATA MODELS
  • ABOUT DATABASE TECHNOLOGIES
  • LOGICAL DATA MODELS
  • PHYSICAL DATA MODELS
DATA WAREHOUSING & BI
  • TRANSACTIONAL DATABASES
  • WAREHOUSE DATABASES
  • WAREHOUSE MODELS & SCHEMAS
  • ABOUT BUSINESS INTELLIGENCE
  • OLAP, BI, DSS
INTRODUCTION TO ORACLE BI ANSWERS & DASHBOARDS
  • ORACLE BI ARCHITECTURE
  • LAUNCH BI PRESENTATION SERVICES
  • LOG ON
  • BASIC NAVIGATION
USING A DASHBOARD
  • UNDERSTANDING THE DASHBOARD INTERFACE
  • VIEWING THE REQUEST RESULTS
  • USING PROMPTS TO FILTER DATA
  • SAVING & REUSING FILTER SETTINGS
  • MANAGING THE VIEW OF THE DASHBOARD PAGE
  • VIEWING SUPPLEMENTARY CONTENT
  • MISCELLANEOUS TASKS
BUILDING A DASHBOARD
  • CREATING A DASHBOARD
  • UNDERSTANDING THE DASHBOARD STRUCTURE
  • USING THE DASHBOARD EDITOR
  • MANAGING SAVED CONTENT
  • MANAGING DASHBOARD OBJECTS
CREATING A REPORT
  • NAVIGATING THE ANSWERS INTERFACE
  • CREATING A NEW REQUEST
  • ADDING COLUMNS TO A REQUEST
  • PREVIEWING THE ANSWERS
  • CONTROLLING THE REPORT DEFINITION
  • DOWNLOADING THE ANSWERS
REPORT FORMATTING
  • REPORT ATTRIBUTES
  • SORTING DATA
  • FILTERING DATA
  • REUSING FILTERS
  • PROMPTS
COLUMN FORMATTING
  • COLUMN FORMATTING
  • COLUMN FORMULAS
USING PRIMARY VIEWS
  • ABOUT VIEWS
  • CUSTOMIZING THE TABLE VIEW
  • CHART VIEW
  • GAUGE VIEW
  • FILTERS VIEW
  • MANAGING THE VIEWS
USING SECONDARY VIEWS
  • COLUMN SELECTOR VIEW
  • VIEW SELECTOR VIEW
  • TICKER VIEW
  • LEGEND VIEW
  • NARRATIVE VIEW
  • NO RESULTS VIEW
USING PIVOT TABLE VIEWS
  • PIVOT TABLE CONCEPTS
  • A PIVOTING SCENARIO
  • DEFINING THE PIVOT VIEW
  • SECTIONS & PAGES
  • TOTALS WITHIN PIVOT TABLES
ADVANCED FORMATTING
  • SET OPERATIONS
  • PDF & PRINT CONTROL
  • VIEW XML & SQL CALLS
ADMINISTERING THE PRESENTATION CATALOG
  • ACCESSING THE PRESENTATION CATALOG
  • BI & PRESENTATION CATALOG SECURITY
  • MANAGING PRESENTATION CATALOG OBJECTS
DEPLOYING REQUESTS TO DASHBOARDS
  • VARIABLE REFERENCES
  • USING DASHBOARD PROMPTS
  • PREPARING OBJECTS FOR DASHBOARD DEPLOYMENT

 
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