Vlamis Software Solutions

40 Westwoods Drive
Liberty, MO 64068
sales@vlamis.com

816-781-2880

Test Drive Oracle Software

Try Oracle's Business Intelligence and Analytics software completely free!

http://www.vlamis.com/td/

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 papers@vlamis.com with the name of the conference and the year you need. Links to papers will open in a new window.

BIWA Summit

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.

RMOUG Training Days

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.

Oracle Advanced Analytics Webinar

March 23, 2016

Advanced Analytics using Oracle DB EE

Presented by Tim Vlamis

If you’ve been wanting to expose your colleagues to the power of using the Oracle Database as a platform for predictive analytics, this special session will be perfect for you. We’ll use a combination of live demos and business use cases to explain that predictive analytics doesn’t require an advanced degree in mathematics, just a database and a few good business questions. We’ll share how to leverage the work you’ve done in building a data warehouse and collecting business data sets into solid evidence for business decisions. Predictive analytics is all about looking forward into the future and leveraging data to assess and evaluate alternative courses of action. Too often, executives and managers rely on gut instinct without using the data they already have to make better decisions.
Here’s the outline for the session:

  • Key issues in leveraging the power of analytics
  • Using Oracle database as an analytics platform
  • Oracle Advanced Analytics overview
    • Oracle Data Mining
    • Oracle R Enterprise
  • Common use cases for predictive analytics
  • Where to start when developing your analytics capabilities

New Release of BI Cloud Services (BICS) Webinar

April 5, 2016

New Release of BI Cloud Services (BICS)

Presented by Dan Vlamis

Did you notice that Oracle released their March 2016 version of BI Cloud Services? If “About BI Cloud Service…” in the drop-down next to your userid in the upper right corner says version 11.1.1.11.0, you’ve been upgraded! Join our webcast on April 5, 2016 at 12pm Central time to see what’s new in our continuing line of webcasts on Oracle BI releases. Just as a preview, here are some of the new features:

  • New Visualizations in VA:
    • Donut
    • Combo (with dual axis)
    • Stacked Scatter
    • Images
  • Enhancements in VA:
    • Color management (change the palette)
    • Improved filtering and drill down
  • BICS and DVCS VA Feature Parity
    • Insights
    • Storytelling and Presentation mode
  • Answers and Dashboards
    • Legend view
    • Ticker view
    • Save column as
  • Webcat Lift and Shift from on-premise to Cloud
  • Multiple DB Connections and Subject Areas
  • BICS Remote Data Connector
Just like our previous demonstrations of new BI releases, we will give a live demonstration of as many of these features as we have time for. Join us for this popular webcast!

Collaborate 16 IOUG

April 10 - 14, 2016 • Las Vegas, NV • Website

Upgrading to Oracle Business Intelligence 12c

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

Oracle Big Data Science

Presented by Tim Vlamis

Oracle offers data scientists and those with an Oracle background who are interested in learning data science the opportunity to perform highly sophisticated analytics on humongous data sets without requiring years of specialized study and arcane knowledge acquisition. Using Oracle Big Data Discovery, Oracle Big Data SQL, and Oracle R Advanced Analytics for Hadoop complement each other exceptionally well and provide an extraordinary capability unmatched by patchwork systems cobbled together. You’ll see how to conceptualize and approach analytics common to most every organization and understand which tools to use in what order. Like other scientific disciplines, data science requires a thorough and well-grounded approach to the analysis and understanding of data. You’ll see how to use Oracle’s most powerful tools for processing massive data sets in Hadoop.

Analytic Views Simplify Complex Business Intelligence Queries

Presented by Dan Vlamis

Analytic Views (new in Oracle 12.2 and discussed at Oracle OpenWorld 2015) change the way you build analytical applications. Analytic Views are created in a similar way to regular relational views, but add a syntax that allow you to add multiple levels of data and calculations that insulate your application from complex SQL necessary to calculate even simple concepts such as time series, share calculations and aggregations. You can even access Analytic Views from MDX-enabled applications such as Excel. Analytic Views can be defined against a variety of data sources, including In-Memory column stores, regular tables, external tables, even Big Data SQL.

Collaborate 16 OAUG

April 10 - 14, 2016 • Las Vegas, NV • Website

BI Movie Magic: Maps, Graphs, and BI Dashboards at AMC Theatres

Presented by Tim Vlamis

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. 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 of business users, executive sponsors, BI experts, and IT leaders are making a difference in the future of one of America’s entertainment leaders.

Case Study of Improving BI Apps and OBIEE Performance

Presented by Jeff McBride (of AFL Global) and Mike Caskey

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.

Collaborate 16 Quest

April 10 - 14, 2016 • Las Vegas, NV • Website

Data Analysis with Various Oracle Business Intelligence and Analytic Tools

Presented by Tim Vlamis

Built from business use cases, we cover the advantages and best practice uses of Oracle’s BI and analytics offerings from a data analysis perspective. Systems include: OBIEE dashboards including tables, graphs, embedded content, OBIEE map views,BI Publisher, Visual Analyzer, R visualizations from Oracle R Enterprise, Big Data Discovery, Endeca, BI Mobile App Designer. We explain why to use each tool in different circumstances, how to optimize value from each implementation in the real world where tradeoffs exist, and how to help others in your organization understand data analysis best practices.

Test Drive Announcement on OTN

April 12, 2016 • Las Vegas, NV

Advanced Analytics and Business Intelligence Oracle Cloud Test Drive

Heartland OUG Spring Meeting

April 28, 2016 • Omaha, NE • Website

Visual Analyzer and Best Practices for Data Discovery

Presented by Tim Vlamis and Arthur Dayton

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.

Implement Maps in OBI in a Week

Presented by Tim Vlamis and Arthur Dayton

Great Lakes Oracle Conference

May 18 & 19, 2016 • Cleveland, OH • Website

Starting Smart with Advanced Analytics

Presented by Tim 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.

Data Visualization for Oracle Business Intelligence

Presented by Tim Vlamis

Built around business use cases, we will cover the advantages and best practice uses of the array of Oracle’s BI and analytics offerings from a deep data analysis perspective. Covered systems include:

  • OBIEE dashboards including tables, graphs, and embedded content
  • OBIEE map views and Oracle MapViewer
  • BI Publisher
  • Visual Analyzer
  • R visualizations on OBIEE dashboards from Oracle R Enterprise
  • Big Data Discovery
  • Endeca
  • BI Mobile App Designer
All of these have powerful and important capabilities; however, too many organizations end up misusing and applying these tools and end up frustrated with their results. Using case studies, we’ll break down why to use which tool in different circumstances, how to optimize organizational value from each implementation in the real world where significant tradeoffs exist, and how to bring along others in your organization in understanding data analysis best practices.