Tim Vlamis to Present at the East Coast Oracle Users Conference

Tim Vlamis is scheduled to present at the East Coast Oracle Users Conference (ECO) in Raleigh, NC. ECO takes place from November 6th to November 8th, 2017 at the Hilton North Raleigh/Midtown Hotel.

Tim will be presenting "Getting Started with Advanced Analytics in Finance, Marketing, and Operations" on Tuesday, November 7th, from 4:00pm - 5:00pm in Salon C. 

For more information, visit our Presentations page!

Tip on using New Waterfall Viz in DVD 3.0

In preparing for my presentation on What's New in DVD 3.0 Webinar (tomorrow!), I found that the new waterfall visualization was geared towards balance measures (like a checking account balance) instead of a flow or performance measure such as profit.  One of the key differences is that for a flow measurement the value can easily be negative.  In any business, you may lose money in a given period, but you hope to make up for it in prior or future periods.  In addition, flow analysis can be great for showing sources of gains and losses.  A waterfall graph typically shows this very nicely.

But the waterfall graph in DVD 3.0 is designed for balance information.

In order to use the waterfall graph, you can convert from the flow measure (such as profit) to a balance by using the RSUM function in OBIEE.  Put simply, RSUM(profit) gives you the running sum of profit for the year, adding up each month.  It accumulates the profit which is exactly what you need in order to use the waterfall graph.

So, on the left you can see a waterfall graph of an inventory balance.  No special formulas needed.  On the right, you can see a waterfall graph of profit.  In this case, we actually use the cumulative profit measure so we can properly visualize the periods where we lost money.  We can easily see that we ended the year with a total of $9346.

Join us at Oracle OpenWorld 2017!

We are happy to invite you to our annual OpenWorld reception on Tuesday, October 3, 2017. Join us for an evening of drinks, hors d’oeuvres and networking. In addition to food and drinks, we will incorporate some visualizations and analytics in the festivities—we’ll just leave it at that, so bring your conference badge and your phone. For more information and to request an invitation, send an email to Carolyn.

Dan and Tim hope that you will be able to attend their sessions. With over 1000 sessions and over 50,000 people, it can be tough to find a time to meet at Oracle OpenWorld if we leave it up to chance. Please send an email to Doug if you are attending so we can help find a time to meet with Dan or Tim during this conference.

Webcast on DVD 3.0 New Features August 29 at 12:00pm Central Time

Register now!

See live and be “in the know” about new features to be added to Oracle Business Analytics products such as Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Analytics Cloud (OAC), Data Visualization Cloud Services (DVCS), Business Intelligence Cloud Services (BICS) by seeing a live demo of the latest features added to Data Visualization Desktop (DVD).  Join Dan Vlamis, Oracle ACE Director, and President of Vlamis Software Solutions, as he breaks down the exciting new features in Data Visualization Desktop 3.0 (internally known as 12.2.3), available July, 2017 from Oracle. Also joining us will be Philippe Lions, Senior Director, BI and Data Visualization at Oracle to help answer any questions you may have. Expect a fast-paced presentation with live demos of DVD, on as many of the new features as time allows such as:

  1. Data Visualization
    • Graphical confidence levels
    • Top & Bottom N Filters
    • New Waterfall & Boxplot Visualizations
    • Duplicating & re-ordering canvases
    • Chart & Axis layout additional options
  2. Data Sources
    • Generic ODBC / JDBC support
    • Support for O-Data, Oracle Docs
    • Source data from remote OBIEE subject areas
    • Additional text delimiters (e.g. csv files), undo in query builder
  3. Data Prep 
    • Enhanced Convert-to-Date feature
    • Set time grain level & format for time object
  4. Data Flows
    • Improved flow-chart UI
    • Deliver output to remote connection (e.g. Oracle DB or Hive)
    • Merge columns step, additional expression functions
  5. Console & Administration
    • Custom Visualization plugins upload screen
    • Custom map layers support & upload console

Just like our previous demonstrations of new BI releases (see www.vlamis.com/obiwebinars for a list), we will give a live demonstration of as many of these features as we have time for.  We will also include an update on the new Oracle Analytics Cloud Store, where you can download many additional visualizations and see additional demonstrations of Oracle BI technology. Register and join on time to ensure you can view the webcast—attendance is limited!

Tim Vlamis in a 2 Minute Tech Tip - Data Visualization: Just Say No to the Default Sort Order

Tim Vlamis was asked by Bob Rhubart of Oracle Technology Network to share a 2 Minute Tech Tip during his recent trip to the Great Lakes Oracle Conference in Cleveland, OH.

Tim's tip focuses on the importance of applying your own sort order when visualizing data.

See Tim's speedy (33 seconds!) Tech Tip below or read more from Bob Rhubart!