Presentations - 2006

You must have an Adobe Acrobat compatible reader installed to view our presentations. If you would like to have a copy of a paper or presentation we have given that has not yet been posted, please send an e-mail to papers@vlamis.com with the name of the conference and the year you need. Links to presentations will open in a new window.

Collaborate 2006

April 23-27 • Nashville, Tennesee • Website

Oracle OLAP -- What's All This About?

Presented by Dan Vlamis

What are those "multi-dimensional cubes" anyway? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?

This exercise will demonstrate the process of implementing Oracle OLAP using Analytic Workspaces. By creating cubes themselves in hands-on exercises, class participants will gain first-hand knowledge of the process involved. Participants will also be able to analyze the data in their cubes using tools such as Discoverer, BI Beans, and the OLAP BI Spreadsheet Add-in for Excel.

Armed with information such as "What is an Analytic Workspace", and "what metadata is required?", will help a DBA prepare a database and design schemas for use by an OLAP application and help an application developer understand what options are possible and how to gain maximum value from a data warehouse or data mart.

Building Advanced BI Applications using Oracle BI Beans

Presented by Chris Claterbos

Do you think building a Business Intelligence applications hard? Think again. Oracle's BI Beans have significantly improved the ability of inexperienced Java developers to create Complex Rich Business Intelligence Applications with minimal effort. This session explains how developers can take advantage the new features in JDeveloper and BI Beans 10g to create extremely powerful interactive business intelligence applications, which can be used for guided analyses by management. Attendees will see how to use Oracle 9i/10g, Oracle OLAP, JDeveloper 10g and BI Beans to build a powerful forecasting and what-if analysis application. An actual application will be presented. The experiences of the development process will be presented along with tips and techniques.

Building an End to End OLAP Solution using Oracle Business Intelligence

Presented by Chris Claterbos

Using Oracle 10g R2 and Oracle Business Intelligence we can now design, construct, load and view data in a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g, Oracle OLAP, Discoverer for OLAP and how to design and construct an Oracle 10g database that can be used for OLAP analysis and presentation. The many new features that improve on the ability to build OLAP warehouses taking advantage of the many new features in Oracle 10g will be presented. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP based datamart. A complete end-to-end demonstration will be presented.

ODTUG Kaleidoscope 2006

June 17-21 • Washington, D.C. • Website

Oracle Business Intelligence in the Real World: Case Studies from the Trenches

Presented by Dan Vlamis

So you've heard of Oracle BI and Oracle OLAP, huh? Maybe you've heard about how it speeds up calculations, about the lightning-fast response times on queries, about how users can customize their own environment and queries without bothering the IT department. Or perhaps you are wondering what the value of OLAP really is or need to justify it to your CIO.

This presentation will have a brief overview of Oracle BI and Oracle OLAP, by case studies, and a discussion of some real-world topics encountered and techniques developed as we work on Oracle OLAP implementations, with a focus be on how real businesses are using Oracle OLAP to solve business problems and meet the needs of their managers.

Solid Foundations 2006 - Seminar 4

October 17 • Omaha, NE • Website

Oracle BI and Oracle OLAP--What's All This About?

Presented by Dan Vlamis

So you've heard of Oracle Business Intelligence and Oracle OLAP, huh? Maybe you've heard how it speeds up calculations; the lightning-fast response times; how users can customize their own environment and queries without bothering the IT department.

What are those "multi-dimensional cubes" anyway? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?

This presentation will describe the architecture of Oracle OLAP, and the various front-end choices in the Oracle BI suite (including Oracle Discoverer, Oracle Spreadsheet Add-in and Oracle BI Beans) will be shown and compared using the cubes built earlier in the presentation. Finally, Dan will discuss some of the real-world topics that he has encountered while working on several Oracle OLAP implementations.