Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle Fusion Middleware > Oracle BI 11g: Create Analyses & Dashboards Training

Oracle BI 11g: Create Analyses & Dashboards Training

Course#: WA2139

This course 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.

 

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

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 Course After completing this textbook, advanced users should proceed onto the next textbook in the Sideris Oracle BI learning series entitled.

  • ORACLE BI 11G: ADVANCED ANALYSES FOR POWER USERS.

Duration

2 Days

Outline of WA2139 Oracle BI 11g: Create Analyses & Dashboards Training

1. DATA WAREHOUSING, BUSINESS INTELLIGENCE & DATA ANALYTICS

  • THE TECHNOLOGY BEHIND BI
  • WAREHOUSE MODELS & SCHEMAS
  • DATA ANALYTICS & THE WAREHOUSE

2. GETTING STARTED WITH ORACLE BI

  • ACCESS BI PRESENTATION SERVICES
  • GLOBAL HEADER & HOME PAGE
  • STAR & SNOWFLAKE SCHEMA MODELS
  • THE PRESENTATION CATALOG

3. 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

4. CREATING AN ANALYSIS

  • CREATING A NEW ANALYSIS
  • ADDING COLUMNS TO THE ANALYSIS
  • MANAGING THE ANALYSIS DEFINITION
  • VIEWING THE RESULTS
  • WORKING WITH SUBJECT AREAS

5. SELECTING & ORDERING DATA

  • SORTING DATA
  • FILTERING DATA
  • REUSING FILTERS
  • PROMPTS

6. COLUMN FORMATTING

  • CUSTOMIZING COLUMN PROPERTIES
  • SYSTEM-WIDE COLUMN FORMATTING
  • COLUMN FORMULAS

7. EMPLOYING TABLE & TITLE VIEWS

  • ABOUT VIEWS
  • WORKING WITH VIEWS
  • TABLE VIEW
  • TITLE VIEW

8. EMPLOYING GRAPH & GAUGE VIEWS

  • CHART VIEW
  • GAUGE VIEW

9. EMPLOYING PIVOT TABLE VIEWS

  • PIVOT TABLE CONCEPTS
  • DEFINING THE PIVOT VIEW
  • SECTIONS & PAGES
  • TOTALS WITHIN PIVOT TABLES

10. EMPLOYING SECONDARY VIEWS

  • FILTERS VIEW
  • COLUMN SELECTOR VIEW
  • VIEW SELECTOR VIEW
  • TICKER VIEW
  • LEGEND VIEW
  • NARRATIV VIEW

11. DEPLOYING ANALYSES TO DASHBOARDS

  • USING DASHBOARD PROMPTS
  • PREPARING OBJECTS FOR DASHBOARD DEPLOYMENT

12. BUILDING A DASHBOARD

  • CREATING A DASHBOARD
  • UNDERSTANDING THE DASHBOARD STRUCTURE
  • USING THE DASHBOARD EDITOR
  • MANAGING SAVED CONTENT
  • MANAGING DASHBOARD OBJECTS
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.