DataVizMark
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 […]
The new sample map application that has been provided for Oracle APEX 21.1 is full of great ideas. After reviewing the application, one example I was keen to try for myself was the ‘Nearest Neighbour’ capability. I had an existing map demo (see previous articles on this site) showing customers in proximity to a restaurant, […]
The http://apex.oracle.com website was recently upgraded to a pre-release version of APEX 21.1 which has a host of new features available for preview. One which specifically interested me was the new maps region. I already had some geocoded data in a table (using Spatial Studio) which holds information about a fictional restaurant and also their […]
Oracle Spatial Studio 20.1 was released in early December 2020 and has some great new features. I presented a few of these at the UKOUG virtual event and if you’re a member you can see the replay at the UKOUG website. One feature I wanted to highlight is the ability to view data over time […]
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 […]
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 […]
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 […]
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 […]
Oracle Analytics Cloud has a range of new capabilities including a new chart type, the Butterfly Chart. This can be thought of as a variant of the bar chart and is useful when wanting to directly compare two measures side by side. As a simple example, I have created some sales v profit figures across […]
Oracle Analytics Server (OAS) is now available on Linux. OAS is essentially a variant of Oracle Analytics Cloud for customers who want an on-premises installation. So, just like BI Enterprise Edition it is a customer managed download and install. This is not a particularly challenging exercise for those familiar with a BI Enterprise Edition installation […]