Laser Tag for Cloud Analytics

A friendly game of laser tag between out-of-shape technology consultants became a small gold mine of analytics simply by combining the power of Essbase and the built-in data visualization features of Oracle Analytics Cloud (OAC)! As a “team building activity,” a group of Edgewater Ranzal consultants recently decided to play a thrilling children’s game of laser tag one evening.  At the finale of the four-game match, we were each handed a score card with individual match results and other details such as who we hit, who hit us, where we got hit, and hit percentage based on shots taken.  Winners gained immediate bragging rights, but for the losers, it served as proof that age really isn’t just a number (my lungs, my poor collapsing lungs).  BUT…we quickly decided that it would be fun to import this data into OAC to gain further insight about what just happened.

Analyzing Results in Essbase

Using Smart View, a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products, we sent the data straight to Essbase (included in the OAC platform) from Excel, where we could then apply the power of Essbase to slice the data by dimensions and add calculated metrics. The dimensions selected were:

  • Metrics (e.g. score, hit %)
  • Game (e.g.Game 1, Game 2, Total),
  • Player
  • Player Hit
  • Target (e.g. front, back, shoulder)
  • Bonus (e.g. double points, rapid fire)

With Essbase’s rollup capability, dimensions can be sliced by any one item or at a “Total” level. For example, the Player dimension’s structure looks like this:

  • Players
    • Red Team
      • Red Team Player 1
      • Red Team Player 2
    • Blue Team
      • Blue Team Player 1
      • Blue Team Player 2

This provides instant score results by player, by “Total” team, or by everybody. Combined with another dimension like Player Hit, it’s easy to examine details like number of times an individual player hit another player or another team in total. You can drill in to Red Team Player 1 shot Blue Team or Red Team Player 1 shot Blue Team Player 1 to see how many times a player shot an individual player. A simple Smart View retrieval along the Player dimension shows scores by player and team, but the data is a little raw. On a simple data set such as this, it’s easy to pick out details, but with OAC, there is another way!

Laser Tag 1

Even More Insight with Oracle Analytics Cloud (OAC)

Using the data visualization features of OAC, it’s easy to build queries against the OAC Essbase cube to gain interesting insight into this friendly folly and, more importantly, answer the questions everybody had: what was the rate of friendly fire and who shot who? Building an initial pivot chart by simply dragging and dropping Essbase dimensions onto the canvas including the game number, player, score, and coloring by our Essbase metric “Bad Hits” (a calculated metric built in Essbase to show when a player hit a teammate), we discovered who had poor aim…

Laser Tag 2

Dan from the Blue team immediately stands out as does Kevin and Wayne from the Red team!  This points us in the right direction, but we can easily toggle to another visualization that might offer even more insight into what went on. Using a couple of sunburst type data visualizations, we can quickly tie who was shooting and who was getting hit – filtered by the same team and then weight by the score (and also color code it by team color).

Laser Tag 3

It appears that Wayne and Kevin from the Red Team are pretty good at hitting teammates, but it is also now easy to conclude that Wayne really has it out for Kevin while Kevin is an equal opportunity shoot-you-in-the-back kind of teammate!

Reimagining the data as a scatter plot gives us a better look at the value of a player in relation to friendly fire. By dragging the “Score” Essbase metric into the size field of the chart, correlations are discovered between friendly fire and hits to the other team.  While Wayne might have had the highest number of friendly fire incidents, he also had the second highest score for the Red team.  The data shows visually that Kevin had quite a few friendly fire incidents, but he didn’t score as much (it also shows results that allow one to infer that Seema was probably hiding in a corner throughout the entire game, but that’s a different blog post).

Laser Tag 4

What Can You Imagine with the Data Driving Your Business?

By combining the power of Essbase with the drag-and-drop analytic capabilities of Oracle Analytics Cloud, discovering trends and gaining insight is very easy and intuitive. Even in a simple and fun game of laser tag, results and trends are found that aren’t immediately obvious in Excel alone.  Imagine what it can do with the data that is driving your business!

With Oracle giving credits for a 30-day trial, getting started today with OAC is easy. Contact us for help!

Oracle Data Visualization for Strategic Analytics

The world of analytics and data visualization continues to change at a rapid pace. New tools, processes, buzz words (Cloud anyone?) have penetrated our industry and can become overwhelming.  Most of these changes, though, are for the better – one of them being self-service data visualization. Solutions like Tableau, PowerBI, and Qlik have been around for several years, earning reputations as leaders in the self-service, easy, and sexy exploration of data.

Oracle Business Intelligence Enterprise Edition (OBIEE), although a great tool and long-time market leader, lacks ease of deployment, maintenance, and connectivity, and the freedom from “IT tyranny” access to data craved by business users – attributes already addressed by Tableau and others. For many years, I’ve listened to IT describe OBIEE as its enterprise Business Intelligence (BI) solution while business users use Tableau to connect to their own databases and spreadsheets because Tableau doesn’t require them to enter a ticket and potentially wait weeks for that new column to be added to their report.

Today, there is an Oracle tool – Oracle Data Visualization (DV), an Oracle Analytics Cloud (OAC) component,  that exceptionally meets the needs of business users.  Because it is part of a suite of products, Data Visualization also provides enterprise and financial reporting capabilities, advanced analytics and big data, mobile access, what-if scenario modeling, ingestion, preparation and transformation of data, and yes – you guessed it – Cloud.  Some highlights include:

  • Dynamic visualizations that can be organized into stories to be shared across the organization
  • Consumer (drag and drop) style with easy uploads, mashups, and exploration
  • Mobile authoring and consumption, device agnostic, and with dynamic design optimization
  • Connections to dozens of different sources, including SaaS, relational databases, big data tools, NoSQL, and others through JDBC/ODBC
  • Cloud and desktop versions with identical features

The full Oracle Analytics Cloud suite is a comprehensive solution that offers analytics and reporting tools to effectively address business requirements as well as accommodate different users within an organization (analysts, consumers, admins, etc.). Also included with OAC is Business Intelligence Cloud Service (BICS), a tool that is essentially “OBIEE in the Cloud.”  Data Visualization and BICS complement each other and address different needs, summarized in the following:

BICS vs DV

With continued rapid changes inevitable in technology, the future of Oracle Analytics Cloud will likely be promising as additional components are added. After seeing and supporting clients as they “take the plunge” into Cloud analytics, it becomes clearer that Data Visualization is Oracle’s strategic future of analytics.

See an overview of the history of Oracle DV and OAC as well as a demonstration of the products’ main features and wide array of possible sources in this webinar: The Strategic Future of Analytics…Starring Oracle Data Visualization