Categories
GenAI Oracle Analytics

Oracle Analytics Cloud AI Assistant

The September 2024 release of OAC introduced the new AI Assistant. The on-line help gives a great introduction to the process of the rollout of the AI Assistant and also some caveats, most importantly “Always verify the results and consult your primary data sources before making critical decisions based on results generated by the Assistant.” […]

Categories
APEX Oracle Analytics Oracle Spatial

Oracle APEX and Analytics with Oracle Database Geocoded Data

Spatial analytics is a powerful tool that provides insights into geographical aspects of data. This technology can be employed to optimize delivery routes, visualize and interact with the geographical distribution of customers, or even plan sales campaigns based on locality.  By applying spatial analytics, businesses can go beyond traditional analytics of knowing who their suppliers […]

Categories
Oracle Analytics

Oracle Analytics REST API Connection

There is a new REST API connection available with the September 2022 release of Oracle Analytics. This is currently in preview so does need to be enabled in system settings. Once we’ve enabled this preview feature, the REST API connector is then made available in the list of connections. Selecting it brings up the following […]

Categories
Oracle Analytics

Introduction to Conditional Formatting in Oracle Analytics 6.1

Oracle Analytics (Cloud and Desktop) 6.1 introduced conditional formatting in the Data Visualisation interface. The ability to conditionally highlight data elements is clearly very useful when used appropriately and allows us to provide ‘RAG’ statuses to draw the consumers’ attention. To demonstrate some simple formatting, we’ll use a table of monthly ETL runtimes, split by […]

Categories
Oracle Analytics

Emotional Visualisations

Recently I took photographs of some of my guitars as I was creating a little APEX application to log them and record information about each one. E.g. the serial number, the date of manufacture, the pickups, the string gauge, etc. I then got to thinking – maybe if I recorded when I played each one […]

Categories
Oracle Analytics Oracle Analytics Server

Create a Custom Filter Layer in Oracle Analytics

With Oracle Analytics 5.6 came the facility to do the following : Upload an Image as a Map Background Draw Custom Map Layer Shapes on an Uploaded Image Associate a Data Set with Map Layer Shapes Drawn on an Uploaded Image This new set of features can be used to create a custom filter based […]

Categories
Oracle Analytics

Thoughts on Pre-attentive attributes with Oracle Analytics

Pre-attentive attributes are types of visual stimuli that are processed subconsciously and can be used in Data Visualization to guide the consumer to exactly where we want them to focus.  So, we can add (or even layer) visual cues such as movement, shape and colour to draw attention to where we as the designers believe […]

Categories
Oracle Spatial

Oracle Spatial Studio and Oracle Analytics Cloud

Last week I performed a virtual ‘awareness’ workshop for a customer.  Whilst primarily focused on Oracle Analytics Cloud components, we took time to look at some other technology which they haven’t really looked at yet, just so that they had an appreciation of what is available. One thing that particularly piqued interest was discussing performing […]

Categories
Storytelling Challenge

ODTUG Oracle Analytics Storytelling Challenge

It is time to put your data storytelling skills to the test! I’m delighted to be part of the committee of the Oracle Developer Tools User Group (ODTUG) organising a Storytelling Challenge . The challenge runs from Wednesday, January 29, 2020 at 12 a.m. (PST) through to Thursday, January 30, 2020 at 11:59 p.m. (PST). […]