Skip to main content

Posts

Showing posts from May, 2023

Conditional maps formatting in Oracle Analytics

Oracle Analytics Cloud (OAC) is now frequently updated on bi-monthly basis. May Update release has been announced a week or so ago, and I was able to take a look at preview version which brings again several nice new features and functionalities . The one that has drawn my attention was Maps Conditional Formatting , an option to highlight important data events in map visualizations along with other visualization types. So how does this work? Actually, it is very straight forward as the same model is used as with any other conditional formatting. The map above is the starting point and presents profitability by country. Couldn't be more simple, right? In order to implement conditional formatting on the map, click on the traffic light icon ( Manage Conditional Formatting Rules ). This will open Conditional Formatting popup window. Select to what this particular conditional formatting applies to, the whole workbook or just selected visualization. Provide a name for the rule a

Talking to Oracle Analytics

Being able to talk, by using natural language, to computers, especially with the advancements in general AI models like ChatGPT, has become very fashionable in the last couple of months. Everybody does it. It is simple, easy to use and let's be frank, it can be also very useful. Something that has been around for a while, remember Siri or Alexa or TV remote controllers, has been lifted to a new level and has wide spread use in business already. A bit of a secret is also that  Oracle Analytics  can use natural language, query and generation. Here are some of my findings about NLQ and NLG support in  Oracle Analytics . Natural Language Querying (NLQ) In Oracle Analytics , NLQ has already been around for a while, at least for some years now. I remember those early days when Oracle Day by Day mobile application has been introduced. One of the coolest features in Day by Day was actually the ability to ask a question using natural language. Something like What is revenue by region a