Presentations - 2004

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.

KCOUG January Quarterly Meeting

January 27 • Overland Park, KS • Website

Using Oracle9i Warehouse Builder to Create OLAP-Ready Data Warehouses

Presented by Dan Vlamis

With the use of the new features found in Oracle's Warehouse Builder(OWB) 9i and Oracle9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle9i OLAP and how to design and construct an Oracle9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. 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.

IOUG Live! 2004

April 18 - 22 • Toronto, Ontario, Canada • Website

Building and Maintaining Applications Using Oracle BI Architecture -- University Class Full-Day

Presented by Chris Claterbos and Dan Vlamis

This class will present the technologies that were introduced with Oracle 9i/10g and 9i Internet Developers Suite (9iDS). These include analytical functions in the relational database, OLAP Services, 9i Oracle Warehouse Builder (OWB), Java OLAP API, and BI Beans. Attendees will see how to use Oracle 9i, OLAP Services, 9i OWB, JDeveloper 9i and BI Beans to build an OLAP aware warehouse and then develop simple and complex applications to view the warehouse data. A comparison between thick and thin client applications will also be discussed. The attendees will be shown how to start building OLAP warehouses and developing applications using BI Beans and JDeveloper. A sample datamart will be built and an application will be built to access this data during the class. All attendees will have access to the resulting application code.

Developing Advanced Thin Client Applications with BI Beans -- Expert Technical Session

Presented by Chris Claterbos

When building business intelligence applications data is important, but the key piece is making the data easily accessible so that the end-user can use it to improve upon the business. This session explains how developers can take advantage of their existing J2EE and data warehouse servers as a platform 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, OLAP Service, JDeveloper 9i 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.

Discoverer 10G or BI Beans - Which Is Right for You? -- Technical Session

Presented by Dan Vlamis

Discoverer release 10g uses BI Beans to present Oracle OLAP data. It gets its power from BI Beans. How does this strategy give Discoverer users the flexibility to analyze OLAP data? What features does this expose to the users over what has been available previously? Custom applications that use BI Beans have many of the capabilities that are in the Discoverer 10g application. When would you want to use Discoverer and when would you want to code an application directly in BI Beans? This presentation will contrast Discoverer 10g with custom-built BI Beans applications and discuss why you should consider these products.

Using the Oracle9i OLAP Spreadsheet Add-In -- Quick Tip

Presented by Dan Vlamis

The Oracle OLAP Spreadsheet Add-In provides access to Oracle OLAP data from within Microsoft Excel. This presentation will demonstrate how this add-in can provide users access to very powerful analytics within an application they are already comfortable using.

Managing Oracle OLAP -- University Class Half-Day

Presented by Chris Claterbos

In Oracle9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. Physically, data can be stored in relational tables, or in Analytic Workspaces (multidimensional storage). Analytic Workspaces make possible all sorts of interesting business intelligence applications, such as collaborative budgeting, collaborative forecasting, predictive analysis, and modeling applications. All of this is now available within the Oracle9i database. With this new freedom comes new challenges in managing these tables and analytic workspaces. How are AWs updated? What is the best storage location for your data? When should the OLAP option be used? What are the major new capabilities in Oracle OLAP 10g and how does this affect the design of a data warehouse? We will discuss exactly that these mysterious Analytic Workspaces are. We will also present best practices and strategies pulled from a decade of experience with these analytic workspaces in their former life, as Express databases as well as multiple projects involving analytic workspaces. Attendees will see how Oracle tools such as Oracle Warehouse Builder, Oracle Enterprise Manager, Analytic Workspace Manager, and OLAP Worksheet can be used to manage the Oracle OLAP environment.

ODTUG 2004

June 20-24 • Scottsdale, Arizona • Website

An End-to-End Solution for OLAP: From OWB to JDeveloper to Analyze Your Data Warehouse

Presented by Dan Vlamis

