Papers and Presentations | 2016
You must have an Adobe Acrobat compatible reader installed to view our papers. 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 email@example.com with the name of the conference and the year you need. Links to papers will open in a new window.
January 26 - 28, 2016 • Redwood City, CA • Website
Visual Analyzer and Best Practices for Data Discovery
Presented by Tim Vlamis and Dan Vlamis
Oracle’s new Visual Analyzer tool is especially designed for data exploration, whereas traditional OBIEE dashboards tend to be designed for data explanation. How do you provide best practices for how to explore data, since this tends to be more ad-hoc in nature? What training and guidance beyond the built-in suggestion engine should you employ? How do and when should you include Visual Analyzer insights on existing OBIEE dashboards? How does Visual Analyzer change the way we visualize data and develop analyses and dashboards? Join the conversation as we explore these topics in an engaging presentation.
Case Study of Improving BI Apps and OBIEE Performance
Presented by Dan Vlamis
A customer implemented BI Applications and query performance was not as good as they expected and was getting worse over time. Vlamis Software Solutions, Inc. was engaged for an OBIEE “health check” to help evaluate how they could improve their query performance. The three-week assessment focused on improving their query performance and the overnight ETL process. Vlamis used APE Diagnostics from Troype software and OBIEE’s usage tracking tables to investigate the performance issues. In this engaging session, come learn about how you too can improve performance over what is delivered out of the box with BI Apps. Learn how you can identify the reports and analyses as well as the underlying tables and partitions that are being accessed the most and which ones are contributing to you performance bottlenecks. Learn how a customer can quickly drill down from a report to a logical query to a physical query (including an Explain Plan) and identify performance bottlenecks. See how they are implementing empirically-based performance improvements. We will discuss techniques such as: Aggregate tables, proper indexes, eliminating complex filters and predicates in the front end, and other techniques. We expect that others in the audience will also share their ideas on how to analyze and improve query performance in Oracle BI.
Preparing for BI 12c Upgrade
Presented by Dan Vlamis
So you’ve heard about the major new features of Oracle BI 12c, including Visual Analyzer, Data Mashups, and BI Ask, but what’s it *really* like to upgrade to BI 12c? How do you ensure that the upgrade process goes smoothly? Sure, VA looks exciting, but what about the library of dashboards and analyses you’ve built up over the years? What steps should you take now to “clean up” your catalog before you upgrade and how do you organize it for the future? What changes to the RPD file should you make and how do you evolve your repository strategy? And what must you do to enable your users to successfully integrate use the new data mashup capability into your dashboards? What’s the appropriate scope for training and rollout? Come learn about the utilities that Oracle provides to ease the upgrade path and ensure that you know about any changes in BI 12c. Hear about real-life upgrades and lessons learned with the new release. We will share what we have learned about upgrading to 12c and what is involved.
BI Movie Magic: Maps, Graphs, and BI Dashboards at AMC Theatres
Presented by Maury Carollo and Cathye Pendley
AMC Theatres is transforming the way they see their business data through the use of OBIEE map views and other visualizations as they transition from a traditional Hyperion Enterprise reporting environment to a progressive OBIEE 11g implementation. Showing a bubble for each theater and color-coding and sizing them according to various performance metrics makes previously hidden patterns easy to see. Management can now watch the effect of various theater programs and policies and track them over time with maps, graphs, attendance heat maps, and performance tiles. Learn how a team comprised of business users, executive sponsors, BI experts, and IT leaders are making a huge difference in the future of one of America’s entertainment leaders. Expect real world lessons, practical tips, and honest discussion of tradeoffs.
Scaling R to New Heights with Oracle Database
Presented by Mark Hornick and Tim Vlamis
Oracle R Enterprise (ORE), a component of the Oracle Advanced Analytics Option, provides a comprehensive, database-centric environment for end-to-end analytical processes in R, with immediate deployment to production environments. Entire R scripts can be operationalized in production applications - eliminating the need to port R code. Using ORE with Oracle Database enables R users to transparently analyze and manipulate data in Oracle Database thereby eliminating memory constraints imposed by client R engines. In this hands-on lab, attendees will work with the latest Oracle R Enterprise software, getting experience with the ORE transparency layer, embedded R execution, and the statistics engine. Working with the instructors through scripted scenarios, users will understand how R is used in combination with Oracle Database to analyze large volume data.
Learn Predictive Analytics in 2 hours!! Oracle Data Miner 4.0 Hands on Lab
Presented by Charlie Berger and Tim Vlamis
Learn predictive analytics in 2 hours!! Multiple experts in Oracle Advanced Analytics/Oracle Data Mining will be on hand to help guide you through the basics of predictive analytics using Oracle Advanced Analytics 12c, a Database 12c Option and SQL Developer 4.1's Oracle Data Miner workflow GUI. Oracle Advanced Analytics embeds powerful data mining algorithms in the SQL kernel of the Oracle Database for problems such as predicting customer behavior, anticipating churn, identifying up-sell and cross-sell, detecting anomalies and potential fraud, market basket analysis, customer profiling, text mining and retail market basket analysis. Oracle Data Miner 4.1, an extension to SQL Developer 4.1, enables business analysts to quickly analyze data and visualize their data, build, evaluate and apply predictive models and develop predictive analytics methodologies—all while keeping the data inside the Oracle Database. Oracle Data Miner's easy to use "drag and drop" workflow user interface enables data analysts to quickly build and evaluate predictive analytics models, apply them to new data in the Database and then, most importantly, immediately generate SQL scripts to accelerate enterprise deployment. Come see how easily you can discover big insights from your Oracle data, generate SQL scripts for deployment and automation and deploy results into Oracle Business Intelligence (OBIEE) and other BI dashboards and applications.
Oracle Database Analytic Views
Presented by Dan Vlamis, Mike Caskey and George Lumpkin
Analytic views (new in Oracle 12.2 and discussed at Oracle OpenWorld) will let you easily transform tables into the next-generation data source for BI applications and Excel Pivot Tables. Analytic views add analytic content to data using a dimension model and a library of hierarchical, time series, and other calculations. They are the perfect complement to Oracle Database In-Memory, allowing you to add analytic content to tables in the in-memory column store, conventional tables, and views. Learn how analytic views transforms a star schema (and more) into a rich model with time series and hierarchical calculations. See how these views are easily created using both tools in Oracle SQL Developer and SQL data definition language and query them using SQL and Microsoft Excel.
February 9 - 11, 2016 • Denver, CO • Website
Preparing for an Upgrade to Oracle Business Intelligence 12c
Presented by Dan Vlamis and Tim Vlamis
So you’ve heard about the major new features of Oracle BI 12c, including Visual Analyzer, Data Mashups, and BI Ask, but what’s it *really* like to upgrade to BI 12c? Upgrades are not only about tools and techniques, but also about improving and updating your implementation and correcting accumulated problems. You shouldn’t move your mess from one house to another, but take the opportunity to reorganize and set new patterns. How do you ensure that the upgrade process goes smoothly? Sure, VA looks exciting, but what about the library of dashboards and analyses you’ve built up over the years? What steps should you take now to “clean up” your catalog before you upgrade and how do you organize it for the future? What changes to the RPD file should you make and how do you evolve your repository strategy? And what must you do to enable your users to successfully integrate use the new data mashup capability into your dashboards? What’s the appropriate scope for training and rollout? Come learn about the utilities that Oracle provides to ease the upgrade path and ensure that you know about any changes in BI 12c. Hear about real-life upgrades and lessons learned with the new release. We will share what we have learned about upgrading to 12c and what is involved.
Starting Smart with Oracle Advanced Analytics
Presented by Tim Vlamis and Dan Vlamis
Everyone knows they should be integrating data mining and predictive analytics, but it can be challenging to discuss the merits of a project before team members share a common understanding of data mining and predictive analytics. We will share a detailed outline of the best practice methodology for getting clients started with Oracle Data Mining and Oracle R Enterprise, how we develop that common understanding using “live” software, and how to facilitate brainstorming sessions to identify projects with the highest ROIs. We’ll share excerpts from our 3-day start up process to create a common set of skills and knowledge through hands-on learning with live software and complemented by expert guidance for placing tools and algorithms within a broader analytics context.