Presentations - 2009

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 2009

May 3-7 • Orlando, Florida • Website

Tales from the Front: Strategies for a Successful OBIEE Implementation

Presented by Mark Thompson

Are you starting a new OBIEE project? Or perhaps you're mired in the muck of an existing project, and things aren't going well. No matter what your experience with OBIEE has been so far, no matter what industry your company is in, this session will provide you with helpful tips and techniques to guide you toward a successful OBIEE implementation.

We'll discuss topics such as:

  • Divide and Conquer: The key strengths you need on your OBIEE implementation team.
  • Nothing Stops a Train: But a lack of proper training can stop your project in its tracks.
  • Why every team member needs training, and the importance of cross-trained teams.
  • To Contract, or Not To Contract, That Is the Question: Getting help from someone who's "been there, done that".
  • Any Way You Slice It: Why your security model should be one of the first, second, and third things you consider.
  • What's In a Name?: Ideas for implementing a standardized naming convention for the objects in your OBIEE schema.
  • Who's On First? The first, most important steps when beginning your project.
  • You want WHAT? Maintaining a manageable scope of deliverables.
  • Tiny Steps, Big Results: Building your OBIEE environment in successive stages for quick Proofs of Concept.
  • Stars, Snowflakes, Constellations, and other Unnatural Phenomena: The proper schemas for a clean configuration and ease of maintenance.
  • Aggregates, OLAP, and Cache, OH MY: Your three-prong approach to great performance.
  • Become a Master Locksmith: The proper use of Keys for fun and profit.
  • Users and Other Difficult Concepts: The Pilot User Group and who should be in it.
  • Jammin': Using post-implementation jam sessions to enhance your users' knowledge and expertise.

We'll discuss these topics and more, using examples pulled from real projects. If you're interested in avoiding the "gotchas" of an OBIEE implementation, then come along for the ride and learn from our mistakes.

Having your Business Intelligence the Way You Want It!

Presented by Dan Vlamis

Oracle's Business Intelligence (OBI EE+) is a platform from which to build your BI delivery the way you want it. This presentation discusses the various ways to provide data access to all users inside and outside the organization. Using the open service based architecture users can now access the OBI EE data in JDeveloper to produce custom applications and Apple iPhone users can view reports and receive alerts no matter where they are. Demonstrations of these technologies will illustrate how these new features can allow access to the BI data any way you want to see it.

Building Cubes and Analyzing Data Using Oracle OLAP 11g

Presented by Mark Thompson

Oracle Database 11g OLAP provide several new features that can used to enhance performance of Oracle-based data warehouses. In addition, while providing a complete summary management capability, they can add additional calculation capabilities. Views are automatically created that allow standard SQL to access the original data, as well as any additional measures. By placing the calculations in the database, all of your business rules and measures can be securely stored in the database. All of this content can be accessed with any application, including Oracle Business Intelligence Enterprise Edition, Oracle Application Express, Oracle Discoverer, BI Publisher, Oracle SQL Developer, as well as non-Oracle tools.

Oracle Essbase and Oracle OLAP: A Guide to Oracle's Multidimensional Solution

Presented by Dan Vlamis and Michael Schrader

The term online analytic processing (OLAP) describes a category of business intelligence (BI) software that supports activities ranging from self-service reporting and analysis, to comprehensive planning and budgeting systems. The OLAP category is not monolithic; there are many different types of OLAP products, each of which seek to provide solutions to certain problems and to service certain user communities. With the acquisition of Hyperion Systems in 2007, Oracle finds itself owning the two most capable OLAP products on the market-Essbase and the OLAP Option to the Oracle Database. While both products fall within the OLAP category and have some similar capabilities, they are different in significant ways. This presentation will help the reader understand where these products are similar and where they differ. Most importantly, it will help the reader architect the Oracle OLAP product that is most appropriate for his or her application.

Ask the Experts: Dan Vlamis and Michael Schrader - Time dimensions in Essbase and Oracle OLAP

Presented by Dan Vlamis and Michael Schrader