This presentation will produce an actual, completed, OLAP-ready datamart, with a working BI application. It will address the steps necessary and options in building a Oracle OLAP cubes, including using Oracle Warehouse Builder, Oracle Enterprise Manager, and Analytic Workspace Manager. It will then move into developing simple and complex applications using JDeveloper, and BI Beans. Tips on the development of a commercial BI Application built using JDeveloper and BI Beans will also be presented.

Effectively Using Oracle OLAP in Business Intelligence Applications

Presented by Dan Vlamis

This presentation will describe the components of Oracle OLAP. Armed with information answering the questions "What is an analytic workspace?" and "What metadata is required to support the Java OLAP API and BI Beans?", a designer will be able to design a data warehouse or data mart for use by a business intelligence application. In addition, a manager will understand what options are possible and how to gain maximum value from a data warehouse or data mart. In a live demonstration, we will show how Discoverer for OLAP or another BI application can use Oracle OLAP to answer real business questions.

Ohio Oracle User Group Meeting

July 22 • Dublin, OH • Website

Using Oracle Business Intelligence Tools to Analyze Data Warehouses

Presented by Dan Vlamis

Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a "best of breed" solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features?

This presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, 9i Internet Developers Suite (9iDS), and OracleAS Discoverer 10g. These include:

  • 9i Oracle Enterprise Manager (OEM)
  • Oracle OLAP
  • JDeveloper
  • BI Beans
  • Discoverer for OLAP (new in Discoverer 10g)
  • Accessing Oracle OLAP data from Excel

The attendees will be shown how to start building OLAP warehouses and how to develop simple and complex applications using BI Beans and JDeveloper. A sample datamart will be built and an application will be shown that accesses this data during the presentation. A comparison between thick and thin client applications will also be discussed.

It concludes with a review of the advantages of an integrated approach.

KCOUG Fall Conference

October 26 • Kansas City, MO • Website

Using Oracle Business Intelligence Tools to Analyze Data Warehouses

Presented by Dan Vlamis

Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a "best of breed" solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features?

This presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, Oracle Developer Suite, and OracleAS Discoverer 10g. These include:

  • Oracle Enterprise Manager (OEM)
  • Oracle OLAP
  • JDeveloper
  • BI Beans
  • Discoverer for OLAP (new in Discoverer 10g)
  • Accessing Oracle OLAP data from Excel

It concludes with a review of the advantages of an integrated approach.

Oracle Open World 2004

December 5-9 • San Francisco, CA • Website

Discoverer 10g or BI Beans - Which Is Right for You?

Presented by Dan Vlamis

Discoverer release 10g uses BI Beans to present Oracle OLAP data. It gets its power from BI Beans. How does this strategy give Discoverer users the flexibility to analyze OLAP data? What features does this expose to the users over what has been available previously? Custom applications that use BI Beans have many of the capabilities that are in the Discoverer 10g application. When would you want to use Discoverer and when would you want to code an application directly in BI Beans? This presentation will contrast Discoverer 10g with custom-built BI Beans applications and discuss why you should consider these products.

Presented through: IOUG

Developing Advanced Thin Client Applications with BI Beans

Presented by Chris Claterbos

When building business intelligence applications data is important, but the key piece is making the data easily accessible so that the end-user can use it to improve upon the business. This session explains how developers can take advantage of their existing J2EE and data warehouse servers as a platform 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, OLAP Service, JDeveloper 9i 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.

Presented through: IOUG

Using Oracle Business Intelligence Tools to Analyze Data Warehouses

Presented by Cathye Pendley

Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a "best of breed" solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features?

This presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, Oracle Developer Suite, and OracleAS Discoverer 10g. These include:

  • Oracle Enterprise Manager (OEM)
  • Oracle OLAP
  • JDeveloper
  • BI Beans
  • Discoverer for OLAP (new in Discoverer 10g)
  • Accessing Oracle OLAP data from Excel

It concludes with a review of the advantages of an integrated approach

Presented through: ODTUG