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

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 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 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
Oracle Analytics

Oracle Analytics Cloud Butterfly Charts

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 […]