Oracle Analytics Clips (61+)

The previous Oracle Analytics Clips page (1-60) consisted of 60 videos of OAC functionality I wanted to highlight upto the Jan 2026 release. This page continues this initiative, looking at features introduced from the March 2026 release and beyond.

61. Data Bars in Tables

March 21st 2026

One interesting feature introduced in the March 2026 release is the ability to have visual representation of data in tables. This provides the consumer with multiple views of the data in one column as sometimes a visual cue can certainly enhance the experience and draw attention to the differences between the elements in the table.

In this video we crate a new table, and add a new data bar and then set the colour and transparency and also tweak the actual data values to make the whole visualization pop.

62. Conversational AI

May 3rd 2026

The OAC AI Assistant has been able to generate visualisations from natural language questions for a while now, but the March 2026 release takes the experience further in two ways. First, when the Assistant generates a chart, it now also generates a written narrative to explain what the chart is showing. So rather than presenting a visual and leaving the user to do the interpretation, OAC now tells you what it found. Secondly, follow-up questions are now contextually linked to the previous response. The Assistant remembers what you were looking at, which means the conversation flows naturally without you needing to re-state the dataset, the filters or the scope at each step.

In this video we use a UK regional sales dataset to demonstrate these more powerful conversational AI introduced in the March 2026 release. We start with a fairly broad question about performance and then follow up with progressively more specific questions that lead us to insights without the necessity to add any visualisations ( if we don’t want to ). We can scroll back through the conversation thread and see the linked exchanges that build on each other, which is a genuinely different experience to what was possible before this release.

63. AI Agents

June 28th 2026

AI Agents are in so many products now, and Oracle OAC is one of them. In this example video we show a sample HCM dataset we have uploaded and indexed. We then link that dataset to a new HCM Agent so that we have a new agent that the users can access to ask questions of the data.

In addition, we then add a HCM Policy Document to the agent, so that it has contextual information about the company policies that it can refer to in addition to the actual data. If you’re familiar with AI concepts, then this is RAG, which grounds the answers the AI provides with the information held in the associated documents.

Here’s the list of the questions we are going to ask, and where we have questions like “How many hours were they supposed to do”, then the “Supposed to do” is coming from the policy document as it’s based on the grade that the people are in.

This is the snippet from the policy section :

TRAINING AND DEVELOPMENT

Annual Training Target
All employees are expected to complete a minimum of 40 hours of formal
training per calendar year (Grades A to C). Employees at Grade D and above
are expected to complete a minimum of 35 hours per year.

Questions we will ask of the data

How many employees are there?

Show the number of employees in each grade band

In grade band E list all employees

Show the Training_Hours they did as well

How many hours were they supposed to do

Did anyone at grade D meet the training hours target

64. AI Calculations

15th August 2026

New AI Calculations in OAC

Oracle Analytics has provided the ability to create custom calculations for quite a while. Now ( since July 2026 release ) AI has been extended to help developers with the syntax to create these. In this example we take a sample Invoice Holds database and first look at a custom calculation provided by the AI assistant, then we create our own using a “natural language” request to the AI. We then create a visualization of the core data and add our new calculation to it to see it working in action.

65. 100% Bars In Tables

16th August 2026

Prior to the July 2026 release as we showed in video 61, we could have data bars in tables ( and pivots too ). This facility has been extended to allow us to use 100% bars. This is easier to explain having the two together as we show in the image above where I have used the same metric ( Amount ) and in one view I have a bar ( in green ) and in the blue I have the new 100% bar. You can see that the 100% refers to the bars being a fixed size and the fill being relative to the size of the metric values. This gives a more interesting visual effect as by just looking at one value I can see where that sits compares to all the other values by how much “fill” there is. Each visualisation facility has its own usage and whilst this doesn’t look like a significant enhancement I think it provides some real added context when looking at values in tables.