Come join two leading experts for a discussion on dimensional modeling in Oracle's two leading multi-dimensional database offerings: Oracle OLAP and Oracle Essbase. Oracle OLAP is built into the Oracle database and exposes data through SQL. Oracle Essbase has a rich history with Hyperion and Arbor Software and has a series of applications for multi-dimensional analysis. Both Oracle OLAP and Oracle Essbase can be used with OBIEE (as well as other tools). Which one is right for your situation? This talk will pick up where the presentation "Oracle Essbase and Oracle OLAP: A Guide to Oracle's Multidimensional Solution" ends.

This roundtable discussion will start with a focus on ways of working with time dimension(s?) in Oracle OLAP and Essbase. We will then use this as a springboard for discussions on topics of interest to the audience. Come armed with your own topics to "Ask the Experts".

ODTUG Kaleidoscope 2009

June 21-25 • Monterey, California • Website

Tales from the Front: Strategies for a Successful OBIEE Implementation

Presented by Mark Thompson

Are you starting a new OBIEE project? Or perhaps you're mired in the muck of an existing project, and things aren't going well. No matter what your experience with OBIEE has been so far, no matter what industry your company is in, this session will provide you with helpful tips and techniques to guide you toward a successful OBIEE implementation.

We'll discuss topics such as:

  • Divide and Conquer: The key strengths you need on your OBIEE implementation team.
  • Nothing Stops a Train: But a lack of proper training can stop your project in its tracks.
  • Why every team member needs training, and the importance of cross-trained teams.
  • To Contract, or Not To Contract, That Is the Question: Getting help from someone who's "been there, done that".
  • Any Way You Slice It: Why your security model should be one of the first, second, and third things you consider.
  • What's In a Name?: Ideas for implementing a standardized naming convention for the objects in your OBIEE schema.
  • Who's On First? The first, most important steps when beginning your project.
  • You want WHAT? Maintaining a manageable scope of deliverables.
  • Tiny Steps, Big Results: Building your OBIEE environment in successive stages for quick Proofs of Concept.
  • Stars, Snowflakes, Constellations, and other Unnatural Phenomena: The proper schemas for a clean configuration and ease of maintenance.
  • Aggregates, OLAP, and Cache, OH MY: Your three-prong approach to great performance.
  • Become a Master Locksmith: The proper use of Keys for fun and profit.
  • Users and Other Difficult Concepts: The Pilot User Group and who should be in it.
  • Jammin': Using post-implementation jam sessions to enhance your users' knowledge and expertise.

We'll discuss these topics and more, using examples pulled from real projects. If you're interested in avoiding the "gotchas" of an OBIEE implementation, then come along for the ride and learn from our mistakes.

Having your Business Intelligence the Way You Want It!

Presented by Dan Vlamis

Oracle's Business Intelligence (OBI EE+) is a platform from which to build your BI delivery the way you want it. This presentation discusses the various ways to provide data access to all users inside and outside the organization. Using the open service based architecture users can now access the OBI EE data in JDeveloper to produce custom applications and Apple iPhone users can view reports and receive alerts no matter where they are. Demonstrations of these technologies will illustrate how these new features can allow access to the BI data any way you want to see it.

Oracle Open World 2009

October 11-15 • San Francisco, California • Website

Lies, Damn Lies, and Visualizing BI Data

Presented by Dan Vlamis and Tim Vlamis, StrategyScape LLC

Are you involved in generating reports for your business, but want to know which formats are best to use in which situations? Would you like a simple way of understanding when to use pie charts, bar charts, line charts and bubble charts? Want to know when data is presented objectively and when it's not? You'll learn basic design principles for writing reports and generating graphs. You'll see examples of how capabilities built into Excel and Oracle BI Enterprise Edition (formerly Siebel) both help and hurt in presenting and visualizing data in everyday situations. Join BI mavens Dan Vlamis and Tim Vlamis for an entertaining session on how managers typically manipulate, misuse, and abuse reports and analytics to conquer their companies on their way to world domination and what you can do to turn Oracle BI EE into a tool for the good!

Budgeting and Planning with Microsoft Excel and Oracle OLAP

Presented by Cathye Pendley and Dan Vlamis